Understanding How to Recost Blend Lots

You can run the Recost Blend Lots Batch program (R31B30) to update the harvest cost-component for all lots, including closed lots, that include grapes from a repriced grape receipt. When you run the Recost Blend Lots Batch program, the program:

  • Compares the cost of the grape in the Purchase Order Receiver File (F43121) to the harvest cost-component value for the corresponding weigh tag (WT) or bill of lading (BOL).

    The harvest cost-component for the WT or BOL exists in the Blend Lot Cost table (F31B31C).

  • Applies the difference between the cost in the F43121 and F31B31C tables proportionately by volume to the receipt operation record and all affected lots that include the repriced grape.

    In final mode, the process adjusts the cost-component in the F31B31C table for existing lots. In proof mode, the process does not update the F31B31C table.

    The process skips receipts for which no change in price exists.

    Though the Reprice Procurement/Receipts program does not reprice reversed receipts, if you reversed a receipt, the Recost Blend Lots Batch program recosts the affected lots.

  • In final mode, inserts a record in the Lot Comments table (F31B317) for the initial receipt operation. The initial receipt operation, generally a WT or BOL, includes the value REC in the Category Code 1 field of the operation.

    If you run the process in proof mode, the process does not update the table.

  • Generates a report that includes these sections:

    • Costs Updated

      This section includes information about the REC (received) operation for which the harvest cost-component is updated when you run the process in final mode. When you run the process in proof mode, this section includes information about the blend lots that can be updated. This section includes the block, harvest, vessel, lot, and operation information; the adjustments; and, the old and new extended lot costs for these blend lots.

    • Costs are Current

      This section includes information about blend lots that are not updated because the receipt price is the same as the lot cost. This section includes the block, harvest, vessel, lot, and operation information; the extended receipt price; and, the extended lot cost for these blend lots.

    • Manual Adjustment Required

      This section includes information about the repriced receipts for which you must make a manual adjustment to blend accounting records. Though the recost process updates lot costs, the system cannot create the recost variance when:

      • The operation is removed from the JD Edwards EnterpriseOne Blend Management system.

      • Accounting is complete for the operations.

      • No unaccounted (closed or open) downstream lot exists for the recosted receipt.

        The process writes the adjustment to an unaccounted, downstream operation associated with the recosted receipt, so an unaccounted operation (closed or open) must exist to which the process can write the adjustment.

      • Downstream, unaccounted (open or closed) operations exist for only part of the harvest that is received on the repriced and recosted receipt.

        For example, if you crushed the grapes associated with a weigh tag and created a tank-to-tank (T2T) operation for 90 percent of the grapes, but have not yet created an operation for the remaining 10 percent, then the process cannot create an adjustment for the remaining 10 percent of the harvest because no downstream unaccounted (open or closed) operation exists for the 10 percent.

      The Manual Adjustment Required section includes the block, harvest, vessel, lot, and operation information, and the extended receipt price for these blend lots.

      See Removed Lots

    • Costs not Updated - Error Conditions

      This section includes information about the blend lots that could not be updated because of an error condition, such as a reserved vessel. This section includes block, harvest, vessel, lot, and operation information; the extended receipt prices; and, a description of the error.

      Note: The Recost Blend Lots Batch program utilizes record reservation. Oracle recommends that you run the program when other users are not using blend lot records.

After you run the Recost Blend Lots Batch program, you must run the Blend Cost Accounting Journal Entries program (R31B802) to update the Blend Transaction table (F31B66) and the Account Balances table (F0902).

See Performing Cost Accounting