Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to display "cost" as column in items list?
Hi all, I have "Average Cost" displaying as a cloumn which displays in $AUD. This works sort of ok except the AVG claps out sometimes due to warranty returns, etc etc. We used to be able to select "Purchase Price" which converted by the exchange rate automatically to display AUD. The introduction of "Multiple Vendors" shut this option down, unless we wanted to enter the cost into 2 fields....not an option.
Is there a formula maybe that somebody could kindly show me which would take the preferred vendor cost * current exchange rate (vendor currency)?
Thanks in advance.
0