Difference between balance due on statement and balance due in system?

Posted by Alex on May 12, 2007, 12:21 pm

Please log in for more thread options

A client of mine had a recent server mishap that caused them to lose 3
months of sales data. Fortunately, they keep paper records of customer
charges and were able to adjust the customer balances accordingly.

This worked for most of the statements. However, there is a small
group that is really throwing me for a loop. This group of statements
is printing a new balance due that is completely different than the
balance due as listed in the customer manager. The difference between
the correct amount and the mis-print is exactly the amount listed as
"Previous Balance" on the statement. Looking at the xml file for the
statement, the previous balance figure comes from
AccountStatement.PresentStartingBalance.

I am quite familiar with the table structure running RMS and have
written many web-based applications and reports. Does anybody know
exactly how the previous balance is calculated? To rephrase the
question, which fields and parameters are used to specifically arrive
at this figure?

Any ideas are much appreciated...

Alex Nielsen
Nielsen Technology, LLC