Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Sage MAS Partner
Catherine
Posts: 4
Registered: 03-05-2009
0

Importing a Sum for Freight

I am trying to import a sum from the line detail to the freight field - does anyone know a way to calculate this field in version 4.3?  I am importing into SO_SalesOrderHeader.  The source file has multiple lines with freight amounts.  I need the summary of these amounts to import into the freight field.  It doesn't seem to bring in the summary automatically; I have also tried creating a temp field and then calculating the sum: {SO_SalesOrderHeader.FreightAmt}+Temp001.  I would appreciate any help.  Thanks.

 

Catherine

Regular Visitor
fastasset
Posts: 4
Registered: 01-26-2009
0

Re: Importing a Sum for Freight

Catherine

 

I did get the following to work. Note the designation of Line & Header for the fields.

 

0031 L.Temp002 NUM TEMP REPL 18

0032 L.Temp003 NUM TEMP CALC 26

 Calc. Expression: Temp003+Temp002
0033 H.FreightAmt NUM STD CALC 18

 Calc. Expression: Temp003