Print Extended Integration Transactions by Business Object (tfgld4482m100)

Use this session to print a report of the integration transactions, based on a range of business objects and any additional criteria. This session also allows you to generate user-definable ASCII or XML files that can be imported in Excel, Access, and other reporting tools.

This session is designed to list all primary and derived integration and reconciliation transactions of a limited set of selected business objects.

To specify a selection:

  1. On the Primary Selection tab, in the Business Object field, specify the appropriate business object, for example, Purchase Order.
  2. Specify either of the following:

    • A selection of specific orders, using the Select Specific Orders check box and the Specific Orders button.
    • A limited range of orders, using the Business Object ID From and To fields.

      The meaning of limited in the latter case depends on the specifics of your organization, and the sizes of tables tfgld482 and tfgld495 in the particular selection area. An organization should define its own user guidelines in this.

  3. On the Additional Print Criteria tab, specify any other criteria to narrow down your primary selection.

 

Primary Selection
Settings
Currency
Select the appropriate currency in the Currencies (tcmcs0102m000) session.
Exchange Rate Type
A way to group currency exchange rates. You can assign different currency exchange rates to different invoice-to business partners and/or to different types of transactions (purchase, sales, and so on).
Financial Report
Financial Report
If this check box is selected, you can enter a flexible reporting code on the Streamed Reporting tab to generate an output file.
Report Dimension
One of up to twelve available analysis account bases for ledger accounts.
Print Totals by Ledger Account
If this check box is selected, LN prints total amounts by ledger account.
Show Amounts in Transaction Currency
If this check box is selected, LN displays the amounts in the transaction currency.
Primary Selection
Business Object Company
A working environment in which you can carry out logistic or financial transactions. All the transaction data is stored in the company's database.

Depending on the type of data that the company controls, the company is:

  • A logistic company.
  • A financial company.
  • A logistic and a financial company.

In a multisite structure, some of the database tables can be unique for the company and the company can share other database tables with other companies.

Business Object
In the context of financial integration transaction processing, a business object is a logistic entity or event such as an item, a purchase order, a business partner, or a warehouse issue.
Print by Sort Position
If this check box is selected, the report output is printed by sort position. If this check box is cleared, the Print Integration Transactions by Business Flow (tfgld4482m100) prevents the printing of duplicate transactions for sort positions.
Select Specific Orders
If this check box is selected, you can click the Specific Orders button to specify a range of specific orders.
Business Object ID
The unique code that identifies a specific business object. For example, the business object ID of a Purchase Order business object is the purchase order number.
Note

Ensure to specify a limited range of business object IDs. Do not specify a full range.

Position
The value used to sort the financial transactions within a business object. For every business object, LN generates the sort position from the values of some of the business object properties. For example, for a freight order cluster the sort position is the cluster line, and for an inventory transaction the sort position is the inventory transaction sequence.
Additional Print Criteria
Transaction Date
The date you enter when you create the transaction such as a sales order or a warehouse receipt. Usually the transaction date is the current date. Only for backdated and antedated transactions, the transaction date differs from the current date. Internally, the transaction date is registered in UTC time.
Integration Document Type
Represents a type of Operations Management transaction for the purpose of mapping and posting the integration transactions to Financials and for financial reconciliation.

The integration document types supplied by LN each have the corresponding business object attached to them. For example, the integration document types for the various sales order transactions have the Sales Order business object linked to them.

Fiscal Period
Fiscal Period
Financial Document
A user-defined three-position code used to identify documents. The series linked to the transaction type give documents the sequence number.
Financial Document
The identification of a transaction.

The document code is a combination of:

  • Transaction-type code
  • Series number
  • Sequence number
Financial Document Line
The transaction line.
Note

This field is only available if a single document is selected.

Ledger Account
A register used to record financial transactions and to accumulate the values of the transactions for reporting and analysis. The ledger accounts classify the transactions into categories such as revenues, expenses, assets, and liabilities.
Dimensions
Analysis account for ledger accounts to get a vertical view on ledger accounts. Dimensions are used to specify ledger account information.
Dimensions
Analysis account for ledger accounts to get a vertical view on ledger accounts. Dimensions are used to specify ledger account information.
Reconciliation Element
A property of a logistic transaction that you can use to trace the transaction for reconciliation. The reconciliation elements correspond with the mapping elements of the business objects.
Element Value From/To
The value of the reconciliation element.
Streamed Reporting
Options
Streamed Reporting Code
The appropriate flexible reporting code selected from the Streamed Reporting Codes (tfgld0592m000) session.
Print Selection Details
If this check box is selected, LN prints a single-page report with the selection criteria that were used.
Create XML format
If this check box is selected, LN generates an XML file.

If this check box is cleared, LN generates an ASCII file.

Settings
Separator
The character to be used as column separator in the output file.

Default value

"|"

Export Location
Select Local System or Server, as required.
Export Directory
Click the browse button to select the directory in the Browse For Folder dialog box.
Export File Name
Click the browse button to select the file in the Open dialog box in the selected directory.

 

Print
Prints the report or creates an export file, depending on your choices.
Specific Orders
Starts a dialog box which allows you to select specific orders based on the selected business object.