Sales Order OrderAmt not equal to DocOrderAmt

Kinetic ERP
, ,
1

OrderHed_OrderAmt does not equal OrderHed_DocOrderAmt

From Sales Order Entry - Summary :
Charges field is 644.59. Shows as the OrderHed_OrderAmt (plus many other fields).
Order Total is 613.67. Shows as OrderHed_DocOrderAmt.
5 lines on a counter sale order.
Difference is equal to the last line item on the order.

All items were “shipped” at the exact same date \ time. Checked the Sales Order Tracker àLines Detail ChangeTime. Also checked PartTransHistTr Sys Time.

The invoice shows the full 644.59.

On Sales Order Tracker - No figures in the Summary Discount, Misc, Tax, Rounding.

I looked at every field in OrderHed, OrderDtl. , and OrderRel. All fields show values across the 5 lines. The only field with a difference is this OrderHed_DocOrderAmt.
I looked at every field referencing discount.
No lines are open on dtl or rel

We are on 2023.2.11

These customer service people are using the classic screens.

Of course they looked at the Order Total to collect money from the customer.

Something similar happened the week before, but the dollar amount is a fixed 125.00. One of the line items here had a price of 1250/m is the only odd thing here.

I saw the previous topic from last year. This is the same as Rick was working on.
Definitive Logic behind OrderHed.DocTotalCharges

1 Like
2

You don’t happen to use multi currency / csf do you?

3

Jeff

Not in this company. My other company is multiple currency.

Scott

4

The difference is suspiciously close to the Mexican peso exchange rate.

DaveO

5

Sorry guys, I must be missing something about the rate.
Here are the rate numbers from the days in question from our other company.

Source Currency Target Currency Rate Group Effective Date Rate
USD MXN MAIN 8/16/2024 18.8478 0.053
USD MXN MAIN 8/24/2024 19.4235 0.051
6

Now I get the multi currency question. I took a look at info from my Mexican company. There is a difference on the order dollars for these fields. That difference calculates to the variance with the rate. (I try to stay out of Mexico).

I found that in the last 3 months this happened 3 times in my US company. Twice the difference was the last line item. The third was this straight value (related to 10% of item price).
Now the numbers thing set me sideways. This happened on the 8th, 16th, and 24th. We don’t sell on Sunday, so I am going to look again on Sept 9.