Skip to content

Retail Inventory Stores

QOH/Stats and Main->Housekeeping->Inventory Setup->Inventory->SCW->Store QOH/Stats
Menu: Inventory->Retail Inventory->SCW->Store QOH/Stats

Action: RETLSTOR

This feature is available with the optional ProfitSystem Multi-Store integration ProfitSystem. This feature maintains retail inventory SCW statistics and on hand quantities on a store by store level.

The SCW form will display quantity on hand by SCW with the mult-istore option installed. By selecting the View Stores Statistics button the screen will display sales statistics (MTD, YTD, Totals) and quantities on hand at the store level. ​ This form also provides the variance from what the computer believed to be Quantity on hand to what was physically counted at the last physical (if any) and the date the style, size, color & width was last physically counted. ​ Each store's on hand quantity (QOH) for the SCW may be manually modified on this form. QOH changes will automatically adjust the Receive History to match the manually QOH edit, when different. As an aid for QOH edits, the system display two values in top right corner, 1) Total QOH for all stores (based upon the values entered in this form) 2) Total QOH for receive history (total QOH entered in the receive history).

Note

The preferred method for updating store quantities is via the TRANSFER form. This requires the transfer out and receipt steps and thus provides a great audit trail. Edit store quantities directly on this form bypasses the audit trail, but is a very quick way to correct entry errors. All manual quantity modifications are logged. ​ Hint:The totals shown on the SCW statistics and Statistics Tab are calculated on-the-fly by summing the quantities for each store. ​

Fields

Store...The store where this inventory is located. Click a store in the grid to see a specific store's stats.

Qty on hand...The total quantity on hand at this store. To make a change to this field, double-click on it. If security is enabled (the security option that controls access to this field is HISTQTY) the user will be prompted for a username and password. The total QOH for all stores must match the total QOH for the receive history. When you change the QOH and close this form, ProfitSystem will change the total QOH for the Receive History for this style/size/color/width to match the total QOH here for all stores after providing a warning. For this reason, it is important that he total QOH for all the stores is correct when the Save button is clicked.

With the optional WinTPS rental production module the system warns the user when the manual quantity adjustment makes the total on hand quantity fall below the rental quantity on the Rental Sizes form. The Rental Sizes form show a quantity equal to or less than the total on hand quantity. A user must correct this error condition by increasing the on-hand quantity on the stores form or the Rental Sizes quantity.

Reorder qty...The reorder quantity for this SCW, for this store. Used by the Reorder Report.

Sales statistics...These are the sales statistics for this specific store. The type of statistics are documented in detail on the Sizes form.

Variance from last physical...The total quantity over/under during the last physical. A positive number means that the quantity actually counted during the physical was more than the quantity on hand in the computer. A negative means you counted less than the computer thought was on-hand.

Date of last physical...This date indicates the date that the selected Size, Color, Width was counted for the selected store.

Buttons

Save...Save this session's edits.

Cancel... Cancel / Discard edits.

Delete...Delete the currently selected store's SCW quantities and stats. CAUTION, data cannot be recalled. If unsure, DO NOT delete.

Done...Exit this form and return to previous form.