<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tf/integrations/400045" xml:lang="en">
	<Header>
		<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">To analyze the reconciliation data</Title>
		<Keyword><Level1>Reconciliation</Level1>
			<Level2>analyses</Level2>
		</Keyword>
	</Header>
	<GeneralSection><Paragraph>The best way to analyze the reconciliation data depends on your main business processes and your information requirements. The <GUIRef href="/baanerp/tf/gld/tfgld4595m000" role="session">Operations Management - Financial Reconciliation (tfgld4595m000)</GUIRef> session and the report options in the <GUIRef href="/baanerp/tf/gld/tfgld4495m000" role="session">Print Reconciliation Data (tfgld4495m000)</GUIRef> session enable you to create various views of the reconciliation data on various levels of detail.</Paragraph>
		<List><ListIntro>For example, you can generate the reports:</ListIntro>
			<ListItem><List><ListIntro>By business object:</ListIntro>
					<ListItem>Order number</ListItem>
				</List>
			</ListItem>
			<ListItem><List><ListIntro>By reconciliation element:</ListIntro>
					<ListItem>Item</ListItem>
					<ListItem>Business partner</ListItem>
					<ListItem>Purchase office</ListItem>
				</List>
			</ListItem>
			<ListItem><List><ListIntro>By status:</ListIntro>
					<ListItem>Open/Active</ListItem>
					<ListItem>Closed</ListItem>
				</List>
			</ListItem>
			<ListItem>By ledger account</ListItem>
			<ListItem>By transaction type</ListItem>
		</List>
		<Paragraph>For more details about how to print the reconciliation reports, refer to <Link href="/baanerp/tf/integrations/400046" role="manual">To print the reconciliation reports</Link>.</Paragraph>
		<Paragraph>This topic describes a few example types of reconciliation transaction and gives some general guidelines on how to approach the analysis.</Paragraph>
	</GeneralSection>
	<GeneralSection><SectionTitle>Types of reconciliation transactions</SectionTitle>
		<List><ListIntro>In general, the following types of reconciliation transactions can be distinguished:</ListIntro>
			<ListItem>Transactions logged on Business Object (order) level. For example, the Production Order (SFC) WIP and the Project (PCS) WIP.</ListItem>
			<ListItem>Goods received not invoiced (GRNI) transactions (Invoice Accrual 3).</ListItem>
			<ListItem>Transactions on inventory accounts.</ListItem>
			<ListItem>Transactions on interim transit accounts. Related integration transactions belong to different Business Objects. You can link the transactions by means of the generated reference link.</ListItem>
		</List>
	</GeneralSection>
	<GeneralSection><SectionTitle>Transactions logged on Business Object (order) level</SectionTitle>
		<Paragraph>You can print a reconciliation report to check whether the balance for <GUIRef href="" role="manual" Update="No">Closed</GUIRef> production orders is zero. You can analyze this type of transactions, for example, Production Order (SFC) WIP and the Project (PCS) WIP after acceptance of the reconciliation data.</Paragraph>
		<List><ListIntro>In the <GUIRef href="/baanerp/tf/gld/tfgld4495m000" role="session">Print Reconciliation Data (tfgld4495m000)</GUIRef> session, select the following options: :</ListIntro>
			<ListItem>Select the production orders with the <GUIRef href="" role="manual" Update="No">Closed</GUIRef> status.</ListItem>
			<ListItem>Select the full range of periods.</ListItem>
			<ListItem>Select the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#supr.zero" role="formfield">Suppress Zero Balances</GUIRef> check box.</ListItem>
			<ListItem>Clear the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#full" role="formfield">Print Full Specification</GUIRef> check box.</ListItem>
			<ListItem>Select the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#group.rbid" role="formfield">Group by Business Object ID</GUIRef> check box.</ListItem>
		</List>
		<Paragraph>If all is well, no differences exist and the report is empty. If a difference exists, you can use the <GUIRef href="/baanerp/tf/gld/tfgld4595m000" role="session">Operations Management - Financial Reconciliation (tfgld4595m000)</GUIRef> session to investigate the transaction and drill down to the Operations Management transactions.</Paragraph>
	</GeneralSection>
	<GeneralSection><SectionTitle>Goods received not invoiced (GRNI) transactions</SectionTitle>
		<Paragraph>For GRNI transactions, you can print the report by closed purchase order to detect any differences between the closed order balance and the invoice accrual amounts. You can analyze the GRNI reconciliation group after acceptance of the reconciliation data.</Paragraph>
		<List><ListIntro>You can print the following reports:</ListIntro>
			<ListItem><List><ListIntro>In the <GUIRef href="/baanerp/tf/gld/tfgld4495m000" role="session">Print Reconciliation Data (tfgld4495m000)</GUIRef> session, you can print a report based on the logged transactions in the Reconciliation Data (tfgld495) table.</ListIntro>
					<ListItem><List><ListIntro>Select the following options:</ListIntro>
							<ListItem>Select the production orders with the <GUIRef href="" role="manual" Update="No">Closed</GUIRef> status.</ListItem>
							<ListItem>Select the full range of periods.</ListItem>
							<ListItem>Select the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#supr.zero" role="formfield">Suppress Zero Balances</GUIRef> check box.</ListItem>
							<ListItem>Clear the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#full" role="formfield">Print Full Specification</GUIRef> check box.</ListItem>
							<ListItem>Select the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#group.rbid" role="formfield">Group by Business Object ID</GUIRef> check box.</ListItem>
						</List>
					</ListItem>
				</List>
			</ListItem>
			<ListItem>In the <GUIRef href="/baanerp/tf/gld/tfgld4495m200" role="session">Checklist Reconciliation Goods Received Not Invoiced (tfgld4495m200)</GUIRef> session, you can print a report based on both the logged transactions in the Reconciliation Data (tfgld495) table and the registered purchase receipts in Order Management or the posted receipts and invoice approvals in Accounts Receivable.</ListItem>
		</List>
	</GeneralSection>
	<GeneralSection><SectionTitle>Transactions on inventory accounts</SectionTitle>
		<Paragraph>By their nature, inventory accounts usually do not balance at any particular moment in time. You can print the reconciliation reports to obtain a report of the inventory by reconciliation element, for example, by item, by item group, or by warehouse.</Paragraph>
		<Paragraph>You must first analyze the Inventory reconciliation group before you can accept the reconciliation data.</Paragraph>
		<Paragraph>To analyze the inventory accounts, print a report of the reconciliation data with the balances on a higher level, for example, by warehouse item. In the <GUIRef href="/baanerp/tf/gld/tfgld4495m000" role="session">Print Reconciliation Data (tfgld4495m000)</GUIRef> session, select the full range of periods.</Paragraph>
		<Paragraph>If no transactions have been archived or deleted, the report that results lists the inventory by reconciliation element (item). This report must be in accordance with the report from the <GUIRef href="/baanerp/wh/ina/whina1210m000" role="session">Perform Inventory Valuation (whina1210m000)</GUIRef> Perform Inventory Valuation (whina1210m000) session. If inventory transactions have already been archived or deleted, you can manually create an opening balance for reconciliation.</Paragraph>
		<Note><SectionTitle>Note</SectionTitle>
			<Paragraph>The reconciliation report is per financial company. The inventory valuation report should include all the warehouses that are linked to the financial company through their enterprise unit, and not other warehouses.</Paragraph>
		</Note>
	</GeneralSection>
	<GeneralSection><SectionTitle>Interim transit transactions</SectionTitle>
		<Paragraph>Interim transit accounts are used for the integration transactions of which the debit and credit entries on these accounts belong to different Business Objects. The transactions are linked by a reference link.</Paragraph>
		<Paragraph>Because the debit and the credit entry on interim accounts are created at the same time, the balance of these accounts is usually zero. You can use the <GUIRef href="/baanerp/tf/gld/tfgld4495m000" role="session">Print Reconciliation Data (tfgld4495m000)</GUIRef> session to print a reconciliation report to check whether the balance is indeed zero.</Paragraph>
		<List><ListIntro>Select the following options:</ListIntro>
			<ListItem>Select the production orders with the <GUIRef href="" role="manual" Update="No">Closed</GUIRef> status.</ListItem>
			<ListItem>Select the full range of periods.</ListItem>
			<ListItem>Select the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#supr.zero" role="formfield">Suppress Zero Balances</GUIRef> check box.</ListItem>
			<ListItem>Clear the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#full" role="formfield">Print Full Specification</GUIRef> check box.</ListItem>
			<ListItem>Select the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#group.rbid" role="formfield">Group by Business Object ID</GUIRef> check box or the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#group.ref.link" role="formfield">Group by Reference Link</GUIRef> check box.</ListItem>
		</List>
		<Paragraph>If all is well, no differences exist and the report is empty. If a difference exists, you can use the <GUIRef href="/baanerp/tf/gld/tfgld4595m000" role="session">Operations Management - Financial Reconciliation (tfgld4595m000)</GUIRef> session to investigate the transaction and drill down to the Operations Management transactions.</Paragraph>
		<Paragraph>You can analyze the Interim Transit reconciliation group after acceptance of the reconciliation data.</Paragraph>
	</GeneralSection>
	<RelatedTopics><SectionTitle>Related topics</SectionTitle>
		<RelTopic><Link href="/baanerp/tf/integrations/400018" role="manual">Period handling for integration transactions</Link>
		</RelTopic>
		<RelTopic><Link href="/baanerp/tf/integrations/400042" role="manual">Reconciliation - multicompany aspects</Link>
		</RelTopic>
		<RelTopic><Link href="/baanerp/tf/integrations/400032" role="manual">To set up reconciliation</Link>
		</RelTopic>
	</RelatedTopics>
</ManualTopic>
