Understanding Outbound Product Activity Data Transactions

Run the EDI Product Activity Data Extraction program (R47122) from the Product Activity Data menu to generate product activity data transactions (852/INVRPT) to send to a central distribution center, warehouse, or the parent company.

The receiver of the transaction typically maintains inventory levels for the sender of the transaction and plans when orders should be issued to replenish the sender's stock.

You can run the EDI Product Activity Data Extraction program in either proof or final mode. In proof mode, the program edits and prints the transaction. In final mode, the program edits and prints the transaction and also updates the JD Edwards EnterpriseOne system tables.

You specify which transactions to extract using the processing options for EDI Product Activity Data Extraction. Valid codes are found in UDC table 47/PA. You can generate these transactions:

  • QS: Quantity sold

  • QR: Quantity received

  • QO: Quantity out of stock

  • QT: Adjustments to inventory

  • QW: Quantity withdrawn from warehouse

  • QC: Quantity committed

  • QD: Additional demand quantity

  • QH: Quantity damaged or on hold

  • QI: Quantity in transit (receipt routing bucket 1)

  • QP: Quantity on order, not received

  • QA: Current quantity available to ship

  • QE: Current quantity on hand

  • QL: Minimum reorder quantity

  • QM: Maximum reorder quantity

  • QN: Planned reorder quantity

  • QX: Quantity requested