This chapter contains the following topics:
Section 4.2, "Setting Up AAIs for the Bulk Stock Inventory System"
Section 4.3, "Setting Up UDCs for the Bulk Stock Inventory System"
Section 4.4, "Setting Up Next Numbers for the Bulk Stock Inventory System"
This section discusses how to activate the JD Edwards EnterpriseOne 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. |
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 |
|
See Also:
|
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.
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.