Inventory Control

The manufacturing system is driven by your inventory. Jobs and POs are generated in response to each item's net demand relative to stock on hand. Without accurate on hand quantities, it is not possible to plan jobs and POs efficiently without shortages, over-stocking, high expediting costs, and late shipments. DBA gives you the tools and processes you need to ensure the accuracy of your inventory, which is an absolute requirement for achieving lean manufacturing.


Locations - Manufacturing efficiency is enhanced when you can store and track inventory in multiple locations. Locations can be shelves, bins, bulk storage areas, work centers, and receiving areas. At the item level, you can specify a default receipt location and primary storage location, as well as other allowable locations. Items can be transferred from one location to another within the Stock Transfer screen.

Lot/Serial Control - In the Lot/Serial Control screen each item can be designated for lot control, expiration date tracking, serial control, and revision tracking. Whenever stock is received, picked, issued, or transferred, you must enter or select the item's tracking characteristics. Serial numbers can optionally be generated automatically by the program.

Stock Counts - Stock counts for cycle counting or physical inventories or stock takes are entered on this screen. First you select the items to be counted, then you print out the stock count worksheet, which is used to make and enter the actual counts. The actual count quantities are entered in the Stock Counts screen. Any variance between the on hand quantity and count quantity is calculated and posted to your inventory adjustments account.

Item Labels - Manufacturing companies often have special item labeling requirements, not only for internal identification and stock tracking purposes, but to comply with customer or legal requirements as well. An unlimited number of custom label formats can be created. Item labels can be generated as needed at time of PO receipt and job receipt prior to receiving items to stock or shipping items to customers.

Workflow Processes - Inventory gets updated within four processing screens - PO Receipts, Job Receipts, Job Issues, and Order Picking. In most cases you can use the 'pre-fill' option to update all the line items in a single step.

Dispatching - A unique feature in DBA is inventory dispatching. When a work center supervisor needs raw material or components to run a job, he or she can dispatch the items on the screen first and then print a dispatch list that is given to the stock person to use for gathering the items from specified locations. Dispatching gives you real time inventory updating and is ideal for lot control and multiple location environments.

Inventory Value Report - This report enables you to list your current inventory value or the value as of any past date. You can subtotal your inventory by item category and the report can be limited to the change in value between two past dates.

Data Views - Data views enable you to create your own custom reports in a spreadsheet format. You can sort, filter and report on your stock items, stock on hand, and inventory transactions, including lot and serial number traceability.