Programmatically change Taxable amount and trigger bill balance recalculation

Hello,

I’d like to see more information about your tax requirements, and an example of what Acumatica is calculating with explanation of why it’s wrong.

I’m wondering if you have tried changing the below Calculation Rule and Cash Discount settings on the Tax ID to change from Line Level to Document level, to Change from Exclusive (merchandise price does not include tax) to Inclusive, and/or to specify whether discounts reduce tax owed.

My recommendation is to avoid developing ovver-rides of system calculated taxes… customization in this situation, IMO, is the very last resort.

Thank you.

Laura

Hello,

If changing configuration of Calculation Rule and Cash Discount didn’t help… is it possible you are  trying to implement UK tax agency (HMRC) rules that require an "offset" of the net cost to the tax agency instead of paying the subcontractor?

If so, could the "Offset"  be handled like a withholding amount (such as withholding taxes from a subcontractor payment, similar to how paychecks deduct taxes from employees)? Following is a link to an Acumatica Knowledge-base Article from Tech Support; let me know if you can't access the post:

https://community.acumatica.com/how-tos-and-faqs-231/how-to-report-1099-tax-box-4-federal-tax-withheld-7446?tid=7446&fid=231

The only other way I know to withhold from subcontractor payments is with Retainage features of Acumatica... and when retainage is paid, it's only a delayed payment to the same contractor, not paid to the government tax agency.

Hopefully someone with specific UK tax experience will weigh in on this topic.

Laura

Thank you Laura, yes that is my scenario: additional deduction on the net amount alongside regular taxes also on the net amount. Retainage will need to be handle as well but this is separate. I’ll look into the withholding tax and let you know if it brings it to the expected outcome.

We looked into withholding taxes, overall it implements what we are trying to achieve but we would need to have it applied directly to the invoice: basically we need the balance of the invoice to show the deduction already. I’ll keep looking for the right solution. Thank you