Reports not matching up

[aprilc]

Peachtree Complete version 8: An item is received in on say, Feb 4th. When the invoice comes in, it is assigned the date. When we receive the invoice from the vendor, we change the receive in date to match the invoice date, say Jan 31st. After posting, the item does not show up on the Inventory Status Report ran as of Jan 31st. However, it does show the activity in the Item History Complete Report as being received in on the 31st. This is throwing the total of the Inventory Status Report off, and it is not matching up with the total on the balance sheet. Why it the item not appearing on the Inventory Status Report?

[bluegal]

I ran across a problem when editing a date for a check in AP that was originally entered as Dec. 2001 and then edited to January 2002. Since I was still in my December accounting period, I assumed any transactions associated with that edit would be updated with the new date. However, the program still showed the invoices as being paid and therefore absent from the December AP aging report, even though the GL transactions posted correctly to January. So I'm wondering if the same thing happens in Inventory; your GL balances get updated correctly (Jan. instead of Feb) but the Inventory reports do not.

[aprilc]

Correct. It shows up when you do an item history report, but not in the stock status report, therefore, the balances are not mathing up.

[aprilc]

Can this be fixed?

[bluegal]

Run a report with a date of 2/28/02 and see if the transactions have "caught up" with each other. When I ran a report ending 1/31/02 my balance sheet and AP aging report once again were correct. I guess you would have to be careful not to cross months when editing dates.