Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Sales Tax Specification Ledger

Posted on by 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

  • Mamdouh Profile Picture
    Mamdouh 146 on at
    RE: Sales Tax Specification Ledger

    good news :)

  • Verified answer
    Ethan Ong Profile Picture
    Ethan Ong 1,800 on at
    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 Profile Picture
    Ethan Ong 1,800 on at
    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 Profile Picture
    Mamdouh 146 on at
    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 Profile Picture
    Ethan Ong 1,800 on at
    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 Profile Picture
    Mamdouh 146 on at
    RE: Sales Tax Specification Ledger

    could you attaches actual screenshot  

  • Ethan Ong Profile Picture
    Ethan Ong 1,800 on at
    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 Profile Picture
    Mamdouh 146 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans