Clearly something is wrong with the order. Delete the order and start again.

Unfortunately shipments have already been processed against it.

At this point I'm curious what happened to cause this discrepancy and where (and if) it can be pinpointed. Unless it's a just a weird glitch.....? Any one else experienced this before?

We have experienced it at lest 4-5 times over the last 3 years.  no explanation as to why and each time we have to do a data repair.  We usually see it happening with Taxes trying to calculate based on a cost that isn't there, or we see it throw a qty into location details even after the item is deleted.

Thanks for your response, Mike!

I'm glad we're not the only ones at least....

Is your IC costing set to Posting?

We've seen strange things happen in OE and PO with costing on posting.

It's actually set on Day End Processing.

Does data integrity report any errors?

It's been running for about 2 hours and it's only at 7% completion...

I'll post another response once it's done! Thanks!

check the tax base of the order header/detail lines.  I've seen the tax base become large when updated by an import or SQL update.  for example, sell item x for $300 but tax base (tax included) becomes $30,000, driving the invoice/order negative yet the total looks normal.

The tax base is actually correct. It matches the order subtotal on the "Totals" tab within order entry.  So it's weird that on the "order" tab, the order subtotal is negative.

The DIC completed as well and this is what is showed:

Order: WO-00017389

E: Header mismatch. Total Amt. Items (ORDTOTAL) is incorrect.

E: Header mismatch. Order Total Est. Weight (INVWEIGHT) is incorrect.

Worthy to re-mention that there are no line items anymore on this WO in the test database that the DIC was ran against.

Thanks Everyone!