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.

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 in the Stock Transfer screen.

Lot control is a must for many manufacturers and in some industries, a legal requirement.

On this screen each item can be designated for lot control, expiration date tracking, serial control, and revision tracking.

Here we are looking at the Job Receipts screen. 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, as you see here.

Stock counts for cycle counting or physical inventories or stock takes are entered on this screen.

First you select the items to be counted on this screen.

You then print out the Stock Count Worksheet, which is used to make and enter the actual counts.

You then enter the actual count quantities on this screen. Any variance between the On Hand quantity and count quantity is displayed in this column.

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.

You can create an unlimited number of custom label formats on this screen. 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.

There are four processes where inventory gets updated - 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 process.

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 stockperson 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.

A variety of reports and data views enable you to assess your inventory

The Inventory Value 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 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.

Here we are looking at the transactions by Lot/Serial data view.

Does your company suffer from chronic shortages, over-stocking, high expediting costs, and late shipments? This does not have to be so. 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.