Sales Tax Specification Ledger

(0) Share

Report

Posted on by Ethan Ong

1,800

Hi all,

We had patch report as above. However, it doesn't seem right. Currently per se we have invoice amount of $1,000 and the break down of the two lines say comprise of $500 and $500 where assuming the GST 10% for each line, hence the report by right should show below:

Invoice Number Invoice Amount GST

INV100500 500.00 50.00

500.00 50.00

But what the patch and upgraded is showing something like this:

Where there is breakdown two or three lines for GST but source from one Single line of Gross/Origin Amount. Anyone can assist or replicate this issue?

*This post is locked for comments

All responses (8)

Answers (1)

Mamdouh 146 on at

Like (0)

Report

RE: Sales Tax Specification Ledger

good news :)
Verified answer

Ethan Ong 1,800 on at

Like (0)

Report

RE: Sales Tax Specification Ledger

This issue is deemed closed because the error due to add-ons and customization in the AX2012 environment. By right the report layout created is inaccurate!!!!
Ethan Ong 1,800 on at

Like (0)

Report

RE: Sales Tax Specification Ledger

Hi Fahim.

For other report is able to show breakdown both origin amount and calculated GST in such as Sales Tax Transaction report. Is so happen that this report is not showing the breakdown after given patch by Microsoft. Is it possible for you to test on the same report menu GL>Reports>Groupings>Sales Tax Specification by Ledger Transaction?
Mamdouh 146 on at

Like (0)

Report

RE: Sales Tax Specification Ledger

Dear Ethan,

I think you means the GTS split amount (154.53 + 26.8), the same for next invoice in your screenshot so may be this invoice have 2 lines.

I need more data for GTS setup and invoice lines to try to support

thanks
Ethan Ong 1,800 on at

Like (0)

Report

RE: Sales Tax Specification Ledger

Can you see the highlighted. The Credit Amount is total Amount. However the GST shows breakdown of calculated sales tax. Should it not be the Credit Amount should also show a breakdown associated with the GST.
Mamdouh 146 on at

Like (0)

Report

RE: Sales Tax Specification Ledger

could you attaches actual screenshot
Ethan Ong 1,800 on at

Like (0)

Report

RE: Sales Tax Specification Ledger

Hi Fahim.

Not interested how is calculated how is presented. Because the report is showing a grand total for Invoice Amount which is 500+500

However, at GST column is showing breakdown of 50.00 and 50.00. Why is it so? Is it a norm in Standard AX report?

If it so, I do I explain this to client to look at the right angel? Because as far I know the purported report is to derive the calculated tax code in reference to the Main Account. However, what Client is expected in the report is to have the Calculated Tax (GST) to be aggregated by Main Account, and Amount Origin.
Mamdouh 146 on at

Like (0)

Report

RE: Sales Tax Specification Ledger

Dear Ethan,

I cannot get your point but if you want to insure that the GST is calculated correctly and you already post the transaction, we can inquire about the main account of GST to check the tax amount form General Ledger / Inquires / Voucher transactions