web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Inquiry - Posted sales tax shows all invoice lines

(0) ShareShare
ReportReport
Posted on by

I am setting up AX 2012 for my PH company. I have set conditional sales tax. So when i issue an invoice it generate "accrued sales tax" and when customer pay us it will automatically transferred the amount from "accrued sales tax" to "realized sales tax."

My question is when i issue an invoice with multiple invoice lines, it will show all the invoice lines in Inquiries-Posted Sales Tax. So for each invoices, is there any way I can group the invoice lines which has the same items sales tax group into one line in the Posted Sales Tax? Or is there any other way to work around this? Functionality wise it works perfectly but when i have more invoices, the record in Posted sales tax will be very messy.

Appreciate for your help!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Stanleycyk,

    The different lines that you get, do they all have post to the same ledger account and financial dimension?

    Is the sales tax calculated on a line by line Basis or on the invoice total?

    Do you have one or multiple sales tax codes in your invoice?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    Thanks for getting back to me. It is posted to different ledger account. I have 3 lines in the invoice, charging different kind of revenue. (e.g. Revenue for service type A: sales tax code "VAT", item sales tax code"VAT", revenue for service type B: sales tax code "VAT", item sales tax code"VAT", revenue for service type 3: sales tax code "VAT", items sales tax code"No VAT")

    in the posted sales tax, currently it shows all three lines. I would like to see if it can sum type A and type B into one line since they share the same sales tax code and items sales tax code.

    Thanks and regards,

    Stanley

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Stanley,

    If different ledger accounts-financial dimension combinations are used then you can't get different transactions lines summarized.

    What you can do though for reconciliation purposes is running the ledger account by sales tax code report that helps you getting those data toghether and reconciled.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    Thanks for your explanation and advice.

    Got it now!

    Thanks

    Stanley

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Stanley,

    If there is nothing left open \ unanswered then it would be great if you could verify the answers.

    Thanks,

    Ludwig

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans