On the Item Record for Item A, it shows me that I have "1092" "on hand & available" quantity but I know for a fact that I physically only have "756"
I checked all the Item Receipts and Fulfillments and it should technically only have "756" left but for some reason it's showing me "1092". Please note that the difference is 336.
I had entered a Sales Order with 804 x Item A and Billed/Invoiced it. But later the customer only wanted 468 x Item A (note that the difference is 336). Then I ended up closing the SO after 468 (804-336) items were fulfilled and then issued a credit note for the extra 336 billed. Please note that the invoice still says 804 but the credit note was applied to that invoice and sorted all billing issues.
Would this have caused my inventory on hand to increase by 336? Now, I checked if there was any inventory committed or allocated that's causing the issue. However, I confirmed that's not the case.
I kindly request assistance in helping me sort this elevated inventory on hand value.
Thanks very much.