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
items.
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".
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).