Localization, Tax Codes, Report Transformations and QR don't work correctly

Continuing the discussion from QR Code Generation for Invoice:
Besides our problems with QR Extension in the linked topic we have another problem that we have a customized Report Transformation that we depend on submitting our VAT Report to ZATCA, it was the same as the VAT Returns Report Localized Report but with a simple modification. Now, it is not working correctly and give us the following result:

We hope to get a reply from @lubos soon or anyone who has any idea about these problems. we would be very grateful.

please always clearly elaborate every issue separately so that it is easier to understand and provide solutions.

the post you have linked was edited 4 times where you seem to be posting questions and then answering your own questions. this will only confuse readers thereby lesser chances of getting a response.

why did you have to modify the report? was the original report lacking any necessary info? if so, the original report needs to be updated in Localizations based on user feedback.

which report? the original provided with the Localizations or the one modified by you? does the original report work?

Post edits were while I was trying to find the reason for my problem with no result, so I was lost between many possible reasons.

I customized a new report since the developer announced Report Transformations - No-code development platform

The modified report is that in the screenshot.

Just to have the Tax Rates more detailed in the report.

you did not answer this question.
just like custom themes, custom reports are the responsibility of the user because no other user or the developer knows what parameters you have modified. you have not provided any such details nor have you explained what is wrong with the report or what is the expected output.

if there is a legal requirement from official sources to have more details wrt tax rates on the said report, then the original localization needs to be updated so that it is beneficial to all users.

It’s working, did you read the topic of the no-code platform?

The modified report is the same as the original report, like what I said before, It was just for having the Tax Codes more detailed and there is nothing invented here from us. Same report and same result but more details. :face_with_raised_eyebrow:

The report is devoid of any values or numbers as shown in the screenshot attached above.

@Ehab report transformations can no longer see tax codes directly. But they can see custom fields on tax codes. So you’d create custom field on tax code form and then select those custom fields in report transformation.

Are your report transformations generic? If so, they should be part of country template. This way I guarantee they won’t break when changes are made.

Ok, Custom filed in tax code succeded to show the requested Amount while building the report but there is no amounts calculated in the report.

What about QR Problem, what is my mistake here?!

@Ehab from my testing it should be working. Any chance you can send me Manager file to lubos@manager.io ? I can have a look why it’s not picking up.

Absolutely, I am very grateful for your help.

Should I send the current Manager file I’m using “Complete” or I can delete the personal data and give you a simple transaction just to see the problem?

Simple is better. I don’t need to see everything, just enough to reproduce the issue.

1 Like

Done, I hope this will be enough to know the mistake I did.

I have added a Custom Field to my Tax codes

but they do not appear when I create/edit a Report Transformations - what am I doing wrong?

@Joe91 I’m not able to reproduce the issue. Tax code custom fields appear in my dropdown in report transformations.

I will test again

I will work on to upload this report to localization file for Saudi.
For your information, all what I have in my report is to add tax codes in separate lines one for 5% and the other for 15%, just to match inputs while submitting the VAT returns report online to ZATCA that if you have any purchases or sales with 5% tax rate.

I have created a new business
I did not choose a country
I created a Tax Code Custom field


I created a Tax Code and added entered a value in the custom field

I created a new Report Transformation but there is no sign of the custom field

I obviously have not understood what I am supposed to do :frowning:

@Joe91 you should see tax code custom field in the dropdown. What version are these screenshots from?