## Setting Up JD Edwards EnterpriseOne Blend Management

This chapter discusses how to:

- Set up blend system constants.

- Run the Populate Base Operations and Summary Attributes Table program (R31B20).

- Set up user-defined codes (UDCs).

- Set up temperature conversion charts.

### Setting Up Blend System Constants

This section provides an overview of blend system constants and discusses how to set up blend system constants.

#### Understanding Blend System Constants

A constant is a piece of information that you set up to define how the system processes information. The system uses constants as default information in many JD Edwards EnterpriseOne systems. After you determine the information to use throughout the system, you can enter the appropriate values using the Blend Management Constants program (P31B14). You define tracking methods and separator numbers for barrels. You can also define barrels, lot rounding, weight factor, and other miscellaneous facility information.

#### Form Used to Set Up Blend System Constants

Form Name | FormID | Navigation | Usage
Edit Blend System Constants | W31B14A | Blend System Setup (G31B01), Blend Constants | Set up blend system constants.

#### Setting Up Blend Management Constants

Access the Edit Blend System Constants form.

Number Separator Used | Specify whether the system uses a character separator when generating barrel numbers.
Separator | Specify the separator character that the system uses between the different segments of a barrel number.
Rounding Method | Specify which rounding method to use in the event that the total percentage for a particular composition does not equal 100 percent.
Decimals to Round | Specify the number of decimals to use in calculating composition records.
Density of Water | Enter the fixed amount that represents the density of water, which is used to calculate the weight factor.
Conversion Factor | Enter the fixed amount that represents the conversion factor, which is used to calculate the weight factor.
Blend ID Sequence Number Level | Enter the level at which the system generates sequence numbers for blend IDs. Values are: Implementation Variety - Winery Winery
Block Unit of Measure | Specify the unit of measure in UDC 31B/UM.
Lot Comment Threshold | Enter the percentage that is required to carry lot comments forward when using the percentage carry method.
Inventory Issues Document Type | Enter UDC 00/DT for the document type.

### Running the Populate Base Operations and Summary Attributes Table Program (R31B20)

After you set up system constants, run the Populate Base Operations and Summary Attributes Table program (R31B20) to load blend data into the system. This program resets the next numbers in the Winery Constants table (F31B13), adds additional automatic accounting instructions for JD Edwards EnterpriseOne Blend Management, and populates the Base Operation Configuration table (F31B73).

Note. The R31B20 program does not affect other data, such as next numbers in the Next Numbers table (F0002) in the system, only blend data.

#### Running the Populate Base Operations and Summary Attributes Table Program (R31B20)

Select Blend System Setup (G31B01), Populate Base Operations and Summary Attributes Table Program (R31B20).

### Setting Up UDCs

This section provides an overview of UDCs for JD Edwards EnterpriseOne Blend Management.

#### Understanding UDCs for JD Edwards EnterpriseOne Blend Management

UDCs enable you to customize the way the system operates. Many programs in the JD Edwards EnterpriseOne Blend Management system use UDCs to process information. Some UDCs are shipped with predefined data. You can change or delete the predefined data if it is not hard-coded and add UDCs to meet business requirements.

See JD Edwards EnterpriseOne Tools 8.98 System Administration Guide

This table lists some of the primary UDCs that you must set up for JD Edwards EnterpriseOne Blend Management:

UDC | Description
31BA1-5 | Work Area Category Codes.
31B/AC | Activity Code. For example: Active Contaminated Destroyed In repair
31B/AL | Asset Classification Code. For example: Lifestyle Luxury Premium
31B/BA | Barrel Attributes. For example: Barrel type Forest Toast level Cooper number
31B/BO | Bottle Type. For example: Burgundy - 750 ml Bordeaux - 750 ml Standard - 750 ml
31B/BT | Barrel Type. For example: French Burgundy Bordeaux American Oregon
31B/C1-9 31B/CC | Wine Category Codes 1–10.
31B/CB | Barrel Color Status. For example: Port Red White
31B/CL | Barrel Class. For example: Fortified Sherry Wine
31B/CM | Comments. For example: General Operations comments Operations testing Tasting Blending comments
31B/CR | Refrigerant. For example: Freon Dimple jacket Glycol jacket
31B/CU | Current Use. For example: Fermentation Storage Transport
31B/E1–4 | Equipment Category Codes.
31B/ET | Employee Type. For example: Cellar department Barrel department Maintenance department
31B/FC | Configuration - Floor. For example: Flat Sloped Sloped - 10°
31B/FM | Fabrication Material. For example: Concrete Cement Stainless steel Wood
31B/FO | Forest. For example: Mixed - French Nevers Vosges Oregon
31B/FT | Facility Type. For example: Bottling only Distilling plant Fermentation only
31B/HM | Medium (tank heating). For example: External Heat exchanger
31B/HS | Status - Hygiene. For example: Clean Dirty Sanitized Unknown
31B/HT | Head Toast. For example: Toasted Not toasted
31B/JT | Job Title. For example: Manager Senior winery worker Temporary worker
31B/LA | Lot Attributes. For example: Material type Wine status
31B/LC | Lot Comment Option. For example: Do not carry forward. Carry forward to all lots. Carry forward if contributes.
31B/LS | Barrel Leased. For example: Yes No
31B/LT | Last Treatment. For example: Bleach Saltwater Water rinse Sulfur
31B/MC | Method - Calibration. For example: Flow meter Volumetric Manufacturer specs
31B/NU | Next Use. For example: Fermentation Storage Maturation Aging
31B/OI | Owner Identifier. For example: Internal External
31B/OC | Owner Category Code. For example: Wine owner. Owner category code 1.
31B/PY | Parameter Type for Blend ID. For example: Fixed text Lot attribute Summary attribute
31B/R1–5 | Barrel Category Codes.
31B/RC | Reason Code. For example: Gain or loss New receipt Overshipment Shortage
31B/RD | Status Change Reason Code. For example: Deactivated equipment Defective equipment In maintenance
31B/S1–3 | Staff Category Codes.
31B/SG | Skill Grade. For example: Entry level Tech Senior level Expert
31B/SH | Barrel Shaved Y/N. For example: Yes No
31B/SL | Blend ID Substitution List. For example: GS (Grapes) S1 (Style1) SLD (WBSLD)
31B/SM | Summary Material Type. For example: Concentrate Fortified wine Grapes Juice Must
31B/SV | Status - Vessel. For example: Active Decommissioned Inactive Out of commission
31B/SW | Work Shift. For example: Day Swing Graveyard On call
31B/T1–2 | Style Category Codes.
31B/TC 31B/TH | Temperature Control (Heating). For example: Computerized Manual Plant intelligence system
31B/TE | Equipment Type. For example: Filter Press Mixer
31B/TL | Toast Level. Vales are: Light Medium Heavy None (not toasted)
31B/TP | Tank Placement. For example: Fixed Movable
31B/TT | Tank Type. For example: Fermentation - Red Storage Transport Wood fermentation
31B/TV | Tank Shape. For example: Conical Cylindrical Square
31B/TX | Material Type Tax Class. For example: Tax paid Distilling materials Wine alcohol < 14% Wine alcohol > 21%
31B/U0–9 | EUR Category Codes.
31B/UM | Unit of Measure. For example: Barrel Fahrenheit Gallon Liter Ton
31B/V1–2 | Variety Category Codes.
31B/VC | Variety Color. For example: Blush Red White
31B/VF | Variety Family. For example: Chardonnay Italian red Pinot family Rhone red
31B/VS | Volume Status. For example: Empty Full Partial Unknown
31B/W1–5 | Wine Status Category Code 1–5. For example: Block Barrel Equipment Operation
31B/WT | Work Group Type. For example: Bottling group Cellar group Filtration group Pressing group

### Setting Up Temperature Conversion Charts

This section provides an overview of temperature conversion charts and discusses how to:

- Add new temperature conversion charts.

- Copy existing temperature conversion charts.

- Import existing temperature conversion charts.

#### Understanding Temperature Conversion Charts

When you set up different spirit material types in the Material Type Master table (F31B04) , you specify a standard temperature for the material type. Once you perform an operation on a spirit and measure the ambient temperature, the result might be higher or lower than the standard temperature. To ensure that the transaction volume is correct, the system recalculates the volume based on a temperature conversion chart that you define. Use the Temperature Chart Conversion program (P31B116) to set up a conversion chart. The system stores the temperature chart information in the Temperature Conversion Chart Header table (F31B116) and the Temperature Conversion Chart Detail table (F31B117), The temperature conversion chart lists ambient temperatures, alcohol percent values, and the conversion factor or volume modifier that the system needs to calculate the spirit volume for an operation correctly. When you set up the spirit material type, you reference the temperature conversion chart that you want the system to use for recalculating spirit volumes.

When you measure the ambient temperature or the alcohol percent value of a spirit during an operation, the values that you record may fall between two values on the temperature conversion chart. In this case, the system uses a straight-line calculation to arrive at the correct conversion factor. The following table lists the ambient temperatures in Fahrenheit, alcohol percentages, and related conversion factors for a standard temperature of 68 degrees Fahrenheit:

