Credit Memo with Qty Return Will Reduce Qty Sold in Sales History

Q - Please see below. It seems as though there is some disconnect with the location history table and what was sold.  In the attached screen below,  you can see there are two quantity sold for this item in the month of January 2016.


So why does the sales history in I/M Location History show zero quantity sold for January 2016?


A - If you look at the third entry on the Inventory Transaction Inquiry in your attached screen, you will notice there's an "R" transaction from COP on 1/12/16. It implies that you have a return from customer #383350 for qty 2 in January. Then they are sold on 1/19/16. The return and sold cancel each other. So you have zero quantity sold in the history. 

EMK


Feedback and Knowledge Base