Working With the Product Activity Code

Use the product activity code from user-defined code (UDC) table 47/PA in each detail record to specify the type of transaction and how it affects inventory.

This table describes the defined action for each product activity code:

Code	Action
− (Decrease inventory)	If the product activity code description is −, the transaction functions similarly to the Inventory Issues program (P4112). The quantity of the transaction decreases the quantity on hand for records in the F41021 table and updates the F4115 table if the processing options are set accordingly. The transaction also generates the necessary general ledger transactions to account for the decrease if the item's general ledger code and the document type interface with inventory.
+ (Increase inventory)	If the product activity code description is +, the transaction functions similarly to the Inventory Adjustments program (P4114). The quantity of the transaction increases in the Item Location record's quantity on hand. The system writes the new quantity on hand to the F4111 table and generates the necessary general ledger transaction to account for the receipt of the inventory.
I (Information only)	If the product activity code description is I, the transactions are informational only and do not update any JD Edwards EnterpriseOne tables. The transaction is edited for validity and prints on the Product Activity Audit Report.
R (Replace inventory on-hand balance)	If the product activity code description is R, the transaction functions similarly to the Cycle Count Update program (R41413). The quantity of the transaction replaces the quantity on hand for the records in the F41021 table. The system writes the new quantity on hand to the F4111 table, updates the F4115 table, and generates the necessary general ledger transactions to account for the adjustment to the inventory.
T (Transfer inventory from one location to another)	If the product activity code description is T, the transaction functions similarly to the Inventory Transfers program (P4113). The quantity of the first transfer transaction (the From side) decreases the quantity on hand for the Item Location record. The second transfer transaction (the To side) increases the quantity on hand for the record in the F41021 table (requires two records to be sent in). The transactions also generate the necessary general ledger transactions to account for the changes to the inventory if the item's general ledger code and the document type affect inventory.
C (Outbound Consumption Reporting)	Product activity code C identifies that the transaction is for reporting outbound inventory consumption. (Release 9.2 Update) See Processing EDI Transactions for Outbound Inventory in the JD Edwards EnterpriseOne Applications Outbound Inventory Management Implementation Guide.

The Sort Selection Sequence field in the inbound detail record controls the order in which transactions are processed. For example, process the beginning balances first, then plus (+) transactions, then minus (−) transactions, and ending balances.