Task 07 - Inventory Tracking - Sub-Task 1 Warehouse tracking master maintenance WTKMNT

In Inventory Control (module 5), Warehouse master (Task 19) each item has a picking sequence. This picking sequence is the spot the item is located in the warehouse. When you receive the merchandise it should be put away in this picking sequence. When you sell the item it should be physically taken out of this picking sequence. Sometimes the warehouse picking sequence doesn’t have enough room for the inventory. In this situation the excess inventory is kept in another reserved area in the warehouse. The inventory tracking system allows inventory to be moved from a “picking sequence slot” to a “reserve slot”. This is a way to know where the excess inventory is located.

The inventory tracking system posts a date & time (down to seconds) of when an item is received. The inventory tracking system assumes when inventory is sold it is physically taken out of the oldest receiver. This gives the current quantity on hand from each receiver. So the inventory tracking system can be a valuable tool even if “reserve slots” aren’t used.

The inventory tracking system is located in Inventory control (module 5)

Inventory tracking (Task 7)
- Warehouse tracking master maintenance WTKMNT (Sub-task 1)
- Move inventory WTMENT (Sub-task 2)
- Print warehouse bin labels BINLAB (Sub-task 3)
- Slot master maintenance SLTMNT (Sub-task 4)
- Empty / negative slot report SLTEMT (Sub-task 5)
- Drop Overstock report SLTDRP (Sub-task 6)
- Purge zero qty tracking master records WTPURG (Sub-task 7)

When a P/O module receiver is posted, a new transaction is posted into the Warehouse tracking master maintenance WTKMNT (Sub-task 1).
When Sub-task 2 Move inventory WTMENT is posted a new transaction is posted into the Warehouse tracking master maintenance WTKMNT.
When an order processing customer order is invoiced, the picking slot transaction is updated in the Warehouse tracking master maintenance WTKMNT.
As in all Profits Plus maintenance files this has sub-tasks:

· 1 Enter new Slot record

· 2 Change existing Slot record

· 3 Delete existing Slot record

· 4 Print Selected Slot records

· 5 Erase selected Slot records

· 6 Sort existing Slot records

· 7 Adjust size of Slot file

· 8 Update slots from import

· As in most maintenance files there shouldn’t be any reason to go into any of these sub-tasks on a normal daily basis, except 4 Print selected slot records.

· Sub-Task 4 Print selected Slot records

o This report can be printed to see where an item is & how many in each slot. For example:

§ Print report by: 2) item # / warehouse # / datetime added.

§ Please enter – starting item #: 10061

§ - ending item #: 10061

§ Please enter – starting warehouse #: 01

§ - ending warehouse #: 01

§ Please enter datetime added: Enter key for ALL

· This report will list all the slots for this item.

· Each slot will have the current sell-by & stock-by quantity.

· The totals for each item should match the I/C Warehouse master (Task 19), on hand quantity (Field 3)

· This report can be printed to do a physical inventory. The best option is to export this report & open it in a spreadsheet.