Price Codes

Taking a Framing Materials Inventory Count

Main Menu > Price Codes section > Find Price Code Item button

How to edit a Work Order when the Auto Update of materials inventory feature is active.

• There are a number of ways to check what is currently in stock through the Price Codes file accessible by Main Menu > pink Price Codes section > Inventory Reports. The report can show moulding, matboard, mounting, and glass by Location or Group. See: Inventory Reports

• Knowing what you have in stock isn’t enough. Use the above report in conjunction with the best selling moulding report, Moulding/Matboard Usage Report, to see which inventory isn’t moving. It can be printed for any date range and gives the total footage or quantity sold, as well as listing the items actually sold in order of volume. See Printing the Moulding Usage by Supplier Report.

• The designer can check the inventory at the point-of-sale for rush orders by using the Frame1 detail screen or hovering the mouse over the Frame1's Description field (a tooltip appears to show you the quantity on hand).

How to take a Framing Materials Inventory Count

1. Navigate to Price Codes file.

2. Click the Moulding sidebar button to find all of the wood, metal, liner, fillet etc. items in your database. You can then do the same for each of the other sidebar button groups listed on the left side of the Form View screen.
   
   Or
   
   You may want to search for only those items that are in stock, i.e. click Find and enter  >0  into the Qty field.

3. In list view, click the Inventory List View button.
   
   The Inventory List View screen appears.

4. Optional: Use the Sort button to sort the items by location or quantity or whatever will help you in your manual inventory.

5. Optional: Click the Print List button to print a document to use in conjunction with your physical inventory count. Caution: This may consume many sheets of printer paper.

6. In the Inventory List screen, for each item, enter the amounts which have been counted into the Actual field.

7. When you entered a number into the Actual field, the difference is immediately calculated and put into the Variance field. This will provide you with a variance report of what you thought you had in inventory and what is actually there. Large variances should be investigated.

8. When you enter zero  0  into an Actual field, then, during step #10,  the value in the Quantity field will be replaced with a zero.

9. After you have entered your counts into the Actual column, you can move all of the numbers into the Qty field.
   
   To move the numbers from the Actual field to the Qty field, go to the Main Menu, in the Price Codes section and click the Clear Inventory Fields button.
   
   The Clear Inventory Fields window appears.

10. Click the button titled, Move the values from the Actual field to Quantity field and clear the Actual field. You will not be asked to confirm this action.

11. Do NOT click the Clear All Price Code Items button. This will delete the amount in ALL of the Quantity fields.

12. When finished, the Main Menu appears.

Why is there a negative quantity on my physical inventory list?

• A negative quantity appears when an item has been sold but not first recorded as received into inventory.