Skip to Content
Menu
This question has been flagged

While doing a batch update on several products I used an interface to update the cost field. I just used code, description, product (code+description) and cost fields in the interface (from the accounting module).

I run the interface and it created a new product without the code. The problem is that the UoM of the original code, was changed from "Piece" to "m" (meter).

The other problem is that I didn't notice the first problem and created an inventory movement. So now the system does not allow me to make the correct update.

I reproduced the error without the inventory movement but is the same, previous inventory movements of the original product were done in "pieces" and the new ones can't be done because the UoM is "meter".

So, the interface wrongly changed the UoM, any solution?


Avatar
Discard
Author Best Answer

Just to close this ticket.

The interface file (xls) used to update the materials' data did not contained the external key of the materials, so Odoo took the internal code and located the product but treated it as if it was a new code. The interface overwrote the data of the materials that were already created and all the fields that weren´t filled in the interface (xls) were overwritten with the default value of each field. That's why the UoM was changed to the default value, in this case "Piece".

Avatar
Discard
Related Posts Replies Views Activity
0
Mar 24
1503
2
Sep 23
2497
1
Dec 23
4581
1
Jan 23
5320
1
Jan 24
1293