Hi,
I am building EDI message for Invoicing. I need to put in my message the VAT%.
My problem is i dont understand how to get this value from custInvoiceTrans.TaxGroup and custInvoiceTrans.TaxItemGroup.
Can somebody help me ?
thank you
PS: I'm using this good old AX4
*This post is locked for comments
Thank you very much both of you for explanation, and solution. This is all good, I will just check if I need to add a date range as you said and it's done.
EDIT: Ok no date are specified in taxData
Hi
Try this:
Share
Report
All responses (
Answers (
select taxData
join taxOnItem
where taxOnItem.TaxCode == taxData.TaxCode
&& taxOnItem.TaxItemGroup == custInvoiceTrans.TaxItemGroup
join taxGroupData
where taxGroupData.TaxCode == taxOnItem.TaxCode
&& taxGroupData.TaxGroup == custInvoiceTrans.TaxGroup;
info(strfmt("%1", taxData.TaxValue));
You may add date range to taxData table if needed.
Hi,
The item sales tax group and sales tax group combination result in a VAT code.
You can identify this VAT code in the item sales tax group and sales tax group setup forms in GL.
The % value of the tax is linked to the VAT code in a special form/table.
Best regards,
Ludwig
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