Program Description
This program can be found on the System Manager Main Menu (LMSY-1-8). It summarizes the current financial status of a particular business. No input is required. This program begins running immediately after it is selected from the System Manager Main Menu. Output includes Cash in Checking Balance, Accounts Payable Balance, Pending Accounts Payable, Accounts Receivable Balance, Open Orders, Open Purchase Orders, Month-to-Date Revenue, Month-to-Date COGS, Month-to-Date Gross Profit, and Moth-to-Date Expenses. The results are shown below:
The following fields are described below:
Cash in Checking
This comes from the Chart of Accounts file set up in Accounts Payable/General Ledger Control File Maintenance fields 6 and 8. If using Accounts Payable, this should include all AP dollars and should equal AP Aged Trial Balance and Cash Requirements By Vendor.
A/P
This comes from the Chart of Accounts file set up in Accounts Payable/General Ledger Control File Maintenance fields 6 and 8. If using Accounts Payable, this should include all AP dollars and should equal AP Aged Trial Balance and Cash Requirements By Vendor.
A/R
This comes from the Accounts Receivable (ARECD) data file (Total Invoice less Amount Paid To Date) as of the time and date this report is run.
Pending A/P
These are the purchase orders that have been received and have yet to be posted in Accounts Payable. This should match the Pending Invoice Report.
Open Orders
This comes directly from the Order Entry transactions, whether open or backordered. This should match the Open Order by Item Report (OE-4-1).
Open P/O
These are those purchase orders that have been issued, but have yet to be received. This skips all prepaid ourchase orders (since they have been paid for) whether they are received or not. This should match the Open Purchase Orders by Item Report (PO-4-3).
MTD Revenue, MTD COGS (Cost of Goods Sold), and MTD Gross Profit
These come from the Month-to-Date Sales Analysis file (SALID). This is updated at the time of invoice, credit memo, or non-billable service ticket entries.
MTD Expenses
These are any General Ledger accounts that begin with 6 for the current fiscal month. If the Sales Analysis/General Ledger interface switch (field 7) is set to Y for yes in Billing Control File Maintenance, it looks at the last fiscal month updated in field 8 and adds one month. This is the fiscal month that is used. For example, if it is July 1 and June has not been closed out yet, it would be 5 in Billing Control File Maintenance. Add one month to this and the month would be 6. The system date is always used.