Is there a way to add the Tax percent on the SOP Invoice depending on the Tax detail ID?
What about the Report Writer User-Defined function: RW_TXGetPercentOrAmountString I can't find any info in SDK about this function and parameters required.
Anyone knows and could help me?
Thanks,
Sylvie
*This post is locked for comments
You can create a formula field to get the percentage of tax
'SOP_LINE_WORK'.'Tax Amount' * 100 ) / ( 'SOP_LINE_WORK'.'Extended Price' - 'SOP_LINE_WORK'.'Trade Discount Amount'
Hi Leslie
Do you know of a way to display the Tax Detail Percent on the RM Blank Document report footer? This is required for a UK customer where there is only one tax rate applied per transaction. The fallback position is do a calculation as you mentioned above, however, this can lead to rounding errors/discrepancies.
I've added the Sales/Purchases Tax Master table to the report and added the applicable field, but it just displays as 0% even though the transaction has a 20% tax rate applied...
Thanks in advance.
Regards
Ana
Sylvie,
Are you looking for each line to have the taxdetail ID and Tax % charged each line? There would be a 'sub' line equal to each of the tax details assigned to the tax schedule. Or, do you just want the taxschedule ID and the sum of the percentages of each detail. This won't give you an accurate number because the tax base is still unknown. Alternatly, you could just do the math and figure out the tax percentage using simple arithmatic divide the total tax amount for that line to the price of that line.
What are you looking for?
Kind regards,
Leslie
Hi,
I believe this function returns a string and requires 3 parameters to be passed to it in this order:
in 'Tax Detail Base'
in 'Tax Detail Percent'
in 'Tax Detail Amount'
I don't know if this will get you what you want, but I think I have the parameters correct. Give it a shot and see what you get.
Kind regards,
Leslie
Hi Sylvie
Granted this is a really old post, do you recall if you ever found any information on this RW function?
If so, please could you share.
Many thanks.
Ana
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (