Understanding Cost Analyzer Balances

After you have entered cost object information in various systems, such as JD Edwards EnterpriseOne Accounts Payable, JD Edwards EnterpriseOne General Accounting, and Procurement, you must post the cost object information to the Cost Analyzer Balances table (F1602). The F1602 table captures all transactions, assignments, and activity balances. You must update the F1602 table before you can make allocations, report on data, or make online inquiries about cost object information.

You run the Post to Cost Analyzer Balances program (R1602) to update the F1602 table. You can then run reports and view online inquiries in various "what-if" scenarios without affecting the source data.

Note: The F1602 table stores amounts in only one currency. The Post to Cost Analyzer Balances program reviews for multiple currencies and will post to only one currency.

JD Edwards EnterpriseOne Advanced Cost Accounting provides the following financial reports that are based on the F1602 table:

  • Item Profitability (R16022).

  • Customer Profitability Report (R16028, version XJDE0001).

  • Promotion Profitability Report (R16028, version XDJE0002).

  • Profitability by Cost Object (R16023).

  • Income Statement by Cost Object (R16024).

  • Trial Balance by Cost Object (R16025).

  • Trial Balance by Object Account for Cost Object (R16026).

You can also create financial reports that are based on the F1602 table by using Oracle's JD Edwards EnterpriseOne Report Writing application.

JD Edwards EnterpriseOne Advanced Cost Accounting provides three online inquiry programs. You can view information online as described in the following table:

Inquiry Program

Information Available

Cost Analyzer Inquiry (P1602)

Details of a specific entry, including the net posting balances and year-to-date total for the selected entry

Cost Analyzer Inquiry by Account (P16021)

Original and net balances by account.

Cost Analyzer Account Ledger Inquiry (P16200)

Original batch and journal entries for records.