Hi Gurus! :)
Scenario:
I have a situation where I need to credit an AR invoice with many items and their respective taxes and then "eliminate" the tax amount from some.
So, imagine i have an invoice with 2 items, revenue for each item is $45, tax for each item is $5.
Dr. AR $100
Cr. Deferred Revenue $90
Cr. Tax Payable $10
Now I need to reduce my invoice by the tax on just one item, by $5, so my tax lability to government is $5 only (because customer qualified for a tax free item, let's say - so this is not a general CM, but a specific tax liability reduction issue).
In terms of debits and credits, what I need now is this GL impact:
Dr. Tax Payable $5
Cr. AR $5.
Question:
Can you think of any way to accomplish such a tax liability reduction, so that it is reflected on BOTH invoice AND the GL and I can reissue my invoice as $95 invoice and send it to the customer?
Potential solution that has some problems:
Create a custom transaction (similar to a JE) and record the same entry as above.
Dr. Tax Payable $5
Cr. AR $5.
Problem: this will affect control level AR but will not affect the invoice.
Note: a traditional credit memo will probably not work (whether directly from invoice or standalone because we are not returning any product; we are simply crediting and reducing a portion of the tax amount).
Please let me know if you can think of any solution.
Thanks! :)