Inventory Ovwerview

You can maintain information about your inventory using this module. In addition to setting up a standard inventory by physical product, you can maintain inventory-type records for non-inventory items such as labor, freight, or disposable parts. CAS Accounting Series II & III allows you to begin with a few pieces of this information so that you can later expand it to be a full-fledged inventory system when you are ready. The summary below shows several options for implementing the CAS Accounting Series II & III inventory control system: If you want no formal inventory control, you can run CAS Accounting using vouchers and not make use of the invoicing and purchase order facilities of the system.|


If you do plan to use sales orders, Invoice modules and purchase orders to reflect your transactions but do not need to track units on hand assign product codes with prices and sales accounts in Inventory Control. Mark your products as N (non-inventory) types. You can handle a combination of physical inventory items and non-inventory items on a sales order or purchase order with a standard price associated with each. (You also have the opportunity to alter the price on a sales order for any line item.) You can implement a price matrix for your inventory. Use of a price matrix will allow you to assign multiple price levels. The level assigned within the customer record can then be used to determine the product or service price to a specific customer.


The CAS Accounting Series III Sales Order module can use the inventory file to maintain information on backorders and reserving units for specific orders to be filled at a later date. CAS Series II does not have backordering.
If you would like to track inventory items for multiple locations, you can keep a count of the units on hand at each site or run each location as a profit center. CAS Accounting keeps a separate record of open sales orders, backorder items, reserved items, and purchase orders to be received for each inventory item at a location. CAS Series II does not have multiple location.
After you have set up your inventory records, the transactions from other parts of the CAS Accounting Series II & III system are automatically reflected in your inventory history. In the same fashion, when you make adjustments to the inventory record after you have made a physical inventory, your changes are automatically posted to the appropriate General Ledger accounts.
The Inventory Control module contains the program options below. Immediately following is an overview of the program operations.

A- Enter/Chg Inventory
B- Print Price List
C- Print Sales Info
D- Print Avail/Ord Info
E- Print Physical Check
F- Print General Info
G- Adjust Levels to Phys
H- Enter Price Matrix
I- Print Price Matrix
J- Global Price Change
K- Enter Change Product Classes
L- Print Product classes

A- Enter/Chg Inventory
This program will add, change or delete records from the inventory file. Records cannot be deleted if any on-hand or units-on-S/O values remain.
B- Print Price List
This program will print a price list including product code, description, last cost, and profit margin (gross margin) percentage. it can be limited by product code, category, and class.
C- Print Sales Info
This program will print sales by product including product code, description, units sold, gross sales, cost of goods sold, net sales, and percentage net/gross. Amounts are month-to-date, year-to-date, last year, and variation of this year to last year. This report may be limited by product code, category, and class.
D- Print Avail/Order Info
This program will print the availability and order history for inventory products. The report includes product code, description, units on hand, units on sales order, total units (units on hand + units on sales order), total value, reorder level, units on order, and date of last order. You can limit this report by product code, category, class, and units below reorder level.
E- Print Physical Check
The program will print a list of inventory items and the number of units that should be on hand. A blank space is provided for the actual count to be recorded during an inventory check.
F- Print General Info
This report is a useful detailed summary for the requested inventory items. The report includes all of the general information entered in the inventory record in IC-A.
G- Adjust Levels to Phys
Use this program to adjust the units on hand or cost/unit for an item. The appropriate G/L accounts are automatically updated. Normally, you would run this program after taking a physical inventory count, but you can make adjustments at any time.
H- Enter Price Matrix
This program allows you to define discount percentages or a set of fixed prices for products.
I- Print Price Matrix
This program prints the information entered in IC-H.
J- Global Price Change
Use this program to change the price for a set of products rather than having to make a similar change to individual inventory items. You can limit the range of the products you want to affect by specific product code ranges as well as category or class ranges. You can increase or decrease prices by a flat amount or by a percentage.

 

Any Questions Please contact us at Computer Accounting Solutions
1-800-358-4222

horizontal rule