You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Rounding problems SHIPMENT / SHIPMENT COST and INVOICE/LINE_ITEMS

edited Mar 25, 2025 5:23PM in Transportation Management 6 comments

Summary:

Hi,

We are experiencing rounding issues with amounts in SHIPMENT vs SHIPMENT_COST and INVOICE vs INVOICE_LINEITEMS for some shipments.

We are noticing that in many cases, the sum of the detailed amounts in SHIPMENT_COST or INVOICE_LINEITEMS does not match the total in SHIPMENT or INVOICE for the same shipment/invoice. There are differences of 0.00x decimals, which causes a 0.01 discrepancy when rounding to two decimal places. For example, these cases at SHIPMENT and SHIPMENT_COST differences:

In the example above the TOTAL_ACTUAL_COST_BASE is the SHIPMENT.TOTAL_ACTUAL_COST_BASE field, and the COST_BASE_DET is the SHIPMENT_COST.COST_BASE. Both values must be equal..

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!