Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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?

(1) ShareShare
ReportReport
Posted on by ISDev 24
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,449 Super User 2024 Season 2 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 24 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... 291,532 Super User 2024 Season 2 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,449 Super User 2024 Season 2 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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,575 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