Hi, I don't know if I'm overlooking something totally obvious but I seem to have encountered a serious flaw in the software. Maybe everyone is familiar with this already but I'd really appreciate some help.
Here's the scenario: RMS 2.0 HQ and Store Ops. Local currency is Euro while a number of suppliers are set to use Dollars and Sterling. Exchange rates are updated once a week. Within Item Properties, the Supplier tab has two cost columns listing both the supplier's cost is the supplier's currency and a local cost which is the conversion to Euro eg. Supplier Cost = $8.77 Local Cost= ?6.05
Here's the problem: The Cost price on the General tab is simply pulling the figure from supplier cost column and sticking the local currency symbol in front of it. So on the General tab, I'm seeing a cost price of ?8.77. Which means the Profit Margin is wrong. And not only here, but in Reports as well as I believe this is the field Cost price is pulled from. It's also causing a problem in the creation of PO's.
Can anyone shed any light on this?
I've been working on a SQL statement to copy idata from the Supplier Cost field into the Cost field on the General tab for a number of items where the cost price is missing, but I realise now it's actually the Local Cost that I'll need. I can't find this column in any of the obvious tables in the database. I could nearly live with the above problem if I could write a report that pulls data from the correct column.
I really need help! Thanks.