Maintenance Application
73
The Parent / child fields are used to link items together for inventory tracking. For example, you purchase cartons of 200 cigarettes, packaged as 8 packs of 25 cigarettes each. The cigarettes are sold by both the carton and by the package. You therefore need to create 2 items with separate UPC codes so that they both affect a common inventory level. Here is an example for parent - child
·Create item 1111111111 (the UPC code for a carton of 8 packs of 25 cigarettes of Brand A).
·Set this item 1111111111 to track inventory in the inventory tab. Set the minimum and reorder quantity to the desired level.
·In the cost tab select the vendor and set the quantity per case as 1 with a case cost of $24 (for our example of course you can set your real cost here...) Enter the vendor item code if required on your system. This is the warehouse number for the product. Set the default vendor flag if not already selected.
·In the Price tab, set the price of item 1111111111 to sell as a carton. For example, 1 quantity for $32. ·Now create item 2222222222 to be able to sell a package of cigarettes of Brand A.
·Price the item 2222222222 to sell for $4.25 for one pack. ·Item 2222222222 would not be set to track inventory. ·Item 2222222222 will have Parent - child set to Active.
·Below the active you will enter the item number of the parent product. In this case that field will be set to item 1111111111 which is the code for the carton of Brand A.
·The parent item would be set to 1111111111 (UPC code of carton Brand A.)
·The quantity in the
Now you will able to sell both packages or cartons and reduce inventory for the same item.
NOTE: You can also decide that you want to maintain the inventory in packages, not in cartons of cigarettes. In that case you would program the cost on the package of cigarettes (item 2222222222) as follows: Vendor xxx, units per case would show 8, cost per case would show $24 (as above) and the vendor item code would be the same as before. Then you would set the inventory to be tracked on this item. The " parent - child " relationship would be set to active on the carton (item 1111111111) with a quantity of 8. This means that when a carton of cigarettes is sold, it will remove a quantity of 8 packages from stock on hand. So you are still purchasing cartons of 8 packs of cigarettes and both the carton UPC and the package UPC will be reducing the same inventory.
4.6.1.8Sales Tab
Item (PLU) Maintenance: Sales Tab
The Sales tab is available to view sales of this item for the last 7 weeks. If there is no weekly closing for the last weeks, the Maintenance application shows a warning message asking if you have run the MAKEWEEK command. Normally, the daily, weekly and monthly closing commands are configured as events in the Events / Tasks manager at installation to run automatically at appropriate times.