Setting Up the Bulk Stock Inventory System

This chapter discusses how to:

Activate the JD Edwards EnterpriseOne Bulk Stock Inventory system.
Set up automatic accounting instructions (AAIs) for the JD Edwards EnterpriseOne Bulk Stock Inventory system.
Set up user-defined codes (UDCs) for the JD Edwards EnterpriseOne Bulk Stock Inventory system.
Set up next numbers for the JD Edwards EnterpriseOne Bulk Stock Inventory system.

Activating the Bulk Stock Inventory System

This section discusses how to activate the JD Edwards EnterpriseOne Bulk Stock Inventory system.

Form Used to Activate the Bulk Stock Inventory System

Form Name	FormID	Navigation	Usage
EnterpriseOne System Control – Revisions	W99410B	In the Fast Path, enter P99410. On the Work With EnterpriseOne System Control form, select the row for Bulk Stock Management and click Select. On the EnterpriseOne System Control – Revisions form select Yes and then click OK	Activate the Bulk Stock Inventory system.

Form Name

FormID

Navigation

Usage

EnterpriseOne System Control – Revisions

W99410B

In the Fast Path, enter P99410.

On the Work With EnterpriseOne System Control form, select the row for Bulk Stock Management and click Select.

On the EnterpriseOne System Control – Revisions form select Yes and then click OK

Activate the Bulk Stock Inventory system.

Activating the Bulk Stock Inventory System

Access the Work With EnterpriseOne System Control form.

Setting Up AAIs for the Bulk Stock Inventory System

You need to set up the AAIs for the JD Edwards EnterpriseOne Bulk Stock Inventory system. The AAIs for the JD Edwards EnterpriseOne Bulk Stock Inventory system identify the general ledger accounts that the system updates when recording transactions. You must create AAIs for each unique combination of company, document type, and general ledger class code that you use.

This table identifies the AAIs used in the JD Edwards EnterpriseOne Bulk Stock Inventory system:

AAI	Description
4122	Provides the inventory offset account. The General Stock Movements program (P415101) uses this AAI.
4124	Provides the offset account for expense or cost of goods sold. The General Stock Movements program uses this AAI.
4152	Provides the inventory account used in the reconciliations process.
4182	Provides the physical gain/loss account. The General Stock Movements and Reconciliations programs use this AAI.
4184	Provides the work-in-process account to record the interim gain or loss on bulk items. The General Stock Movements program uses this AAI.

This example illustrates the accounting transactions for these AAIs:

Transaction	Description
If decreasing inventory	Debit AAI = 4182 Gain/Loss Credit AAI = 4152 Inventory
If increasing inventory	Debit AAI = 4152 Inventory Credit AAI = 4182 Gain/Loss

Setting Up UDCs for the Bulk Stock Inventory System

The UDCs program (P0004A) enables you to establish and maintain a table that defines valid codes for various types of information. Codes are categorized by system and code type. You might need to review or revise codes for the JD Edwards EnterpriseOne Bulk Stock Inventory system. In addition, you need to define the UDCs for the various document types used by the system.

The JD Edwards EnterpriseOne Bulk Stock Inventory system uses these UDCs:

UDC	Description
Blending Categories (Type BC)	Identifies valid product groups that can be put into a specific blending tank
Dispatch Group (Type DG)	Used by the Transportation Management system to group bulk products for dispatch
Density Table (Type DN)	Indicates the density conversion algorithm to be used in calculations
Dip Type (Type DP)	Identifies the method of measurement when calibrating volumes from tank dips
Density Type (Type DT)	Identifies the type of density
Fill Category (Type FC)	Identifies the different filling categories
Gauging Method (Type GM)	Indicates the method used to measure product
Meter Status (Type MS)	Indicates whether the meter is active or inactive
Product Group (Type PG)	Identifies the line of products with similarities enabling them to be grouped
Replenishment Type (Type RT)	Indicates the type of supply, such as blended product, purchased, and filled
Tank Status (Type ST)	Indicates whether the tank is active or inactive
Strapping Units (Type SU)	Indicates the size of the strapping table increments, such as centimeters
Tank Location (Type TL)	Identifies the location of the tank
Temperature Type (Type TL)	Identifies the type of temperature, such as Celsius or Fahrenheit
Temperature Conversion Table (Type TT)	Indicates which standard ASTM-IP-API table to invoke for calculation of standard stock accounting units
Tank Usage (Type TU)	Indicates the primary usage for the tank-for example, storage, blending, and holding
Tank Type (Type TY)	Identifies the physical shape of the tank

This UDC table indicates document types for System 41B:

UDC	Description
Load Confirmed Sales (Type LC)	Includes all of the codes for the document types for load-confirmed sales that will go through the meter
Other Metered Outgoings (Type OM)	Includes all document types for all other types of transactions that will go through the meter
Non-Metered Outgoings (Type NM)	Includes all document types for transactions that left the tank but did not go through the meter
Incomings (Type IN)	Identifies the document types to include in the incoming transactions
Outgoings (Type OT)	Identifies all document types to include in the outgoing transactions
Throughput Reconciliation (Type TR)	Identifies any documents for which you must complete throughput reconciliation before completing operational reconciliation

In the Fast Path, enter UDC.

Setting Up Next Numbers for the Bulk Stock Inventory System

When you create a document such as an invoice, a voucher, or a journal entry, you can assign a document number or let the Next Numbers program (P0002) assign one.

Next numbers is an automatic numbering feature. The Next Numbers program assigns numbers to documents using either or both of these types of numbers:

Standard next numbers.

The system finds the next available number in the Next Numbers - Automatic table (F0002) and assigns that number to the document.
Next numbers by company and fiscal year.

The system finds the next available number by company and fiscal year, or by company only, in the Next Numbers by Company/Fiscal Year - Automatic table (F00021).

Next numbers work in conjunction with the data dictionary. Each data dictionary item that uses next numbers contains a next numbering index value that corresponds to the line number that contains the next number value for that data item.

When you set up next numbers:

Do not use blank as a next number value.
Do not change a next number.

Changing the numbers can result in duplicate numbers, as well as the inability to locate previously added numbers. If you must change a next number, change it to a greater value only.
Do not delete next number values. If you delete a next number value, you might get unexpected results.
Do not change the sequence of the next numbers in the table.

Each next number must remain on its current line because programs reference a specific line in the table. For example, in the JD Edwards EnterpriseOne General Accounting system, the next number for journal entries must be on the second line.

You can have the system assign check digits for any set of standard next numbers. Check digits prevent errors caused by transposition during data entry. For example, activating check digits in the address book for suppliers prevents a voucher from being assigned to the wrong supplier if digits are transposed during voucher entry. It is recommended that you use check digits for next numbers only when a transposition error is likely to occur during data entry.

Note. If you choose to manually assign a document number instead of using next numbers, you must enter the number during data entry.

In the Fast Path, enter NN.