I need to add the Tax Amount Field at Check with Stub on Top report using Report Writer to appear any tax calculations on the purchasing document. Any help to achieve this task?
*This post is locked for comments
Dear Ian, Thank you for replying.
Actualy that was very helpful as it's enable me to drag Tax Amount field to Check With Stub On Top report.
But the bad news is that it didn't gives the right amount as it always gives a zero value !!
What you think ?
Hi Ehab, in the Check with Stub on Top report the table 'Multicurrency Payables Transactions' is available - on this is a field called 'Originating Tax Amount'.
This field can be dragged onto the Check report (into the remittance area) - however it will only have a value if the payables invoice was entered in an originating currency.
To add the standard PM Transaction table(s) to the report. Open the report Definition window in report writer and click on 'Tables'. Highlight the first table listed 'PM Payment Work' and click New.
In the list presented select 'PM Key Master File' and click OK.
Then highlight the table you just added, and click new. Select the PM Transaction Open and PM Transaction History tables and add them.
The 'Tax Amount' field is on these tables for each transaction.
You may need to create a calculated field that prints the 'Tax Amount' from either table depending on whether or not the transaction is in open or history. Or you can drag both fields out onto the report and set them to be Invisible when empty. Also you may need to consider multicurrency (Originating or functional values).
I haven't tested the above - but it will point you in the right direction.
Let us know how you get on.
Ian.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,432
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
