Reporting to the MAX Accounting Software

Sometimes you can see that the sum of the activity on the Aging tab of the Vendor master record does not equal the amount on the Statistics tab in the Total Due field.  Or you ran the Control Report which showed that there were differences between the master file and the open file – and you can determine that the open file has the correct data.

 Both of these conditions are correctable by using the Recalculate Vendor Balances function found in   Options  File Maintenance  Recalculate Vendor Balances.

This function can be performed for one, or a range of, AP Codes.  It can be performed for one, or a range of, Vendors.

Once you start processing by pressing OK, CMS will search the APITM (Open Header) file’s APITOAMT (Original Amount) field and recalculate a total.  Since the original amount field contains information about charges, credits, and payments, it is the total of all open activity - similar to the GL Audit Trail.  This calculated total replaces the AP_DUE (Total Due) amount showing in the APMSD file.

SUMBITTED BY KAY COOK, INFORMATION ADVANTAGE