QBE - Enhanced Inventory Receiving - Problem with Credit Memo
Ok we use QBE with Enhanced Inventory Receiving so the normal work flow looks like this...
PO for 10 widgets - inventory is 0
Bill for 10 widgets - inventory is still 0 (EIR does not receive inventory with bills)
Item Receipt for 10 widgets - inventory is now 10
Invoice for 10 widgets - inventory is now 0
So here is where it does not work...
PO for 10 widgets - inventory is 0
Bill for 10 widgets - inventory is still 0 (EIR does not receive inventory with bills)
Item Receipt for 7 widgets - inventory is now 7 because the vendor only shipped 7
Credit Memo for 3 widgets because the vendor billed for 10 - Inventory is now 4 (problem)
Invoice for 7 widgets - inventory is now -3 (problem)
So at first the solution seemed to be that Credit Memo's under EIR should be like bills and NOT effect inventory, but then I though about an product return and how that would work or not work...
PO for 10 widgets - inventory is 0
Bill for 10 widgets - inventory is still 0 (EIR does not receive inventory with bills)
Item Receipt for 10 widgets - inventory is now 10 but 3 are defective
Credit Memo for 3 widgets to return to vendor - Inventory is now 7 (so it works for now)
Invoice for 7 widgets - inventory is now 0 (correct)
But with the fix...
PO for 10 widgets - inventory is 0
Bill for 10 widgets - inventory is still 0 (EIR does not receive inventory with bills)
Item Receipt for 10 widgets - inventory is now 10 but 3 are defective
Credit Memo for 3 widgets to return to vendor - Inventory is still 10 (problem)
Invoice for 7 widgets - inventory is now 3 (incorrect because they were sent back to vendor)
So we need two things...
1. A fix for credit memo's to NOT adjust inventory when using EIR
2. A way to do a reverse item receipt for goods returned returned to a vendor
And this needs to be in a manner that normal QB users can do. Yes, as an admin I can do journal entries and inventory adjustments but your typical user needs to be able to accomplish this all in a daily workflow.