Duplicates in Item Movement History Report

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Duplicates in Item Movement History Report Eric J 01-08-2007
Posted by Eric J on January 8, 2007, 6:56 pm Please log in for more thread options We recently did a full physical inventory and for hundreds of items, the Item Movement history report show duplicate entries for "Physical Inventory Adjustment". The InventoryTransferLog table shows only one Physical Inventory Adjustment for each item, but the view created by the report shows two rows for each item, with different ReferenceEntryID #s and a DateTransferred about a minute apart. The resulting inventory numbers in RMS appear to be very screwed up as a result. Have any of you experienced such a thing? Any ideas what causes it, and how to fix it? Similar Threads Posted Item Movement History Report December 23, 2006, 7:44 pm ITEM MOVEMENT HISTORY REPORT IN RMS VER 1.3 November 29, 2007, 12:26 am Item Value List vs Item Movement History Report (including cost) July 1, 2009, 1:55 pm Item Movement/Movement History and Item Qty reports October 13, 2005, 9:24 pm Item Movement Report with On Hand and Reorder kudos to Akber - "Items - Item Movement Report.qrp.zip" yEnc (1/1) April 17, 2008, 2:02 am Item Movement vs. Item Movement History December 21, 2006, 4:38 pm Adding onhand quantity to inventory movement history report July 28, 2006, 3:05 am Item Duplicates June 5, 2007, 1:35 pm Item History Report December 22, 2005, 5:26 am Report on the item movement report should show qty on hand as we September 1, 2005, 10:37 am