Adding Tax info into 1322 - Purchase Order Report

(0) Share

Report

Posted on by Community Member

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.

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

Have you added as a dependencies?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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" } ],

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

Now can you please check my earlier example?

Thanks.

Was this reply helpful? Yes No

Suggested answer

YUN ZHU

95,681 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Akash Shukla 365 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Akash. You are absolutely right.

Thank you all for sharing your thoughts on this issue.

Was this reply helpful? Yes No