Inventory Management

AS/AP™ is composed of two independent inventory control systems. Finished Goods Inventory handles the products sold to your customer, while Raw Material Inventory, the component inventory, is related to the Finished Goods Inventory by the Bill-of-Materials.

Several user-defined Excel© spreadsheets can be interfaced with the AS/AP™ Inventory Master file in the form of spec sheets, cost sheets, and style setup sheets.


The Apparel/Sewn Products matrix of Style, Size, Dimension, and Color is reflected in every module of Apparel Sales Order Processing and Finished Goods Inventory Control.

This system is a powerful and thorough implementation of the Style/Size/Dimension/Color matrix common to all sewn products industries.

Sizes are referred to as ‘size buckets’ or just ‘buckets,’ whether they are the quantity order, WIP or shipped.

Finished Goods Inventory

Included in the Inventory Control system is a 12-character alphanumeric Style number, 3-character Color code, 3-character Dimensional code, and 3-character Warehouse. Additional fields of note include: Product Class, Price Code, Season (user-defined field), Stockroom [rack] Location, Standard Pack Notation, Stock Room Locations, and Suppliers Style Number.

The System provides the ability to enter incoming stock from a Cutting Order (manufactured) or a Purchase Order (imported or purchased), and provides an instant query of quantity on-hand by Color and Size, Dimension, location, price, and cost.

Colors are entered using a 3-letter code which can be expanded up to 12-15 character description reports. Colors can be canceled and the orders applied against another color automatically. An individual style can be entered with a virtually unlimited number of colors.

Inventory can be based on last cost, standard cost, or weighted average cost. Selling prices are permitted at 6 price levels with 6 corresponding commission levels.

Raw Material Inventory

Raw Materials Inventory Control is a parallel inventory system intended for manufacturers. The Raw Materials Inventory System tracks everything not covered in the Finished Goods Inventory. The Raw Material is integrated to the Finished Goods and Cutting Order modules through the Trim Sheet (Bill-of-Materials) and to Sales Order Processing through the Material Requirements reports.

Trim Sheet (Bill-of-Materials)

Interfaced to Sales Order Processing, Finished Goods Inventory Control, and Raw Materials Inventory Control the Bill-of-Materials is a list of Raw Materials required to assemble or manufacture a Finished product. Our apparel industry roots cause us to refer to this as the Trim Sheet.

The AS/AP Trim Sheet is size sensitive and can contain any number and combination of fabrics, trims, and supplies.

Spec Sheets

AS/AP Finished Goods Inventory Style file includes an assortment of Specification and Instruction Sheets. These are FoxPro memo fields that can contain any free-form data the company may select. AS/AP™ then provides the ability to edit and print the sheets as necessary.

  • General Instructions
  • Trim Specifications
  • Cutting Instructions
  • Sewing Specifications
  • Finishing Specifications
  • Quality Control Specs

The biggest advantage with the AS/AP Spec and Instruction Sheets is that they take up no space if they aren’t used, and can be of unlimited length for those who need that capacity.

Apparel Inventory Control Reports

  • Cut and Sold by Style Only
  • Cut and Sold in detail by Style/Color/Size
  • Available to Sell Report
  • Finished Stock On Hand
  • Garments In-Process
  • Stock Movement (Current Period & YTD)
  • Price Lists by Style/Color
  • Commission Level by Style/Color
  • Open Cutting Orders by C.O. Number
  • Open Cutting Orders by Style
  • Open Cutting Orders by Contractor
  • Open Purchase Orders
  • Raw Material on Hand
  • Raw Material on Order
  • Raw Material Utilization
  • Raw Material Requirements
  • Minimum Raw Material Levels by Vendor
  • Brief and Detailed Production Grids

Roll-by-Roll/Case/Dye Lot Control

There are two optional Raw Material upgrades that permit the inventory to be layered.

The roll-by-roll inventory tracks fabric by the dye lot and individual roll number. This enhancement offers the ultimate in fabric control and accountability.

The Dye Lot control system is similar to the roll-by-roll tracking, but, tracks the dye lot number and roll count. It is intended as the functional equivalent to the roll-by-roll inventory, for companies who are so inclined.

UPC Maintenance

Visual AS/AP™ has a specially designed group of programs for issuing, tracking, and maintaining UPC codes for each Style/Color/Size manufactured. The AS/AP hang tag program then takes over and exports the data to dedicated label printing equipment to print industry standard hang tags and pin tickets.

Currency Conversion

Effecting only the cost, the currency conversion function converts the Last and Standard Costs ONLY, the Average Cost is maintained at the company’s base currency. The currency conversion function is used to adjust for operation with mixed (different) currencies, and therefore, different rates of exchange.