930
Hi frieds, in my company we need to print an invoice with some items taxables and others exempts, but in my test enviroment I can't find a field on the table SOP10100 or SOP30200 that show me something like "Document Subtotal Exempt" and "Document Subtotal Taxable"... so on my invoice printable form I can't separate the amount that is taxable and the amount exempt....
do you have any idea? or recomendation?
thanks in advance
HB
*This post is locked for comments
There is no such thing as 'exempt' in GP - only whether the line item is tax analysed or not - by this I mean does it have a tax detail attached to it, or not.
It may well have a tax detail called 'exempt' which calculates tax at 0%, attached to it.
If it is, you can group your subtotals in a tax analysisat the bottom of the invoice layout based on the tax detail ID assigned to each line.
IMO - Ideally, every line should be tax analysed in this fashion, so that you can print a complete tax analysis for your sales tax returns. (totals for each tax detail in the period). If a line item does not have a tax detail attached to it, it is left off this report and so the picture is not complete, regardless of the fact that there is no tax liability because it is exempt.
Best regards,
Hi there,
To achieve this, you will need to be assigning each sales line item with a Tax Schedule. Then you will need to link the sales line items, SOP10200, with the tax detail table, SOP10105, on line item sequence number, LNITMSEQ.
The SOP10105 will hold the tax information you need, ie.. total amount of sales and/or total tax amount per tax detail per line item.
Im not too good on the vba to achieve this result, but this should work.
Thanks
Mark
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (