<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tf/integrations/400045" xml:lang="en">
   <Header>
      <Title>Analyzing the reconciliation data</Title>
      <Keyword type="header" order="d1e1598440">
         <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="manual">Suppress Zero Balances</GUIRef> check box.</ListItem>
         <ListItem>Clear the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#full" role="manual">Print Full Specification</GUIRef> check box.</ListItem>
         <ListItem>Select the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#group.rbid" role="manual">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="manual">Suppress Zero Balances</GUIRef> check box.</ListItem>
                     <ListItem>Clear the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#full" role="manual">Print Full Specification</GUIRef> check box.</ListItem>
                     <ListItem>Select the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#group.rbid" role="manual">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 <GUIRef href="/baanerp/procurement" role="package">Procurement</GUIRef> 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> 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="manual">Suppress Zero Balances</GUIRef> check box.</ListItem>
         <ListItem>Clear the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#full" role="manual">Print Full Specification</GUIRef> check box.</ListItem>
         <ListItem>Select the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#group.rbid" role="manual">Group by Business Object ID</GUIRef> check box or the <GUIRef href="/baanerp/tf/gld/tfgld4495m000#group.ref.link" role="manual">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>