Skip to Content
Menu
This question has been flagged
1 Atsakyti
1678 Rodiniai

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?


Portretas
Atmesti
Autorius 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".

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
0
kov. 24
1503
2
rugs. 23
2498
1
gruod. 23
4581
1
saus. 23
5320
1
saus. 24
1293