This chapter provides an overview of system setup and discusses how to:
Set up constants.
Set up warehouse locations.
Set up default location information.
Set up standard units of measure.
Set up item cross-references.
Set up messages.
Set up document type information.
Set up Automatic Accounting Instructions (AAIs) in Distribution systems.
Reserve item records.
This table describes the features that you must set up before using the JD Edwards EnterpriseOne Inventory Management system:
Feature |
Description |
Constants |
Constants provide the system with these types of default information:
|
Warehouse locations |
Warehouse locations define the locations that are available in branch/plants. |
Default location and printers |
Default location and printer settings provide the system with branch/plant, printer output queue, and approval route code information to use as default settings. |
Item cross-references |
Item cross-reference numbers enable the system to associate internal and external items. |
Messages |
Messages appear depending on which programs you specify and which messages you determine should print. |
Document type information |
Document type information is typically set up in a user-defined code (UDC). You can use the Document Type Maintenance program to set up and maintain this information for Distribution. |
AAIs |
AAIs provide accounting information and the general ledger relationships for interacting with the JD Edwards EnterpriseOne General Accounting system. |
This section provides an overview of constants, lists prerequisites, and discusses how to:
Define branch/plant constants.
Review branch/plant ALL.
Set up ABC Analysis codes.
Define item availability.
Define system constants.
Define batch control constants.
Define the location format.
Define segments for locations.
Constants provide a basic framework for the JD Edwards EnterpriseOne Inventory Management system. Based on the business needs, you associate specific constants with either the entire system or a specific branch/plant. The JD Edwards EnterpriseOne Inventory Management system uses constants as default information in other JD Edwards EnterpriseOne systems.
After you determine the information that you want to use throughout the system, you can enter the appropriate values or change any predefined values.
Note. The JD Edwards EnterpriseOne Inventory Management system includes branch/plant ALL, which is required for default information.
Accelerated Pricing Resolution Engine
To increase system performance, you can activate the Accelerated Pricing Resolution Engine feature on the System Constants form. Before you use this feature, thoroughly read the details of how the Accelerated Pricing Resolution Engine feature works.
See Working with the Accelerated Pricing Resolution Engine.
Before you complete the tasks in this section, you must:
Create an address book record for the branch/plant.
Set up the branch/plant as a business unit.
Activate Location Segment Control on the Branch/Plant Constants form.
Form Name |
FormID |
Navigation |
Usage |
Work with Branch/Plant Constants |
W41001B |
|
Review branch/plant constants. |
Branch/Plant Constants |
W41001H |
Click Add on the Work with Branch/Plant Constants form. |
Define branch/plant constants. Review branch/plant constants. |
ABC Codes |
W41001I |
Select ABC Codes from the Form menu on the Branch/Plant Constants form. |
Set up ABC analysis codes. |
Item Availability Definition |
W41001G |
Select Availability from the Row menu on the Work with Branch/Plant Constants form. |
Define item availability. |
System Constants |
W41001F |
Select Sys. Constants from the Form menu on the Work with Branch/Plant Constants form. |
Define system constants. |
Application Constants |
W41001E |
Select App. Constants from the Form menu on the Work with Branch/Plant Constants form. |
Define batch control constants. |
Branch Location Definition |
W41001A |
Select Location Def from the Row menu on the Work with Branch/Plant Constants form. |
Define the location format. Define segments for locations. |
Access the Branch/Plant Constants form.
Branch/plant constants enable you to configure the processing of daily transactions for each branch/plant in the distribution and manufacturing systems.
Note. If you use the JD Edwards EnterpriseOne Warehouse Management system, you must define the warehouse information on the Branch Location Definition form of the Branch/Plant Constants program (P41001). Otherwise, you should at least define location length information.
Short Item Number Identifier |
Enter a symbol that identifies the eight-character short item number when you do not want to use it as the primary number. Leave this field blank to indicate that you want to use this item number as the primary number. That is, you use it most often to enter or review information. If this is not the primary number, you must enter a special symbol to identify it. Use a symbol that is not significant for any other purposes of entry such as /, *, or &. Do not use a period or a comma as a symbol. When you enter this item number on any other form, you must include this symbol as the first character. Note. Only one of the fields for item number symbols (SYM1, SYM2, SYM3, or SYM6) can be blank to identify it as the primary number. All others must include a unique symbol. |
Second Item Number Identifier |
Enter a symbol that identifies the 25-character second item number when you do not want to use it as the primary number. Leave this field blank to indicate that you want to use this item number as the primary number. That is, you use it most often to enter or review information. If this is not the primary number, you must enter a special symbol to identify it. Use a symbol that is not significant for any other purposes of entry such as /, *, or &. Do not use a period or a comma as a symbol. When you enter this item number on any other form, you must include this symbol as the first character. Note. Only one of the fields for item number symbols (SYM1, SYM2, SYM3, or SYM6) can be blank to identify it as the primary number. All others must include a unique symbol. |
Third Item Number Identifier |
Enter a symbol that identifies the 25-character third item number when you do not want to use it as the primary number. Leave this field blank to indicate that you want to use this item number as the primary number. That is, you use it most often to enter or review information. If this is not the primary number, you must enter a special symbol to identify it. Use a symbol that is not significant for any other purposes of entry such as /, *, or &. Do not use a period or a comma as a symbol. When you enter this item number on any other form, you must include this symbol as the first character. Note. Only one of the fields for item number symbols (SYM1, SYM2, SYM3, or SYM6) can be blank to identify it as the primary number. All others must include a unique symbol. |
Symbol Customer/Supplier |
Enter a character that identifies the customer's or supplier's number in the system. When you enter a number preceded by this character, the system recognizes the number as the customer's or supplier's number. The system then uses the cross-reference table to match the number to the item number. You must complete this field if you want the system to perform cross-referencing. |
Customer/Supplier Cross Ref. Code (customer/supplier cross-reference code) |
Enter a code from UDC 41/DT that identifies the type of cross-reference setup for this customer. Examples of cross-reference types include substitutes, replacements, and customer and supplier item numbers. |
Segment Separator Character |
Enter the character that you want to use to separate item numbers into segments. When you define segments for items, set up a template for all items throughout the branch/plant. If you use segments across branch/plants, you must define all segments the same for all branch/plants. The character or symbol will be used to separate segments within an item number based on the template that is associated with the item number. If this field is left blank, the system displays the segments as one string of characters. |
Current Inventory Period |
Enter a number from 1 – 14 that identifies the current accounting period. The system uses this number to generate error messages, such as PBCO (posted before cut off) and PACO (posted after cut off). |
General Ledger Explanation |
Specify the default description that appears on the second line of a journal entry in the general ledger. Values are: 1: Item master description (default). 2: Primary item number. |
Write Units to Journal Entries |
Select this check box to indicate that the system moves units to the general ledger after the system records a journal entry. |
Sales/Inventory/Purchasing Costing Method |
Enter a code from UDC 40/CM to indicate the cost method that the system uses to calculate the cost of goods that are sold for the item. Cost methods 01–19 are reserved. |
Purchase Order Issue Cost |
Enter the amount that you want the JD Edwards EnterpriseOne Procurement system to use to calculate the Economic Order Quantity (EOQ). This cost should be the estimate of the cost of materials, labor, and overhead that you incur when you issue a single purchase order. The default value is 00. This example indicates how the Purchase Order Issue Cost method determines the EOQ:
|
Inventory Carrying Cost (%) (percentage) |
Enter the percentage of inventory investment that you want the JD Edwards EnterpriseOne Procurement system to use to calculate EOQ. Enter the percentage as a decimal value. The default percentage is .00. This example indicates how the system determines EOQ using the Inventory Carrying Cost Percentage:
EOQ = Square root of ((2S/I) x (Y/C)) = the square root of (2(15) divided by .09)) × (3000/10) = 316.23 Note. Access field help for the Economic Order Quantity field for more information about the EOQ formula. |
Commitment Method |
Enter a code to indicate the method that you want the system to use to commit lot items from inventory. Values are:
|
Specific Commitment (Days) |
Enter the number that you want the system to use to determine when to commit inventory to an order in sales order processing. This value in days is added to current date and compared with the promised ship date for the order line. If the promised date is greater than the calculated date, the order line is future committed in the F41021 table. Enter 999 to eliminate future commits. |
Number of Days in Year |
Enter the number of days in a year that the company is open for business. This field is required. You must enter a number from 252 through 365. The JD Edwards EnterpriseOne Procurement system uses this number to calculate the EOQ. |
Branch Country of Origin Code |
Enter a code from UDC 40R/CO that specifies where a part was made. Enter a two-digit code indicating parts made outside the USA, for example, CA equals Canada. Enter a three-digit code indicating parts that are made in the U.S.. For example, U equals United States and xx equals two-digit state postal code, meaning that UOH equals Made in Ohio, U.S.. |
Approval Route Code |
Enter a code that determines to whom an order is routed for approval. |
Location Control (Y/N) |
Select this check box to indicate which type of location control the system requires. You should use location control if you want to use only locations that are in the F4100 table. Values are: Y: Use only locations that are defined in the F4100 table. When the Warehouse Control option is selected, the Location Control option must be Y. N: Do not restrict locations to those in the F4100 table. Use all locations that conform to the location format that is defined on the Branch Location Definition form. |
Warehouse Control (Y/N) |
Select this check box to indicate that the system creates warehouse transactions for the branch/plant. |
Quality Control (Y/N) |
Select this check box to indicate that the JD Edwards Quality Management system is enabled for the branch/plant. In addition to activating quality control for each branch/plant that you want to include in quality tests, you need to activate quality management on the Quality Management Setup menu (G3741). |
Use Product Cost Detail (Y/N) |
Select this check box to indicate that the Distribution programs use the total cost method or the detailed product cost method. |
Foreign Depot |
Select this check box to indicate that another company owns the branch/plant. The Bulk and Packed Load Confirmation programs use this code to determine whether the depot from which product is being loaded is a foreign depot. If it is a foreign depot, you must enter a valid borrow agreement during load confirmation. |
Location Segment Control (Y/N) |
Select this check box to enable the Location Segment Specifications in the Location Definition program (P41001). The segment specifications determine how the system segments locations within a branch using UDC 41/ER. |
Access the Branch/Plant Constants form.
The branch/plant ALL is a generic branch/plant that the JD Edwards EnterpriseOne Inventory Management system uses as a source of default information against which to validate certain types of entries.
You can copy branch/plant ALL to create a new branch/plant. Under some circumstances, you might need to change the settings in branch/plant ALL.
Access the ABC Codes form.
ABC Analysis is based on the principle that a small number of items (A) typically accounts for the largest part of a company's business. A slightly larger number of items (B) accounts for a smaller yet significant amount of business. The remaining large number of items (C), taken together, accounts for only a small amount of business.
You can use the ABC Analysis as the basis for inventory cycle counts (in which A items are counted more often than C items). Determine the natural breaks in the inventory item listing to determine where to define the percentage breaks in the branch/plant constants.
Sales/Gross Margin/Average Investment % (percentage) |
Enter a percentage that specifies how to define the A group during ABC analysis. This number is the total of the A percentage added to the percentage that you want the system to use when it assigns items to the A group. For example, if you want items that make up the top 75 percent of the selling items in the A group and items that make up the next 20 percent in the B group, you enter .95 in this field, which is the total of 75 percent and 20 percent. You enter percentages as decimal amounts. For example, to specify 75 percent, enter .75. During ABC analysis, the system compares the total sales of a single item to the total sales of all items to calculate the value of each item. An item's value is its percentage of the total sales. The system then arranges the values of all items from those of highest value to those of lowest value and adds the values together beginning with the highest. After it reaches the limit for A items, it continues to add values until it reaches the limit for B items. All items for which value is included in the total between the A limit and the B limit are B items. If an item's value causes the total to go over the B limit, the system assigns that item to the C group. |
Access the Item Availability Definition form.
You must define how you want the system to calculate item availability for each branch/plant. Item availability affects how the system calculates back orders, cancellations, and customer delivery times.
Note. If you are using configuration management, you must enter 1 in the Check Availability field in the Configurator Constants program (P3209) to check availability during sales order entry. If the system finds the exact item and string match, a form displays all locations containing the specific configuration.
Access the System Constants form.
Set up system constants to specify which functions to perform. For example, assume that you have several branch/plants and you use different units of measure for the items in each branch/plant. You can set a system constant to automatically convert units of measure by branch/plant.
System constants apply to all branch/plants. You cannot configure system constants for individual branch/plants.
Note. You must restart the system for the changes to take effect.
Unit of Measure Conversion by Branch |
Select this check box to indicate that the system displays the item-specific conversion table when you add an item to a specific branch/plant. If you clear this check box, the system displays the item-specific conversion table for all branch/plants from the Item Master table (F4101). |
Update Average Cost Online |
Select this check box to indicate that the system calculates a new average cost immediately after any transaction occurs that affects the average cost of an item. If you clear this check box, the system calculates a new average cost when you run the Average Cost Update program. All processes that affect average cost create transactions in the F41051 table. |
ECS Control (Energy and Chemical System control) |
Select this check box to indicate that the system will use the Energy and Chemical System control. |
Internet Enable PPAT Messages |
Select this check box to indicate whether the system sends messages that are generated by Distribution programs over the internet. Values are: Y: Send email over the internet. N: Send email to the JD Edwards EnterpriseOne mail box. |
Scientific Rounding |
Select this check box to indicate that scientific rounding should be performed. Currently, this feature is enabled only for Quality Management Test Results. |
Use Customer Set |
Select this check box to indicate that the system uses the customer set. |
Ship Ascending Date Rule |
Select this check box to indicate whether the system applies the ship ascending date rule by customer and by item. When you select this option, the system applies the ship ascending date rule during the sales order entry, and pick slip/commitment and ship confirmation processes. When the system applies the Ship Ascending Date rule, the system sorts shipping customers' lots in ascending order by expiration date, sell by date, or best before date. |
Allow Duplicate Lots |
Enter a code to determine whether the system can assign the same lot to multiple items. Values are: 1: Do not enable duplicate lots. The lot is restricted to one item and one branch/plant. 2: Enable duplicate lots. You can create a lot that crosses multiple items and branch/plants. 3: Do not enable duplicate lots. The lot is restricted to one item, but can contain quantities in multiple branch/plants. |
Sales Price Retrieval UOM (sales price retrieval unit of measure) |
Enter a code from UDC 40/SU that specifies the unit of measure that the system uses for retrieving base prices and price adjustments for sales order processing, service and warranty management, and ship and debit processing. You can define base prices in the F4106 table and price adjustments in the F4072 table in various units of measure. If the base price or price adjustments are not found in the specified unit of measure, the system then uses the primary unit of measure for the item. |
Purchase Price Retrieval UOM (purchase price retrieval unit of measure) |
Enter a code from UDC 40/PU that specifies the unit of measure that the system retrieves for the purchase base price from the F41061 table during purchase order processing. If you specify the unit of measure for transaction or pricing and the system does not find a record in that unit of measure, the system repeats the process using the primary unit of measure of the item. |
Sales Price Based On Date |
Enter a code from UDC 40/D that specifies how the system updates the price effective date in the F4201 and F4211 tables. The JD Edwards EnterpriseOne Sales Order Management system uses the price effective date to retrieve the base price from the F4106 table and price adjustments from the F4072 table. |
Purchase Rebate Category Code |
Enter a code from UDC 43/RU that specifies which category code the system uses in the criteria for inclusion comparison. |
Preference Schedule |
Enter a code from UDC 40/AP that identifies the advanced preference schedule that the system uses when resolving preferences. The advanced preference schedule determines which preferences the system resolves when using the advanced preference functionality. You cannot maintain preference schedules directly through UDCs, but you can maintain preference schedules by using the Price Adjustment Schedule program (P4070). |
Pref Retrieval UOM (preference retrieval unit of measure) |
Enter a code from UDC 40/RU that specifies the unit of measure that the system uses for retrieving advanced preference adjustments during sales order processing. The system enables you to define the advanced preference adjustments in the F4072 table in various units of measure. If you specify the unit of measure for transaction or pricing and the system does not locate a record in that unit of measure, the system repeats the process using the primary unit of measure of the item. |
Accelerated Pricing Resolution Engine |
Specify whether to use the Accelerated Pricing Resolution Engine and whether to use the auto load feature. Values are: Blank or 0: Do not use the Accelerated Pricing Resolution Engine. 1: Use the Accelerated Pricing Resolution Engine. 2: Use the auto load feature. |
Access the Application Constants form.
You define batch control constants to prevent the system from applying changes that unauthorized personnel make to the general ledger. Also, you can define a constant that requires you to enter batch control information before the system runs a batch processing job. You might enter batch control information to compare the anticipated size of the job to the end result.
You must define management approval and batch control separately for each distribution and manufacturing system that you use.
System Code |
Specify a system code. Values include: 31: JD Edwards EnterpriseOne Shop Floor Control 41: JD Edwards EnterpriseOne Inventory Management 42: JD Edwards EnterpriseOne Sales Management 43: JD Edwards EnterpriseOne Procurement |
Mgmt Apprv (management approval) |
Enter a code that indicates whether you want to require approval of batches before they can be posted to the general ledger. Values are: Y: Assign a status of Pending to each batch that you create within the listed systems. N: Assign a status of Approved to each batch. |
Batch Ctrl (batch control) |
Specify whether to require entry of batch control information. Values are: Y: Require entry of batch control information. N: Do not require entry of batch control information. For each batch, the system displays a batch control form on which you must enter information about the number of documents and the total amount of the transactions that you expect in the batch. The system uses these totals to edit and display differences from the actual transactions that you entered. This field applies only to the JD Edwards EnterpriseOne Inventory Management system and the JD Edwards EnterpriseOne Procurement system. In the JD Edwards EnterpriseOne Inventory Management system, the value Y indicates that the system displays a batch control form before you issue, adjust, or transfer inventory. In the JD Edwards EnterpriseOne Procurement system , the value Y indicates that the system displays a batch control form before you enter receipts. |
Access the Branch Location Definition form.
Define the location format to specify how to set up item locations. You can define elements that contain more specific information about the actual location. An element can represent an aisle, bin, shelf, or any other location that you use in a branch/plant. You can use up to ten different elements to define a location's format. For each element, you can define:
Length
Justification
Separator character
The total length of all elements, including separators, cannot exceed 20 characters. The system does not store separators in the tables, but uses separators to edit a location on a form or report. If you do not want to use separators, leave the separator field blank. When you do so, the system displays the location as one string of characters.
Note. If you use the JD Edwards EnterpriseOne Warehouse Management system, you must also define default units of measure for volumes, dimensions, and weights.
Location Separator Character |
Enter a character that divides the elements of the location when you display them on forms or reports. For example, you might use a / as a separator character to divide elements such as aisle, bin, and shelf in a location code. The location code can contain up to 20 characters, including separators. Separators are not stored in the tables, but are used to edit a location on a form or report. If you do not want to use separators, leave this field blank. However, you must enter characters and spaces to equal the correct length of each element in the location code. The system then displays the location as one string of characters. The system uses the character that you enter in this field to separate the combination of tank/owner and aisle/bin as it appears on forms or reports. Companies commonly use a . (period) as the separator character. |
Aisle |
Enter a number that identifies the number of characters to represent the tank (or aisle for packaged stock). Values are numbers 1 –8. |
Bin |
Enter a number that identifies the number of characters to represent the owner for commingled bulk stock (or bin for packaged stock). Values are numbers 1 – 8. |
Code 3–10 |
Enter the number of characters to represent codes 3–10 in the location format specification. |
Access the Branch Location Definition form.
You can separate locations into segments. When you define segments for locations, you set up a template for all the locations throughout the branch/plant. If you use segments across branch/plants, you must define all segments the same for all branch/plants. Locations with segments are useful if the company handles commingled product in the same locations or works with consigned inventory for a customer or vendor.
You cannot add segment information to an existing location. You must either define the segments when you add a new record or manually add the segment information to every existing location.
A location can have up to 10 segments. Each segment is an attribute that you can use for inquiry purposes. Each segment is assigned a rule number that designates that segment as one of these:
Address book number
User-defined code
Range of numbers
Alphanumeric value
You can assign an address book number to the first two segments only. Each segment is limited to a specific length.
Location Segment Specification
Select the Location Segment Specification tab.
Blank Location Allowed |
Select check box to enable a blank location for this branch/plant. |
Aisle |
Enter a code that represents which edit rule the system uses for validating segment 1. Values are: Blank: The system does not perform any validation. 1: The system uses an address book number for validation. 2: The system uses a UDC for validation. 3: The system uses a numeric range for validation. 4: The system uses an alphanumeric code for validation. 5: The system uses an item number for validation. Note. You cannot use this rule with location segment specification. If you want to assign location ownership, either the Aisle or Bin field must contain edit rule 1 to enable an address book number for that segment. |
Bin |
Enter a code from UDC 41/ER that specifies whether to edit rules and values for a location segment. If you want to assign location ownership, either the Aisle or Bin field must contain edit rule 1 to enable an address book number for that segment. |
Code 3–10 |
Depending on the code that you enter in the code fields, enter a valid code or number in the values fields. |
This section provides overviews of warehouse locations setup and multiple location entry, lists prerequisites, and discusses how to:
Set processing options for Location Master (P4100).
Enter locations individually.
Enter multiple locations.
The warehouse consists of locations, such as bins, spaces on a rack, pallet spaces on the floor, and so on. To locate items more easily, you can create a hierarchy of locations within the warehouse and enter information about zones.
After you have defined the format for the locations, you must define all of the locations in a warehouse. Use the format that you specified on the Branch/Plant Constants form to enter each location where you store inventory in the warehouse.
You can define a primary location to store basic information about items in a warehouse. A primary location is not an actual physical location. For example, you could designate a primary location as Location A, and then assign every item in the warehouse to a location that begins with A.
You can also define a blank location as the primary location for inventory items. How the system displays the primary location depends on the location format specifications that you defined for the branch/plant.
Location control is a feature that you activate through the branch/plant constants. Location control is required for the JD Edwards EnterpriseOne Warehouse Management system but optional for all other distribution systems. The system stores location information in the F4100 table.
You can add or revise multiple locations simultaneously instead of one at a time. You specify the range of locations to create (starting and ending at locations that you define) and the incremental value that separates each location.
The Speed Location Setup program (P4100A) enables you to set up the warehouse quickly by copying an existing location to create new locations. Using this program is much faster than entering locations individually. However, if you copy an existing location that contains errors, you duplicate the errors for each new location.
You can use an existing location as the model for creating new locations without having the JD Edwards EnterpriseOne Warehouse Management system installed. However, the fields that the program copies such as the putaway, pick, and replenishment sequences are specific to the JD Edwards EnterpriseOne Warehouse Management system.
You can use up to ten elements to define the location. These elements consist of aisle, bin, and location codes 03 – 10. Each element can consist of either alphabetic characters or numbers. You cannot combine numbers and letters in a single element. You can, however, use multiple elements, some consisting of numbers (such as aisles) and some consisting of letters (such as bins).
The system completes the spaces that precede the elements with either blank spaces or zeros, depending on the business requirements. Some bar code readers do not correctly process blank spaces. To precede elements with zeros, you must specify on the Speed Location Maintenance Revisions form that the system complete the leading spaces with zeros. If you have activated location segment control in the Branch/Plant Constants program (P41001) and are using the address book numbers for validation of the new locations, the system creates locations that do not contain zeros.
A step is a number that the program uses to create locations from a specified range of locations. After the program creates each new location, it increments the location, either by the step number that you enter for locations that are numeric, or by 1 for locations that are alphabetic. Therefore, by entering a range of locations in combination with a step, you can enter many locations at once.
For example, assume that you want to enter new locations for a flow zone in Warehouse A. The flow zone consists of aisles and bins. There are three aisles marked A, B, and C and six bins marked 1 – 6.
For aisles, the range is A through C.
The program creates aisles A, B, and C because it always uses a step 1 for alphabetic locations.
For bins, the range is 1 – 6 and the step number is 1.
The program creates bins 1 – 6 for each aisle, resulting in aisle and bin locations A1, A2, A3, A4, A5, A6, B1, B2, and so on.
In this example, if you enter a step number of 2, the program creates the bin locations of 1, 3, and 5 for each aisle, resulting in aisle and bin locations A1, A3, A5, B1, B3, B5, C1, C3, and C5.
Before you complete the tasks in this section, you must:
Set up the information on the Location Format Specification tab on the Branch Location Definition form.
Verify that Location Control is activated on the Branch/Plant Constants form (optional).
Form Name |
FormID |
Navigation |
Usage |
Work with Location Master |
W4100C |
Inventory Setup (G4141), Define Warehouse Locations |
Work with location master. |
Enter Location Information |
W4100B |
Click Add on the Work with Location Master form. |
Enter locations individually. |
Speed Location Maintenance Revisions |
W4100AA |
Inventory Setup (G4141), Speed Location Maintenance |
Enter multiple locations. |
Work with User-Defined Codes |
W0004AA |
Select Fields To Copy from the Form menu on the Speed Location Maintenance Revisions form. |
Review fields to copy to multiple locations. |
User-Defined Codes |
W0004AI |
Click Add on the Work With User-Defined Codes form. |
Identify fields to copy. |
Processing options enable you to specify the default processing for programs and reports.
Display
1. Location Records |
Specify whether to omit item location records with no quantity available and no quantity inbound/outbound when calling Availability by Location. Blank: Include item location records. 1: Omit item location records. |
Access the Enter Location Information form.
Enter locations individually if you have only a few locations to create or if you do not want to use the speed location process. You select the naming convention (a combination of numbers, letters, or both, such as A/3/4, 6/B/2/A, and so on), and use the format and separator character that you specified on the Branch/Plant Constants form. A separator character is a character such as / that you use to name locations such as A/3/4 or 3.C.9).
Location |
Define a location but do not use a separator character. If you enter the location identifier without the separator character, you must enter characters and spaces to equal the correct length of each element. The system displays the location with the correct separator and spaces. |
LOD (level of detail-location) |
Enter a code from UDC H40/LL that summarizes or classifies locations and provides a hierarchy of locations for review purposes. For example, you can assign aisles to level 2, and individual bins within the aisle as level 3. Use the Detail Level field to specify the beginning level of detail that you want the system to display for the location. |
Mix Item/Lot |
Enter a code from UDC 41/ML that specifies whether to prohibit or enable the system to combine different items into one location or to combine different lot or serial numbers of the same item into one location. |
Access the Speed Location Maintenance Revisions form.
The Speed Location Setup program (P4100A) enables you to:
Specify the location information.
Choose the operation to be performed (Add Locations or Revisions).
Update the F4100 table.
After you select the operation to be performed, the program displays a line in the upper left corner of the form that indicates the number of locations that the specification will create. Be sure that this number is correct before you update. You can change the specification and select the operation again as often as needed to obtain the desired results before you update the table.
If you make a mistake in setting up the locations with the Speed Location Setup program, you cannot delete locations using Speed Location Setup. You can use the Work With Location Master form to:
Delete the mistakes on a location by location basis if only a few errors exist.
Delete an entire range of locations and create them again if many errors exist.
Putaway/Pick/Replen Sequence (putaway/pick/replenishment sequence) |
Assign a number to a location to determine its place in the putaway sequence. Putaway is the movement of inventory to storage after receipt. A sequence of locations describes the path that warehouse employees follow through the warehouse during movement tasks. You can specify in the Movement Instructions program (P46095) whether the system uses the putaway sequence as a tiebreaker when more than one location selected for putaway. For example, you can establish sequencing for the most efficient putaway routing. |
Copy From Location |
Enter the area in the warehouse where you receive inventory. The format of the location is user-defined, and you enter the location format for each branch/plant. |
Leading Zeroes |
Specify whether the system populates leading spaces with zeroes instead of blank spaces. |
This section provides an overview of default location information setup, lists prerequisites, and discusses how to:
Define a default location and approval route code.
Assign default print queues.
When you set up default location information, you assign a branch/plant and print queue to a terminal that the system uses every time you sign in.
A default location is the branch/plant that is assigned to the user ID or terminal ID. If the system uses a default location, it automatically displays the branch/plant. In addition to setting up a default branch/plant for each user who works for the organization, you can also set up a default branch/plant for each supplier and customer who uses the self-service website to enter and review information about orders, quotes, inventory, and so on. If no branch/plant is assigned to a user ID or terminal ID, the user then must enter a branch/plant manually. When you set up a default branch/plant, you also can define an approval route code if you use approval routing for purchase orders.
Default print queues represent the location where the system sends certain types of documents. You can assign a default print queue so that for each time that you print, the system sends the document to the default print queue. If you have not assigned a default print queue, the system first accesses the print queues that were assigned in the version list, and then accesses the print queue that is assigned to the user profile.
Print programs that you have automatically defined access the Default Print Queues table (F40096). To display other print programs, you must set them up as UDCs and modify them to access the F40096 table.
Before you complete the tasks in this section, you must:
Verify that branch/plants are set up.
Verify that print queue codes are set up in UDC 40/PP.
Form Name |
FormID |
Navigation |
Usage |
Work With Default Location & Printers |
W400951A |
Inventory Setup (G4141), Default Location & Printers |
Review default locations and printers. |
Default Location & Approval |
W400951B |
Click Add on the Work With Default Location & Printers form. |
Define a default location and approval route code. |
Default Print Queues |
W40096A |
On the Work with Default Location & Printers form, select a record, and then select Print Queues from the Row menu. |
Assign default print queues. |
Access the Default Location & Approval form.
Terminal/User ID |
Enter the workstation ID number. |
Blend Business Unit |
Enter the blend business unit that the system uses as a default. This field is visible only when you are using system SY31B. |
Grower Cost Center |
Enter the grower cost center that the system uses as a default. This field is visible only when you are using system SY40G. |
Approval Route Code |
Enter a code that determines to whom an order is routed for approval. |
Access the Default Print Queues form.
Output Queue |
Specify the waiting area that a job goes to after it has processed. Output queues (OUTO) are sometimes attached to printers. If an OUTQ is not specified, the system uses the default value from the user's job description. |
Note. You must sign out and restart the system to see the new and changed assignments.
This section provides an overview of standard units of measure, lists a prerequisite, and discusses how to set up standard units of measure.
You must define units of measure for each inventory item. Use the standard unit of measure information as a template for configuring the unit of measure information. You specify the primary unit of measure and unit of measure conversions for:
Each item or item/branch combination.
All items using standard units of measure.
Specify the primary unit of measure information for individual items or item/branch combinations when you set up item or branch information. The system stores unit of measure information in the Item Units of Measure Conversion Factors table (F41002).
The system stores unit of measure conversions that are not item specific in the Unit of Measure Standard Conversion table (F41003). You can also use unit of measure conversion information that you set up here for non-stock items in other distribution systems.
After you enter a transaction, the system uses this hierarchy to determine the unit of measure for an item:
The system first searches the Item Master for records that have item-specific unit of measure conversions.
If no records are found in the F41002 table, the system checks for system-wide standard UOM conversions for the item or item/branch in the F41003 table.
If no records are found in either the F41002 table or the F41003 table, the system displays an error message.
When you define standard units of measure, you can create any number of conversion factors for any number of units of measure, but they must all be able to convert to primary through either a direct path—for example, 1 box equals 2 each where each is primary—or an indirect path—for example, 1 crate equals 2 boxes equals 4 each. You can also set up conversion factors that associate each unit of measure with the primary unit of measure.
Example: Conversion Factors for Units of Measure
1 box = 2 each
1 crate = 2 boxes
1 pallet = 2 crates
To determine the primary unit of measure, the system performs this calculation:
1 box = 2 each
1 crate = 4 each
1 pallet = 8 each
Before you complete the tasks in this section, you must verify that units of measure are set up in UDC 00/UM.
Form Name |
FormID |
Navigation |
Usage |
Work with Standard Units of Measure |
W41003A |
Inventory Setup (G4141), Standard Units of Measure |
Review standard units of measure. |
Standard Units of Measure Revisions |
W41003B |
Click Add on the Work with Standard Units of Measure form. |
Set up standard units of measure. |
Access the Standard Units of Measure Revisions form.
From Unit of Measure |
Enter a code from UDC 00/UM that identifies the unit of measure for an item. For example, it can be eaches, cases, boxes, and so on. |
Conversion Factor |
Enter the factor that the system uses to convert one unit of measure to another unit of measure. |
To Unit of Measure |
Enter a code from UDC 00/UM that specifies an additional unit of measure. |
This section provides an overview of item cross-reference setup, lists prerequisites, and discusses how to:
Set processing options for Item Cross Reference (P4104).
Set up cross-references for promotional items.
Set up price cross-references for related items.
As you manage the inventory, you might decide to define relationships between the company's item information and the item information of the suppliers and customers. Additionally, you might set up substitute items, replacement items, and bar codes that are associated with an item. Cross-references associate the internal item numbers with those from other trading partners. You can manage these cross-references in the JD Edwards EnterpriseOne Inventory Management system. For example, customers can order items using their item numbers. If you set up item cross-references for a customer, you can easily convert the customer's item numbers into the company's equivalent.
This table provides examples of cross-referenced items:
Cross-Referenced Item |
Usage |
Vendor item numbers |
Use when vendors require their part numbers for orders or communications. |
Customer item numbers |
Use when customers prefer to order their part numbers. |
Item revision level |
Use for demand scheduling when customers order new parts for older items. In some industries, such as the automotive industry, a supplier manufactures new parts for current models and replacement parts for older models, while receiving a variety of orders for different parts. In this situation, you can use a combination of the values for customer item number and the customer item revision level. |
Substitute items |
Use when the item that is ordered has no quantity on hand. |
Replacement items |
Use when you or your vendors discontinue an item and replace it with a new item. |
Bar codes |
Use to associate bar code input with a specific item. |
Associated items |
Use to recommend an item as part of the sale. |
When setting up cross-references for electronic data interchange, you should cross-reference each possible number that the trading partners might transmit.
Cross-References for Promotional Items
During sales and purchase order entry, the system can automatically replace an item with a promotional item. Examples of promotional items include:
A regular item with a coupon.
A larger item, such as ten percent additional quantity for free.
An item with an additional item in the same package.
You specify prices for new items according to the price indicators that you assign using cross-reference information. You can establish only one promotional item for an item at a time.
You set up promotional item information at the customer or supplier level. For supplier promotions, you can order a regular item and replace it with the promotional item, or order the promotional item itself.
This table describes how the system handles promotional line items for sales orders and purchase orders:
Promotional Line Item |
Description |
Sales Order Entry (P4210) |
For sales orders, the system cancels the original line item and adds a new promotional line item. If you specify the cross-reference type SP (Sales Promotional Item) in the Promotional Items processing option on the Cross Ref tab, the system searches the F4104 table for sales promotional items. If a promotional item exists, the system cancels the original order line and adds the promotional item to the order. |
Purchase Orders (P4310) |
For purchase orders, the system replaces the original line item with the values for the promotional line item and issues a warning. If you specify the cross-reference type PP (Purchasing Promotional Item) in the Promotional Items processing option on the Cross Ref tab, the system searches the F4104 table for promotional items and replaces the original item with the promotional item. |
The system uses the F4104 table to process promotional items, as well as these activity status codes in UDC 40/AT for promotional purposes:
917: Added Promotional Item.
990: Canceled by Promotional Item.
Cross-References for Related Items
When an item is out of stock and you offer a substitute or related item, you can specify that the system should offer the best or lowest price. For example, a promotion of ten percent is given for a particular item. If the item is out of stock when ordered, and you offer the customer a substitute item, you can offer the promotional price for the substitute. This price is the lowest price after applicable promotions or discounts. It also can be the original item's price or the substitute item's price.
When you specify substitutes for items using the Item Cross Reference program (P4104), you must specify the type of base price and adjustment to use for the substitute item. If you do not specify values for the base price and adjustment indicators, the system uses the value that is specified in the Substitute Items processing option on Cross Ref tab of the Sales Order Entry program (P4210).
Before you complete the tasks in this section, you must:
Set up additional, user-defined cross reference types in UDC 41/DT.
Set up Purchasing Promotional Items (PP) and Sales Promotional Items (SP) cross-reference types in UDC 41/DT.
Use special handling codes to prevent multiple promotional items within the same time frame.
Verify that you have entered Y in the Advanced Procurement Pricing field and the Advanced Sales Pricing field on the Pricing Constants form if you need to apply adjustments.
You can access the Pricing Constants form by selecting Price Constants from the Form menu on the Branch/Plant Constants form.
Note. Depending on how you set the processing options, the system displays either the Item Cross Reference Revisions By Address form or the Item Cross Reference Revisions By Item form.
Form Name |
FormID |
Navigation |
Usage |
Work with Item Cross Reference |
W4104A |
|
Review cross-references for related items. |
Item Cross Reference Revisions By Item |
W4104C |
Click Add on the Work with Item Cross Reference form. |
Set up cross references for promotional items. |
Item Cross Reference Revisions By Address |
W4104B |
Click Add on the Work with Item Cross Reference form. |
Set up price cross-references for related items. |
Processing options enable you to specify the default processing for programs and reports.
Processing
Revise by Item or Address |
Specify whether to enter cross-references by item number or by address book number. Values are: Blank: Use the Item Cross Reference Revisions By Address form to revise by address book number. 1: Use the Item Cross Reference Revisions By Item form to revise by item number. Note. This processing option does not affect the display of the Work with Item Cross Reference form. |
Access the Item Cross Reference Revisions By Item form.
Base Price Indicator |
Enter a value from UDC 42/IP that indicates which base price to use for related items. For example, this code can specify using the price for the original item, the substitute item, or the best price, depending on the item's value. If you leave this field blank, the system uses the code that is specified in the Pricing for Substitute Items processing option on the Cross Ref tab in the Sales Order Entry program (P4210). If you leave this processing option blank, the Adjustment Indicator field must also be blank. Likewise, if you enter a value in this field, you must also enter a value in the Adjustment Indicator field. |
Adjustment Indicator |
Enter a code from UDC 42/IA that indicates which price adjustment to use for related items. These adjustments can include the original item's adjustment, a substitute item's adjustment, the best adjustment, or no adjustment, depending on the item's value. If you leave this processing option blank, the system uses the value that is specified in the Pricing for Substitute Items processing option in the Sales Order Entry (P4210) processing options. |
Card Number |
Enter an OEM-assigned value from UDC 40R/CD that further describes the part number. |
See Also
Setting Processing Options for Sales Order Entry (P4210)
Setting Processing Options for Purchase Orders (P4310)
Access the Item Cross Reference Revisions by Address form.
Note. You can optionally enter the effective date, expired date, cross-reference description, and customer supplier item revision level.
X-Ref Type (cross reference type) |
Enter a code from UDC 41/DT that identifies the type of cross-reference setup for this customer. Examples of cross-reference types include substitutes, replacements, and customer and supplier item numbers. |
Address Number |
Enter the address number of the customer or supplier. Leave this field blank to apply to all customers or suppliers. |
Item Number |
Enter a number that the system assigns to an item. It can be in short, long, or third item number format. The format is determined by branch/plant ALL. The item identifier that is blank is the primary item number. Enter the primary item number. |
Cross Reference Item Number |
Enter the cross-reference item number that the system assigns to an item number. A cross-reference number enables you to use a supplier's item number if it is different from the item number you use when you are processing an order or printing. You set up this number in the Item Cross-Reference program (P4104). This item number is not validated against the Item Master because it may or may not be stored in the Item Master. |
Expired Date |
Enter the date on which a transaction, text message, agreement, obligation, or preference has expired or been completed. |
Cross Reference Description |
Enter a remark about an item. |
Customer Supplier Item Revision Level |
Enter a reference number that is used to identify the revision level of the customer's item. When using item cross-reference to translate a customer or supplier external item number to the internal short item number, the customer's number only is not always sufficient. In some instances, the customer part number must be used in conjunction with the item revision level. This combination enables the system to uniquely identify the customer's item. |
This section provides an overview of message setup and discusses how to:
Set up messages.
Define print information for messages and item notes.
Define document type exceptions.
You can define two types of messages throughout JD Edwards EnterpriseOne systems:
Print messages, which are messages that you attach to different document types, customers, or suppliers.
Item notes, which are messages that you attach to items.
You set up print messages and item notes in the same way. An easy and efficient method is to select an existing message as a base and modify the description and text. Using a base message is also helpful when you need to define the same message or note in multiple languages.
You can display:
Print messages or item notes.
Current messages.
All messages, including those that have expired.
To print a message, you can select an existing version from the versions list or create a new version.
You also can delete a message, although you should consider that:
If you delete a message in a specific language, the system deletes only that message.
No other languages are affected.
If you delete the base message, the system deletes all messages that are related to the base message.
The system removes the message code, detail information, and text lines from the text tables.
Form Name |
FormID |
Navigation |
Usage |
Work with Print Message |
W40162D |
Inventory Setup (G4141), Print Message Revisions |
Review print messages. |
Print Message Revisions |
W40162C |
Select a record, and select Revisions from the Row menu on the Work with Print Message form. |
Set up messages. |
Document Selection |
W40162A |
Select a record on the Work With Print Message form, and then select Documents from the Row menu. |
Define print information for messages and item notes. |
Document Type Exceptions |
W40162B |
Select Doc Typ Exception from the Row menu on the Document Selection form. |
Define document type exceptions. |
Access the Print Message Revision form.
Print Message |
Enter a code from UDC 40/PM that identifies a predefined message from Print Message Revisions form. You can print the message on sales orders, purchase orders, and so forth. |
Access the Document Selection form.
You must define the documents on which to print messages. For example, you might print special delivery instructions on every work order. You cannot define individual print programs for item notes. All item notes print on all documents.
Sometimes a print program generates a document that is used for multiple purposes. For example, you can use the Purchase Order Print program (R43500) to print both purchase orders and other documents such as blanket orders and sales bids. In this example, you might have a message that you print only on blanket orders. For each print program, you can define the document types that exclude messages.
Print on Report |
Specify whether the print message/item note text should print on a specific report. Values are: Y: Print. N: Do not print. |
Access the Document Type Exceptions form.
This section provides an overview of document type information and discusses how to set up document type information.
Document types can have various characteristics associated with them. The system stores this information in a UDC that is specific to the type of information.
You can set up and maintain information about document types by using the Document Type Maintenance program (P40040). This program updates the Document Type Master table (F40039), a single repository for information that is currently stored in various UDCs. This program also updates the User Defined Codes table (F0005).
The Document Type Maintenance program currently maintains information for document types in these UDCs:
Trace/Track Document Types in UDC 40/DC
Commitment Document Types in UDC (40/CT
Blanket Order Types in UDC 40/BT
Inventory Update Types in UDC 40/IU
Transaction Type in UDC 39/TT
Nature of Transaction in UDC 40/NT
Category of Order in UDC 40/OC
Other Quantity in UDC 40/OQ
Interbranch Orders in UDC 40/IB
Service Contract Type in UDC 17/CM
Work Order Type in UDC 48/OT
Carton Status in UDC 46/RS
Note. When you add information directly into any of these UDCs, only the F0005 table is updated. The information is not updated in the F40039 table.
You can use the Document Type Maintenance program to add document types. Using this program is an advantage if you specify some or all of the other information that is included in the Document Type Maintenance program.
You can also specify which document types to exclude if you do not want certain branch/plants to be included in the Item History table (F4115)when processing specific document types.
Form Name |
FormID |
Navigation |
Usage |
Work with Document Types |
W40040A |
Inventory Setup (G4141), Document Type Maintenance |
Review document types. |
Document Type Revisions |
W40040B |
Click Add on the Work with Document Type form. |
Set up document type information. |
Edit Document Type Exclusions |
W400391A |
|
Specify which branch/plants to exclude when processing a specific document type. |
Access the Document Type Revisions form.
Inventory
Select the Inventory tab.
Ignore, Incoming, Outgoing, and Both |
Select one of these options: Ignore: The system selects no transactions. Incoming: The system selects only incoming transactions. Outgoing: The system selects only outgoing transactions. Both: The system selects both incoming and outgoing transactions. |
Include in Integrity Report |
Select this option if you want the system to include transactions with the appropriate document type in inventory integrity reporting (R41543-Item Ledger/Account Integrity report and R41544-Item Balance/Ledger Integrity report). Note. This feature is not currently activated. |
Cross Docking Supply |
Enter a value that specifies the type of transaction the document type is used for.Values are: Blank: Other transactions 1: Purchase order receipts 2: Work order completions |
Display Lot Trace/Track |
Specify whether inventory transactions with the appropriate document type are displayed in lot tracing and tracking. If you do not select this option, the system processes inventory transactions with this document type, but the transactions do not appear in lot tracing and tracking. |
Consolidate Lot Trace/Track |
Select this check box to consolidate inventory transactions. |
Nature of Transaction |
Enter a code from UDC 40/NT that specifies how Lot Trace/Track processes inventory transactions that have a From side and a To side, as well as Bottom and Top levels. Examples of From/To transactions are Inventory Transfers, Inventory Reclassifications, and Work Order Issues/Completions. Examples of Bottom/Top transactions are Sales Orders and Purchase Receipts. An inappropriate value causes the inventory transaction to be processed incorrectly. |
Sales
Select the Sales tab.
Order Category |
Enter a code from UDC 40/OC that identifies blanket order types in the JD Edwards EnterpriseOne Sales Order Management system and the JD Edwards EnterpriseOne Procurement system . Values are: 0: Regular Order 1: Blanket Order 2: Quote - No Quantity Release 3: Quote - Quantity Release In the JD Edwards EnterpriseOne Sales Order system, when the Order Type option is selected, if the order is set up as type 2 or 3 (Quotes), a value will be hard coded into the F4201 OTIND (Order Type Indicator) field to specify that a particular order is a quote. |
Interbranch Orders |
Enter a value of 1 to identify this order type as an interbranch order type. When you create an interbranch order using the Sales Order Entry program (P4210), the system processes additional order information, such as cost markup. You would use an Interbranch order in a situation in which the customer places an order with a sales office, but the sales office ships the inventory to the customer from a warehouse facility. The system creates accounting transactions and intercompany invoices for interbranch sales orders during Sales Update and Invoice Print. |
Other Quantity |
In the JD Edwards EnterpriseOne Sales Order Management system, this field determines whether the Quantity on Other Sales Order 1 or 2 field in the Item Location file is updated instead of the Soft Commit field or the Hard Commit field. In the JD Edwards EnterpriseOne Procurement system, this field determines whether the Quantity on Other Purchase Order field is updated in the Item Location file instead of the On Purchase Order field. |
Relieve On Hand Inventory at Ship Confirm |
Use this field to indicate whether the quantity that is committed to this sales order should be relieved from the on hand quantity during the Shipment Confirmation process. If this option is disabled, the Shipment Confirmation process hard commits only the quantity that is shipped to the appropriate item location. Note. This feature is not currently activated. |
Ship And Debit Processing |
Specify whether ship and debit processing is activated or inactivated for a document type. |
Next Number System Code |
Enter a code from UDC 98/SY that identifies a system. |
Document Type Next Number |
Specify which next number series to use when creating order numbers for this order type. Ten next number series are available. Use this field with:
|
Send Status Notification |
Specify whether to send notification of status change. Enter Y or N. |
Procurement
Select the Procurement tab.
Next Number System Code |
Enter a code from UDC 98/SY that identifies a system. |
Commit Procurement Orders |
Select this check box to indicate that the system automatically commits the amount on a purchase order for a service or a subcontract. |
Publish Externally |
Select this check box to indicate that you can publish a document type externally. |
S/WM
Select the S/WM tab.
Contract Type |
Enter a code from UDC 17/CM that the system uses to define whether the document type relates to either a service or supplier contract. The service contract can be either a regular or quote contract. |
Work Order Definition
Select the Work Order Definition tab.
Order Type |
Enter a code that the system uses to determine the type of work order, based on the value in the Order Type field. Values are: 01: Unrelated to work order. 02: Manufacturing work order. 03: Manufacturing rework work order. 04: Equipment work order. 05: Service work order. 06: Warranty claim order. 07: Supplier recovery order. 08: Engineering change order. 09: Engineering change request order. 10: Property Management order. 11: Engineer to Order summary order. 12: Rate schedule order. |
Shipping
Select the Shipping tab.
Carton Creation Status |
Enter a code from UDC 46/RS that specifies which status the system uses when creating cartons in the F4615 table. |
Carton Change Status |
Enter a code from UDC 46/RS that specifies which status the system uses when changing cartons in the F4615 table. |
Recommended Standard Packs |
Select this check box to indicate that standard pack carton recommendations are created for a document type. |
Enable Shipment Sequencing |
Select this check box to enable shipment sequencing. Shipment sequencing is a functionality that is available within the JD Edwards EnterpriseOne Transportation Management system. |
This section provides overviews of AAIs in distribution systems and AAIs in the JD Edwards EnterpriseOne Inventory Management system, lists prerequisites, and discusses how to:
Set processing options for distribution AAIs (P40950).
Set up AAIs.
AAIs define the day-to-day functions, chart of accounts, and financial reports. The system uses AAIs to determine how to distribute GL entries that the system generates. For example, in JD Edwards EnterpriseOne Inventory Management, AAIs indicate how to record the transaction after you issue inventory from a location.
For distribution systems, you must create AAIs for each unique combination of company, transaction, document type, and GL class that you anticipate using. Each AAI is associated with a specific GL account that consists of a business unit, an object, and a subsidiary (optional). You also can enter memo text on the generic text form for each AAI table.
After you review and revise the existing AAIs for the business needs, you might need to set up additional AAI items. The system stores AAIs in the F4095 table.
This table identifies the predefined AAI items that are available in the JD Edwards EnterpriseOne Inventory Management system:
AAI |
Description |
3910 |
An AAI to identify the inventory account for the inflation adjustment process. |
3911 |
An AAI to identify the results account, which serves as the offset to the inventory adjustments account. |
4122 |
An inventory AAI that provides the balance sheet inventory valuation account. |
4124 |
An inventory AAI that provides the expense or cost of goods sold account. |
4126 |
A zero balance adjustment AAI that provides the inventory offset account. |
4128 |
A zero balance adjustment AAI that provides the expense or cost of goods offset account. |
4134 |
An item balance cost change AAI that determines the inventory offset account. |
4136 |
An item balance cost change AAI that determines the expense or cost of goods offset account. |
4141 |
A standard cost variance AAI that determines the cost of goods offset account. |
4152 |
A physical inventory update AAI that determines the inventory offset account. |
4154 |
A physical inventory update AAI that determines the cost of goods offset account. |
4162 |
An AAI that determines the average cost update-inventory |
4164 |
An AAI that determines the average cost update-cost of goods sold |
4172 |
A batch cost maintenance AAI that determines the inventory offset account. |
4174 |
A batch cost maintenance AAI that determines the expense or cost of goods offset account. |
4182 |
A bulk product gain/loss AAI that determines the bulk inventory offset account. |
4184 |
A bulk product gain/loss AAI that determines the expense or cost of goods offset account. |
Before you complete the tasks in this section, you must:
Set up companies.
Verify transaction types in UDC 00/DT.
Set up document types in UDC 00/DT.
Set up GL Class codes in UDC 41/9.
Set up account master information.
Determine the account numbers to use for recording transactions.
Form Name |
FormID |
Navigation |
Usage |
Work with AAIs |
W40950B |
Inventory Setup (G4141), Automatic Accounting Instructions |
Review AAIs. |
Account Revisions |
W40950D |
Select a record, and select Details from the Row menu on the Work with AAIs form. |
Set up AAIs. |
Processing options enable you to specify the default processing for programs and reports.
Defaults
AAI Table Number |
Enter 1 if the Cost Type field should be available to these Distribution AAI tables: 4122 4124 4134 4136 4220 4240 4310 |
Access the Account Revisions form.
Co (company) |
Enter a code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note. You can use company 00000 for default values such as dates and AAIs. You cannot use company 00000 for transaction entries. |
Do Ty (document type) |
Enter a code from 00/DT that identifies the origin and purpose of the transaction. The system reserves several prefixes for document types, such as vouchers, invoices, receipts, and time sheets. |
GL Cat(GL category) |
Enter a code from UDC 41/9 that identifies the GL offset that the system uses when it searches for the account to which it posts the transaction. If you do not want to specify a class code, you can enter **** (four asterisks) in this field. You can use AAIs to predefine classes of automatic offset accounts for the JD Edwards EnterpriseOne Inventory Management, the JD Edwards EnterpriseOne Procurement system, and the JD Edwards EnterpriseOne Sales Order Management systems. You can assign GL class codes in the following ways:
The system can generate accounting entries based upon a single transaction. For example, a single sale of a stock item can trigger the generation of accounting entries similar to:
The system uses the class code and the document type to find the AAI. |
Branch Plant |
Enter an alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority. If you leave this field blank, the system uses the business unit that you entered on the work order, in the Charge to Cost Center field. |
Obj Acct (object account) |
Specify the portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note. If you use a flexible chart of accounts and the object account is set to six digits, You should use all six digits. For example, entering 000456 is not the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a six-digit object. |
Sub (subsidiary) |
Enter a subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. Note. If you are using a flexible chart of accounts and the object account is set to six digits, you must use all six digits. For example, entering 000456 is not the same as entering 456 because, if you enter 456, the system enters three blank spaces to fill a six-digit object. If you leave this field blank, the system uses the value that you entered on the work order in the Cost Code field. |
This section provides an overview of item record reservations.
JD Edwards EnterpriseOne systems provide you with an item record reservation capability which, when activated, allows only one user at a time to update information that is contained in the F4101 table and the F4102 table. After one user finishes updating information, then another user can access the appropriate program to continue updating information.
After you have entered Item Master and Item Branch/Plant records, you may want to limit access to the programs to preserve data integrity. Inaccuracies can result when multiple users are updating data at the same time.
By accessing UDC 00/RR for record reservations, you can specify that record reservation be activated for a particular program by entering a value of 1 in the Special Handling field.
You can reserve item records for these programs:
Item Master (P4101).
Matrix Items (P4101E).
Non Stock Item Master (P4101N).
Item Branch (P41026).
Item Master Unedited Transactions Inbound Processor (R4101Z1I).
Item Balance Purge F4102 (R4102P).
ABC Analysis (R4164).
Global Reporting Code Update (R41803).
Item Master Global Update (R41804).
Item Balance Global Update (R41805).
When you reserve a record, other users receive an error message for the record. You can view all reserved records from the Remove Business Object Reservation program (P00095).