Inventory item bought with wrong unit of measure

Question

Hi,

We found a keying error in our Accountright inventory where the product was received on the 5/3/25 and entered into stock as 915 m/t(915,000kg) when it should have been 0.915m/t(950 kg). Since then, we have received more stock which was entered correctly, but how do we fix the error in the stock after such a long period of time?

The price the product was bought for is correct, but because it was entered with the wrong weight the cost is incorrect

Pen4 · Answer

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

BJ3 · Answer

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