This chapter contains the following topics:
Section 3.3, "Working with the Accelerated Pricing Resolution Engine"
Section 3.4, "Setting Up Automatic Accounting Instructions (AAIs) for Advanced Pricing"
You can set up JD Edwards EnterpriseOne Advanced Pricing to meet your company's needs. JD Edwards EnterpriseOne Advanced Pricing integrates with JD Edwards EnterpriseOne Sales Order Management for efficiency and accuracy.
This table lists the JD Edwards EnterpriseOne Advanced Pricing setup features:
You must set up these JD Edwards EnterpriseOne Advanced Pricing features in other EnterpriseOne systems, such as Inventory Management, Procurement, Sales Order Management, and General Accounting:
Additionally, if you use JD Edwards EnterpriseOne Advanced Pricing with the JD Edwards Grower, Pricing, and Payments system and the JD Edwards Grower Management system, you must ensure that you select the Advanced Procurement Pricing constant on the Pricing Constants form and activate the JD Edwards Grower Management system.
To use JD Edwards EnterpriseOne Advanced Pricing with the JD Edwards EnterpriseOne Quality Management system, you must activate the JD Edwards EnterpriseOne Quality Management system.
This section provides an overview of Advanced Pricing constants and discusses how to set up:
System constants
Pricing constants
Set up system constants to determine which functions to perform. For example, if you have several branch/plants and 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. System constants apply to all branch/plants. You cannot customize system constants for each branch/plant.
For Advanced Pricing, the system constants define how the system retrieves price adjustments for sales orders and purchase orders. When you set up base prices and adjustments, you can use various units of measure and effective date ranges. The system retrieves the unit cost for a purchase order detail line based on either the transaction unit of measure, the purchasing unit of measure, or the primary unit of measure. Additionally, you can retrieve the price based on specific dates in the order process. For example, you can base the sales price on the date that the item is shipped versus the date that the order is entered in the system.
The system uses pricing constants to control which JD Edwards EnterpriseOne system— Sales Order Management, Procurement, or both—uses JD Edwards EnterpriseOne Advanced Pricing. Additionally, you can assign the special characters in the price formulas for sales or purchase order adjustments. You can also specify other controls, such as using the sold to address book number to retrieve direct price adjustments, applying pricing approvals, or use promotional pricing. You can set the Sales Pricing on Override Price, Procurement Pricing on Override Price, or both options to override the price and perform manual price adjustments and view the price history records. To increase system performance, you can activate the Accelerated Pricing Resolution Engine.
Like system constants, pricing constants apply to all branch/plants. You cannot customize the settings for each branch/plant.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
System Constants | W41001F | Sales Order Management Setup (G4241), Branch/Plant Constants
Select Sys Constants (system constants) from the Form menu on the Work With Branch/Plant Constants form. |
Set up and review system constants. |
Pricing Constants | W41001D | Select Price Constants from the Form menu on the Work With Branch/Plant Constants form. | Set up and review pricing constants. |
Access the System Constants form.
Enter a user-defined code (UDC) 40/SU to specify 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. The system enables you to 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, then the system uses the primary unit of measure for the item.
Enter a value to determine how the system updates the Price Effective Date in the F4201 and F4211 tables. In JD Edwards EnterpriseOne Sales Order Management, the system uses the Price Effective Date to retrieve the base price from the F4201 table and price adjustments from the F4211 table.
Enter a value from UDC 40/PU to specify the unit of measure that the system retrieves for the purchase base price from the F41061 table during purchase order processing. If you use JD Edwards EnterpriseOne Advanced Pricing and Procurement, complete this field.
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.
Enter a UDC (43/RU) to determine which category code that the system uses in the criteria for inclusion comparison. If you use JD Edwards EnterpriseOne Advanced Pricing and Procurement, complete this field.
Enter a value from UDC 40/AP to identify 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). If you use advanced preferences, complete this field.
Enter a value from UDC 40/RU to specify 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 unit of measures. If you use advanced preferences, complete this field.
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.
Enter 1 to use the Accelerated Pricing Resolution Engine. When you enter 1 in this field, you must then access the Accelerated Pricing Resolution Engine Workbench program (P4530) to load the cache. Anytime you restart the system, you must access the Accelerated Pricing Resolution Engine Workbench program to load the cache.
Note: JD Edwards recommends that you become familiar with the functions and limitations of the Accelerated Pricing Resolution Engine, and how to manage the Accelerated Pricing Resolution Engine before you enable its use.When any changes are made to cached tables that the system accesses for transactions (for example, sales order entry), the system does not use the changes until you reload the cache. |
See Working with the Accelerated Pricing Resolution Engine.
Values are:
Blank or 0: Do not allow use of the Accelerated Pricing Resolution Engine.
1: Allow use of the Accelerated Pricing Resolution Engine.
Access the Pricing Constants form.
Indicate how the system determines the price of items within the system. If your system includes the JD Edwards EnterpriseOne Advanced Pricing system, you may use this feature. Values are:
Y: Yes, use the JD Edwards EnterpriseOne Advanced Pricing system.
N: No, do not use the JD Edwards EnterpriseOne Advanced Pricing system.
Specify whether to apply advanced pricing to the purchase price. Values are:
Y: Apply advanced pricing to the purchase price.
N: Apply standard price adjustments to the purchase price.
Enter the value that specifies whether all price changes are provided through price approval workflow. Values are:
Y: Yes, apply price approval workflow.
N: No, do not apply price approval workflow.
Enter a value to specify how the pricing calculation program selects the price adjustments. Leave blank to select a named price adjustment schedule. Blank is the default.
Enter 1 to select the pricing address number.
Enter 2 to select both a schedule and the address number.
Specify whether to apply additional adjustments when overriding pricing on sales order detail lines. Values are:
Y: Yes, apply adjustments for an override price.
N: No, do not apply adjustments for an override price.
Specify whether to apply additional adjustments when overriding pricing on purchase order detail lines. Values are:
Y: Yes, apply adjustments for an override price.
N: No, do not apply adjustments for an override price.
Enter a UDC, (01/TS) that identifies a type of organizational structure that has its own hierarchy in the JD Edwards EnterpriseOne Address Book system (for example, e-mail). When you create a parent/child relationship for the JD Edwards EnterpriseOne Accounts Receivable system, the structure type must be blank.
Select to use the ship to address book number to retrieve direct price adjustments. The system uses this address number as the starting point for processing through the buying structure to find direct price adjustments. Clear to use the sold to address number.
Specify the character the system uses to identify a variable table in the JD Edwards EnterpriseOne Advanced Pricing system. When you precede a table name by this character, the system recognizes the name as a table name for formula pricing calculations, such as alphabetic, numeric, and mathematical functions. For example, the +,−,×, and ÷ symbols are not valid in this field.
Specify the character the system uses to identify a unit of measure in advanced pricing formulas. When you precede a unit of measure by this character, the system recognizes the entry as a unit of measure for formula pricing calculations, such as alphabetic, numeric, and mathematical functions. For example, the +,−,×, and ÷ symbols are not valid in this field.
Specify the character the system uses to identify a currency code in advanced pricing formulas. When you enter a precede a currency code by this character, the system recognizes the entry as a currency code for formula pricing calculations, such as alphabetic, numeric, and mathematical function. For example, the +,−,×, and ÷ symbols are not valid in this field.
Specify the character the system uses to identify database fields in advanced pricing formulas. When you precede a database field by this character, the system recognizes the entry as a database field for formula pricing calculations, such as alphabetic, numeric, and mathematical function. For example, the +,−,×, and ÷ symbols are not valid in this field.
Enter a character to identify a test result name in an advanced pricing formula in your system. When you enter a test result name preceded by this character, the system recognizes the name as a test result name for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example, +,−,×, and ÷) symbols are not valid in this field.
Note: When you set up test result names, it is recommended that you do not use a user-defined character in the Test Result Name field. For example, do not use any user-defined characters that you set on the Pricing Constants form or special characters, such as &,%,!,?, @, $, | or #. When you use a test result name with an advanced pricing formula, the system does not interpret this symbol in both the formula and the test result name. For example, you want to reduce the purchase price of grapes by 10 percent for every Brix test result below 23. A Brix test result of 22 reduces the price by 10 percent, a Brix test result of 21 reduces the price by 20 percent, and so forth. For example, the advanced pricing formula might be:((23 − @BRIX) × −.1) × #UPRC In this example, the @ symbol is part of the formula to determine the price of the grapes based on the Brix test result. If you use a symbol in the formula and add a test result name with a symbol, the system does not distinguish between the two symbols. |
Enter a character to identify a function name in an advanced pricing formula in your system. When you enter a function name preceded by this character, the system recognizes the name as a function name for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example, +,−,×, and ÷) values are not valid in this field.
Enter a character to identify a function argument separator in an advanced pricing formula in your system. When you enter a function, the system recognizes the arguments of the function based on the function argument separator. Alphabetic, numeric, parenthesis, and mathematical function (for example, +,−,×, and ÷) values are not valid in this field.
Enter a character to identify an adjustment detail reference sequence in an advanced pricing formula in your system. When you enter an adjustment detail reference preceded by this character, the system recognizes the sequence as an adjustment detail reference sequence for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example, +,−,×, and ÷) values are not valid in this field.
Enter a UDC, (40P/PS) to use an internal or third-party promotion package.
Values are:
0: No promotions system.
1: JD Edwards EnterpriseOne promotions system.
2: Third-party promotions system.
Enter a UDC, (40P/PR) to specify which promotion to use when multiple promotions are in effect for an item or customer.
This section provides an overview of the accelerated pricing resolution engine and discusses how to set up the accelerated pricing resolution engine.
As you use the JD Edwards EnterpriseOne Advanced Pricing system, you can create a substantial number of records for the system to process. You can use the accelerated pricing resolution engine to increase system performance and give users quicker access to pricing and advanced preference data. You must first set the Accelerated Pricing Resolution Engine field on the System Constants form.
Whenever you start or restart your system, you must then manually load the cache using the Accelerated Pricing Resolution Engine Workbench program (P4530).
The cache contains data from these JD Edwards EnterpriseOne Advanced Pricing tables:
Price Adjustment Detail (F4072).
Group Code Key Definition Table (F4092).
Item Key ID Master File (F40941).
Customer Key ID Master File (F40942).
Order Group Key ID Master File (F40943).
When the accelerated pricing resolution engine loads the cache, it runs the Accelerated Pricing Resolution (R45390) UBE in subsystem. Occasionally, your company might make substantial changes to your system setup, pricing structure, or pricing tables. When this occurs, you must access the Accelerated Pricing Resolution Engine Workbench program and reload the cache. Any substantial changes you make are not available for the system to calculate until you reload the cache. It is recommended that you perform this task during off-peak hours, as it can take substantial system resources to reload the cache. While the cache is loading, the system accesses data directly from the database. When the reload is complete, the system reverts to accessing data using the cache. Additionally, occasions might occur when you must disable the cache. You use the Accelerated Pricing Resolution Engine Workbench program to do so.
(Release 9.1 Update) You can use the Accelerated Pricing Resolution Scheduler program (R45391) to perform one of the three types of action the system performs on the Accelerated Pricing Resolution Engine. The system may perform one of the following actions:
Load the cache for the Accelerated Pricing Resolution Engine when the cache is inactive.
Reload the cache for the Accelerated Pricing Resolution Engine when the cache is active.
Terminate the cache for Accelerated Pricing Resolution Engine when the cache is active.
Note: In order for the system to perform one of the preceding actions, you must set the Accelerated Pricing Resolution Engine system constant to option 1 (Allow Use) or option 2 (Auto Load). |
Processing options enable you to specify the default processing for programs and reports
These processing options enables you to specify processing values.
Specify whether the system filters records in the Adjustment Detail table (F4072) that are loaded into the Accelerated Pricing Resolution Engine based on the adjustment expiration date. Values are:
Blank: The system does not filter adjustment detail records.
1: The system filters adjustment detail records based on the specified adjustment detail expiration date for filtering.
Specify the adjustment detail expiration date that the system uses to filter records in the Adjustment Detail table (F4072) that are loaded into the Accelerated Pricing Resolution Engine. For example, if the filter date is November 30, 2012 the system loads all of the F4072 records that expire on or after November 30, 2012 to the Accelerated Pricing Resolution Engine cache.
If you leave this processing option blank, the system uses the system date.
Access the Accelerated Pricing Resolution Engine Workbench form.
Figure 3-3 Accelerated Pricing Resolution Engine Workbench form
Click to retrieve and display the state of the cache.
Click to load the cache.
Click to reload the cache.
Click to deactivate the cache and remove the cache from memory.
Displays the source of the data which the system retrieves and loads into the cache. The system bases the data source on OCM mappings for the Environment, Role and User fields.
Displays the environment which the user is currently accessing. If this environment does not match the value in the Cache Load Environment field, you should log out and log in to the Cache Load Environment to perform a cache reload or terminate operations against the cache.
Displays the current state of the cache. Values are:
Active: Pricing operations are retrieving pricing data from the cache.
Inactive: Pricing operations are retrieving pricing data from the database tables and not from the cache.
Invalid: An exception condition has occurred. Pricing operations are retrieving pricing data from the database tables and the system is not retrieving pricing data from the cache. To reactivate the cache, you must click the Terminate button and then click the Reload button.
Displays the name of the environment the system uses to load the cache for the data source. The user must log in to this environment to perform a cache reload and terminate operations on the cache for this data source.
Displays the number of EnterpriseOne processes that are currently attached to the cache. This number includes any Call Object Kernel or run batch processes that were actively accessing cache data at the time the system retrieves state information.
Displays the date and time you initiate the most recent cache load or reload.
Displays the approximate size of the cache in memory in kilobytes. This number represents the amount of memory the system requires to store the data and manage the cache in memory. This value is approximate and actual allocation might vary by operating system.
Displays the number of concurrent cursors open in the cache at the time the system retrieves the cache state information. Cache operations are very fast and this field might frequently display zero (0). Cursor count must be zero before reload and terminate operations begin.
Displays the maximum number of concurrent open cursors that access the cache from the original load of the cache. The system does not reset this number when you reload the cache. If the system attempts to open a cursor at a time when the maximum number of cursors are in use, the system directs the pricing operation to retrieve data from the database table instead the cache. If this number matches the maximum number of cursors the system permits, you should consider increasing the cursor limit. You can increase or decrease the cursor limit to optimize the cache memory usage by adjusting the constant MRDB_CURSOR_MEM_SPACE_SIZE in business function B4504640.
When you run the Accelerated Pricing Resolution Scheduler program, use these processing options to specify the system process.
Specify the action to perform on the Accelerated Pricing Resolution Engine. Values are:
Blank: The system loads the cache for the Accelerated Pricing Resolution Engine when the cache is inactive.
1: The system reloads the cache for the Accelerated Pricing Resolution Engine when the cache is active.
2: The system terminates the cache for the Accelerated Pricing Resolution Engine when the cache is active.
Specify the version of the Accelerated Pricing Resolution Engine Workbench program (P4530) that the system uses when it processes the Accelerated Pricing Resolution Engine cache. If you leave this processing option blank, the system uses version ZJDE0001.
This section provides an overview of AAIs for Advanced Pricing, lists prerequisites, and discusses how to set up AAIs in Advanced Pricing.
AAIs provide the rules that the system uses to create general ledger entries automatically. Each program that posts to the general ledger uses AAIs.
For logistics systems, you must create AAIs for each unique combination of company, document type, and general ledger class that you anticipate using. Each AAI points to a specific general ledger account consisting of a cost center, an object, and a subsidiary.
After you define AAIs, the system can appropriately record transactions. When you run a sales update, the system creates entries for inventory accounts, for expense accounts for cost of goods sold (COGS), and for revenue accounts for orders. You may also offset accounts for freight, taxes, or any other charges that are associated with orders.
AAIs enable you to direct how sales order transactions create various journal entries. Each AAI contains combinations of:
Company.
Document type.
General Ledger class code.
General Ledger account.
You can create various combinations to direct journal entries to different offset accounts. For example, phone-in orders might affect different general ledger accounts than over-the-counter orders.
Note: When using JD Edwards EnterpriseOne Advanced Pricing and Procurement, the system does not use AAIs for purchase order adjustments. For example, the system does not create entries for the additional discounts that are applied to the unit cost when you match a voucher to a receipt. |
This table lists AAIs used in JD Edwards EnterpriseOne Advanced Pricing:
After you review and revise the existing AAIs for your business needs, you might have to set up additional AAI items.
Before you complete the tasks in this section:
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Account Revisions | W40950D | Sales Order Management Setup (G4241), Automatic Accounting Instructions
On Work With AAIs, locate the AAI and click Select. |
Set up and revise AAIs. |
Access the Account Revisions form.
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, use all six digits. For example, entering 000456 is different from entering 456 because, if you enter 456, the system enters three blank spaces to fill a six-digit object. |
Enter the subset of the object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
Note: If you use 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 different from 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.