Skip to Content
Menu
Dette spørgsmål er blevet anmeldt
3 Besvarelser
6172 Visninger

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

on clicking validate it shows this error.


Avatar
Kassér
Bedste svar

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


Avatar
Kassér
Bedste svar

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 

Avatar
Kassér
Bedste svar

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.

Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
2
okt. 24
1975
2
mar. 22
5323
1
jul. 21
2515
0
jan. 23
2226
3
sep. 19
4125