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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Conditional sales tax linking the sales tax transactions on posting to the original invoices

(0) ShareShare
ReportReport
Posted on by 20

Hi,

     I have setup Conditional sales tax in a Philippines company. So as you know, when a vendor invoice is posted it generates a sales tax transaction against say 'ConSalesTaxCode1'.When the invoice is paid (in full),  2 Sales tax transactions are generated, one with a negative amount against the 'ConSalesTaxCode1' and thus reversing the 'conditional' sale tax transaction at the time of invoice posting. The second transaction is against 'TrueSalesTaxCode'. These 2 transactions have a different voucher number than the payment transaction that is in VendTrans. 

How can I tie back the 2 sales tax transactions generated at the time of payment with either the invoice or the original sale tax transaction generated at the time of invoicing. 

I can't seem to find any connection between the transactions and I don't see any standard report or inquires that tie them together either. 

Has any one else been successful in this?

regards,

 

I have the same question (0)
  • ToddB Profile Picture
    on at

    Hi ssly,

    In checking, I found the below in regard to a partial fix around this made in 10.0.14; and it states "With the current data structure, it is possible to populate the Name only, however Invoice number identification is not feasible."

    Sales tax transaction report missing details when the conditional sales tax is paid and reported to original tax

    fix.lcs.dynamics.com/.../Details

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello ssly,

    Did you fix your issue in the meantime?

    Also, can you let us know whether you operate AX2012 or D365FO?

    Many thanks,

    Ludwig

  • ssly Profile Picture
    20 on at

    Hi Todd,

                 Thanks for that, we were thinking of doing a development to get the vendors details and as the KB says, it was not possible to go back to the original invoice based on the existing data. We plan to upgrade to the latest version in the next few weeks so we see how this looks like then.

    I think that we have reached the limit of what currently possible.

    regards,

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans