QAD 2017 Enterprise Edition > User Guides > Sales > Customer Consignment Inventory > Managing Consigned Inventory > Creating Inventory Transaction History
  
Creating Inventory Transaction History
Every inventory transaction creates a record in inventory transaction history. Each record has a unique, sequential transaction number and a transaction type. Transactions include the following information:
• Transaction data
• Inventory data
• Cost data
• GL transaction data
• User ID of the person entering the transaction
Customer Consignment Inventory Transaction Types
The transaction type code identifies the function used to initiate the inventory change. Consignment Transaction Types lists the customer consignment transaction type codes included in inventory history records with a brief description of each type and the programs that create the transactions.
 

Consignment Transaction Types
 
 
Transaction Type
Menu Number
Program that Creates the Transaction/Description
CN-ISSTR/CN-RCTTR
7.18.7
Consignment Inventory Transfer
Transfers inventory between locations at a site.
ISS-SO, CN-USE
7.18.10
Aging Inventory Update
Instead of extending the aging date of consigned inventory, enter Yes in the Use field to indicate its consumption. Initiates ISS-SO and subsequent invoicing.
7.18.13
Inventory Usage Create
Indicates consumption and initiates ISS-SO and subsequent invoicing.
7.18.14
Authorization Usage Create
Indicates consumption of consigned inventory shipped based on scheduled orders referencing customer authorization. Initiates ISS-SO and subsequent invoicing.
7.18.15
Sequenced Usage Create
Indicates consumption of consigned inventory shipped based on scheduled orders referencing customer sequences. Initiates ISS-SO and subsequent invoicing
7.18.22
Usage Create Undo
Reverses the movement of inventory out of a consigned location. Reverses GL transactions created at original usage creation.
CN-ADJ
7.18.25.1
Consignment Inventory Adjustment
Adjusts balances of consigned inventory at selected locations. Debits SO Consigned Inventory or SO Consigned In-Transit accounts and credits the SO Consigned Offset account. Negative adjustments credit SO Consigned Inventory and debit SO Consigned Offset accounts.
ISS-UNP, CN-USE
 
3.7
Issues – Unplanned
Adjusts balances for negative quantities only.
ISS-TR, RCT-TR
CN-SHIP
7.9.5
Pre-Shipper/Shipper Confirm
Ships inventory to a consigned location.
7.9.15
Sales Order Shipment
Ships inventory to a consigned location.
7.9.21
Shipper Unconfirm
Unconfirms an inventory shipment to a consigned location.
CYC-CNT
CN-CNT (negative only)
 
3.13.2
Cycle Count Results Entry
Makes adjustments to consigned inventory balances.
3.16.21
Inventory Balance Update
Changes consigned inventory balances. Updates tags.
TAG-CNT
CN-CNT
3.16.11
Tag Count Entry
Makes adjustments to consigned inventory balances. Also creates CN-CNT.
CYC-RCNT
CN-CNT
3.16.12
Tag Recount Entry
Makes adjustments to consigned inventory balances. Also creates CN-CNT. See Balancing Consigned Inventory After Cycle or Physical Counts.
Reviewing Transaction History
Use Transactions Detail Inquiry (3.21.1) to display detailed inventory transaction history records sorted by transaction number. Enter the transaction number to display all the information about that transaction.
Consigned Inventory Transactions in Transactions Detail Inquiry (3.21.1) shows the details about transaction 380636.

Consigned Inventory Transactions in Transactions Detail Inquiry (3.21.1)
When consigned inventory is used, multiple inventory transactions are processed and corresponding transaction history records created. For the consigned transaction, the system records the number of the standard transaction initiating it in the Remarks field.
In Consigned Inventory Transactions in Transactions Detail Inquiry (3.21.1) showing transaction 935, the number 934 in the Remarks field reflects the standard RCT-TR transaction that initiated the consignment CN-SHIP transaction. For transaction 934, the Remarks field contains the word Consigned, to indicate the type of inventory involved in the transaction.