R31B702 - Inventory Balance Report

Each time you close an operation, the system creates transactions that result from operations. The Blend Transaction table (F31B66) stores information from closed operations. These include accounting transactions and inventory transactions that are similar to those in the Item Ledger table (F4111) in the JD Edwards EnterpriseOne Inventory Management system. Transactions include before and after lot costs, lot quantities, survey gains and losses, and operational gains and losses.

The F31B66 table includes this data:

  • Transaction units.

  • Transaction unit of measure.

  • Unit cost.

  • Transaction amount.

  • Configured operation short code.

  • Operation close date.

  • Facility.

  • Lot number.

  • Material type.

  • Wine status.

  • 702 line number.

  • Document type.

  • Company.

  • Document number.

  • G/L date.

  • Journal entry line number.

You run the Inventory Balance Report to capture the data in the F31B66 table.