Running the Crush and Purchase Report (R40G150A)

Select Crush and Purchase Report (G40G12111), Crush and Purchase Report.

Use the Crush and Purchase report (R40G150A) to generate a listing of crop quantities that were crushed or purchased during a specified reporting period. You can report crop quantities using the following criteria or scenarios:

• Grown internally.

• Purchased from growers.

• Purchased by non-growers.

• Crushed for growers, but not purchased.

• Crushed for non-growers, but not purchased.

You can track purchased crop quantities using these criteria:

• Purchased from growers.

• Purchased from non-related growers.

• Purchased for distilling or as substandard.

• Purchased from growers and resold without crushing.

• Purchased from growers and crushed by an external processor.

Because all purchases and receipts for a facility are processed using a weigh tag, you use the weigh tag as the basis for including quantities on the report. You can use a weigh tag without an associated crush operation, but you cannot report on a crushed quantity without an associated weigh tag. After you select a weigh tag, the system retrieves data from the harvest and the weigh tag operation header.

On the Crush and Purchase report, you can report five standard values for Brix levels. The following table describes these standard values:

Value	Description
Allowed Minimum Value	Minimum acceptable Brix level.
Allowed Maximum Value	Maximum acceptable Brix level.
Adjustment Limit - Target Value	Preferred Brix level.
Adjustment Limit - Minimum Value	Minimum allowed Brix level before an adjustment is applied.
Adjustment Limit - Maximum Value	Maximum allowed Brix level before an adjustment is applied.

You set up these standard values in the Quality Result Limits program (P40G151) and store them in the Quality Result Limits table (F40G151). You set up these attributes by variety, district, and test result name.

Crush and Purchase reporting includes the following steps:

1. The first step for generating the Crush and Purchase report is to run a data extraction using the Crush and Purchase Report - Build program (R40G1501). You can access this program from the Crush and Purchase Report menu. Use the processing options to determine how data are retrieved and calculated. The system extracts data from these tables:

   • Operations Header (F31B65)

   • Operation Vessel Assignments (F31B70)

   • Weigh Tag Master (F31B85)

   • Test Results (F3711)

   • Price Adjustments Ledger (F4074)

   • Purchase Order Receiver (F43121)

   • Grower Harvest (F40G03)

   • Quality Result Limits (F40G151)

   The system stores the extracted data in the Crush and Purchase Report Details table (F40G150).

2. After you have extracted the data into the Crush and Purchase Report Details table, you can manually update the information and enter additional information. Use the Crush and Purchase Application (P40G150), that you access from the Crush and Purchase Report menu, to make updates and additions as needed.

3. Next step is to launch the Crush and Purchase Detail Report (R40G150A), so as to report the information in the Crush and Purchase Reporting table (F40G150).

   For the Crush and Purchase Report, you can use either the report provided or you can create custom reports based on report indicators. These report indicators identify transactions for inclusion in the reporting scenarios. An individual crush operation or purchase transactions might appear in multiple reporting scenarios. The following table describes the report indicators:

   Report Indicator	Description
   Crush and Purchase Detail	Consists of these three sections: Crush detail: Includes all crush operations, with information on quantity and Brix level. Purchase detail: Includes only purchases from growers, with information on quantity, actual and acceptable Brix levels, Brix adjustment factors and limits, and base and net pricing. Distilling material and substandard crops: Includes only purchases from growers, with information about quantity and Brix levels.
   Resale	Crops that are purchased from growers and resold without crushing.
   Repurchase	Crops purchased from entities that are not the original growers.
   External crush	Crops purchased, but crushed by an external processor.
   Crush service	Crops crushed, but not purchased.

4. You can purge the data from the Crush and Purchase Report Details table using the F40G150 Purge program (R40G150P).