<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tp/msproject/user/us000220" xml:lang="en">
   <Header>
      <Title>Some important manual checks</Title>
      <Keyword type="header" order="d1e2264083">
         <Level1>Manual checks</Level1>
         <Level2>estimate line templates</Level2>
      </Keyword>
      <Keyword type="header" order="d1e2264088">
         <Level1>Estimate line templates</Level1>
         <Level2>manual checks</Level2>
      </Keyword>
   </Header>
   <GeneralSection>
      <Paragraph>While you enter the amount values, such as the values of
		surcharges, you must ensure that the value entered in the corresponding
		percentage field is as per the calculation in LN Project.
		Related amounts will be calculated again in LN Project,
		but differences owing to a different approach could be misleading and
		confusing.</Paragraph>
      <List>
         <ListIntro>The following rules are applied:</ListIntro>
         <ListItem>Fields that are editable in Excel must be updated in LN Project
		  without further recalculations. Therefore, what you see in Excel is what you
		  get in LN Project.</ListItem>
         <ListItem>
            <List>
               <ListIntro>Fields that are Read Only in Excel are recalculated in LN Project
				during the Save action from Microsoft Excel. This applies to the following
				fields:</ListIntro>
               <ListItem>Cost Amount</ListItem>
               <ListItem>Landed Cost Amount</ListItem>
               <ListItem>Gross Sales Amount</ListItem>
               <ListItem>Net Sales Price</ListItem>
               <ListItem>Net Sales Amount</ListItem>
            </List>
            <Paragraph>Therefore, to have the latest values, a <GUIRef href="" role="manual">Read From Baan</GUIRef> action is required to retrieve the recalculated values. To
			 perform this action, you can use the corresponding icon from the Baan Workbook
			 toolbar.</Paragraph>
         </ListItem>
         <ListItem>
            <List>
               <ListIntro>An exception to these rules is when the fields that can be
				expressed either as a percentage or in an amount are both editable in Microsoft
				Excel. However, if the percentage is filled, the amount will be recalculated in LN Project.
				This applies to:</ListIntro>
               <ListItem>Surcharge percentage / Surcharge Amount</ListItem>
               <ListItem>Markup percentage / Markup Amount</ListItem>
               <ListItem>Discount percentage / Discount Amount</ListItem>
            </List>
         </ListItem>
      </List>
      <Paragraph>If you change the <GUIRef href="" role="manual">Cost/Sales Currency</GUIRef> or <GUIRef href="" role="manual">Date of Incurred Costs / Date of Expected Sales</GUIRef> in Microsoft
		Excel, the latest <GUIRef href="" role="manual">Rates</GUIRef>, <GUIRef href="" role="manual">Rate Factors</GUIRef>, and <GUIRef href="" role="manual">Express in Base</GUIRef> flags are retrieved.</Paragraph>
      <Paragraph>If you change cost price and sales price through some formula,
		you must manually check that the fields origin of cost price and origin of
		sales price are set to <GUIRef href="" role="manual">Excel</GUIRef>.</Paragraph>
      <Paragraph>You must enter the date of incurring cost and the date of
		expected sales when a new record is saved back to LN Project.</Paragraph>
   </GeneralSection>
</ManualTopic>