<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tp/msproject/user/us000230" xml:lang="en">
   <Header>
      <Title>Other templates</Title>
   </Header>
   <GeneralSection>
      <Paragraph>In all the other templates under this group, you can only modify
		the records. You cannot insert new records from Microsoft Excel to ERP Enterprise Project. In
		addition, you can only write the values of a few fields back to ERP Enterprise Project.
		For each template, only a small number of relevant fields appear, while other
		fields are hidden. To view these fields, you can use the unhide property on the
		columns. Related amounts will be calculated again in ERP Enterprise Project.</Paragraph>
      <List>
         <ListIntro>The following additional templates are available:</ListIntro>
         <ListItem>The quantity calculations template calculates the quantities of
		  estimate lines. Only the fields quantity, adjustment factor, scrap factor, norm
		  and production rate can be written back to ERP Enterprise Project.</ListItem>
         <ListItem>The Cost Price Calculation template calculates the cost price
		  of estimate lines. Information about quantity, landed cost amount, surcharges
		  and so on, are passed to Excel where an optimum cost price is to be calculated
		  and brought back to ERP Enterprise Project. Whenever the value of cost price is changed
		  directly or through calculation, the value of the field <GUIRef href="" role="manual">Origin of cost price</GUIRef> must be set to <GUIRef href="" role="manual">Excel</GUIRef>.</ListItem>
         <ListItem>
            <List>
               <ListIntro>You can only write the following field properties back to ERP Enterprise Project:</ListIntro>
               <ListItem>Cost price</ListItem>
               <ListItem>Surcharge percentage or surcharge amount</ListItem>
               <ListItem>Escalation amount</ListItem>
               <ListItem>Contingency amount</ListItem>
            </List>
         </ListItem>
         <ListItem>
            <List>
               <ListIntro>You can perform the sales price calculation in the
				following two templates:</ListIntro>
               <ListItem>Sales price calculation - Markup template</ListItem>
               <ListItem>Sales price calculation - Target pricing
				template</ListItem>
            </List>
            <Paragraph>To choose the appropriate template, you must take into
			 account the pricing method. Through these templates, you can pass the basic
			 cost information to the desired level to Excel, calculate an optimum sales
			 price, and bring this information back to ERP Enterprise Project.</Paragraph>
            <Paragraph>In the sales price calculation – markup template, only the <GUIRef href="" role="manual">Markup Percentage</GUIRef>, <GUIRef href="" role="manual">Markup Amount</GUIRef>, <GUIRef href="" role="manual">Discount Percentage</GUIRef>, and/or <GUIRef href="" role="manual">Discount Amount</GUIRef> fields can be written back to ERP Enterprise Project. In the sales price calculation – target pricing
			 template, only the <GUIRef href="" role="manual">Discount Percentage</GUIRef> and/or <GUIRef href="" role="manual">Discount Amount</GUIRef> fields can be written back to ERP Enterprise Project.
			 You must set the origin of sales price value to <GUIRef href="" role="manual">Excel</GUIRef> if you
			 change or calculate the gross sales price directly or calculated.</Paragraph>
         </ListItem>
         <ListItem>In the Amounts template, only the <GUIRef href="" role="manual">Surcharge Percentage or Surcharge Amount</GUIRef> field, the <GUIRef href="" role="manual">Escalation Amount</GUIRef> field, and the <GUIRef href="" role="manual">Contingency Amount</GUIRef> field can be written back to ERP Enterprise Project.</ListItem>
      </List>
      <Paragraph>In all the templates under the group estimate lines, a few
		form/Excel/calculated fields:</Paragraph>
      <TABLE width="100%" border="1" borderstyle="default"
             space-and-orientation="indented-estimated">
         <TBODY noTR="4">
            <TR no="1" isLast="false">
               <TH rowspan="1" colspan="1">Total Cost Amount</TH>
               <TD rowspan="1" colspan="1">Landed Cost Amount + Contingency Amount + Escalation Amount</TD>
            </TR>
            <TR no="2" isLast="false">
               <TH rowspan="1" colspan="1">Gross Quantity</TH>
               <TD rowspan="1" colspan="1">Quantity * Adjustment Factor * (Norm/Production Rate) * (1 +
				Scrap Factor/100)</TD>
            </TR>
            <TR no="3" isLast="false">
               <TH rowspan="1" colspan="1">Profit Amount</TH>
               <TD rowspan="1" colspan="1">Net Sales Amount – Total Cost Amount</TD>
            </TR>
            <TR no="4" isLast="true">
               <TH rowspan="1" colspan="1">Profit Percentage</TH>
               <TD rowspan="1" colspan="1">Profit Amount / Total Cost Amount *100</TD>
            </TR>
         </TBODY>
      </TABLE>
   </GeneralSection>
</ManualTopic>