Updating Tax Total Not working - AR invoice Screen

Hi ​@amitkaryekar ,

If the tax code G1SALES GST has been configured with a rate then it will overwrite your manual taxes.

I would suggest creating a dedicated manual tax zone as described by ​@gusl on this thread:

As regards the commissions, the information on the commissions tab is calculated by the system for detail lines where the ‘Commissionable’ checkbox is selected.  The percentages for each salesperson default from the customer screen but can be overwritten.  To get to a specifc amount, I think you would need to calculate this percentage in Excel based on the amount, sum the total per order, and in your scenario populate this total value on the commissions tab.

Hope this helps!

Laura

@amitkaryekar Laura's right that the auto-calculated tax is what keeps overriding yours.

A tax amount you enter by hand on the Taxes tab of AR301000 only holds until something recalculates the invoice: a new line, a changed line amount or tax category, or a new date, tax zone, currency or terms. Every tax row is then rebuilt from the lines.

Two things work against doing this in one scenario. The whole mapping runs for every row in the file. And both of your Save rows are set to Once, for Last Detail Line, so an invoice isn't saved until its last row. Each row's line lands after the previous row's tax step.

Split it into three scenarios on the same provider. Keep your current one up to the first Save. The second finds the invoice by Type and Reference Nbr. and adds the commission as an invoice line from commission_amount_inc_gst and commission_gl_account. On its Source Restrictions tab, add commission_amount_inc_gst Does Not Equal 0, then click Prepare on Import by Scenario (SM206036) and check the zero rows are gone. The third keeps only the invoice search, your Tax ID search, Tax Amount and Save. Both new scenarios need your agent_slug restriction too.

Run the tax scenario last. The commission lines would recalculate the tax, and Tax Total temp already includes their GST. Try all three in a test tenant first.