Accounting report errors can occur due to duplicate transaction numbers, duplicate blank transaction numbers and incorrect dates. Accounting's Audit Option will automatically locate these transactions and allow you to correct them.

Duplicate transaction numbers can cause an accounting report to loop on the duplicate number. To correct this delete one of the first duplicate transaction number. If necessary the transaction can be re-entered with a new transaction number.

Duplicate blank transaction numbers can cause an accounting report to loop on the blank transaction printing out only lines and no transactions. To correct this delete the blank transaction numbers.

Invalid dates such as 03/99/92 can cause a transaction report to skip all remaining transaction for month 03. Use the accounting audit option to locate any invalid dates and then edit the transaction's date.

Types of transactions to include:


A All
S Cash sales only
O Recvble vouchers only
Recvble payment only
P Cash purchases only
I Accts payable vouchers only
E Payable payments only
W Payroll checks only

14.5.2 All Transactions For A Specified Chart Of Accounts (T Accts)

Selection 2 prints out or displays all transactions in the transaction data base file for a specified chart of account for:


M Month
T Time period
A All transactions regardless of time

Types of transactions to include:


A All S Cash sales only
Recvble vouchers only
R Recvble payment only
P Cash purchases only
I Accts payable vouchers only
E Payable payments only
W Payroll checks only

14.5.3 Current Balance For A Specified Account

Prints out and totals the account's beginning balance and transactions for the current month. For this report to be correct all prior months to the current month must have been current and posted. This is the fastest method for providing your current balance in a chart of accounts, such as your checking account.

14.5.4 Account Payables Reports

Allows you to print out accounts payable reports. You can select all open, all closed and aging reports of 30, 60 and 90 days.

14.5.5 Account Receivable Reports

Allows you to print out accounts receivable reports. You can select all open, all closed and aging reports of 30, 60 and 90 days.

14.5.6 FIFO Inventory Value Report

Prints out or displays a FIFO Inventory Value Report. This report uses the receivers and the qty onhand to determine the value of the inventory.

14.5.7 Sales Tax Report

The sales tax report option prints and or displays a sales tax report for a specified time period. The sales tax reports will include all invoices entered during the time period you specify.

If you select In State, pc/MRP will sort and subtotal sales taxes due on the invoice tax codes, such as taxable, resale, out of stare, US government, etc. The report (taxlog.frx) will consist of invoices created during the time period specified. The invoices must contain sales tax codes (automatically inserted from sales orders into invoices). If you create a custom in state report, it must be named ctaxlog.frx.

If you select Out of State, pc/MRP will sort and subtotal sales taxes due by the invoice state and tax entity code such as CA01, CA02, NY01, etc. The report (taxlogo.frx) will consist of invoices created during the time period specified. . The invoices must contain tax entity codes (automatically inserted from the address book into sales orders and then into invoices). If you create a custom out of state report, it must be named ctaxlogo.frx.

If you select Out of State for a specified state, pc/MRP will sort and subtotal sales taxes due by the tax entity code such as CA01, CA02 for the specified state such as CA. The report (taxlogo.frx) will consist of invoices created during the time period specified for the specified state. The invoices must contain tax entity codes (automatically inserted from the address book into sales orders and then into invoices). If you create a custom out of state report, it must be named, ctaxlogo.frx

If you are required to pay state sales taxes for only the county you are based in, print out the instate report.

If you are required to pay state sales taxes for other counties in your state, print out the instate report and the out of state report for a specified state (yours.)

If you are required to print out sales taxes to two or more states, print out the instate report and the out of state report.

14.5.8 Sales Commission Report

Prints out or displays a Sales Commission Report for a specified month. subtotaled by Salesman. Commissions can be based on:

• Payments received during a specified month in the accounting module.
  • This option basis the commissions on the accounting's R, Revenue and S, Cash Sale transactions. This option will not correctly calculate and subtract the tax if the invoice line items have different tax rates.
• Invoices issued during the specified month.
  • This option basis the commissions on the date the invoice was entered and not on payment of the invoice.
• Date the invoice line items were paid in full.
  • This option basis the commissions on the datepaid and complete fields in the invoice. This option will correctly calculate and subtract mixed tax rates on an invoice. Commissions will only be reported when an invoice line items are paid in full. This option requires pc/MRP versions 7.01N, 7.02R, or 7.03B or higher.

14.5.9 Cash Out Projection Report (POs)

The Cash Out Projection Report is based on outstanding purchase orders being paid off 30 days from the expected delivery date for each PO line item.

14.5.10 Cost Of Sales Report

Will print out (on a wide carriage printer only) a Cost of Sales Report for a specified month. The information is obtained from the invoice records. pc/MRP's Configuration Menu, Option 17, will allow you to select how the cost of sale for each invoice is obtained from the Average Cost field in the Partmaster Module, from the Cost field from Related Purchase Orders, or turned off (P/R/O). The Average Cost Field for all parts the Partmaster Module should be filled and the "Cost Roll Up Option" in the Partmaster Module should be run prior to update all assembly average costs prior to running this cost of sales report.

14.5.11 Purchasing Price Variance Report

Accounting's Purchase Price Variation Report compares standard costs listed in the Partmaster Module with the actual purchase price from the receiver. Purchasing can use this report to show management the cost savings per month over list prices.

14.5.12 Check Reconciliation Report

pc/MRP allows you to print out a check reconciliation report for all checks or uncleared checks only. Select All checks to see a running pc/MRP and bank balances from day 1. Select Uncleared checks only to see the difference in the pc/MRP and bank balance only. Select Last 160 days only (assumes all checks over 160 days have been cleared), to see the last 160 days of bank transactions comparing pc/MRP's balance with the banks balance.

Select how you would like this report sorted by transaction number, date, or check number. Enter the checking accounts chart of accounts number. pc/MRP will then display/print the reconciled running balances between the bank statement and pc/MRP's transaction files. The balance column contains pc/MRP's balance. The cleared balance column contains the bank's balance. The uncleared balance column contains the differences in the two balances.

The Last 160 days only report first totals up all checking transactions greater than or equal to 160 days old. If pc/MRP finds any deposits or checks have not been cleared over or equal to 160 days old, it will display an error message with the transaction number and return back to the main menu. If all the 160 days and older checks have been cleared, pc/MRP puts the total of all the checks into a memory variable named mprevtot. It then goes on to create a report listing each checking transaction less than 159 days old, a running balance for pc/MRP, a running balance for the bank, and the difference based on if the check cleared or not.

To automatically clear all checks greater than 160 days old, go to accounting, select "Pay Bills/Print/Clear Checks", and select "Clear all checks for a date range".