Hi,
I am wanting to import multiple items adjustment in the DB.
So, i looked how /inventory/adjustments.php?NewAdjustment=1&application=stock works.
I understand that:
1. Adjustments are recorded in the table 0_stock_moves.
2. The value of material_cost in 0_stock_master is updated to give an average value of the item cost.
However, there is 2 fields in the table 0_stock_moves which i am not sure about:
> person_id: I see it is a tinyblob. My feeling is that , this is user type of doing the request, but I am not sure. Especially some entries has a value of 0 so for sure it is not the user_id.
> trans_no: This seems to be an incremental value mapped with the stock_id, right ?
Also, is there any other tables except from 0_stock_master and 0_stock_moves that are impacted from item adjustment ?
Tx for your help
Maurice