I have a solution that I have used before on Premier. I think it will work on AR Desktop too.
Create another item (you can delete this later). Make sure the unit of measurement on the new item is correct. Best to also fill in all other fields the same as the original except for the item number (as can't be the same). Save.
Now open the old item that has the wrong unit of measurement.
Use the Copy From button at the bottom of the "Profile" Tab
Click OK to the question "Selecting an item to copy will replace any info..."
Find the new item you created.
Easiest way is to click CTRL-F (brings up search)
Click use item
This should adjust all fields (including the buying & selling "No of Items per Buying Unit")
If you are able to re-record the original purchase this might fix up your inventory qty but if not you'll just have to do a Inventory Adjustment to fix up your stock levels but moving forward all new purchases should use the new "NOIPBU"
Fingers crossed. Hope this helps.
PS after a re-read of you question I'm not sure if the issue I have addressed is your issue but hopefully it helps
Hi BJ3, thank you for your response. The item code is not the issue, it is the product that has been received against the item that is incorrect and the average cost messes with the margin reports
It's a transaction in last financial year but would it be as simple as doing a reversal of the incorrect entry in this financial year and re-entering the invoice correctly but using a date in this financial year? Would I have to do the correct enry first and then do the reversal of the incorrect entry? I don't want to be creating a bigger than Ben Hur situation though...
