customer utility: REBALANCE CUSTOMER ON ORDER AND POSTED BALANCES

[Chris Kelleher]

In customer master, I would like to have more information about the posted
Bal field. I would like to know how it's updated.

In this sentence, "The Posted Bal field is calculated as the sum of the
Amount of the customer's Open Items."
What's the customer's Open Items ?

Thanks,

Mireille Carrier

 

[Chris Kelleher]

Here's a snip of the rebalance utility. This could also help Michael Dobies
earlier question about an ar report.

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
for each artran where artran.cust-num = {&cust-record}.cust-num
and artran.amount <> ? no-lock:

assign
d-amt = artran.amount + artran.misc-charges +
artran.sales-tax + artran.sales-tax-2 + artran.freight
customer.posted-bal = customer.posted-bal +
if artran.type = "C" or artran.type = "P" then (- d-amt)
else d-amt.

[/code]