You’re offline. This is a read only version of the page.
Announcements
Hello Expert's,
We are trying to bring "GST Amount" & "Net Total" fields value as shown in the Purchase Order Statistics page to Purchase Order Report 1322. When we inspect the page it is showing the Table is "Purchase Header(38), attached is the screen shot. But we cannot relate any fields for GST Amount and Net Total in the Purchase Header(38)Table. How this can be achieved to bring the said field values to the report by creating report extension? We did report extension/customization successfully for other pages like sales invoice, but we are stuck with this particular GST related information's for PO Report. As per PO page inspect, GST is an Extension Application by Microsoft for India.
Appreciate your earliest help on this.
Thank you Akash. You are absolutely right.
Thank you all for sharing your thoughts on this issue.
Hi Ranjith,
Please change the report ID as currently 1322 report is standard report which used by US, UK, Canada and other localization. If you going to extend this, then it will take more time and maybe you are not able to add the GST amount here.
I will suggest to use the standard report which already available for Indian localisation. Report ID is 18008. On this report ID all the GST related field already there, you can easily extend this report as per your need.
You can change report layout selection by searching - Report Selection - Purchase
Change usage as Order and select report ID in line
And run this report from purchase order and you can see there are all detail available related to GST.
Please mark this as suggested answer if it helps you.
Thank you.
Nitin / Zhu,
Thank you very much for your time and guidance.
We have added dependencies and symbol has been downloaded as mentioned.
Using EventSubscriber() we are trying to get GST values into Purchase Header and trying to display the same. But we are facing with the error when passing the parameter. See the screen shots.
Regards,
Ranjith
Hi, Nitin's suggestion is absolutely correct.
I just briefly summarize.
1. Adding "dependencies" feature in app.json file.
| dependencies | No | List of dependencies for the extension package. For example: "dependencies": [ {"id": "4805fd15-75a5-46a2-952f-39c1c4eab821", "name": "WeatherLibrary", "publisher": "Microsoft", "version": "1.0.0.0"},{}].Note: For dependencies to the System Application and Base Application these are no longer listed as explicit dependencies, but captured in the application setting as a reference to the application package. Must be filled in with the version number of the Application package. See application below.Note: The version specified defines the minimum version for the dependency. At runtime and when downloading symbols, the latest version of the dependency satisfying the specified name, publisher and, minimum version will be returned. When runtime is set to 4.0 or earlier, use appId instead of id. |
2. Download symbol files
3. adding GST fields
Hope this also helps.
Thanks.
ZHU
Hi,
Now can you please check my earlier example?
Thanks.
Nitin,
We have added following dependencies.
India GST, Tax Engine, India Tax Base
"dependencies": [ { "id": "db643212-b7fb-4dd4-b5a8-cb44ac714461", "name": "India GST", "publisher": "Microsoft", "version": "19.5.36567.39381" }, { "id": "c1eafb3f-e397-468e-bdb4-ecc5c317ca00", "name": "Tax Engine", "publisher": "Microsoft", "version": "20.0.37253.38362" }, { "id": "d3c551dd-5903-4194-b153-04ced9d29a2c", "name": "India Tax Base", "publisher": "Microsoft", "version": "20.0.37253.40041" } ],
Hi,
Have you added as a dependencies?
Hi Nitin,
Thank you for your response.
We are unable to access the said code unit. Getting error message as "GST Statistics is inaccessible due to its protection level AL(AL0161)". Is there anyway to overcome this?
Also, is there any other method to bring the GST values to PO Report instead of access code unit 18006?
Regards,
Ranjith
Hi,
You can try to achieve if you have access of Base application app of India GST, then you search Codeunit in that i.e. codeunit 18006 "GST Statistics", by going inside that CU you can find various functions which are used to show GST amount values in Sales and Purchase Statistics page.
Please check below image and try to navigate same.
Hope it will help you.
#1
André Arnaud de Cal...
294,233
Super User 2025 Season 1
#2
Martin Dráb
232,982
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
