<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/td/onlinemanual/000362" xml:lang="en">
   <Header>
      <Title>To reconcile sales schedules</Title>
      <Keyword type="header" order="d1e1295112">
         <Level1>Sales schedule</Level1>
         <Level2>reconciling</Level2>
      </Keyword>
   </Header>
   <AimSection>
      <Paragraph>Sales schedule reconciliation is the process to monitor if your
		business partner's <GUIRef href="/baanerp/td/sls/tdsls3532m000#tdsls331.qicr" role="manual">Received CUM</GUIRef> matches with your <GUIRef href="/baanerp/td/sls/tdsls3532m000#display.cum" role="manual">Cumulative Shipped Quantity</GUIRef>. Matching is only
		performed for material releases and shipping schedules that contain
		non-referenced items. If the CUMs do not match, disputes are generated that
		must be solved.</Paragraph>
   </AimSection>
   <Important>
      <SectionTitle>Important!</SectionTitle>
      <List>
         <ListItem>In the <GUIRef href="/baanerp/td/isa/tdisa0510m000" role="session">Items - Sales Business Partner (tdisa0510m000)</GUIRef> and/or <GUIRef href="/baanerp/td/sls/tdsls3102m000" role="session">Sales Contract Line Logistic Data (tdsls3102m000)</GUIRef> session, the <Link href="/baanerp/td/isa/tdisa0510m000#tdisa010.cddr" role="formfield">Consider Planned/Actual Delivery Date during Reconciliation</Link> check box determines how the <Link href="/baanerp/td/sls/tdsls3131m000#e.form.cum" role="formfield">Cumulative Shipped Quantity</Link> is calculated in the <GUIRef href="/baanerp/td/sls/tdsls3131m000" role="session">Sales Schedule Reconciliation (tdsls3131m000)</GUIRef> and <GUIRef href="/baanerp/td/sls/tdsls3532m000" role="session">Shipped CUM (tdsls3532m000)</GUIRef> sessions.</ListItem>
         <ListItem> 
            <List>
               <ListIntro>If the sales schedule is based on a sales contract with a
				linked terms and conditions agreement:</ListIntro>
               <ListItem>And the <Link href="/baanerp/tc/trm/tctrm1131m000#tctrm131.sycu" role="formfield">Synchronize Cums</Link> check box is selected in the <GUIRef href="/baanerp/tc/trm/tctrm1131m000" role="session">Schedule Terms and Conditions (tctrm1131m000)</GUIRef> session, you cannot reconcile sales
				schedules.</ListItem>
               <ListItem>You can specify how the last <Link href="/baanerp/wh/glossary/glossary#000021" role="glossary">shipment</Link> is determined for calculating <Link href="/baanerp/td/glossary/glossary#000006" role="glossary">received cumulatives</Link> in the <Link href="/baanerp/tc/trm/tctrm1131m000#tctrm131.msid" role="formfield">Method of Last Shipment ID determination</Link> field of the <GUIRef href="/baanerp/tc/trm/tctrm1131m000" role="session">Schedule Terms and Conditions (tctrm1131m000)</GUIRef> session.</ListItem>
            </List>
         </ListItem>
      </List>
   </Important>
   <GeneralSection>
      <SectionTitle>To insert reconciliation records</SectionTitle>
      <List>
         <ListIntro>When you confirm a shipment for a sales schedule, LN creates a sales
		  schedule reconciliation record in the <Link href="/baanerp/td/sls/tdsls3131m000" role="session">Sales Schedule Reconciliation (tdsls3131m000)</Link> session with the following
		  information:</ListIntro>
         <ListItem>The date on which the items are shipped.</ListItem>
         <ListItem>The number of the shipment with which the goods are shipped.</ListItem>
         <ListItem>The quantity that you shipped with that specific shipment.</ListItem>
         <ListItem>The last quantity that is received for the sales schedule.</ListItem>
         <ListItem>The total cumulated quantity that you already shipped for the
		  sales schedule.</ListItem>
      </List>
      <Paragraph>For each shipment, one reconciliation record is created with the <GUIRef href="/baanerp/td/domains/rcst#created" role="option">Created</GUIRef> status.</Paragraph>
      <ProcedureList>
         <ListIntro>When you approve a sales schedule, LN:</ListIntro>
         <ListItem>Inserts the number of the last shipment that your business
		  partner received for the sales schedule in the <GUIRef href="/baanerp/td/sls/tdsls3131m000" role="session">Sales Schedule Reconciliation (tdsls3131m000)</GUIRef> session.</ListItem>
         <ListItem>Inserts the last quantity that your business partner received
		  for the sales schedule in the <GUIRef href="/baanerp/td/sls/tdsls3131m000" role="session">Sales Schedule Reconciliation (tdsls3131m000)</GUIRef> session.</ListItem>
         <ListItem>Calculates the new <GUIRef href="/baanerp/td/sls/tdsls3131m000#tdsls331.qicr" role="field">Received CUM</GUIRef> by adding the <GUIRef href="/baanerp/td/sls/tdsls3131m000#tdsls331.qilr" role="field">Last Receipt Quantity</GUIRef> to the <GUIRef href="/baanerp/td/sls/tdsls3131m000#tdsls331.qicr" role="field">Received CUM</GUIRef> of the concerned and next reconciliation
		  records.</ListItem>
         <ListItem>Compares the business partner's <GUIRef href="/baanerp/td/sls/tdsls3131m000#tdsls331.qicr" role="field">Received CUM</GUIRef> with your <GUIRef href="/baanerp/td/sls/tdsls3131m000#e.form.cum" role="manual">Cumulative Shipped Quantity</GUIRef>. If these CUMs are equal,
		  the reconciliation record receives the <GUIRef href="/baanerp/td/domains/rcst#matched" role="option">Matched</GUIRef> status. If these CUMs are unequal, the reconciliation record receives the <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef> status.</ListItem>
      </ProcedureList>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When you approve a sales schedule for which a reconciliation
		  record with the <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef> status exists, a warning message is printed on the
		  approval report. For more information on approving sales schedules, refer to <Link href="/baanerp/td/onlinemanual/000358" role="manual">To approve sales schedules</Link>.</Paragraph>
      </Note>
      <GeneralSection>
         <SectionTitle>Reconciliation statuses</SectionTitle>
         <List>
            <ListIntro>A reconciliation record can have the following statuses:</ListIntro>
            <ListItemHead>
               <GUIRef href="/baanerp/td/domains/rcst#created" role="option">Created</GUIRef>
            </ListItemHead>
            <ListItem>The sales schedule reconciliation record is created and you
			 have not yet received your business partner's received CUM and last receipt
			 quantity for the concerned shipment.</ListItem>
            <ListItemHead>
               <GUIRef href="/baanerp/td/domains/rcst#matched" role="option">Matched</GUIRef>
            </ListItemHead>
            <ListItem>You received your business partner's received CUM and last
			 receipt quantity for the concerned shipment and these quantities are equal to
			 your shipped CUM and shipped quantity.</ListItem>
            <ListItem>The shipped CUM and <Link href="/baanerp/td/glossary/glossary#000350" role="glossary">CUM reset date</Link> that you received from an external component are equal to your
			 shipped CUM and CUM reset date.</ListItem>
            <ListItem>If a shipped cumulative record has the <GUIRef href="/baanerp/td/domains/rcst#synchronize" role="option">Synchronize</GUIRef> status, the previous record is set to <GUIRef href="/baanerp/td/domains/rcst#matched" role="option">Matched</GUIRef>.</ListItem>
            <ListItemHead>
               <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef>
            </ListItemHead>
            <ListItem>You received your business partner's received CUM and last
			 receipt quantity for the concerned shipment and these quantities are unequal to
			 your shipped CUM and shipped quantity.</ListItem>
            <ListItemHead>
               <GUIRef href="/baanerp/td/domains/rcst#reconciled" role="option">Reconciled</GUIRef>
            </ListItemHead>
            <ListItem>You discussed the difference between your business partner's
			 received CUM and your shipped CUM, and as a result you have adjusted the
			 received CUM to equal the shipped CUM.</ListItem>
            <ListItemHead>
               <GUIRef href="/baanerp/td/domains/rcst#adjusted" role="option">Adjusted</GUIRef>
            </ListItemHead>
            <ListItem>You discussed the difference between your business partner's
			 received CUM and your shipped CUM, and as a result you have adjusted the
			 shipped CUM to equal the received CUM.</ListItem>
            <ListItemHead>
               <GUIRef href="/baanerp/td/domains/rcst#adj.recon" role="option">Adjusted and Reconciled</GUIRef>
            </ListItemHead>
            <ListItem>You discussed the difference between your business partner's
			 received CUM and your shipped CUM, and as a result you have adjusted the
			 shipped CUM and the received CUM.</ListItem>
            <ListItemHead>
               <GUIRef href="/baanerp/td/domains/rcst#matched.forced" role="option">Matched (forced)</GUIRef>
            </ListItemHead>
            <ListItem>The received CUM and last receipt quantity that you received
			 from your business partner for the concerned shipment are unequal to your
			 shipped CUM and shipped quantity, but a later entry has already received the
			 status <GUIRef href="/baanerp/td/domains/rcst#matched" role="option">Matched</GUIRef>.</ListItem>
            <ListItem>If a sales schedule reconciliation record has the status <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef>,
			 and its shipped CUM is updated as a result of adjusting previous records with
			 the <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef> status, the current record is set to <GUIRef href="/baanerp/td/domains/rcst#matched.forced" role="option">Matched (forced)</GUIRef> if, after correction, quantities match.</ListItem>
            <ListItemHead>
               <GUIRef href="/baanerp/td/domains/rcst#matched.no.fb" role="option">Matched (no feedback)</GUIRef>
            </ListItemHead>
            <ListItem>You have not yet received your business partner's received
			 CUM and last receipt quantity for the concerned shipment, but a later entry has
			 already received the status <GUIRef href="/baanerp/td/domains/rcst#matched" role="option">Matched</GUIRef> or <GUIRef href="/baanerp/td/domains/rcst#reconciled" role="option">Reconciled</GUIRef>. The received CUM and last receipt quantity
			 remain zero.</ListItem>
            <ListItem>You have not yet received an external component's shipped CUM
			 for the concerned shipment, but a later entry has already received the status <GUIRef href="/baanerp/td/domains/rcst#matched" role="option">Matched</GUIRef>.</ListItem>
            <ListItemHead>
               <GUIRef href="/baanerp/td/domains/rcst#synchronize" role="option">Synchronize</GUIRef>
            </ListItemHead>
            <ListItem>The shipped CUM that you received from an external component
			 is unequal to your shipped CUM , and as a result your shipped CUM is adjusted
			 with a correction value to equal the external component's shipped
			 CUM.</ListItem>
            <ListItemHead>
               <GUIRef href="/baanerp/td/domains/rcst#reset" role="option">Reset</GUIRef>
            </ListItemHead>
            <ListItem>The sales schedule cumulative record or the sales schedule
			 authorization record are reset in the <GUIRef href="/baanerp/td/sls/tdsls3230m000" role="session">Reset Cumulatives (tdsls3230m000)</GUIRef> session.</ListItem>
            <ListItem>The <Link href="/baanerp/td/glossary/glossary#000350" role="glossary">CUM reset date</Link> that you received from an external component is later than your CUM
			 reset date, and as a result the sales schedule cumulative record or sales
			 schedule authorization record are reset.</ListItem>
         </List>
      </GeneralSection>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>To solve disputes</SectionTitle>
      <Paragraph>You can use the <GUIRef href="/baanerp/td/sls/tdsls3131m000" role="session">Sales Schedule Reconciliation (tdsls3131m000)</GUIRef> session to solve disputes between your
		shipped cumulatives and your sold-to business partner's received cumulatives
		for a specific sales schedule. Only if a reconciliation record has the <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef> status, you can adjust the record.</Paragraph>
      <List>
         <ListIntro>To handle sales schedule reconciliation records with the <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef> status, select one of the following on the <Link href="/baanerp/tc/glossary/glossary#specific" role="glossary">appropriate menu</Link> of the <GUIRef href="/baanerp/td/sls/tdsls3131m000" role="session">Sales Schedule Reconciliation (tdsls3131m000)</GUIRef> session:</ListIntro>
         <ListItemHead>
            <GUIRef href="/baanerp/td/sls/tdsls3131m000#reconcile.rec.cum" role="command">Reconcile Received CUMs</GUIRef>
         </ListItemHead>
         <ListItem> LN adjusts the <GUIRef href="/baanerp/td/sls/tdsls3131m000#tdsls331.qicr" role="manual">Received CUM</GUIRef> to equal the <GUIRef href="/baanerp/td/sls/tdsls3131m000#e.form.cum" role="manual">Cumulative Shipped Quantity</GUIRef>. The reconciliation
		  record gets the <GUIRef href="/baanerp/td/domains/rcst#reconciled" role="option">Reconciled</GUIRef> status.</ListItem>
         <ListItemHead>
            <GUIRef href="/baanerp/td/sls/tdsls3131m000#adjust.ship.cum" role="command">Adjust Shipped CUMs</GUIRef>
         </ListItemHead>
         <ListItem>LN adjusts the <GUIRef href="/baanerp/td/sls/tdsls3131m000#e.form.cum" role="manual">Cumulative Shipped Quantity</GUIRef> to equal the <GUIRef href="/baanerp/td/sls/tdsls3131m000#tdsls331.qicr" role="manual">Received CUM</GUIRef>. The sales schedule reconciliation
		  record gets the <GUIRef href="/baanerp/td/domains/rcst#adjusted" role="option">Adjusted</GUIRef> status.</ListItem>
         <ListItemHead>
            <GUIRef href="/baanerp/td/sls/tdsls3131m000#adjust.and.reconcile" role="command">Adjust and Reconcile</GUIRef>
         </ListItemHead>
         <ListItem>The <GUIRef href="/baanerp/td/sls/tdsls3131s000" role="session">Enter new CUMs (tdsls3131s000)</GUIRef> session starts in which
		  you can specify the quantity that must replace the current <GUIRef href="/baanerp/td/sls/tdsls3131m000#tdsls331.qicr" role="manual">Received CUM</GUIRef> and <GUIRef href="/baanerp/td/sls/tdsls3131m000#e.form.cum" role="manual">Cumulative Shipped Quantity</GUIRef>. The sales schedule
		  reconciliation record gets the <GUIRef href="/baanerp/td/domains/rcst#adj.recon" role="option">Adjusted and Reconciled</GUIRef> status.</ListItem>
      </List>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>If a record obtains the <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef> status because the quantity shipped is more than the quantity that you reported
		  shipped, you must record an extra quantity shipped in <GUIRef href="/baanerp/wh" role="package">Warehousing</GUIRef> instead
		  of choosing <GUIRef href="/baanerp/td/sls/tdsls3131m000#adjust.ship.cum" role="command">Adjust Shipped CUMs</GUIRef>, or <GUIRef href="/baanerp/td/sls/tdsls3131m000#adjust.and.reconcile" role="command">Adjust and Reconcile</GUIRef>. The reason for this is that
		  if you adjust the shipped CUM, no invoice is raised for the additionally
		  shipped goods.</Paragraph>
      </Note>
      <List>
         <ListIntro>When the dispute is solved:</ListIntro>
         <ListItem>All previous records with the <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef> status receive the <GUIRef href="/baanerp/td/domains/rcst#matched.forced" role="option">Matched (forced)</GUIRef> status. Previous records with the <GUIRef href="/baanerp/td/domains/rcst#created" role="option">Created</GUIRef> status receive the <GUIRef href="/baanerp/td/domains/rcst#matched.no.fb" role="option">Matched (no feedback)</GUIRef> status.</ListItem>
         <ListItem>LN adjusts the <GUIRef href="/baanerp/td/sls/tdsls3131m000#e.form.cum" role="manual">Cumulative Shipped Quantity</GUIRef> of the following records
		  according to the adjustment. The <GUIRef href="/baanerp/td/sls/tdsls3131m000#tdsls331.qicr" role="field">Received CUM</GUIRef> of successive records is not updated.</ListItem>
         <ListItem>For records with the <GUIRef href="/baanerp/td/domains/rcst#adjusted" role="option">Adjusted</GUIRef> or <GUIRef href="/baanerp/td/domains/rcst#adj.recon" role="option">Adjusted and Reconciled</GUIRef> status, LN redetermines the status of the following records based on the new <GUIRef href="/baanerp/td/sls/tdsls3131m000#e.form.cum" role="manual">Cumulative Shipped Quantity</GUIRef>. If, after adjustment,
		  the <GUIRef href="/baanerp/td/sls/tdsls3131m000#e.form.cum" role="manual">Cumulative Shipped Quantity</GUIRef> of a record with the <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef> status turns out to be correct, the sales schedule reconciliation record's
		  status changes from <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef> into <GUIRef href="/baanerp/td/domains/rcst#matched.forced" role="option">Matched (forced)</GUIRef>.</ListItem>
         <ListItem>And you have chosen to adjust the received CUM, your sold-to
		  business partner must also adjust the received CUM. For invoiced purchase
		  schedule lines, the received CUM can be updated in the <Link href="/baanerp/td/pur/tdpur3432m000" role="session">Update Received CUMs (tdpur3432m000)</Link> session. If the received CUM is not
		  updated on the purchase side as well, each time the purchase schedule is sent,
		  it will cause a dispute.</ListItem>
         <ListItem>The shipped CUM records in the <GUIRef href="/baanerp/td/sls/tdsls3532m000" role="session">Shipped CUM (tdsls3532m000)</GUIRef> session are updated according to the adjustments you
		  made in the <GUIRef href="/baanerp/td/sls/tdsls3131m000" role="session">Sales Schedule Reconciliation (tdsls3131m000)</GUIRef> session.</ListItem>
      </List>
      <GeneralSection>
         <SectionTitle>Loss of inventory</SectionTitle>
         <Paragraph>If as a result of the discussion with your business partner on
		  a reconciliation record with the <GUIRef href="/baanerp/td/domains/rcst#dispute" role="option">Dispute</GUIRef> status is decided to adjust the <GUIRef href="/baanerp/td/sls/tdsls3131m000#e.form.cum" role="manual">Cumulative Shipped Quantity</GUIRef>, you can also agree with
		  your business partner on who will pay for the loss of inventory.</Paragraph>
         <List>
            <ListIntro>The following possibilities exist:</ListIntro>
            <ListItem>You pay for the loss of inventory. In this case, you must
			 create a <GUIRef href="/baanerp/td/domains/rctp#shipcorr" role="option">Correction</GUIRef> record in the <GUIRef href="/baanerp/td/sls/tdsls3140m200" role="session">Sales Schedule Invoice Lines (tdsls3140m200)</GUIRef> session. This will result in a credit
			 invoice to your business partner.</ListItem>
            <ListItem>Your business partner pays for the loss of inventory. In this
			 case, you must not create a <GUIRef href="/baanerp/td/domains/rctp#shipcorr" role="option">Correction</GUIRef> record in the <GUIRef href="/baanerp/td/sls/tdsls3140m200" role="session">Sales Schedule Invoice Lines (tdsls3140m200)</GUIRef> session.</ListItem>
         </List>
         <Note>
            <SectionTitle>Note</SectionTitle>
            <Paragraph>You can also check whether you must create an invoice
			 correction in the <GUIRef href="/baanerp/td/sls/tdsls3140m200" role="session">Sales Schedule Invoice Lines (tdsls3140m200)</GUIRef> session by
			 comparing the <GUIRef href="/baanerp/td/sls/tdsls3533m000#tdsls333.qici" role="manual">Cumulative Invoiced Quantity</GUIRef> from the <GUIRef href="/baanerp/td/sls/tdsls3533m000" role="session">Invoiced CUM (tdsls3533m000)</GUIRef> session with the <GUIRef href="/baanerp/td/sls/tdsls3532m000#tdsls331.qicr" role="manual">Received CUM</GUIRef> after reconciliation. As a result, you
			 can view whether you invoiced your customer too much or too less compared to
			 the receipts.</Paragraph>
         </Note>
         <Paragraph>For more information on shipment corrections and sales
		  schedule invoices, refer to <Link href="/baanerp/td/onlinemanual/000365" role="manual">Sales schedules and <GUIRef href="/baanerp/ci" role="package">Invoicing</GUIRef>
            </Link>.</Paragraph>
      </GeneralSection>
   </GeneralSection>
   <RelatedTopics>
      <SectionTitle>Related topics</SectionTitle>
      <RelTopic>
         <Link href="/baanerp/td/onlinemanual/000361" role="manual">Sales schedule cumulatives</Link>
      </RelTopic>
      <RelTopic>
         <Link href="/baanerp/td/onlinemanual/000130" role="manual">Sales schedule procedure</Link>
      </RelTopic>
   </RelatedTopics>
</ManualTopic>