The following MAS ODBC 90 table & report export processes are to be performed on the system with MAS, the MAS Company file, and Excel (2003) available (steps for Excel 2007 are also provided).
Note: The following process and instructions are based on the MAS90 v4.3 but are very similar across most MAS systems v3.71 and newer.
The following 5 reports must be exported from MAS as of the SAME DATE. This date is commonly the Period End date for the month & year the last entered transaction was made in the file (Ex. If the last transaction in the file is 3/10/2010, the Period End date will be 3/31/2010). These reports will assist in importing and verifying the starting balances in the file.
These reports are used to verify against the MAS ODBC AR/AP Table Exports. These reports should show all open invoices and credit memos for customers/vendors as of the same date as all the other reports exports. The default report setup with the appropriate Aging Date set is generally acceptable.
Your opinion counts! Please use the voting and feedback buttons to help us build a better knowledge base.