Inventory Management

Inventory - Management menu

Adjust on hand balances for products.
Adjustments are printed on an Adjustments Journal, then updated to Inventory and General Ledger.
A variety of contract prices by customer and product type. Quantity break pricing is available, up to nine levels.
Supports multiple warehouses. Reports may print for single warehouse or consolidated for all warehouses.

Inventory Adjustments Entry Inventory Adjustments Entry
User may adjust the on-hand quantity of any product. A posting will occur to the General Ledger for the Inventory asset account and an user-entered adjustment account.
Also use this program to correct errors in the unit cost of a product by deducting the entire on hand quantity at the current (erroneous) cost, then adding it back in at the correct cost.
Each adjustment is assigned a transaction number. Any transaction may be changed or deleted prior to the Adjustments Journal Update.

Product Alert List
Highlights products that will, after the Journal Update, have negative on hand balance, or will have new unit cost that varies greatly from the current unit cost.

Inventory Adjustments Journal & Update Prints a list of adjustment transactions, then posts to the General Ledger and updates Product records.

Current Prices Entry Current Prices Entry
The user may make immediate changes to price records.
There are Inventory prices, one for each Product in the inventory, Special prices which may override the Inventory price temporarily, and various Contract prices by customer and product.
Provision is made to increase (or decrease) prices by a percentage.
Optional quantity break pricing with up to 9 levels is included.

Future Price Entry
Similar changes may be made to the Future Price file which will not affect current prices, but will subsequently take effect after a price update. This allows for the data entry of price changes in advance of a scheduled company-wide or product-line price increase (or decrease).

Update Future Prices
Run this program on the day you want "future" prices to take effect.

Price Master List
Print records from the Price file, selecting either Inventory prices, Specials prices, or one of the Contract prices.

Product Price List
Prints a list of products and their prices, disregarding any contract pricing that might be in effect for a customer.

Customer Price List
Prints a price list specific to one customer, taking advantage of all contract prices established.

Contract Price List
Prints a price list specific to one customer (contract) group, taking advantage of the contract prices established.

Stock Status Report Inventory Stock Status Report
Prints the current availability for each product.
Sort by Product Number, class, vendor, or category.
May exclude products with no activity.
Print for one warehouse, or combined for all warehouses.

Valuation Report Inventory Valuation Report
Print the current valuation (on-hand times unit cost) for each product.
Sort by Product number, class, vendor, or category.
Select Detail, Summary, or Total format. Detail lists every product, summary lists only class, vendor, or category subtotals.

Commitment Report Inventory Commitment Report
Lists the details of all pending outgoing and incoming transactions for active products.
Sort by Product number, class, vendor, or category.
Highlights those products that may go below their minimim stock level, or to a negative stock level.

Aged Inventory Report Aged Inventory Report
Based on FIFO or LIFO, calculates the age of remaining inventory on hand and prints the dollar value of that stock in aging brackets.
Highlights products that are tying up dollars that could otherwise be invested in other parts of the business.

Backlog Report
Prints a summarized look at outgoing and incoming transactions for active products over the next eight user-defined intervals.

Cash Flow Report Inventory Cash Flow Report
Prints a net anticipated cash flow from inventory over the next eight user-defined intervals.

Non-Stock Report
Lists sales of non-stocked products over a user-specified period. Use to evaluate adding products to your finished goods inventory.

Card-X Report
Prints a detailed list of historical outgoing and incoming transactions for each product.
User may specify a product range and a date range.

Unit Number Status Report
Prints the stock status for only products with serial- or lot-number control. Lists individual serial numbers and lot numbers.

Equipment Service Report
Prints list of invoice lines that apply to warranty records for specified products. Used to evaluate service performed on serial-numbered products.

Product QuickView
Same program as on the QuickView menu.

Adjustments QuickView
View any Inventory Adjustment transaction from the past 36 months. Lookup by transaction number.
Drill down to view products on the adjustment.

Adjustments Journal QuickView
View any Inventory Adjustment Journal from the past 36 months. Lookup by Journal Number or Posting Date.
Drill-down to view products on any journal..