Inventory/Warehouse System

The GSS inventory software ties in with GSS's SSMS database, and allows quantity on-hand and cost to be tracked for selected Inventory Filesitems. The inventory locations can be a store or stores, or a separate location where items are stored. The main processes involved in this application are:

Inventory Reduction - Inventory is reduced via daily/weekly scan movement, or via store orders/transfers. Store orders received at an inventory location generate a "picking ticket". Too much confusion Let GSS make life easier...Once items are selected from the location, the picking ticket quantities are updated to reflect actual ship quantities and an invoice is printed that identifies the cost of the order to the store. We have developed a Telxon interface for store orders. The Telxon software allows store orders to be sent directly to the AS/400 via a standard communications line. We can easily support other hand held order devices based on customer requirements.

Inventory Replenishment - Inventory is added to via open orders, and/or back door receiving invoices. Open orders are setup with an expected delivery date and a list of items ordered. The cost and bill-back dollars on an open order are established on entry. Open order receive quantities are adjusted when the product arrives at the back door. At this point inventory is updated and the order is sent to accounts payable.

Inventory Shrink Adjustments - This process allows items to be counted on the floor, with the new counts updated to the inventory database. A report is generated that identifies by department inventory adjustments. The report shows count adjustments as well as net dollar adjustments (using last cost or average cost).

All quantity and cost changes processed through the system are recorded historically in an invoice format. The software allows balancing of current quantity on-hand to the cumulative total of the historical invoices. In addition it is possible to display/print inventory QOH and dollar value for previous periods (using the historical transaction history).