Inventory Management

Multi warehouse. Inventory supports any number of warehouses. The system provides On Hand quantity and monetary values by Warehouse. When Sales Orders is installed these values are provided by Warehouse for Quotations, Sales Orders Allocated and Sales Back Orders. When Purchase Orders is installed these values are provided by Warehouse for Purchase Back Orders.

Fully integrated with Sales Orders and Purchase Orders ... but can also run as a stand-alone module. In either case, direct transaction entry of Receipts, Issues and Transfer transactions is also supported. Issues generated from Sales Invoicing are reflected in Inventory together with their sale value. Receipts from Purchase Orders are reflected in Inventory together with the applicable cost data from the Purchase Order..

Easy transaction entry. When entering transactions directly or through the other modules, you can either specify a Product by entering its Product code or simply select it from the Product table using the lookup help feature which is always available. While entering transactions you can browse through all of them and make any corrections required. Pre-posting listings are available. Transactions are not Posted until your request. You can Post an individual transaction or you can Post a group of transactions.

Transaction importing. Transactions generated externally can be easily imported. All you need to do is insert them into the Import tables of the Inventory. This may be done by any process that can write to these database tables. Valid transactions will be accepted and removed from the Import tables. Invalid transactions will remain in the Import tables with errors identified so you can easily correct and resubmit them.

FIFO or LIFO costing. Issues are applied to Receipts on either a FIFO or LIFO basis and the FIFO or LIFO average cost recalculated.

Full Product movement history. All transactions are cross-referenced and are retained on-line until you archive them. Active Receipts and Issues (e.g. unapplied issues) may be viewed directly with the option to instantly view the full Product movement history. There is no limit on the number of Active and historical transactions that are maintained.

Multiple Product Groups. Any number of Product Groups can be specified. For example, separate groups for Standard Products, Special Products and Parts could be set up. Products inherit the defaults for their Group. Interactive queries can also easily summarize information by Group.

Easy report changes. All reports are based on a visual report designer so they can be readily changed.

Easy queries and analysis. You can use the full power of other database query programs to resolve even the most complex relations between Products, Customers, ShipTos, Suppliers, SalesReps, States, Countries etc.