Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / What is the X++ relati...
Finance | Project Operations, Human Resources, ...
Unanswered

What is the X++ relation to get the ActualTaxAmount in PurchPurchaseorder report in d365fo?

(3) ShareShare
ReportReport
Posted on by ISDev 204
Hello all,
anyone can give me the correct x++ relation to get the actualsalestax value for the purchpurchaseorder report ? 
thank you
Categories:
Dynamics 365 Finance
  • Layan Jwei Profile Picture
    Layan Jwei 7,715 Super User 2025 Season 1 on at
    What is the X++ relation to get the ActualTaxAmount in PurchPurchaseorder report in d365fo?
    Hi,

    Do you still need help?
  • Layan Jwei Profile Picture
    Layan Jwei 7,715 Super User 2025 Season 1 on at
    What is the X++ relation to get the ActualTaxAmount in PurchPurchaseorder report in d365fo?
    Hi ISV,

    And what table are you trying to relate it with?

    for example, if you have the record for VendPurchOrderJour
    then VendPurchOrderJour.RecId=TaxJournalTrans.TransRecId
     
    and from TaxJournalTrans you can get the SourceRegulateAmountCur value
     
    Thanks,
    Layan Jweihan
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
  • ISDev Profile Picture
    ISDev 204 on at
    What is the X++ relation to get the ActualTaxAmount in PurchPurchaseorder report in d365fo?
     
    the path is as follows:
     
    All purchase orders -> purchase order confirmations -> sales tax -> actual sales tax amount .
    field name is  SourceRegulateAmountCur and table name is TaxJournalTrans 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,575 Super User 2025 Season 1 on at
    What is the X++ relation to get the ActualTaxAmount in PurchPurchaseorder report in d365fo?
    Hi ISDev,
     
    Can you please provide some more information about the requirement? In case you shared a screenshot with posted Sales tax transactions (please confirm as we miss the actual path how you opened this page), then you will not find these from a purchase order report. A purchase order doesn't contain posted sales tax transactions. Based on settings, expected tax can be calculated. 
    You can check the Totals form which you can open from any purchase order. This contains a calculated tax amount. You can then reverse engineer how this is being calculated.  
  • Layan Jwei Profile Picture
    Layan Jwei 7,715 Super User 2025 Season 1 on at
    What is the X++ relation to get the ActualTaxAmount in PurchPurchaseorder report in d365fo?
    Hi,

    Can you share the path for this form, so that we can help you further?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans