Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
6018 Lượt xem

hi,

How to transfer Product Quantity from one location to other location?

Example.

two location one is stock_1 and 2nd is stock_2

stock_1 qty. is 50.

now i want to transfer stock_1 to stock_2.database through.

because, i have 5000 product.


Manually is possible in ERP. but, it's take more time.

any idea form database side.

 



Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hello,

You have to work with stock_move after searching for location ids in stock_location :

location_1 : select id from stock_location where name = stock_1

location_2  select id from stock_location where name = stock_2

update stock_move set location_id = "location_2" where location_id = "location_1"

Regards,

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
2
thg 2 25
2293
1
thg 2 19
3240
2
thg 10 18
9790
1
thg 8 15
10362
0
thg 2 25
3835