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

(3) Share

Report

Posted on by ISDev

271

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

I have the same question (0)

All responses (5)

Answers (0)

Layan Jwei 7,995 Super User 2025 Season 2 on at

Like (0)

Report

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

Hi,

Do you still need help?

Was this reply helpful? Yes No
Layan Jwei 7,995 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ISDev 271 on at

Like (1)

Report

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

Hello @André Arnaud de Calavon and @Layan Jwei,

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

Was this reply helpful? Yes No
André Arnaud de Cal... 297,205 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Layan Jwei 7,995 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No