Price in Sales Order is different between Lines tab and Totals tab in Sales Order

Posted By rnssales 11 months ago

We created a Sales Order with a large number of line items. The Total Amount shown on the bottom of the window is correct. When we then navigate to the Totals tab, the Taxable Amount is a completely different number - inflated by almost $30k. We sent this quote to our customer not noticing the discrepency.

Any idea why this is happening? This is the only instance we have noticed so far:

0 BigLouie 11 months ago

On the sales order form you should have seen a warning message that the order was out of balance. I have seen this before, cause unknown.

This is on the Knowledge Base

Summary

Totals tab in Sales Order and Quote History does not match Lines tab.

Cause

Sage Engineering is researching the issue. If you are experiencing this issue, please open a support ticket with Sage 100 support.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rnssales 11 months ago in reply to BigLouie

Hi - there was no warning message displayed. If you hit Accept, it lets you continue as if everything is okay. I'll check out the knowledgebase. Thank you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M 11 months ago in reply to rnssales

We've seen it too, in multiple places... and where it's recurring we've even set up alerts (using 3rd party reporting software) to notify users when SO header totals don't match line totals.

Cause: unknown.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 BShockley 11 months ago

Try changing the tax schedule, save the order, and go back and select the correct tax schedule and see if it fixes the problem.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Price in Sales Order is different between Lines tab and Totals tab in Sales Order

Summary

Cause

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING