Inventory Scw

Setup->Inventory->SCW (size,color,width)
Menu: Inventory->Retail Inventory->SCW (size,color,width) button

Action: RETLSCW

ProfitSystem® tracks inventory on style and size/color/width levels for each store in your chain (available in the optional multi-store version). This capability include maintaining a complete receiving and inventory movement history.

This allows for statistical information at each of these levels allowing the user to easily know how many of each size sold, how many are owned, when it was received, etc, at each store location.

There is a SCW size description called OTHER. OTHER is a system defined SCW. Each inventory style contained within the system will have a SCW called OTHER and it’s entry cannot carry a quantity on hand. OTHER cannot be deleted or edited and is automatically created by ProfitSystem® when a new store style is created. Price tags should not be printed for the size OTHER.

The OTHER SCW is a used by the system to hold sales information about the style it is assigned to. An option within ProfitSystem® is the ability for a operator to sell any size or color or width of a entered inventory style, even if that size or color or width is not found under the inventory style. Basically the operator is allowed to enter ANY size, color or width for the style when that option is set within General Setup. This is called an un-validated entry.

DO NOT add an another size called OTHER when adding new SCW items. Quantities of ANY SCW with a size called OTHER will be automatically deleted by the Physical Inventory module.

All retail sales statistics are accumulated under the SCW OTHER in the instance that the Housekeeping->General Set-up->System Store/Set-up Option Tab in Tickets Section ‘Allow the sale of item not in inventory (checked = YES) and the operator sales an item on a Ticket with a Size or Color or Width that is not in the inventory file for that style.

Fields

Size, Color, Width, QOH grid...Using this list grid you can select the size, color, and width you want to work with. The last column is the quantity you currently have on hand. This quantity is maintained automatically. It is the total of the QOH for every Receive History entry for this size/color/width. If you need to manually change the QOH, change the QOH via the Receive History form.

The colors are all shown in the color column, separated by /'s. If there is only one color, no / is shown.

Receiving History grid...This grid shows the receive history for the selected size/color/width. You can select an item and click the Edit Receive History button to display the Receive History (RETLHIST) form which shows all the details for the receive en try.

SKU...The SKU is automatically generated when you add a new SCW using the Add New SCW button. You can also edit it here. At sale time you can enter the SKU on the Ticket form to sell the item.

Barcode...The barcode uniquely idenfies the item and is automatically assigned by ProfitSystem. You cannot change the barcode. At sale time you can enter the barcode on the Ticket form to sell the item.

Bar-codes should have a even number of digits.

Note: tags with barcodes for reading with barcode scanners should barcode this barcode number. The barcode number is automatically generated by ProfitSystem® with new inventory style/size/color/widths are added.

Note: If the barcode number generated by ProfitSystem™ is not an even number of digits, contact BBL for support. Barcode number are more flexible when they contain an even number of digits.

UPC...You can enter the UPC code of the item here if you wish. At sale time you can enter the UPC code on the Ticket form to sell the item.

Average Unit Value... The system will automatically calculate the per unit average cost for this SCW item utilizing the System Setup-> Other Settings-> Inventory Costing LIFO / FIFO setting. The formula is simple:

QTY Left x Unit Cost (for each receiving history) / Total quantity on hand

Qty on Hand...Total quantity on for the selected Size, Color, Width of this style.

Qty on stock orders...This will show your total quantity for this style, size, color, and width that is outstanding on stock purchase orders.

Reorder Quantity... When your quantity on hand falls below this number, you typically reorder. This is used by the Reorder Report, at Main->Reports->Inventory Reports->Reorder (RP_INVRE) to show you the items you should reorder. The quantity entered here will supersede any quantity entered in the Reorder field on the Style - Details Tab. The Inventory Reorder report will list styles SCW items that the Quantity on Hand has fallen below the Reorder quantity.

Date of Last Physical...This is the date of the last physical that counted this selected Size, Color, Width inventory item.

Attributes...Each size code can have up to five attributes. By default, the first attribute is the Color Family. The attributes are optional. They are used on the F5 Inventory Search. The Color Family is used by the Color Breakdown Report. The attributes can be configured at Setup->Retail Inventory->Attributes.

Checkbox Show in Web Catalog? (checkbox)...This indicates to the system to create a HTML (web) page for this Size, Color, Width item when the Create Web Catalog function is ran.

Buttons

Print button...Allows you to print price Tags for the selected inventory item. At least one inventory Tag must have been created in the Housekeeping->Letters/Tags/Mailing program. When clicked, a list of the Tags that are set up for printing will be displayed for one to be selected. When a single inventory tag is defined ProfitSystem© will print it automatically. Also, for items that have a quantity on hand greater than one the system will stop and ask you for the number of tags to print. Just enter 1 or the total quantity to print.

Add Qty for this SCW button...Click this button when additional inventory quantities for the selected size/color/width should be added. ProfitSystem will display the Receive History form so you can enter the quantity received, date received, PO number, and other relevant information. Remember, you cannot change the QOH directly on the RETLSCW form, you can only affect the QOH by adding Receive History entries, or changing existing receive History entries.

Edit Receive History button…Displays the Receive History form for the selected entry in the Receiving History grid.

Add New SCW button...Allows you to enter a new size/color/width. Actually displays the Receive History form so you can enter the size/color/width, quantity on hand, quantity received, date received, unit cost, etc. When you are entering a new SCW, you should always enter at least a size code. Even if the item does not come in sizes, use NA or NONE. A size, color, or width code can only contain letters, numbers, and $, %, *, -, +, /. It cannot contain “, ‘,[ or ].

Transfers... Optional multi-store module feature. Creates a transfer document for the currently selected SCW item.

Store QOH / STATS... Optional multi-store module feature. Allows operator to view each store's sates statistics and view/edit each store's quantity on hand.

Delete...Deletes the currently selected SCW record, it's receiving history and store stats. Caution, data cannot be recalled.

Save... Save the edits.

Cancel... Cancel / Discard session edits.

Done... Exit to previous from.

Rental Inventory Hint:The WinTPS Rental Production Management software option cannot designate any style as an rental style if the style has a color or width entered.