Hello! This is a weird one… a user was going to create a sales order and just saved the header. No detail lines have been added or charges. [image] How can there be a negative total!?!!!

We had a similar issue where a line was deleted but a misc charge still remained. The fields you show (Charges, Misc, and Tax) did not add up to equal to the Order Total It might have been a tax amount. Either way it didn’t show in the fields, but was included in the total. I’ll look through my …

Here’s an old thread on it [image] Order Total is zero, even though lines have values ERP 10 Clearing “Ready to Process”, saving, Setting “Ready to Process”, then saving again, does not update the order total. Changing the price of line 1, changes the Total Charges, by th…

Thanks! I’ll take a look. The weird thing is if I copy the order the totals become correct. This issue almost caused us to fulfill and invoice the order being 7k off. That’s a huge issue and support is telling me it can’t go to development unless I can reproduce this issue. This happens extremely sp…

I recall finding the entry in one of the tables (escapes me at the moment). So make BAQ’s with OrderHed and each table that relates to it.

I cant find anything :frowning: Nothing in Orderhed, OrderDtl, BookDtl, GlbCustCred EDIT: ok so i added 1 line back to the order and now all of these negative values appear in my query to BookDtl with the order num in question. Values are even there for lines that were deleted

I think in my case, the lines somehow got marked as Warranty, before being deleted.

It doesn’t make sense tho, all the book changes add up to zero

Hi Jeff, We have also seen bug where miscellaneous charge got “stuck” on order header data. The bug was when a sales order with a misc charge was copied, and then… get this, copied again (from 2nd copy) we got some bad data in Order header. I did report bug to epicor, they claimed it fixed in 10.…

Thanks Nancy, This was a brand new order, not copied. I have checked all those fields as well and see this: [image] That is what is throwing the total off. When this order is copied, the new order total is correct. We are on 10.2.300.15

Were any lines deleted? To verify, all the OrderDtl.LineNum’s should not have any gaps

Order Entry negative total with no detail lines!

Epicor ERP 10

ckrusen (Calvin Krusen) August 28, 2019, 12:34am 3

Here’s an old thread on it

Topic		Replies	Views
Order Total is zero, even though lines have values Epicor ERP 10	18	5438	January 20, 2021
Definitive Logic behind OrderHed.DocTotalCharges Kinetic ERP	19	1497	March 21, 2023
Sales order total is incorrect Epicor ERP 10 e10	5	1079	February 16, 2024
Order Total Incorrect Epicor ERP 9	14	3425	January 10, 2018
SalesOrder.CloseOrderLine not correctly updating totals on header Epicor ERP 10 e10 , bpm , salesorder	4	583	July 17, 2023

Order Entry negative total with no detail lines!

Related topics