mibuso.com

On sales Order Hit F9 and on invoicing tab change the tax by 0.01 cent.
There is a setup allow tax differnce to be checked.

I tried adjusting the amount, but I still get the error.
I have the tax difference checked.

One of the sales lines has Outstanding amount = 27.06 and the Amount Including Tax = 27.07.
Changing the tax in the Invoicing tab does not change this amount.
Do I need to change the amount inclusing tax on the sales line itself by editing the line?

Changing the Tax amount in Sales Order Statistic does change Amount including tax on the sales line.

I am only seeing a total taxable amount for each tax type, no breakdown by individual sales line is there a way ti get to that?

on statistic form you see in the detail lines the breakdown of each joursdiction. you can change the tax amount of each line.

But the tax lines are for the order. I don't see a breakdown per line item.

you see a breakdown by jurisdiction. what state are you charging tax and how many lines do you see on statistic form? And have you tried to change the tax amount for one of the lines by 1 cent?

3 lines - 1 per jurisdiction
The tax amount on the sales line is non-editable.
I could change it as a developer, but that means I cannot turn over future problems to the user.
This particular order had a partial shipment, so I posted the invoice only, which appears to have fixed the problem. The remaining items are resources which did not appear on the shipment and the sales tax amount now reconciles with the outstanding amount.

On the statistic Form F9 the user can change the Tax Amount. Click on Invoice tab in statistic form and then on the detail lines where it shows lines for every jurisdiction you can change the Tax amount field. Have you tried to change it by 1 cent?

Yes I did. I still had the error. I then tried posting the invoice without selecting the shipment and invoice problem and that posted and it also adjusted the outstanding amount to match the amount including tax on the sales line.

Really a great JOB.

thanks

I normally use one of the other methods, i.e. create a journal to see what will be posted, or remove the CONSISTENT command to see what was going on. I just recently had a new consistent error, and decided to try this tip, and I must say that its simple, it works and its brilliant.

Well done Ahmed

Thanks.

Leaving the code on customer db won't hurt performance because the function will simply exit out if you haven't run it manually from object designer.

Yes I noticed this, but in the client didn't want modified code in the live db (that would require audit testing etc). Anyway great tip.