DNA/IM
– INVENTORY MANAGEMENT
The inventory management module interfaces
with the purchasing, job cost, order entry, point of sale and general ledger
modules. Information is only entered once and is immediately reflected in all
other affected modules.
Products may be "looked up" by identifying
a part of the item number, by part of the description of the product, by part
of the category of the product, or by part of the supplier's part number.
Products may be purchased from multiple suppliers with the most recent
identified first.
Inventory is tracked on a FIFO basis. As
purchase orders are received, they are put into inventory at the purchase order
cost and a liability recorded for that amount. When the payables invoice is
received, it is matched to the
Inquiry screens provide sales and cost
information for as many year's of data as is maintained on the file. Committed
inventory is tracked and used to provide purchasing reports with suggested
"buy" quantities to satisfy stocking levels and confirmed orders and
jobs. Inquiry screens also provide movement information by fiscal period
including an estimated "out of stock" date based upon sales history,
and a movement detail that tracks each movement of inventory including
associated costs.
Physical counts may be conducted without
shutting down the operations. Cycle counts are easily handled by class or
category or for specified products with the option of clearing all items not
counted to zero.
Velocity reports track your best products by
quantity, sales dollars or margin earned. Many other reports have been created
to provide you with the information you need to maintain inventory levels for
the best customer service possible within the financial constraints of the
organization.
The pricing module permits unlimited special
price books that contain any quantity break-level you want for that customer.
Retail pricing can be established by a gross margin percentage desired, or the
price specified and the gross margin will be displayed. Cost of inventory is
tracked to purchase cost, landed cost (includes foreign exchange conversion,
freight, duty and any management fees), and last received cost (includes any
adjustments to the previous purchase order cost adjusted to actual landed
cost).
New pricing can be established for a
product, a class of products, or a category of product (a category is a group
of classes) as at some future date. Price changes can be specific, or a
percentage change rounded to a nearest specified decimal dollar - ie. nearest
.50 or .99 etc.
Cost changes may be imported from media
provided by your supplier.
No end of period or end of year processing
is required until you wish to remove the movement records from the file. All
reporting is based upon the corporate fiscal calendar, and the number of years
of inventory information may be maintained separately from the number of years
of general ledger information.
As with all DNA systems, any report may be
exported other third party software for further processing or presentation.
|
Data Entry |
Reports |