Hello - We have the situation where a PO has been created, partially recieved and then Billed. The Vendor Bill is for a qty greater than what was received. A Vendor credit note was subsequently processed to correct. The net result is that the Inventory Received Not Billed is incorrect as it does NOT reflect the vendor Credit.
In Summary
1 - PO created for a qty of 100 - no accounting
2 - Item Receipt booked for qty of 30
Dr - Inventory 30 units
Cr - Inventory Received not billed 30 units
3 - Vendor Bill received for a qty of 100 (note although the PO was for 100 we have only received 30, so this is an over bill)
Dr - Inventory Received not billed 100 units
Cr - Accounts Payable Liability 100 units
4 - Create Vendor Credit directly from Vendor Bill
Dr - Accounts Payable Liability 70
Cr - Inventory 70 units <<-- Expect this to go to Inventory Recieved not billed as this relates to a quantity correction NOT a price correction. If this was a price correction then this would be the correct treatment but in this example there is no issue with the price, the issue is the qty.
The actual net impact on the Inventory Received not billed is;
Cr - From Item reciept 30 units
Dr - From Vendor Bill 100 units
Net balance = 70 units DEBIT
The expected net impact on the Inventory Received not billed is;
Cr - From Item reciept 30 units
Dr - From Vendor Bill 100 units
Cr - From Vendor Credit note 70 units <<-- this is missing
Net balance = 0
How are other people dealing with this?
We have considered using a Vendor Return Authorisation but this is NOT a return. We are NOT returning goods, we have been over billed by the vendor and need to reverse the impact of the invoice not the item receipt.