Personalization, Customization and Productivity Tools

[clarkw]

RE: Importing to S/O

I want to accumulate the weight on the line item records, then import the sum of the individual weights to the Header Weight field. Header and Line records are combined on the import file.

This is a more general variation of an earlier post.

Clark

[DFeller]

Are the weights already in inventory or are they only on your source file?

Dawn

[clarkw]

Hi Dawn - the wieghts are located in the IM file. I can do a file lookup temp that returns the weight value for the item, and I see the pvx command to convert it to numeric.

What I have not figured out is how to have VI store a line value over multiple records so I can accumulate it, then import he sum of the accumulated values to a header field.

[DFeller]

Why not turn on the shipping header feature to calculate weight on the order?  Then when you import you will not have to do any of that.  If it calculates the weight when hand-keying in an order, it will automatically calculate it for you when you import an order.

Dawn

[clarkw]

Hi Dawn - that is exactly what is NOT happenning on the SO imports.

The shipping weight is not automatically calculating in S/O entry like when you hand enter.

I have the SO_ORDER_CALC perform logic on success.

You brought up an important point. Maybe I should review my VI setup to verify the perform logic is there.

I've gone through multiple variations, so maybe something got changed.

Clark

[DFeller]

No perform logic ... are you doing this on an old version, older than 4.10?

Dawn

[clarkw]

I am working on a 3.71  VI job for this particular one.

But I still want to learn the general principle of how to accumulate line values in VI to import to a header record.

This would apply to all versions of MAS.

[csaintaz]

Clark,

Assuming your variable to bring in the Item weight is {TEMP01}, with a type = Number, You should be able to add the following formula to the SHIP_WEIGHT field after setting the "Operation" field for SHIP_WEIGHT to Calculated:

STR(NUM ({SO.INVOICEHIP_WEIGHT}) +{TEMP01})

What you are doing is taking the exisiting value in the Header {SO.INVOICEHIP_WEIGHT}, which is a string, and converting it to a number.  You then add the weight from the current line {TEMP01}, which is a number, to your exisitng SHIP_WEIGHT.  Then, because SHIP_WEIGHT is stored as a string, you need to convert your total back to a String.  When the next line of the invoice is read in, VI will take that weight and add it to SHIP_WEIGHT again, to accumulate the weights from each line.

Keep in mind that, in later versions of MAS, VI will add line amounts to the header amounts automatically.  So, what you learn here, may not be applicable in the same way it was in version 3.71.

Good luck.

Message Edited by csaintaz on 09-08-2009 04:45 PM

[Catherine]

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