Discussions
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.