Collection Agency - ARSPAG
This function will create a report, file for a 3rd party collection agency and an AR batch file for invoices that are overdue. This utility can be processed in trial mode so that only the report is created. The user puts in selection criteria and a date as to which transactions / invoices are to be considered overdue by. If an invoice is selected to be placed in the Collection Agency file an event code entry of "COLL" will be created for that invoice so that it is not placed in there again. If a user wants an invoice to not be considered for the Collection Agency, they may place an event code of "SKIP" in the Event Table.
AR Selection Criteria:
01 Command Selection
02 Account Information
03 Responsible ID Information
04 Category (By Term) Information
05 Transaction Detail
06 Special Information
07 AR Reference Details
SF Select File
Invoice Reference Date: Enter the date the transaction reference date will be compared to to see if the transaction is "overdue".
Print Report Only? (Y/N): By entering a "Y" you will put the process in TRIAL MODE and only the report will print out. A "N" will print the report as well as create the Collection Agency file and AR Reversal Batch File. The file will be created in the data directory. The file name will need to be no more than 8 characters long with no special characters. The file will be pipe-delimited and in the format:
ID 12 characters
Name 50 characters
Address Line 1 40 characters
Address Line 2 40 characters
Address Line 3 40 characters
Address Line 4 40 characters
City 20 characters
State 2 characters
Zip Code 14 characters
Invoice Number 16 characters
Reference Date 8 characters
Description 30 characters
Amount 18 characters