Ambient Temperature | Alcohol Percent | Conversion Factor
60.0 F | 0.85 | 0.9800
62.0 F | 0.85 | 0.9920
66.0 F | 0.85 | 0.9965
60.10 F | 0.90 | 0.9700
62.2 F | 0.90 | 0.9880
66.2 F | 0.90 | 0.9960

For an ambient temperature of 65 degrees Fahrenheit and an alcohol percent value of 85, the system has to calculate the conversion factor because the temperature value is not listed on the chart. To calculate the conversion factor, the system looks up the two closest temperature values for the alcohol percent value of 85. In this case, they are 62 and 66. The following calculation illustrates how the system arrives at the correct conversion factor based on the specified values:

0.9920 + (½) × (0.9965 − 0.9920) = 0.99425

If both the temperature and the alcohol percent values fall between values on the chart, the system has to perform multiple calculations. For example, if the ambient temperature is 65 degrees Fahrenheit and the alcohol percent value is 88:

0.9920 + (½) × (0.9965 − 0.9920) = 0.99425

0.9880 + (½) × (0.9960 − 0.9880) = 0.9920

(0.99425 × (½)) + (0.9920 × (½)) = 0.993125

Note. You can enter and store temperatures for the temperature conversion chart only to the 10th degree. Pristine data includes a standard temperature conversion chart for 60 degrees Fahrenheit.

The system can perform conversions only for temperatures that fall between the highest and lowest value that you define in the temperature conversion chart. If you enter an ambient temperature or the vessel has an alcohol percent on a spirit operation that falls outside the chart, the system issues an error message because it cannot perform the conversion.

#### Forms Used to Set Up Temperature Conversion Charts

Form Name | FormID | Navigation | Usage
Search for Temperature Conversion Chart | W31B116A | Blend System Setup (G31B01), Temperature Conversion Chart | Retrieve existing temperature conversion charts. Initiate creation of additional temperature conversion charts by adding new charts or by copying or importing existing charts. Delete a selected temperature conversion chart and all associated detail records.
Add Temperature Conversion Chart | W31B116B | Click the Add button on the Search for Temperature Conversion Chart form. | Add new temperature conversion charts. Copy entire existing temperature conversion charts.
Import Temperature Conversion Chart | W31B116F | Click the Import Entire Chart button on the Search for Temperature Conversion Chart form. | Import temperature conversion charts that were created through third-party spreadsheet applications.

#### Adding New Temperature Conversion Charts

Access the Add Temperature Conversion Chart form.

Chart Name and Chart Description | Enter a name and description for the temperature conversion chart. The system stores this information in the Temperature Conversion Chart Header table (F31B116).
Creator | Displays the address book number of the user who sets up the temperature conversion chart. If the user is not set up in the Address Book Master table (F0101), the system issues an error message when you access the Add Temperature Conversion Chart form.
Chart Temperature UOM (chart temperature unit of measure) | Specify whether to use Celsius or Fahrenheit as the unit of measure for the temperatures that are listed in the chart. The default value is Fahrenheit.
Standard Temperature | Enter the standard temperature of the material type for which you are creating the temperature conversion chart. If you do not enter a value, the default value is 0.
Alcohol Percent | Specify the alcohol percent value for which you want to define conversion factors. If you do not enter a value, the default value is 0.
Add Alcohol Percent | Click to access the Add New Alcohol Percent form. On this form, you can specify the alcohol percent values that you want to be available for selection in the Alcohol Percent field.
Temperature | Specify the ambient temperature for the selected alcohol percent value for which you want to define a conversion factor.
Conversion Factor | Specify the conversion factor that the system uses to calculate spirit volumes for operations.

#### Copying Existing Temperature Conversion Charts

Access the Add Temperature Conversion Chart form.

When you access this form by clicking the Copy button on the Search for Temperature Conversion Chart form, the system copies the entire temperature conversion chart that you selected. To create a new temperature conversion chart from the copy, you enter a new conversion chart name.

#### Importing Existing Temperature Conversion Charts

Access the Import Temperature Conversion Chart form.

Enter a chart name and description, temperature unit of measure, and standard temperature. Use the standard functionality for importing grid data to import an existing temperature conversion chart from a spreadsheet or comma-delimited file.

When you import a chart, ensure that the spreadsheet has the same columns (alcohol percent, temperature, and conversion factor) and format as the import grid on this form. If an error occurs on any of the detail lines, the system issues an error message. In this case, you can either save the chart without the error record or you can return to the spreadsheet, correct the error, and reimport the chart.