Enterprise One / World Calculations

The calculations below apply specifically to the JD Edwards system. As you know, the JDE system has internal logic that can be difficult to calculate. These calculations hide the complexity of the internal logic and allow you to focus on the business requirements.

  • Account Category: This calculation, on its own, does not have any direct use by a customer in a report. It is, however, important when creating Financial, Job Cost, and Fixed Asset reports that leverage the JD Edwards Automatic Accounting Instructions (AAI).
  • Associated Description: Derives meaningful descriptions for many JD Edwards data columns and can be accomplished through a simple double-click of the column caption.
  • Chart of Accounts: Used by DAS for Quick Reports using rows by "Chart of Account" rollup. In the context of creating Quick Reports for Financials, Job Cost, or Fixed Assets, this calculation is created through the wizard. This calculation utilizes the Level of Detail Rollup that can be created inside of the JD Edwards F0901 Account Master table to create grouping levels that roll up in a tree structure based on the designer's settings.
  • Current Mailing Address: Retrieve either the current or as-of-a-date mailing address for an Address Book Number.
  • Date to Period: Take a date and extract the Period Number or Fiscal Year as an output. The date is compared against the F0008 Fiscal Date Patterns and F0010 Company Names & Numbers tables to establish the output based on each data row record.
  • E1 Time to DateTime: Converts JD Edwards Date Updated and Time Updated columns into a single DateTime column.
  • Get Short Item Number: Efficiently retrieve the Short Item Number given the 2nd Item Number. This negates the need to join the Item Master table to your report.
  • JDE Email Address: Return a selected email address for an Address Number.
  • JDE Phone Number: Return a selected phone number for an Address Number.
  • JDE User Name: Leverages JD Edwards' F0092 Library Lists table to retrieve the JDE User Name. This calculation is for administrators of DAS only.
  • Media Objects: Displays text media object information for a media object enabled JDE table. These calculations are usually created for you using the 'Quick Media Object' command.
  • Model Account: This calculation is used by Quick Reports for Financials, Job Cost, and Fixed Assets to compare to the F0901 Account Master for use as a filter, obtaining a business unit's Chart of Accounts as the model account Level of Detail (LD) roll-up structure.
  • Offset Between Two Periods: Allows a user to identify the number of periods between two periods.
  • Period Amounts: Allows a user to make multiple period amounts appear as one period amount column for the use case of the JD Edwards balances table like the F0902 GL Account Balances and the F1202 Fixed Asset Balances.
  • Period to Date Range: Allows you to take a Period, Fiscal Year, and Century and create a Date or Date Range span for desired output and use - mainly used in variables to set filter ranges.
  • Relative Period: Take the calculation's parameter criteria and return balances from a balance table, most often the F0902 GL Account Balances table.
  • Unit Conversion: Returns the conversion factor between two units of measure for a given item number.
  • Work Day Offset: Offsets a date input by a certain amount of work days based on the F0007 Calendar Information table in JD Edwards.
  • Work Days: Allows you to identify if a date is a work day based on the F0007 Calendar Information table in JD Edwards with a 1 or 0 output. This calculation also allows a user to identify the number of work days in a date range.