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

I am trying to update product quantity. Everything goes well until I try to validate it. 

on clicking validate it shows this error.


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

Set the destination location name/ ID in the excel file and try to import. Find the below example.


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

Error received when attempting to process inventory adjustment in Inventory Adjustment Operations screen.During 'process inventory adjustment', system checks for confirmation that destination load number and associated subnum are permanent. If invlod prmflg  fields are not set, system ERROR 10016 occurs, preventing completion of inventory adjustment.

Resolution


Perform the following from Server Command Operations.

1. Check permanent flag on your load and sub numbers. Enter your location and warehouse ID (wh_id).
For Example:

[select s.lodnum,l.prmflg, s.subnum, s.prmflg from invlod l, invsub s where l.stoloc = 'PERM-ADJ-LOC' and l.wh_id = '1918' and s.lodnum = l.lodnum ]
PERM-ADJ-LOD-1918 Unchecked PERM-ADJ-SUB-1918 Checked

2. Above shows invlod.prmflg is unchecked.

3. Set the permanent flag on the inventory load and sub records, by updating the invlod.prmflg = '1' and/or the
invsub.prmflg = '1'. This will allow inventory adjustments to be processed.

For example:

[update invlod set prmflg = '1' where lodnum = 'PERM-ADJ-LOD-1918']

OR

[update invsub set prmflg = '1' where subnum = 'PERM-ADJ-SUB-1918']

4. Retry inventory adjustment.


Regards,

Rachel Gomez 

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

This is because one or multiple product(s) have no Inventory Location set.

You only see this field with the Developer mode activated (Settings application > General Settings (in the left sidebar) > scroll down > Activate the developer mode).

Then go to the Inventory application > Products > Products > search and open the products > go to the Inventory tab > here you can see the Inventory Location setting. Make sure that an inventory location is set for every product.

This should fix the problem and you should be able to validate the Inventory Adjustment.

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
2
thg 10 24
2031
2
thg 3 22
5390
1
thg 7 21
2548
0
thg 1 23
2267
3
thg 9 19
4159