Item Movement Report Error

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

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

Subject Author Date Item Movement Report Error Dave P 11-03-2006
Posted by Dave P on November 3, 2006, 11:09 am Please log in for more thread options We use MS RMS with 6 HQ users. We have encountered a problem whereby it is not possible for the item movement report to be run more than once at any one time. It appears that the report creates a view in the database which gets dropped and created every time the report runs. This appears to have the effect that only the latest run of the report works. Refreshes of the earlier reports fail. This appears to be true for two reports run in different windows by the same user and also for different users. A further consequence appears to be that if users with different database logins run the report and the view fails to be dropped at the end of their session, other users cannot run the report either - because they dont have rights to drop the report. Has any one else encountered anything like this? Similar Threads Posted 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 Value List vs Item Movement History Report (including cost) July 1, 2009, 1:55 pm Report on the item movement report should show qty on hand as we September 1, 2005, 10:37 am Item Movement Report @ HQ December 20, 2005, 6:07 pm Item qty/movement report January 15, 2006, 12:52 am Item Movement Report July 22, 2006, 11:29 am Item Movement Report August 6, 2006, 10:38 pm item movement report July 3, 2007, 6:52 pm Item Movement Report August 10, 2007, 10:16 am Custom Item Movement Report October 11, 2005, 10:07 am