A/R Customer / Activity Tab values

[sebik2000]

Hi,

Do anybody know how the data in the A/R Customer / Activity Tab is updated?
I have very strange values in this screen. Some of the current (active) Customers have “Highest Balance Last Year” dated 11/28/2005 and Largest Invoice Last Year dated 4/27/2003. Shouldn’t last year be either fiscal or calendaristic year? Do I need to run some special processing to force this information to be up to date? I know that is possible to manual edit the values in the form but how can I find the value and the date of the Larger Balance for Last Year for a customer?

Thank you,

Sage Accpac 500 ERP (Version 5.3B)
OE 5.3A SP2
IC 5.3A SP2
Database: Pervasive V8.6

 

[ettienne]

Ar Periodic Processing, Year End
Open the screen and press F1.
Do not Reset All Batch Numbers, you only want to Clear Activity Statistics. This needs to be run at the end of the year, it's kinda late to do that now.

 

[DjangMan]

To calculate the largest balances will require that you use a running total. You might be able to list the transactions in AROBL in DATEBUS order and calculate the date and value of the highest balance.