Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Link TaxCode and TaxPerc to CustConfirmTrans Table

Posted on by 50

Hi everyone,

I have a problem with getting the TaxCode and TaxPercentage on the CustConfirmTrans lines. I have the Taxwritecode, Taxamount, Taxgroup and Taxitemgroup on that line but I am missing the Taxcode en Taxpercentage. Anyone an idea how to add those two fields? I should be an combination of the Taxgroup and Taxitemgroup I guess.

Thank you very much!

*This post is locked for comments

  • FrankRaij Profile Picture
    FrankRaij 50 on at
    RE: Link TaxCode and TaxPerc to CustConfirmTrans Table

    Hi Ludwig! thanks! For a salesconfirmation report. I have the linedetails from the Custconfirmtrans (name, linenum,  salesid, qty, Salesprice, Lineamount etc) and I want to add the taxpercentage and taxcode per line so I can make I summary  with Taxwritecode, Tax%, Amount ex tax and Tax amount. Grouped per Taxwritecode, but I think I will always have one taxwritecode on a Salesconfirmation.

    Thanks!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Link TaxCode and TaxPerc to CustConfirmTrans Table

    Hi,

    The tax codes result from the combination of the sales tax group and the item sales tax group.

    The percentages are linked to the sales tax code table.

    For what process/scenario do you need that information because you used the reporting and bi tag?

    Best regards

    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans