- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Importing a Sum for Freight
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-13-2011 08:52 AM
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
Re: Importing a Sum for Freight
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-20-2011 10:36 AM
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


