Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
1674 Prikazi

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
Opusti
Avtor 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
Opusti
Related Posts Odgovori Prikazi Aktivnost
0
mar. 24
1502
2
sep. 23
2495
1
dec. 23
4576
1
jan. 23
5312
1
jan. 24
1292