inv_status_codes table - relation of inv_status_code to inv_status
(RMS13.2.8)
Can there be more than one inv_status_code for each inv_status in inv_status_codes table? I believe there can be, but I want to confirm it as we are seeing issue of unavailable inventorygetting multiple by the number of inv_status_codes for each inv_status when validated in the inventory adjustment form. Sample data below -
INV_STATUS_CODE | INV_STATUS_CODE_DESC | INV_STATUS |
'0184' | XYZ | 6 |
'0196' | ABC | 6 |
'0211 | CCC | 6 |
If an item location has say 20 qty in inv_status 6 int he inv_status_qty table then the value for above combination is calculated as 60 (multiplied three times) when validating in invadjst form.