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
Related Articles
Feature - Added Days Out of Stock (DOS) Column to the Location History Information, Sales Desk Info - Screen
Release date: 9/19/2018 In Stock Status Inquiry Screen, we added a Days Out of Stock (DOS) column to the Location History Information, in the Sales Desk Info - screen. To access this information, first bring up the stock status of a particular item, ...Feature - Added QI (Qty Sold in Invoice History) Data Type to the User Defined CSV Export
Release date: 10/8/2020 Version: 8.5 & Up Changes have been made to the Reordering Advice User Defined CSV Export programs. You can access this feature from I/M -> Reports -> Reordering Advice Reports -> Maintenance -> User Defined CSV Layout for the ...Feature - Addition of TOR, QtyOH, OHValue to Stock Status Inquiry
Release date 9/3/2020 Version 8.5 & Up The purpose of this feature is to evaluate how planners manage the inventory in the past and the foreseeable future. For this reason, we added the following new columns to Stock Status Inquiry -> Location ...Avalara - Stock Status Inquiry
Release Date: 4/28/23 Version: 8.6 and Above When the Avalara Integration is enabled, the Stock Status Inquiry that is launched from Customer Order Processing-> Inquiry-> Stock Status Inquiry will show the estimated tax percentages for a customer ...Feature - Drill Down to Stock Status and Production History Report from Plus Work Order Inquiry
Release Date: 5/15/25 Version: 8.5 and Above This feature gives the user the ability to drill down to the work order parent item's stock status inquiry from the routing screen in Plus Work Order Inquiry. There is also a new option to print the Plus ...