Request for clarification on correcting purchase quantity, unit, and pricing

I need your guidance on the best way to correct this case in ERPNext:

A Purchase Order was created with quantity 6, and the unit was entered by mistake as “Kilogram”. After that, the goods were received, a Purchase Invoice was created, and there is already stock movement related to production.

However, after review, I found that the correct entry should have been:

  • Quantity: 6

  • Unit: Carton

  • 1 Carton = 12 Kilograms

  • Correct total quantity = 72 Kilograms

Accordingly, I would like clarification on the correct procedure to fix this case, so that I can:

  • Enter the remaining quantity correctly into stock

  • Correct the price per kilogram

  • Correct the price per carton

  • Fix the transaction without causing incorrect impact on stock, valuation, or production-related movements

Please provide the correct step-by-step procedure

@magedbjn

if you dont want to revoke those transactions then;

  1. update item master for conversion factors from kg to cartons.
  2. record a stock entry with type Repack where available stock in kgs has to be repack as cartons with correct costing factors. makes sure to record stock entry with correct dateline where those items must not be issued as well.

In order not to repeat such case again with wrong UOM recording, stock setting offers conversion controls as follwoing;