07/20/2007
For use with Mas90/200 4.20
Intended to be installed in SOA folder, executed by logging into Mas90,
running Syzcon and run "arapfx... It will rebuild AR Customer Sales Hist and
AP Vendor Purchases Hist files independantly... I believe it will run fine
if one or the other module is not installed, as long as you don't try to
execute it for that module.
The two history files will first be cleared of ALL data, then the appropriate
history files will be scanned to accumulate the various totals. Therefore,
you can run this utility as often as you like.
Users will be prompted first for recalc of the AR files, upon completion or
refusal of AR recalc, the AP module will be prompted, upon completion or
refusal of AP recalc, control will return to Mas90.
This utility will first attempt to process those history records with Non-blank
transaction dates, customers/vendors or divisions. Then a second pass will be
made processing those history records with blank transaction dates and substituting
the appropriate document date. This is done because testing has shown that
Invoice history, particularly older invoice history, typically has no transaction
dates assigned.
Be advised that documents that have blank divisions, blank customer/vendor numbers
or are marked as deleted will be skipped and NOT listed in the following error log.
Additionally, the dates are checked for valid form and content... those that fail
will be skipped, but will be listed in a text file named 'AR_AP_Fix_COMP.TXT' in
the SOA directory. Note that COMP in the file name is the Company Code being
processed. This file will only be created and the user notified if corrupt date
fields are found. It will list the offending file name and the corresponding key
value. The following is a sample...
File Name, Key of Offending Record
AR_InvoiceHistoryHeader, 0000001000000
AP_InvoiceHistoryHeader, **28 000000
AP_CheckHistoryHeader, A080000 000000
This utility will deal with fiscal years/periods and calculate the proper
fiscal year/period for each transaction during the recalc process using the dates
as outlined above.
Running in DEBUG mode...
Should you wish to verify the numbers that are being used to calculate totals...
Run syzcon, type in Debug=1 and enter, THEN run "arapfx"
Depending on which modules you recalc, the following files may be created in the
SOA directory...
"AR_Fix_"+COMP$+".csv" This file contains the AR Inv history records visited
"AP_Fix_"+COMP$+".csv" This file contains the AP Inv history records visited
"PAY_Fix_"+COMP$+".csv" This file contains the Check History records visited
08/09/2007
Release of version 1.1
This version of "arapfx" has the version appended to the name...
i.e. arapfx.v1.1 in this case... All following notes regarding how to run the program need to take this change into consideration. So, the executions is now
Run SYZCON, then type run "arapfx.v1.1"
This version, in addition to previous recalcs, now also clears and recalcs the
AR_CustomerSalesPersonHistory.M4T file, if AR is processed and the AR Option
SalesPerson Commission Reporting is turned on. There do not appear to be any
screens to view this data (other than DFDM), but it is used in the AR report
Sales Analysis by SalesPerson Report.
Add to favorites