Distribution, Manufacturing, and Internet Modules

[BShockley]

Can this field be added to the totals screen?

I need the total extended weight to show on the totals screen.

For example, if item 1 weighs 10 lbs, and the order qty is 2, the extended total weight would be 20.

If we have more than 1 item on an order, the extended weight needs to be the total for all items.

If so, any advice is appreciated.

Thanks

Version 4.4

[DFeller]

Yes this can be done with scripting in 4.40.

Dawn

[BShockley]

Dawn,

Do I need to create a p/o detail udf and use a script to calculate the extended weight per line?

Next, I need a way to total each line item's extended weight.

Can this be done with one script?

[TomTarget]

On the header,  it is possible to actually create a UDF that automatically totals the UDF on the detail lines (no script needed!).  Still need the script of course to calculate the individual line extended weight.

Example from Steve M,  shows the following on the data sources tab.  Its for SO but it should work for po in 4.4 as well.

Business Object is SO_Invoice_bus,  select is checked, data source is <Total from SO_InvoiceDetail>  Column is UDF_xxx (the column you want to sum).