• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 8039, created on Feb 7, 2010, last review on Oct 16, 2014

  • Applies to:
  • Odin Business Automation Standard 4.5


PBA-S provides script which may be used to correct customers balance: hspc-acc-balance-fix.pl

This script calls blocks tables which can affect customers balance:

LOCK TABLE acc_balance WRITE, acc_transaction WRITE, ar_doc READ, hspc_setting READ, account READ, vendor_currency as list READ

NOTE: While script is working all others processes which require these tables will wait until tables will be unlocked. You should run this script in minimal activity period.

Run the script without any parameters and it will recalculate balance of all customers from their AR documents. The script will report IDs of accounts whose balance was adjusted:

# /usr/sbin/hspc-acc-balance-fix.pl
Shifting balance of account #6 on -4.00

Depending on the number of customer accounts in PBA-S program execution may take significant time.

Search Words

correct customers balance

Balance of credit adjustment never decreases

ERR: ERROR: Sum of credit turnover in balance

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 624ca542e40215e6f1d39170d8e7ec75 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF