Recalculate Application Balances in Sage Pro ERP With Microsoft SQL Server Does Not Recognize Customer On-Order Discrepancies

  • Created:
  • / Author: tombucci
Issue

If a customer has a non-zero value in their On Order field and there are no open sales orders in system, the Recalculate Application Balances function will not recognize the discrepancy and pass over the record. This issue occurs in Microsoft SQL Server installations of Sage Pro ERP. 

Solution or Workaround

This issue has been documented under PTR 83168 and is being fixed with the Sage Pro 7.4 ERP release.

Possible Solution:

Enter a one penny ($0.01) sales order for the affected customer. This will allow the Recalculate Application Balances function to work and correctly detect and update the customer record. The sales order can then be voided and the customer record will update accordingly.

© Copyright Sage Software

Leave A Comment?