Stock Adjustment (IA) Transaction Type

The Inventory Adjustment (IA) transaction provides the ability to manually adjust inventory levels.

A stock item on the Inventory table may require manual adjustment during the period physical verification of inventory availability. The adjustment may result in the:

• Increase or decrease in On-Hand Quantity

• Increase or decrease in cost

• Increase or decrease in On Hand Quantity and Cost  

The Inventory Adjustment (IA) transaction allows warehouse management to adjust quantities or unit values of on-hand items due to a change in on-hand quantity or unit cost.   

The Internal Inventory Adjustment (IIA) transaction provides the ability to:

• Add internally manufactured items to inventory with a single transaction.

• Record cost for the receiving party and reimbursement for the manufacturing party.    

• Record adjustments to internal inventory to reduce or increase inventory quantities or costs during periodic inventory reconciliation.

Internal Inventory Adjustment (IIA) transactions are limited for use with stock items marked as Internally Manufactured on the Inventory Maintenance (INVN) table. This transaction cannot reference any transaction in the system nor be referenced by any other transaction.  

Quantity and Unit cost cannot be modified at the same time unless the transaction is initializing inventory balances. If unit cost is decreased, the new extended cost assumes the new unit cost for all of the items. The extended cost is updated to the average of all items. The IIA adds to the current Unit Cost instead of replacing it. The IA transaction code changes extended costs for all items, using the current extended cost and adding the new inventory and quantity to it.

The Inventory Correction (IC) transaction provides the ability to adjust all inventory levels that do not impact the On Hand Quantity. The following fields can be adjusted by the Inventory Correction (IC) transaction:

• Reserved Quantity

• Released Quantity

• In Transfer Quantity

• Backorder Quantity

• Currently Requested

• On Order Quantity

The Inventory Correction (IC) transaction provides the ability to adjust quantities not available on the standard Inventory Adjustment (IA) transaction. The Inventory system tracks all movement of inventory from the time it is requested to the time it is received and then issued.   

This transaction should be highly secured and limited to a handful of warehouse managers.  While this transaction has not accounting impact, changing the different quantities without verifying why they are not correct can cause downstream transactions not to process correctly if modified or cancelled. The intention of this transaction is to be used as a last resort when there is no other way to correct one of the aforementioned values. This transaction provides an audit trail for such changes.  

The Inventory Correction (IC) transaction cannot reference any transaction in the system nor be referenced by any other transaction.

The Inventory Location Change (ILC) transaction provides warehouse management capabilities by facilitating the movement of inventory from one location to another.  The ILC transaction has the Header, Commodity, and Commodity Details tabs similar to the other IA transactions. The Accounting tab does not exist for this transaction, because the fields updated do not change the On Hand quantities on the Inventory Maintenance (INVN) table or have any inventory related accounting effect.

This transaction cannot be modified or cancelled. Another ILC transaction must be created to reverse the effects of the original transaction.

The ILC transaction performs the following:

• Reduces the On Hand Quantity on the Inventory By Location (ILOC) table record on the source location by the quantity specified.

• Increases the On Hand Quantity on the Inventory by Location (ILOC) table record on the target location by the quantity specified.

• If Detail Information Required is selected on INVN, the system performs the following additional updates:

• Reduces the On Hand Quantity on the Inventory Maintenance Detail (INVND) table record on the source location by the quantity specified.

• Creates a new entry on the Inventory Maintenance Detail (INVND) table using the details from the source INVND record for the quantity specified.

An overridable error is issued prompting the user to furnish a Warehouse (WHSE) code, when the commodity used is an Inventory item and the Event Type is Consumption.

The Inventory Adjustment Cycle Counting (IACC) transaction provides the ability to adjust the inventory levels as a result of a physical count. IACC transactions are generated as a result of the Physical Inventory Reconciliation Posting process that reconciles the system’s on-hand quantities with the actual quantity that was counted. IACC transactions are only created through the Physical Inventory Reconciliation Posting process and cannot be created from the Transaction Catalog. The IACC displays the Event ID of the count that created it on the Header. By nature, each IACC transaction can only contain one Stock Item, but this can include multiple lines for adjustments to different Warehouse Inventory Locations and/or Item IDs. Each IACC Commodity record, or if Detail Information is required - each IACC Commodity Detail record, is related to an individual Inventory Freeze (INVF) record by Event ID, Warehouse, Stock Item, Location Structure, Inventory Location, and, for Commodity Detail records, Item ID.

The IACC transaction performs the following:

• For items where Detail Information is not required:

• The quantity on an IACC Commodity line must equal the change in quantity required to make the adjustment for the related INVF record.

• For items where Detail Information is required:

• The quantity on an IACC Commodity Detail line must equal the change in quantity required to make the adjustment for the related INVF record.

• Increases the On Hand Quantity on the Inventory By Location (ILOC) table record by the quantity specified.

• If Detail Information is required, the system performs the following additional updates:

• Increases the On Hand Quantity on the Inventory Maintenance Detail (INVND) table record by the quantity specified.

• When a Commodity or Commodity Detail line is removed from an IACC, either by deleting the individual line or discarding the transaction, the related INVF record has the Reconciliation Transaction link cleared and the Reconciliation Required flag set to Yes.

• An IACC transaction cannot be submitted or finalized if any INVF records for the same Event ID, Warehouse, and Stock Item have Reconciliation Required set to Yes or there is no value in Actual Quantity.

• When an IACC transaction is submitted or finalized, all records for the same Event ID, Warehouse, and Stock Item will be removed from INVF.

• If Detail Information is not required, the INVF records will be copied to Inventory Freeze History (INVFH), and Item Transaction History (ITH) records with a 0 quantity change will be inserted for any of those that have no discrepancies.

• The Adjustment Code used on an IACC must be Yes for both Use for Reconciliation and Inventory Adjustment Cycle Counting on the Inventory Adjustment page.

Please refer to the CGI Advantage - Inventory Run Sheet Guide for more information on the Physical Inventory Reconciliation Posting process.