Managing Sub-Analysis Mappings

Sub-analysis mapping allows you to map fields on one custom object to fields on another custom object. You can use sub-analysis mapping for the purpose of profitability reporting on custom sub-analysis fields. Do this by creating custom fields on the Accounting document type objects (sales invoice, sales credit note, payable invoice, payable credit note, journal) and mapping them to corresponding custom fields on the transaction object. A custom field can be any datatype, including a lookup to an object in another Certinia application such as PSA, or to an object in a third party application.

The custom fields on a document are populated during document creation. Once a document is posted, the values entered in the custom fields are mapped across to the resulting transaction, and from there the data is available for profitability reporting.

Setup Required

  1. Add custom fields for the information you want to report on to the Accounting document type and transaction objects. You must add the custom fields at header level, and at line-level if you want line-level analysis. For example, if you have a custom object "Project" and you want to analyze profit by project code, you would need to add a custom field "Project Code" to the sales invoice header and sales invoice line item objects, and to the transaction header and transaction line item objects. You may also want to add the "Project Code" custom field to other document types besides sales invoice. The API Name of your custom field must not match the API Name of another field on the same object.
  2. Connect each custom field to corresponding fields on other document type and transaction objects. This allows values entered in each custom field to be mapped across to associated documents and transactions. Setting up mappings for a custom field is explained in the topic Setting up Sub-Analysis Mappings.

During document creation, if sub-analysis mappings exist for any custom fields on the document type being created, these custom fields are displayed with the Dimension analysis fields so that users can supply the appropriate values. When the document is saved or posted, these values are mapped across to the new document or transaction. This is explained in more detail below.

Note:

The Enable Edit Sub-Analysis (after posting) custom setting (Accounting Settings) controls whether these sub-analysis fields can be edited once the document has been posted.

Setup required for Sub-Analysis Breakdown in Currency Revaluation

If you want CRV summaries, and their resulting transaction line items to be analyzed by custom sub-analysis fields, you must map the custom fields on your document types to custom fields on the Currency Revaluation Summary object (and to custom fields on the transaction line item object as explained above).

Because of the way custom sub-analysis values are stored for use by the CRV process, there is a limit to the number of mappings you can create and there are restrictions on the types of fields that can be mapped. For example, you cannot map Text Area fields, or Text fields longer than 50 characters. A message is displayed if you try to save a sub-analysis mapping that cannot be used with currency revaluation.

Note:

If you use sub-analysis breakdown in currency revaluation, the number of transaction line items generated will increase which may affect your data storage.

How Values are Mapped

Mappings are performed when one document is created from another. For example, when a sales credit note is created from a sales invoice, or when a transaction is created by posting a sales invoice.

Mappings are always made header-to-header or line-to-line except when creating transactions with the Derive Transaction Line Item From Header checkbox selected. This is illustrated below.

Let's assume that Project Code is a custom field on both sales invoice header and sales invoice line item, and that you have created sub-analysis mappings for it across all document type and transaction objects. You have an "In Progress" sales invoice with the project codes shown below. When you create a sales credit note from this sales invoice, the project codes are mapped across header-to-header and line-to line:

Sales Invoice Sales Credit Note
Header: Global Project Header: Global Project
Line 1: Project UK Line 1: Project UK
Line 2: Project US Line 2: Project US
Line 3: <blank> Line 3: <blank>

But when you post the sales invoice, the Derive Transaction Line Item From Header checkbox determines if a value on the transaction header is mapped to the transaction line item:

Sales Invoice Transaction when Derive From Header
checkbox is OFF
Transaction when Derive From Header
checkbox is ON
Header: Global Project Header: Global Project Header: Global Project
Line 1: Project UK Line 1: Project UK Line 1: Project UK
Line 2: Project US Line 2: Project US Line 2: Project US
Line 3: <blank> Line 3: <blank> Line 3: Global Project

When Derive Transaction Line Item From Header checkbox is selected (ON), if the sub-analysis field is blank on the source document line (Line 3 on the sales invoice in the example above), the value from the transaction header is copied down to the transaction line so that the sub-analysis field is not blank on the transaction line.