[atorres]

Hello everybody.

I'm trying to create a custom Item Field with a formula to hold the result of:

{memberquantity}*{memberitem.averagecost}+{vendorc ost}

This is working properly on a Saved Search:

{memberquantity}*{memberitem.averagecost}

but if I try to +{vendorcost} it will sum the vendorcost everytime it calculate the (member quantity * memberitem average cost) which is not right because the only vendor cost would be at the Assembly level.

Since the custom Item Fields cant use as sourcing a Saved Search, I'm wondering is someone have an example SuiteScript to do something similar?

Kind Regards

Alien.

​​​​​​​
This is a cached copy. Click here to see the original post.

[Author]

Posts