<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/td/onlinemanual/000355" xml:lang="en">
   <Header>
      <Title>To reset purchase schedule cumulatives</Title>
      <Keyword type="header" order="d1e1650142">
         <Level1>Cumulatives</Level1>
         <Level2>resetting</Level2>
      </Keyword>
      <Keyword type="header" order="d1e1650147">
         <Level1>CUMs</Level1>
         <Level2>resetting</Level2>
      </Keyword>
   </Header>
   <AimSection>
      <Paragraph>Over time, the <Link href="/baanerp/td/glossary/glossary#CumulaCUMs_td" role="glossary">cumulatives</Link> (CUMS) can be incremented to very high
		values. To avoid domain constraints, you can reset the CUMs in the <Link href="/baanerp/td/pur/tdpur3230m000" role="session">Reset Cumulatives (tdpur3230m000)</Link> session. Although this reset is usually performed at the
		end of the year, the CUMs cannot be reset exactly when the year is changing.
		This means that updates can be stored in the cumulative sessions after the
		reset date. By calculating a reset quantity, these values are also included in
		the reset process.</Paragraph>
      <List>
         <ListIntro>Resetting is carried out based on the following cumulative
		  (CUM) models, which you can define in the <Link href="/baanerp/td/pur/tdpur0100m300#tdpur000.cumm" role="formfield">Model for CUMs</Link> field of the <GUIRef href="/baanerp/td/pur/tdpur0100m300" role="session">Purchase Contract Parameters (tdpur0100m300)</GUIRef>:</ListIntro>
         <ListItem>Order based CUM model.</ListItem>
         <ListItem>Receipt based CUM model.</ListItem>
      </List>
   </AimSection>
   <GeneralSection>
      <SectionTitle>Conditions for successfully resetting the
		cumulatives:</SectionTitle>
      <List>
         <ListItem>Suppliers and customers must use the same <Link href="/baanerp/td/glossary/glossary#000350" role="glossary">CUM reset date</Link> when resetting the cumulatives in the <GUIRef href="/baanerp/td/pur/tdpur3230m000" role="session">Reset Cumulatives (tdpur3230m000)</GUIRef> session and the <GUIRef href="/baanerp/td/sls/tdsls3230m000" role="session">Reset Cumulatives (tdsls3230m000)</GUIRef> session.</ListItem>
         <ListItem>Resetting can only take place when the releases sent by the
		  customer, are received and approved by the supplier. If not, suppliers cannot
		  approve releases that are processed after the reset date, because the reset
		  dates are different. Purchase release lines with the status <GUIRef href="/baanerp/tc/domains/edi.stat#preview" role="option">Preview</GUIRef>, or <GUIRef href="/baanerp/tc/domains/edi.stat#scheduled" role="option">Scheduled</GUIRef> are automatically reset.</ListItem>
         <ListItem>Suppliers must not update incoming releases or manually create
		  new releases, because resetting can then result in wrong quantities.</ListItem>
      </List>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>To calculate the reset quantity</SectionTitle>
      <Paragraph>To reset the existing CUM values, the reset quantity is
		determined and subtracted from the existing CUMs. In the <GUIRef href="/baanerp/td/pur/tdpur3131m000" role="session">Shipped Cumulatives (tdpur3131m000)</GUIRef>, <GUIRef href="/baanerp/td/pur/tdpur3132m000" role="session">Received Cumulatives (tdpur3132m000)</GUIRef>, <GUIRef href="/baanerp/td/pur/tdpur3130m000" role="session">Required Cumulatives (tdpur3130m000)</GUIRef>, and the <GUIRef href="/baanerp/td/pur/tdpur3133m000" role="session">Invoiced Cumulatives (tdpur3133m000)</GUIRef> sessions, a reset record is added and the
		CUMs are reduced by the reset quantity. Furthermore, the <GUIRef href="/baanerp/td/pur/tdpur3534m000" role="session">FAB/RAW Authorizations (tdpur3534m000)</GUIRef> session is reset and the release lines
		that are generated, but not yet sent are reset. Based on the CUM model, the
		reset quantity is calculated as follows:</Paragraph>
      <List>
         <ListIntro>Based on the CUM model, the reset quantity is calculated as
		  follows:</ListIntro>
         <ListItemHead>Order Based CUM model</ListItemHead>
         <ListItem>Reset Quantity = last required quantity that is communicated on
		  a release date that is prior to the new reset date. This quantity is retrieved
		  from the <GUIRef href="/baanerp/td/pur/tdpur3534m000#tdpur334.qicp" role="field">Required CUM</GUIRef> field of the <GUIRef href="/baanerp/td/pur/tdpur3534m000" role="session">FAB/RAW Authorizations (tdpur3534m000)</GUIRef> session.</ListItem>
         <ListItemHead>Receipt Based CUM model</ListItemHead>
         <ListItem>Reset Quantity = last received quantity that is communicated on
		  a release date that is prior to the new reset date. This quantity is retrieved
		  from the <GUIRef href="/baanerp/td/pur/tdpur3534m000#tdpur334.qicr" role="field">Received CUM</GUIRef> field of the <GUIRef href="/baanerp/td/pur/tdpur3534m000" role="session">FAB/RAW Authorizations (tdpur3534m000)</GUIRef> session.</ListItem>
      </List>
      <ExampleSection>
         <SectionTitle>Example 1 - Order Based CUM model</SectionTitle>
         <List>
            <ListItem>Reset date = start week 3</ListItem>
            <ListItem>The schedule lines are generated before the reset takes place</ListItem>
            <ListItem>Schedule line 2 is released in week 3</ListItem>
            <ListItem>Schedule line 3 is released in week 5</ListItem>
         </List>
         <TABLE border="1" width="100%" space-and-orientation="portrait-max"
                borderstyle="default">
            <TBODY noTR="11">
               <TR no="1" isLast="false">
                  <TH valign="top" width="10%" rowspan="1" colspan="1">Week</TH>
                  <TH valign="top" width="10%" rowspan="1" colspan="1">Line 1</TH>
                  <TH valign="top" width="15%" rowspan="1" colspan="1">Required CUM before reset</TH>
                  <TH valign="top" width="10%" rowspan="1" colspan="1">Line
				  2</TH>
                  <TH valign="top" width="15%" rowspan="1" colspan="1">Required CUM before reset</TH>
                  <TH valign="top" width="10%" rowspan="1" colspan="1">Line 3</TH>
                  <TH valign="top" width="15%" rowspan="1" colspan="1">Required CUM
				  before reset</TH>
                  <TH valign="top" width="15%" rowspan="1" colspan="1">Required CUM after
				  reset</TH>
               </TR>
               <TR no="2" isLast="false">
                  <TD valign="top" width="10%" rowspan="1" colspan="1">1</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">20</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">20</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">20</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">20</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">20</TD>
               </TR>
               <TR no="3" isLast="false">
                  <TD valign="top" width="10%" rowspan="1" colspan="1">2</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">20</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">40</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">40</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">40</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">40</TD>
               </TR>
               <TR no="4" isLast="false">
                  <TD valign="top" width="10%" rowspan="1" colspan="1">3</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">20</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">60</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">5</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">45</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">45</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">5</TD>
               </TR>
               <TR no="5" isLast="false">
                  <TD valign="top" width="10%" rowspan="1" colspan="1">4</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">20</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">80</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">5</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">50</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">50</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">10</TD>
               </TR>
               <TR no="6" isLast="false">
                  <TD valign="top" width="10%" rowspan="1" colspan="1">5</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">20</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">100</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">5</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">55</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">20</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">70</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">30</TD>
               </TR>
               <TR no="7" isLast="false">
                  <TD valign="top" width="10%" rowspan="1" colspan="1">6</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">20</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">120</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">55</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">110</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">5</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">75</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">35</TD>
               </TR>
               <TR no="8" isLast="false">
                  <TD valign="top" width="10%" rowspan="1" colspan="1">7</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">5</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">115</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">5</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">80</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">40</TD>
               </TR>
               <TR no="9" isLast="false">
                  <TD valign="top" width="10%" rowspan="1" colspan="1">8</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">5</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">120</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">5</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">85</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">45</TD>
               </TR>
               <TR no="10" isLast="false">
                  <TD valign="top" width="10%" rowspan="1" colspan="1">9</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">5</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">90</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">50</TD>
               </TR>
               <TR no="11" isLast="true">
                  <TD valign="top" width="10%" rowspan="1" colspan="1">10</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">-</TD>
                  <TD valign="top" width="10%" rowspan="1" colspan="1">5</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">95</TD>
                  <TD valign="top" width="15%" rowspan="1" colspan="1">55</TD>
               </TR>
            </TBODY>
         </TABLE>
         <Paragraph/>
         <TABLE border="1" width="60%" space-and-orientation="indented-max"
                borderstyle="default">
            <TBODY noTR="2">
               <TR no="1" isLast="false">
                  <TH width="18%" rowspan="1" colspan="1">TOTALS</TH>
                  <TH width="18%" rowspan="1" colspan="1">CUM line 1</TH>
                  <TH width="18%" rowspan="1" colspan="1">CUM line 2</TH>
                  <TH width="18%" rowspan="1" colspan="1">CUM
				  line 3</TH>
                  <TH width="28%" rowspan="1" colspan="1">CUMs after reset</TH>
               </TR>
               <TR no="2" isLast="true">
                  <TD width="18%" rowspan="1" colspan="1">Start
				  CUM</TD>
                  <TD width="18%" rowspan="1" colspan="1">0</TD>
                  <TD width="78" rowspan="1" colspan="1">40</TD>
                  <TD width="18%" rowspan="1" colspan="1">50</TD>
                  <TD width="28%" rowspan="1" colspan="1">10</TD>
               </TR>
            </TBODY>
         </TABLE>
         <Paragraph>The reset date starts in week 3. Because of the <GUIRef href="/baanerp/td/domains/gen.cumm#order" role="option">Order Based</GUIRef> CUM model, resetting is carried out based on the required
		  cumulatives. At the end of week 2, the reset quantity is 40. As a result, all
		  CUMs are updated by -40 from the CUM reset date (week 3) on.</Paragraph>
      </ExampleSection>
      <ExampleSection>
         <SectionTitle> Example 2 - Receipt Based CUM model</SectionTitle>
         <Paragraph>Take the same data from the previous example, but also take
		  into consideration the following data:</Paragraph>
         <TABLE border="1" width="80%" borderstyle="default"
                space-and-orientation="indented-estimated">
            <TBODY noTR="6">
               <TR no="1" isLast="false">
                  <TH width="10%" rowspan="1" colspan="1">Week</TH>
                  <TH width="30%" rowspan="1" colspan="1">Received qty.</TH>
                  <TH width="30%" rowspan="1" colspan="1">Received CUM before reset</TH>
                  <TH width="30%" rowspan="1" colspan="1">Received CUM after reset</TH>
               </TR>
               <TR no="2" isLast="false">
                  <TD width="10%" rowspan="1" colspan="1">1</TD>
                  <TD width="30%" rowspan="1" colspan="1">10</TD>
                  <TD width="30%" rowspan="1" colspan="1">10</TD>
                  <TD width="30%" rowspan="1" colspan="1">10</TD>
               </TR>
               <TR no="3" isLast="false">
                  <TD width="10%" rowspan="1" colspan="1">2</TD>
                  <TD width="30%" rowspan="1" colspan="1">25</TD>
                  <TD width="30%" rowspan="1" colspan="1">35</TD>
                  <TD width="30%" rowspan="1" colspan="1">35</TD>
               </TR>
               <TR no="4" isLast="false">
                  <TD width="10%" rowspan="1" colspan="1">3</TD>
                  <TD width="30%" rowspan="1" colspan="1">20</TD>
                  <TD width="30%" rowspan="1" colspan="1">55</TD>
                  <TD width="30%" rowspan="1" colspan="1">20</TD>
               </TR>
               <TR no="5" isLast="false">
                  <TD width="10%" rowspan="1" colspan="1">4</TD>
                  <TD width="30%" rowspan="1" colspan="1">-</TD>
                  <TD width="30%" rowspan="1" colspan="1">55</TD>
                  <TD width="30%" rowspan="1" colspan="1">20</TD>
               </TR>
               <TR no="6" isLast="true">
                  <TD width="10%" rowspan="1" colspan="1">5</TD>
                  <TD width="30%" rowspan="1" colspan="1">5</TD>
                  <TD width="30%" rowspan="1" colspan="1">60</TD>
                  <TD width="30%" rowspan="1" colspan="1">25</TD>
               </TR>
            </TBODY>
         </TABLE>
         <Paragraph>The reset date starts in week 3. Because of the <GUIRef href="/baanerp/td/domains/gen.cumm#receipt" role="option">Receipt Based</GUIRef> CUM model, resetting is done based on the received cumulatives.
		  At the end of week 2, the reset quantity is 35. As a result, all CUMs are
		  updated by -35 from the CUM reset date (week 3) on.</Paragraph>
         <Paragraph>The totals from example 1 would then arrive at:</Paragraph>
         <TABLE border="1" width="60%" borderstyle="default"
                space-and-orientation="indented-estimated">
            <TBODY noTR="2">
               <TR no="1" isLast="false">
                  <TH width="18%" rowspan="1" colspan="1">TOTALS</TH>
                  <TH width="18%" rowspan="1" colspan="1">CUM line 1</TH>
                  <TH width="18%" rowspan="1" colspan="1">CUM line 2</TH>
                  <TH width="18%" rowspan="1" colspan="1">CUM
				  line 3</TH>
                  <TH width="28%" rowspan="1" colspan="1">CUMs after reset</TH>
               </TR>
               <TR no="2" isLast="true">
                  <TD width="18%" rowspan="1" colspan="1">Start
				  CUM</TD>
                  <TD width="18%" rowspan="1" colspan="1">0</TD>
                  <TD width="18%" rowspan="1" colspan="1">40</TD>
                  <TD width="18%" rowspan="1" colspan="1">50</TD>
                  <TD width="28%" rowspan="1" colspan="1">15</TD>
               </TR>
            </TBODY>
         </TABLE>
      </ExampleSection>
   </GeneralSection>
   <RelatedTopics>
      <SectionTitle>Related topics</SectionTitle>
      <RelTopic>
         <Link href="/baanerp/td/onlinemanual/000342" role="manual">To reset authorizations</Link>
      </RelTopic>
      <RelTopic>
         <Link href="/baanerp/td/onlinemanual/000353" role="manual">Purchase schedule cumulatives</Link>
      </RelTopic>
   </RelatedTopics>
</ManualTopic>