# Sales Order OrderAmt not equal to DocOrderAmt

**URL:** <https://www.epiusers.help/t/sales-order-orderamt-not-equal-to-docorderamt/118358>\
**Category:** Kinetic ERP\
**Tags:** kinetic, e10, epicor\
**Created:** [August 28, 2024, 8:53pm UTC](https://www.epiusers.help/t/sales-order-orderamt-not-equal-to-docorderamt/118358 "2024-08-28T20:53:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![scott](https://www.epiusers.help/user_avatar/www.epiusers.help/scott/32/31822_2.png) [@scott](https://www.epiusers.help/u/scott)\
**Post date:** [August 28, 2024, 8:53pm UTC](https://www.epiusers.help/t/sales-order-orderamt-not-equal-to-docorderamt/118358/1 "2024-08-28T20:53:30Z")

</div>

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](https://www.epiusers.help/t/definitive-logic-behind-orderhed-doctotalcharges/99999)

---

<div class="post-metadata">

**Author:** ![jgehling](https://www.epiusers.help/user_avatar/www.epiusers.help/jgehling/32/78990_2.png) [@jgehling](https://www.epiusers.help/u/jgehling)\
**Post date:** [August 28, 2024, 8:55pm UTC](https://www.epiusers.help/t/sales-order-orderamt-not-equal-to-docorderamt/118358/2 "2024-08-28T20:55:42Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![scott](https://www.epiusers.help/user_avatar/www.epiusers.help/scott/32/31822_2.png) [@scott](https://www.epiusers.help/u/scott)\
**Post date:** [August 28, 2024, 9:05pm UTC](https://www.epiusers.help/t/sales-order-orderamt-not-equal-to-docorderamt/118358/3 "2024-08-28T21:05:47Z")

</div>

Jeff

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

Scott

---

<div class="post-metadata">

**Author:** ![DaveOlender](https://www.epiusers.help/user_avatar/www.epiusers.help/daveolender/32/260_2.png) [@DaveOlender](https://www.epiusers.help/u/DaveOlender)\
**Post date:** [August 28, 2024, 9:07pm UTC](https://www.epiusers.help/t/sales-order-orderamt-not-equal-to-docorderamt/118358/4 "2024-08-28T21:07:22Z")

</div>

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

DaveO

---

<div class="post-metadata">

**Author:** ![scott](https://www.epiusers.help/user_avatar/www.epiusers.help/scott/32/31822_2.png) [@scott](https://www.epiusers.help/u/scott)\
**Post date:** [August 28, 2024, 9:21pm UTC](https://www.epiusers.help/t/sales-order-orderamt-not-equal-to-docorderamt/118358/5 "2024-08-28T21:21:07Z")

</div>

> [@DaveOlender](#):
>
> Mexican peso exchange rate.

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 |

---

<div class="post-metadata">

**Author:** ![scott](https://www.epiusers.help/user_avatar/www.epiusers.help/scott/32/31822_2.png) [@scott](https://www.epiusers.help/u/scott)\
**Post date:** [August 29, 2024, 8:45pm UTC](https://www.epiusers.help/t/sales-order-orderamt-not-equal-to-docorderamt/118358/6 "2024-08-29T20:45:45Z")

</div>

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.
