Skip to main content

Troubleshooting Guide: Invoice Total Does Not Match Invoice Transaction Extended Price

Distributor fix in Encompass when an Invoice Total doesn't match the sum of line extended prices: unbalance and unreturn the load sheet, unlock and re-save the invoice to recalculate. v26.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 26.01

Pre-Conditions

  • Must be able to identify the specific invoice via an error message.

  • Must have the necessary system permissions to unbalance load sheets, unreturn load sheets, and unlock invoices.

Steps

  • Click the Invoice Num linked in the error message.

  • UnBalance the Load Sheet associated with the invoice.

  • UnReturn the Load Sheet.

  • UnLock the Invoice(s) that need to be recalculated.

  • Edit the Invoice(s) that need to be recalculated.

  • Save changes to trigger recalculation and align the totals.

  • If the issue persists, please contact support. You must gather and provide the following specific information to support for efficient troubleshooting:

    • Exact error messages or codes encountered.

    • Screenshots or video recordings of the issue.

    • Log files (specify which ones if applicable).

    • The exact steps taken by the customer that led to the issue.

    • The date and time the issue was first observed and any recurrence.

    • Any changes made to the system before the issue appeared.

Fields And Definitions

  • Invoice Total: Total price of the Invoice.

  • Invoice Trans Ext Price: Sum of Unit Price multiplied by Num Units.

Best Practices

  • Trigger Recalculation Hooks: Always ensure that when line items are deleted or edited, the invoice is saved properly to force header total recalculation hooks.

  • Consistent Tax and Freight Application: Verify that tax, freight, or discount elements are applied consistently across calculation engines to avoid discrepancies.

  • Monitor Rounding and Precision: Be aware that line-level mathematical rounding differences can compound at the header level. Similarly, monitor for currency exchange rate translation or precision truncation mismatches.

  • Ensure Full Transactional Updates: Partial transactional updates that fail can leave the header and lines permanently out of sync; ensure your network connection and system states are stable when saving edits.

Did this answer your question?