Parts Management Versus G/L
The PAR086 report indicates how the parts management totals were calculated, by listing the break down of the various G/L accounts and the amounts making up the totals for each vendor (or sale account).
The report lists:
-
Parts management values:
-
Vendor or sale account (depending on the option selected in the table COTAB)
-
Cash code
-
Non stock code
-
-
General ledger values:
-
Account/profit center (the G/L account used on the original invoice)
-
Amount
-
The PAR086 report can also be used to indicate possible coding errors in the part master file. For example, on the sample report, the vendor DEERE should only show charges to the 366 series of sale accounts (3660130, 3660230, 263660330, etc). However, the sample reports also shows charges have been made to sale accounts 3700030, 3720030, 3730030, etc. for vendor DEERE. This indicates that there are some parts on the parts master whose vendor is DEERE but the sale account is not a 366 series account (the part could also have a 366 series account with a vendor that is not DEERE). These parts can be printed using the Parts Reports screen, to select all parts whose vendor is DEERE and whose sale account is not equal to 3660130, or by selecting all parts whose vendor is DEERE and whose sale account is equal to 3700030, 3720030 or 3730030 etc.
This could also be the result of the wrong G/L sale account being used on the regular invoicing screen (1. Key Invoices on menu BILL01). This can only happen on sales of new parts as the sale account is forced for part numbers that already exist on the part master.