Inventory Tab – Products File – FR8

The Inventory Tab is found in the Products file.

Inventory Tab

  1. When a new item is entered, the Received date is automatically entered. When the items is entered onto a purchase order and accepted into stock, the date will change to show when the last shipment was received. Each time the item sells, the date is entered into the appropriate sold date. The first time an items sells all three dates will be the same. Eventually all three dates will be different. The Turn Around box identifies the number of days between the Previously Sold date and the Last Sold date. This provides a quick way to see which items are selling quickly and which are not. You can use the Find feature to locate all stock which has a shelf life greater than a certain number of days and sort them by Turnaround in a descending order. This will provide a listing of slow selling stock, however, you will want to look at the Sold dates and Qty Sold to determine the true selling habits of the item. By using the data available on this screen, you will be able to determine a more accurate picture of the sales history of the item and estimate its sales potential. The calculations in this area will track how quickly your products are selling. All fields are available in the search screen and the date fields can be modified in this layout. All fields are available in the search screen.
  2. The Out field is the quantity that has been consigned out using the Consignments file.
  3. The IN field is the quantity of product available in inventory. (Always displays as a whole number.) Quantities below zero will be displayed with a minus sign. The quantity is decreased automatically when an item is entered on an invoice. Items on an invoice with Terms of 48 Hour Approval will not be removed from inventory. To have the item removed from inventory, go the invoice and click on Terms. A message will appear asking if you want to update the inventory at this time. Click Yes and select a term other than 48 Hour Approval. Items returned on an invoice will be added to the IN field of the returned item. (Multi site version – this represents the quantity on hand for all sites.)
  4. Location presents a pop-up menu to identify where the artwork is located/stored. Use Edit… to modify or add a location to the list. Use Other… to enter a location which you do not want added to the menu.
  5. FrameReady Multi site only – Site 1-4 are quantity fields which reflect the Qty of the item at each location.
  6. Inventory List button gives you a way of viewing your data where you can do a physical inventory by entering the actual quantities, print out a report, and then move the actual to the regular quantity fields.
  7. FrameReady Multi site only – The Move Inventory button displays a dialog box where you can enter the quantity that is being moved, the site that it is being moved from, and the site that it is being moved to. Inventory levels are recalculated, and an entry is made in the Log file.
  8. FrameReady Multi site only – The View Log button goes to the Log file and displays the log entries of the activity of moving inventory using the Move Inventory button. This list can be searched (click View menu > Find Mode). It can printed out and can act as packing slip to go with the product when it is physically moved.
    The View Log
  9. Discontinued field allows you to identify if the item is no longer available. You may not wish to delete the record due to having stock in quantity.
  10. Threshold is used to ensure that the product is always in stock. When the amount in the IN field falls below this number, then the amount in the Reorder field will be added to the purchase order created for this company. Company must be identified on screen.
  11. Reorder contains the amount to be reordered when the Threshold falls below the amount in the IN field. When Main Menu > Products file > Create Purchase Order is used, then a purchase order will be created for the supplier identified for this product.
  12. The Activity tab tracks your inventory as it is sold. Date fields can be modified in this layout.
  13. Last Sold is the date when the product was most recently sold on an invoice.
  14. Previously Sold indicates the date sold between first and last. If the date is the same as the first, then the item has only sold twice in its history.
  15. First Sold is the date when the item was first sold. If the two dates below it are the same, this indicates that the item has only sold once.
  16. Received is the date when the item was entered into FrameReady. This field is automatically entered with the current date when you create click on the New Item button.
  17. Qty Sold identifies the number of items sold since inventory was first entered for this item. When items are returned, the quantity sold is reduced. If you are on a specific Site tab (#19) then then all the fields show the information for this site only. The Site # Inventory List View button is also site specific.
    Inventory List View
  18. Turn Around is a calculated field counting the days between the most recent sale dates.
  19. Inventory fields are used to track inventory in each of the different locations that are connected to the network. These fields are automatically updated when an item is sold on an invoice. Site 1 is the main location and is the only site field updated by the Purchase Orders file when new stock is received.


Posted on Carl Jagt in Understanding The Products File Screen