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.