Q: How does a vendor get onto a PAR029 report?
A: A vendor (or sale acct...depending on the cotab switch) will appear on the PAR029 reports based on sales activity. Once a single item is sold to that vendor (or sale acct) the vendor will appear on the Parts Mgmt Reports for 2 years due to history which is retained for 2 years.
For grouping of Parts vendors or Parts sale accts you can use partgrp or partgrpb...please see the following note.Database 'PFW Help', View 'By Author', Document 'Changing PARTGRP table groupings from vendor to sale account or the other way.'
If you use PARTGRP and PARTGRPB together you will get 2 sets of parts management reports. Summarized by PARTGRP and then by PARTGRPB.
Q: Where does the '?' vendor number come from?
A: If a customer keys an invoice hitting a parts sale account and loads the part as ?, the system will put the sale under Vendor ? on the Parts Management Information report. To find the invoices these parts were sold on, run a Sales Analysis Detail - Selected Part Numbers Report (BIL904 - Option 3) for part "?".
Q: Why don't my Parts Management (PAR029) and Financial Statements ever balance?
The parts management report generated during a parts month end will never balance to the financial statements because of work in process. The parts management report will include all parts sold to a W/O regardless if it has been closed or not. The financial statements, however, will not show a parts sale to a W/O until the W/O is closed.
Q: What value is used for Inventory $ current month?
A: The on hand value is used when this month end report is run. PAR029. This data gets saved in the PARTMGMT file.
Q: What do the WITH TFR and WITHOUT TFR totals mean?
A: In the Percent of Fill section on the Parts Management report, there are totals called "WITH TFR" and WITHOUT TFR".
The total for WITH TFR includes parts sales that were transferred from another store in the sales order module. This would be the company total. In sales orders parts can be transferred when creating a PO by specifying a remote store as the vendor. The total for WITHOUT TFR does not include branch transfers. This would be the branch total.
Q: Is the reprint of the report the same as the original?
A: Yes, the values will stay the same.
AVG INVENTORY LAST 12 MONTHS 5473 5464
INVENTORY DOLLARS CURRENT MONTH 8174 8162
INV AT COST,ZERO SALES, L12 282 282
INV AT COST,ZERO SALES & RECPTS L12 282 282 ADDED BEF 1298
Q: Can I regenerate the totals from my PAR029 report through Crystal Reports or query to see what makes up the detail?
A: This capability would not be possible prior to R6V06. For R6V06 the parts management month date will be stored in the labor date field. By following the logic you could recreate some of the parts management report through Crystal reports (query would be able to do certain items, but not the entire report).
Q: The PAR29A report has no totals. Why?
A: If you reprint this report after the last parts month end of the fiscal year has been completed, there will be no figures on it. This is the message that appears when this option is selected (see the last paragraph):
