Cost Price Vs Re-Order Price
We have quite a dilemma…
We sell high value items that are typically brought in on a per order basis. Months can go by between purchases often items have not been purchased before. We use average costing.
We quickly established that Exchequer would not be able to manage our product pricing and built an Excel workbook that manages it for us and uses Postrans to update the Re-Order Price, and list price in €, $ and £ in Exchequer. Our Excel sheet pulls a forex XML for ECB every morning and if the movement exceeds our tolerance automatically initiates an update of Excehquer.
The problem that we have discovered is that it is the cost price that is used in most screens to Sales Order entry screens to show GP. The effect is that VERY misleading GP’s are displayed.
- If the product has not been sold before even when the system knows the Re-Order price it shows 100% margin!
- If the product has been sold before but there is insufficient stock to cover the order or indeed no stock it uses the LAST cost even if this cost was potentially years ago. Very often last cost is a very poor indication of re-order cost.
Why on earth would Excehquer have a Re-Order price and then not use it in any Sales Order Entry screen to indicate expected margin? It is crucial at this screen that we know our expected margin as it’s at this point we accept an order, send an acknowledgement and contractually agree to deliver the product for that price. Does this make sense?
Does anyone else have this problem / a workaround?
Kind regards Olof
-
Comments: 4
-
Comments: 1
-
Comments: 5
-
Comments: 10
-
Comments: 14
-
Comments: 2
-
Comments: 1
-
Comments: 22
-
Comments: 1
-
Comments: 2


Re-Order and Cost Price Fields
Dear Olof,
Yes that all makes sense and we struggled with the system for a while having initially been advised on the settings that would work for our business. We buy in different currencies, mainly Euro and sell in multi currencies although mainly in sterling to UK customers. Nearly 50,000 stock records and legacy standard costs coming across from our old database. Four years on and with some considerable pain we have the system working ok for us with accurate GP on all transaction lines. I would say in Exchequer's defense that really the Re-Order field is there to purely propagate the purchase order with the correct cost price and in the correct currency. It does't work well if your cost prices change all the time though. If you have different suppliers for the same part (different supplier part numbers) Exchq can cope with this. The cost price we found is best set to £ sterling as our consolidated currency. We have ended up changing from standard costing to Serial batch for those products that have serial numbers or creating serial numbers for those items we want to track exactly cost wise but most items are on the FIFO valuation method. Exchequer does do some screwie rounding and averaging when it comes to the stock valuation reports and indeed the BS figures and is wholely inaccurate in this area from both my experience and those of other Exchequer users I have talked to and met. How long have you been using Exchequer?
I may be able to help or give you some pointers from my own painful experience if you wanted to talk further on this matter. 01202 233923 Regards, Peter Marsh