Question
Inventory Valuation Report Changes / Sales Order Item Receipt and Bill Entry
On QB destop.
I found a quirk relating to a unique situation I sometimes have. Here's an example:
- We receive into QB 10 items from a PO on September 30. Inventory is increased by 10 and the value by the related amount. The valuation report reflects this change (+10 pcs).
- I receive the invoice a week later, but the date on the paper invoice from the supplier is October 7. When I enter bill from received items on October 7, I enter the QB bill date as October 7.
- QB then REMOVES 10 pcs from the September 30 valuation report, and plops into into inventory as of October 7, and messes up our inventory valuation report that was actually printed AS OF Sept 30 and printed ON Sept 30.
- Printing the report again in October after that supplier invoice was entered creates a difference. Inventory was already done and adjustments made.
Why do suppliers do this with their invoices? Don't ask me... It happens with a nice handful of them.
My workaround for this is to enter a fake bill date in the month the items were received, (not what's printed on the paper invoice), and manually change the due date.
I guess my question is if this is just a weird way QB works or am I doing something wrong?