My Oracle Support Banner

E1: 45: Formula Functionality in Advanced Pricing - Procurement (P4071 / P4072 / P4075 / P4076) (Doc ID 1360611.1)

Last updated on JULY 09, 2021

Applies to:

JD Edwards EnterpriseOne Advanced Pricing - Procurement - Version XE and later
Information in this document applies to any platform.


Formulas are a tool that can be used to define complex price structures. Each formula can be as simple or as complex as the user requires it to be. When defining a formula, either the Variable table (F4075) or the F4311 table can be used.  Formulas work with Quantity, Weight and Volume Level Breaks. A formula is comprised of components, which can include specific numeric values, F4311 fields (aliases), mathematical operations, variable names, and functions. Some components must be identified by a special character as defined in the Price Constants (P41001).




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Basic Setup
 Formula in a Purchase Order Example
 Formulas and Variables
 Formulas and Functions Enhancement
 Formulas and Adjustment Detail Reference
 Using Formulas with Volume or Weight
 What You Should Know

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.