Description of Changes to Blend Lots After Recosting
You run the Recost Blend Lots Batch program to calculate the difference between the cost of grapes on the receipt record for a weigh tag and the cost that is associated with the harvest cost-component of the weigh tag in the Blend Lot Cost table (F31B31C). The Recost Blend Lots Batch program calculates the difference only when the Recost Blend Lots Batch program is run after you reprice a receipt.
If the Recost Blend Lots Batch program finds a difference between the harvest cost in the Purchase Order Receiver File (F43121) and the harvest cost in the F31B31C table, it changes the cost in the F31B31C table to match the cost in the F43121 table, and applies the cost change proportionately to all of the lots that include the grape. The program changes the cost of the harvest cost-component in the F31B31C table for all affected lots regardless of operation status (open or closed) and regardless of accounting status.
The program inserts a lot comment in the REC operation if the comparison between the previous cost and a new cost results in a cost difference. If the comparison results in no difference in the cost, then the program does not adjust the cost and does not write a lot comment. The program does not write a lot comment for any operation other than the REC operation.
For this example, suppose that the original price of the grapes on Receipt 1 is 10,000, and is distributed to eight vessels in these proportions:
T1 = 30% (3,000)
T2 = 10% (1000)
T3 = 10% (1000)
T4 = 8% (800)
T5 = 7% (700)
T6 = 5% (500)
L1 = 10% (1000)
B1 = 10% (1000)
V1 = 10% (1000)
This table describes the changes to harvest cost-component for the lots in the vessels after you reprice Receipt 1 to 15,000 and run the Recost Blend Lots Batch program:
Vessel or Lot |
Comment |
|---|---|
WT 1 |
The process updates the harvest cost-component in the F31B31C table from 10,000 to 15,000. The process inserts a lot comment in the Lot Comments table (F31B317) because WT1 is the receipt operation. |
T1 |
The process changes the value for the harvest cost-component for T1 in the F31B31C table from 3000 to 4500. No lot comment is inserted for this record. |
T2, T3, L1, V1 |
The process changes the value for the harvest cost-component for these lots in the F31B31C table from 1000 to 1500. No lot comment is inserted for these records. |
T4 |
The process changes the value for the harvest cost- component for T4 in the F31B31C table from 800 to 1200. No lot comment is inserted for this record. |
T5 |
The process changes the value for the harvest cost-component for T5 in the F31B31C table from 700 to 1050. No lot comment is inserted for this record. |
T6 |
The process changes the value for the harvest cost-component for T6 in the F31B31C table from 500 to 750. No lot comment is inserted for this record. |
B1 |
The process changes the value for the harvest cost-component for B1 in the F31B31C table from 1000 to 1500. No lot comment is inserted for this record. |
Continuing with the example, suppose that after you reprice Receipt 1 and recost the lots associated with it, you reprice Receipt 4 and recost the lots associated with that receipt. Receipt 4 has an initial cost of 8000, and is repriced to 7500. WT 4 and T6 are the lots associated with Receipt 4. The harvest cost-component for WT 4 and T6 are recosted from 8000 to 7500. The process inserts a lot comment for WT 4 because it is the receipt operation.
T6 contains grapes from three sources: WT 1, WT 4, and WT 8. WT 1 and WT 4 are closed and have receipts that are recosted. The downstream lots for these weigh tags use the harvest cost-component to reflect the cost of the grapes. WT 8 is open and has no receipts. Because no receipt exists, the cost for the grapes on this weigh tag is passed to the downstream lot (T6) as the cost of the item from the Item Master table (F4101). For this example, assume that the grape item cost that is passed to T6 from WT 8 is 5000.
The reprice and recost processes cause these actions and results for the lot records for T6 in the F31B31C table:
Lot Number |
Action |
Amount |
Explanation |
|---|---|---|---|
101 |
Added grape from WT 1, then repriced and recosted |
750 |
After adding the grape to lot 101, the amount is 500. However, after repricing and recosting, the amount is 750. |
102 |
Added grape from WT 4, then repriced and recosted |
8250 |
Lot 102 is created when you blend the contents of lot 101 with the grape from WT 4. The original amount for lot 102 is 750 + 8000 (8750), but WT 4 is recosted to 7500, so the amount for the lot decreases by 500 and becomes 8250. |
103 |
Added grape from WT 8 |
13,250 |
Lot 103 is created when you blend the contents of lot 103 with the grapes from WT 8. The cost of the grapes for WT 8 (5000) comes from the grape item cost for WT 8, so 5000 is added to the 8250 cost from lot 102 to arrive at the lot cost for lot 103. |