1. Advanced Cost Accounting Implementation Guide
  2. Customer Profitability Report

Customer Profitability Report

Throughout the supply chain, various levels of management in your company might require tools to determine the profitability of customers, products, or both. Your company's management might need reports that show which customers are most profitable and deserve superior customer service. The Customer Profitability report (R16028) provides this information for you.

The Customer Profitability report prints four different sections:

  • Revenue.

  • Expense.

  • Activity Costs.

  • Other Indirect Expense and Income.

The Revenue and Expense sections consist of values with account numbers that fall within the AAI range of Revenue and Expenses.

  • Activity Costs

    The Activity Costs section contains:

  • Accounts that have been assigned to an activity.

  • Accounts where a customer has been assigned.

  • Accounts where the account numbers are greater than the range for the GLG 9 AAI.

  • Other Indirect Expense and Income.

    The Other Indirect Income and Expense section includes:

  • Accounts that fall outside the AAI range for Revenues and Expenses (greater than the GLG 9 AAI).

  • Accounts that have been assigned to a customer.

  • Accounts that have not been assigned to an activity.

Because meeting the needs of every customer is impossible, this report serves as a generic template that you can modify to meet your needs, according to your setup of JD Edwards EnterpriseOne Advanced Cost Accounting. This level of flexibility is achieved through the use of processing options, data selection, and minor code changes.

From the Select tab of the processing options, you can choose the cost analyzer view, fiscal year, from period, thru period, and ledger type for the system to use for the report. The Detail tab provides further flexibility by allowing you to choose the lowest level of account detail and the range of activities for the report.

Note: This report was designed to work for a level of detail of 5, 6, 7, 8, or 9. You must select one of these levels of detail in the Level of Detail processing option to see accurate profitability for a customer.

The Customer Profitability report uses an internal UBE called Profitability Reporting (R16028A). The specifications for this internal UBE need to be checked into the server for the report to run correctly.

This report prints information from the Cost Analyzer Balances table (F1602). You must run the Post to Cost Analyzer Balances program (R1602) to update this table.

Note: Because of the complexity of this report, processing time could be slow. Therefore, we recommend that you run this report at night and with data selection. For example, run only one or two companies at a time.