Here are some of the most common questions about inventory in R.O. Writer.
Why is the on-hand quantity not being reduced when the part is sold?
There can be two reasons this is happening:
- We don't track on-hand for non-stock parts unless that option is checked in the Configuration module. Select Configuration > Repair Order > R.O. Options. Check the box for Track On Hand for Non Stock under the Parts section. Also keep in mind if you check this option, you will have to receive all non-stock parts into Inventory to keep the on-hand from going negative.
- A line code was added to the part on the repair order that does not match the line code for that part in Inventory. This can happen if you post parts from Epicor, Smart eCat, WORLDPAC, NAPA, Nexpart, or ACDelco Wise Connect. When posting from any of these parts catalogs, it also posts the manufacturer’s line code.
To ensure that when posting parts from any of the parts catalogs or when adding or editing line codes that the line code in inventory and history is also updated, you will need to turn on an option in the Configuration module. See PO/Transfer and Other Parts Options.
NOTE: Duplicate part numbers with different line codes are treated as two different parts in R.O. Writer.
How is the parts profit calculated?
The formula the system uses to figure the parts profit is: (1-(part cost / part price))*100
Example: If the cost = 182.74 and the price=478.06, 182.74/478.06=0.3822532
1-0.3822532=0.6177468 0.6177468*100=61.77468
Round that to 2 digits which is 61.77% profit.
Part Prices suddenly zeroed out!
Global pricing was probably run but the mark-up multipliers were left at 0.00 and 0 multiplied by any number is 0.00.
Fortunately, if it has not been too long since they ran the global pricing, the system does a backup before the prices are updated. Restore from backup called “invback.mdb” usually saved in
C:\Users\Username\AppData\Roaming\Progressive Automotive Systems, Inc\ROWriter\Backup\InvBack.mdb.
This is the default backup path when R.O. Writer is installed. For advanced users, this path can be checked or updated in the registry under
HKEY_CURRENT_USER\Software\Progressive Automotive Systems\ R.O. Writer Backup key.
Why doesn't the Itemized Sales report match the Parts Sales Summary?
Because the Parts Sales Summary report will not show any parts that were deleted from inventory or were added only to the repair order and not saved to inventory. The Itemized Sales report shows all parts sold on repair orders whether they are in the inventory list or not.
Why do I get an Invalid Procedure call or argument error printing the Inventory List?
The price levels have been blanked out. Add descriptions back in. Open the Configuration module, select Configuration > Parts > Price Level Descriptions. All price levels need to be filled in.