I was making a query to for a report to show the total value of an order, and the total billings against that order, and found many Orders whose Orderhed.OrderAmt is zero, even though the lines have values.
I double checked and there are no discounts or misc charges to offset the lines.
I’m sure this is something simple, but it is eluding me.
From the Summary tab:
From the Lines\Detail tab:
More info …
The problem isn’t that it always totals zero. I’ve found some orders with lines that aren’t included in the total.
Looking at the OrderDtl table for these shows the fields OrderDtl.VoidLine and OrderDtl.Warranty are both TRUE.
Looking at the Order Tracker or Order Entry give no indication that the line was voided, or made a “warranty”. The only thing that shows on the Order Entry is under the Lines\BookDetails tab.
What is the source of this info?
This comes from the BookDtl table. It is written while the “Ready to Processes” flag is checked.
So why would a line on an Order Entry not be included in the order total?
What business process changes a line from New to Void?
I know if one voids the sales order/line/rel, you get the VOID status. If you manually close the order/line/rel then you get. DEL status - I’m fairly sure.
Mark W.
I think this is a wider error introduced in 10.1.600, my DB has the same. Raised a support ticket, only to be told it’s working as designed. The total doesn’t include any closed lines. I’ll dig out the case and share the full response.
I’ll be very interested to hear their rationale on why the line items of an Order add up to one number (which matches the printed Order Ack, and the amount in OrderHed.TotalCharges), but is different from that shown on the Order Summary (which matches the OrderHed.OrderAmt)
I’m even more confused than ever…
A query of the BookOrd, BookDtl, and BookRel show no voided lines, and the sum of the BookDtl.BookValue is the $55,788.00 number.
I have no idea where the 47,395.19 comes from
Not to hijack this thread, but we have this exact same issue in PO Entry and have an open case with support without any resolution. I’m very curious if these problems are not related. John
John,
Not to answer the hijack but for POs, there’s a standard datafix you can run to recalculate your PO totals. What version are you on?
Calvin,
If you make a change to a value and then change it back, does that fix it? What about the OK to Process flag. Do you see a different behavior if checked or not?
Mark W.
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 that amount. But does not update to the sum of all lines.
I updated every line by changing the unit cost (added $1 to each). The Summary Total Charges still doesn’t match. BUT… It did go up by the same amount the sum of the lines went up by.
| State | Summary Charges | Total of Lines | Diff. |
|---|---|---|---|
| Original | $47,395.19 | $55,788.00 | $8,392.81 |
| After increasing each lines unit cost | $59,707.19 | $68,100.00 | $8,392.81 |
Zeroed out the unit cost of every line, and now Summary Charges is -8,392.81. This is the magic offset I’m chasing.
Confirmed that there are no Discounts or Misc Charges (lines or Header)
EDIT: More Info…
There are 2 Sales Kits lines. But confirmed both are configured to use Parent price, and the unit price of every component is zero.
More info:
Used “Copy Order” to duplicate it, and the new order shows the correct values in the Summary.
I guess I could try deleting each line and adding it back (in the original order) to see if that fixes it.
Edit: (more, “more info”)
Deleted all but 6 lines (these were BTO, and the PO Receipt has already occurred).
These remaining lines add up to $7,290.17. The Summary of Charges is -$1,102.64.
The diff still being $8,392.81
My case ref this issue was CS0000586656.
Reviewing it now, these are the notes from support:
1.The order 10251 was voided so the ORder totals are not maintained.
I have 23 orders already this year that are out of sync. If you raise a case with support, I’d be pleased to raise another one or ask to be linked to yours to get it sorted. We also use Sales Kits, which could be significant.
I’ve got no voided lines or releases. I even double checked the OrderDtl, OrderRel, BookDtl, and BookRel tables for all entries for this OrderNum.
¯\_(ツ)_/¯
I received fix CR19482ESC today and it corrected the SOTotal amount in the GlbCustCred table. I put in a request for the Invoice Amount now as well.
I ran into this in 10.2.100.8. In my particular case, I caused the problem with the DMT tool. Adding OrderDtls and updating their quantities recalculates the totals on the summary page, but deleting OrderDtls does not trigger recalculation. After deleting lines, I triggered recalculation by using the DMT tool again to “update” the remaining lines with the same quantities they already had.
@ckrusen Were you ever able to get to the root cause of the summary not updating correctly? We are experiencing a very similar issue.
I think my second example (where there was always a $8,392.81 offset), turned out to be an orphaned child record. Either a Misc Charge or Tax Detail.
i.e. no useful information on how to fix, this thread just reminded me that order summaries have been able to get “out of whack” for “a while”.
Used to see similar behavior in E9, where I suspected some irregular entry sequences were the cause but… never was able to duplicate/verify anything.
