| | Print Reconciliation Data (tfgld4495m000)Use this session to print various type of
reports that you can use for financial analysis. You can print a number of reconciliation
reports with various levels of detail. The reports are based on the
reconciliation data that LN logs in the Reconciliation Data (tfgld495) table when you save or
close a transaction in Operations Management. Primary Selection Use the fields on the Primary Selection tab to set the main selection and report options. Additional Print Criteria Use the fields on the Additional Print Criteria tab to make specific
selections, especially when you print a detailed report. Options Use the fields on the Options tab to select various other print options. The
major selection options on this tab are located in the Group by and Specific Group by sections. These settings determine
how reconciliation transactions are grouped together on the report. The default Group by option is based on the Basis for Final Acceptance field in the Reconciliation Groups (tcfin0120m000) session. The Business Object ID check box is selected if Basis for Final Acceptance is set to one of these
values: - Business Object ID
- Business Object ID + Reference
- Not Applicable
The transactions that are grouped together are only
printed if the balance of these transactions is greater than the value of the Tolerance for Printing Balances field, or greater
than zero if Suppress Zero Balances is selected.
Note To print reconciliation reports for the work in process (WIP) values of PCS projects, use the Print Reconciliation Data PCS Work In Process (tfgld4495m300) session. Primary Selection Reconciliation Group Reconciliation Group If this check box is cleared, you print the
reconciliation data for a specific ledger account. You can then only print a
summary report that shows total balances per reconciliation group or print a
flat report. The Group by and Specific Group by options will not be available,
because the default Group by option for each reconciliation group is
determined by the value of the Basis for Final Acceptance field in the Reconciliation Groups (tcfin0120m000) session. Caution! Clearing this check box may substantially impact
performance. We recommend that you do so only if you need to print
reconciliation data for a ledger account that is used in multiple
reconciliation groups. The reconciliation group description if one is
present. Selection Range Fiscal Year A separate period, or year for financial purposes. Three financial period types exist: - Fiscal, in which all
transactions are recorded (for example, 12 months).
- Reporting, for
management requirements (for example, 52 weeks).
- Tax, for tax regulations (for
example, 4 quarters).
Ledger Account If the Reconciliation Group check box is cleared, you must
specify a ledger account. Report selection Print Summary Report If this check box is selected, LN prints the totals
for each selected grouping entity and a summary of the transactions grouped by
the selected grouping entity. If this check box is cleared, LN prints the totals
for each selected grouping entity and a detailed report of the individual
transactions grouped by the selected grouping entity. Compare Reconciliation with Finalized General Ledger If this check box is selected, LN prints a full
specification of the entries on the selected ledger accounts. Select this check box to print all the entries on the
selected ledger accounts. LN checks whether the transactions in the reconciliation table are in
balance with the ledger account history. If a difference exists, it is printed
at the bottom of the report. This report includes the opening balance and the
up-to-period balances. You can select this check box and the Suppress Zero Balances check box to print a report of
the ledger accounts that do not balance. Print Transactions Not Logged in Reconciliation If this check box is selected, LN prints a second
report with a detailed overview of the finalized transactions that are not
logged in reconciliation table. Note This field is only available if you selected Compare Reconciliation with Finalized General Ledger. Print Flat Report If this check box is selected, LN prints a flat
report, that is, a report without selection details and (sub) totals. This
report can easily be opened in, for example, Microsoft Excel. For this report
also a Microsoft Report is available which can be printed via an External
Reporting Service device type. Amount Suppress Zero Balances If this check box is selected, LN prints a report of
only the transactions of which the balance is not zero. Tolerance for Printing Balances A threshold amount for printing balances of the grouped
transactions. - If you enter 0.00, all transactions are printed, which
equals leaving Suppress Zero Balances cleared.
- If you enter 0.01, all transactions with a non-zero
balance are printed, which equals selecting Suppress Zero Balances.
Additional Print Criteria Additional Print Criteria 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. Transaction Type A user-defined three-position code used to identify documents.
The series linked to the transaction type give documents the sequence number. Document The identification of a transaction. The document code is a combination of: - Transaction-type code
- Series number
- Sequence number
Logistic Company An LN company used for logistic transactions, such as the production and
transportation of goods. All the logistic data concerning the transactions is
stored in the company's database. Reconciliation (Elements 1 - 5) 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. Dimension Dimension To include the reconciliation data of a dimension type,
select this check box. Dimension Type One of up to twelve available analysis account bases for ledger
accounts. Dimension Analysis account for ledger accounts to get a vertical view on
ledger accounts. Dimensions are used to specify ledger account information. Select Specific Business Object Select Specific Business Object To print the report for one business object or a range of
business objects, select this check box. 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. 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. Sort 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. Options Group by Business Object ID If this check box is selected, LN groups the
transactions on the report by business object IDThe report also shows the totals per
business object ID. The Business Object ID check box is selected if, in the Reconciliation Groups (tcfin0120m000) session, Basis for Final Acceptance is set to one of these values: - Business Object ID
- Business Object ID + Reference
- Not Applicable
Group by Business Object ID /Sort position Reference Link If this check box is selected, LN groups related
reconciliation transactions that belong different business objects by their reference links on the report. The report also shows the totals per
reference link. Note This option only applies to interim
accounts. Specific Group by Reconciliation Element Combination The reconciliation data is grouped by combination of
reconciliation elements up to and including this element. For example, if these reconciliation elements are
available: - Item
- Project
- Warehouse
If you enter 2, the reconciliation data
is grouped by item by project. If you enter 3, the reconciliation data
is grouped by item by project by warehouse. Dimension If this check box is selected, LN groups the
transactions on the report by dimension. The report also shows the totals per
dimension. Integration Document Type The report also shows the totals per
integration document type. Options Include Opening Balance Transactions If this check box is selected, LN prints the opening
balance transactions. Print Not Final Reconciliation Corrections If this check box is selected, LN includes any not yet
posted reconciliation corrections in the report. You can select this check box to check
the effect of the corrections that you created in the Operations Management - Financial Reconciliation (tfgld4595m000) session before
you post the corrections. Include Non-Finalized Transactions If this check box is selected, LN prints the
reconciliation data of transactions that have not yet been posted to the General Ledger. Note For performance reasons, this field is initially hidden. Options Print Only Non-accepted If this check box is selected, LN prints only the reconciliation data of transactions that have not
yet been approved. Print Only Backdated Transactions If this check box is selected, LN prints a report of
only backdated transactions. If the message "No data within
selection" appears, no backdated transactions exist for the selected ranges. Print Header Data once If this check box is selected, LN prints the header
data only once on the report. You can select this check box to save
space on the report, or if you print the data to a file. Check Lifetime Check Lifetime If you clear the Compare Reconciliation with Finalized General Ledger check box, you can select
this check box to select reconciliation data with or without pending
transactions. This option only applies to
reconciliation groups for which the Basis for Final Acceptance is other than Not Applicable. Select Data with Pending Transactions If this check box is selected, LN prints a report only
of reconciliation data with pending transactions. For example, use this option for types
of business objects that stay Open or Active during a number of financial periods or fiscal years. Select Data without Pending Transactions If this check box is selected, LN prints a report only
of reconciliation data with no pending transactions. You can select this check box and the Suppress Zero Balances check box to print a report of
reconciliation data with no pending transactions that still has an open
balance. Details (Only applicable for the detailed reports) Financial Details If this check box is selected, LN prints the financial
details on the report. Select this check box to include this information in
the report: - The kind of entry (Debit/Credit)
- The dimension (if one of the dimensions is selected)
- The ledger account
You cannot select this check box if you
select Logistic Details. Logistic Details If this check box is selected, LN prints the logistic
details of up to two reconciliation elements on the report. You cannot select this check box if you
select Financial Details. Reconciliation Element The reconciliation element of which the details are printed
on the report. | |