1. Administrator's Guide
  2. Defining Reports
  3. Defining Intercompany Transaction Report Scripts

Defining Intercompany Transaction Report Scripts

You can define these types of intercompany transaction reports:

  • IC Transactions - create a list of transactions.

  • Intercompany Match By Account- create matching reports based on accounts selected.

  • Intercompany Match By ID- create matching reports based on transaction ID.

Table 9-1 Keywords for Intercompany Transaction Report Scripts

Keyword Description

ReportType

Specify the report type. For example, ReportType=ICTransactions

ReportLabel

Specify the report name. For example, ReportLabel=Transaction Report

ReportDescription

Specify a report description. For example, ReportDescription=Intercompany Transaction Detail Report

ReportSecurityClass

Specify the security class for the report. The default is [Default].

POV

Specify a valid point of view for the report. For example, POV=S#ActMon.Y#2014.P#January

ScaleFactor

Specify a scale factor for the report. The scale can be a value from 0 to 9.

Decimal

Specify the number of decimals to display in the report. The number of decimals can be a value from 0 to 9.

FromAmt and ToAmt

Specify a range of transaction amounts.

IncludeMatched

Specify True to include matched transactions in the report, otherwise False.

IncludeUnMatched

Specify True to include unmatched transactions in the report, otherwise False.

IncludeMisMatched

Specify True to include mismatched transactions in the report, otherwise False.

IncludePosted

Specify True to include posted transactions in the report, otherwise False.

IncludeUnPosted

Specify True to include unposted transactions in the report, otherwise False.

Entity

The entity must be a valid ICP base entity, not a parent entity.

Partner

The partner entity must be a valid ICP entity for the account.

Entity Account

If you are displaying Entity transactions, specify an entity account.

Partner Account

If you are displaying Partner transactions, specify a partner account.

TransactionID

This ID is required. You must enter an ID for the transaction, with a maximum of 40 characters. When combined with the Sub ID, this ID becomes a unique identifier for the Entity/Partner/Account/C1/C2 within the Scenario/Year/Period.

TransactionSubID

Specify a transaction Sub ID.

TransactionCurrency

This is the currency used for the Invoice transaction. It must be a valid currency defined in the application.

ReferenceID

This is optional. You can enter a Reference ID to store reference information for the transaction. For example, the entity might have its own set of invoice numbering that is different from the entity that issued the invoice. You can enter additional information in this Reference ID for information purposes only.

You can enter the entity reference ID in the Transaction ID and enter the corresponding invoice number from the partner entity.

MatchCode

This is optional. The match code must be one of these prefixes to distinguish the different types of matching processes:

  • A - Auto-matching performed using Accounts

  • I - Auto-matching performed using the Transaction ID

  • R - Auto-matching performed using the Reference ID

  • M - Manual matching performed

ReasonCode

This is optional. The reason code must be a valid reason code defined by the administrator. The main purpose of the reason code is to indicate why a transaction has a MisMatched status - for example, because of a missing invoice from the partner entity, or an incorrect amount entered by the partner. If the transaction has a Matched status, you do not need to assign a reason code for the transaction. You cannot assign a reason code to transactions with an UnMatched status.

FromDate

Optional. This must be a valid date.

ToDate

Optional. This must be a valid date.

DisplayColumns Section

Specifies the columns that are displayed in the report and how they are displayed. Syntax is: <DisplayColumns>, <Sort>,<Label>, <Repeat>, <Totals> where <Displayed Columns> is a valid column, <Sort> is Sort or No Sort, <Label> is a label, description, or both, <Repeat> is Repeat or NoRepeat, and <Total> is Total or NoTotal.

For Custom dimensions, the alias is used for the column, for example:

Customers,NoSort,Label,Repeat,NoTotal

DisplayEntityTransactions

Specify True to display entity transactions in the report, otherwise False.

You can select to display only intercompany transactions for a specific entity and partner, or also display the corresponding transactions from the partner with the entity. For example, if you select only the transactions for Entity A with Partner B in the Entity and Partner selections, the system displays only the transactions that Entity A has with Partner B. However, if you want to see the corresponding transactions for Entity B with Partner A, you can select to include Entity transactions and Partner transactions.

DisplayPartnerTransactions

Specify True to display partner transactions in the report, otherwise False.

SuppressDetails

Specify True to suppress transaction detail and display only the subtotal row.