|
|
|
Inventory Control Features |
|
| " The FDM4 Inventory Control module is updated by the FDM4 Purchase Order and FDM4 Order Entry modules as inventory is received into and sold from multiple warehouses.
FDM4 Inventory Control module is used to make direct adjustments to warehouse stock balances and costs, to transfer and configure items, and to perform physical inventory counts. " |
|
- Allocation Maintenance by Item or by Order
- Inventory Adjustment procedures
- Inventory Cost Adjustment procedures for updating costs layers for items created for goods purchased and vouchered.
- Inventory physical count procedures
- Multiple Price category capability for item pricing setup. This would allow the company to utilize multiple price lists (e.g., wholesales and retail) when pricing items. The Price category is set on the Customer's account, therefore, when the Customer places the order, the price category will determine what price list they will have their orders priced from.
- Within each price category, each item can have up to 10 different price levels set. The price levels can be used to set quantity breaks for Customers ordering a certain volume of goods, or can be used to set levels that the Customer will receive. The level will be determined by the Customer Price Code level file that is set up for the customer in the reference files.
- Calculation procedure to allow automatic update of item pricing based on user defined formulas
- Extensive reporting and inquiry functionality
- All inventory is updated in real-time when goods are received or shipped out since the inventory control module is fully integrated with the Order Entry and Purchasing Modules
- Inventory Control Module is also fully integrated with the General Ledger modules, therefore all G/L postings resulting from movement of inventory is reflected in the G/L once the update procedures are run to post the sub-ledgers to the G/L.
Ability to handle items that are:
- Inventorieds
- Non-Inventoried
- Non-Stocking
- Serialized
- Lot Numbered
- Detail PO audit
- Decimal Quantities
- Multiple Units of Measure can exist for a single item. Each area in the system is set up with a default unit of measure that is used (purchasing, stocking, sales, etc.), but alternate units of measure can be set up critical. Each unit of measure has a Conversion Factor that will be used to recalculate costing on items where necessary.
- ABC/13 inventory classes category report
- Automatic calculation of 13 inventory classifications
- Unlimited comment lines for many different types of comments can be stored and printed
- Unlimited substitute items
- Tracking of sales of non-stocked items (catalogue items)
- Stores FIFO, LIFO, weighted average, standard cost, default cost, and landed cost
- Item reference file can include weight, volume, cubic measurement, unit of measure, manufacturer, and product code
- Allows item companions to display associated parts in order entry
- Items can be designated as lot control with an expiry date
- Items can be serialized with serial number and lot control
- Accommodates lot costing and lot tracing for non serialized items
- Kits can have multiple configurations with different item numbers and different quantities of items per configuration
- Kits can be serialized, non serialized, inventoried, or non inventoried
- Stock kits can be assembled and disassembled
- Multiple tax designation by item can have multiple configurations with multi level bill of materials per configuration
- The selling price of a kit can be categorized in a number of different price categories at the same time. i.e.: In price category 1 the kit could have 1 - 10 different price levels; in price category 2 the kit could have 1 - 10 different price levels based on volume quantity sold; in price category 3 the kit could have 1 - 10 different price levels calculated on a base price (the base price could either be a cost price or a selling price); in price category 4 the kit could have a price catalogue which would display six price levels on the screen - selected by the order entry clerk at time of order
- When a kit is sold it will display and list all of the items that make up the kit with the corresponding quantities of each item
- Detail sales and purchase summary by item
- Calculates inventory shrinkage per item, adjusts the on-hand balances and value of each item, posts the necessary accounting entries, and produces a control repor
- Primary vendor and unlimited alternate vendors per item
- Built in cross-reference item file to allow each vendor and each customer to have a different part number for your inventory part number. This cross reference file will also accommodate customized item descriptions per vendor and customer with different units of measure
- Accommodates the cross reference file obsolete item numbers automatically directing to alternate item numbers
- Accommodates item number changes to reflect all sales history information
- The cross reference item file will accommodate the EDI matching for trading partners
- Automatic price updates
- Various formulas for updating price and cost rollups
- Multiple price levels per foreign currency
- The system can also store contract pricing by customer and catalog pricing
- Inventory item movement inquiry by warehouse for any range of dates displaying all customer shipments and returns, all vendor shipments and returns, and all warehouse adjustments and transfers
- Warehouse transfer for serial and lot numbered items
- Electronic ledger card for all movement for all warehouses
- All inventory books are stored with scheduled or completed status
- Inventory listing by vendor
- Landed cost tables can be stored by alternate vendor by item
- Multiple costs per vendor on the same item with effective dates
- Standard purchase quantity and lead time by vendor by item
- Allows posting cost of accrual items received not invoiced
- Inventory cost reconciliation using cost layers
- The calculated reconciliation amount can be posted to any period
- Cost reconciliation for items that have been sold without a cost price known and will reconcile these costs when the vendor invoice is entered against these items received to stock
- Performs cost reconciliation based on items shipped before cost was known, non-serialized items where cost was adjusted after cost of goods was used, and serialized items with cost of goods not equal to actual cost
- Item availability report by warehouse
- Authorized path of replenishment indication code in the inventory reference file in order to maximize warehouse transfers and volume purchases
- Order point, line point, and EOQ (Economic Order Quantity according to Gordon Graham) by item by warehouse
- Last, previous, and average lead times by item by warehouse
- Safety stock by item by warehouse
- Seasonal items by warehouse with start of month and length of season
- Detail inventory cost layers by item by warehouse
- Serial number tracking receipts and shipments by warehouse
|
 |
| |
|
|
|
|
|
