1. Home
  2. Point-Of-Sale Software
  3. Discrepancies between on-hand quantity and item movement report

Discrepancies between on-hand quantity and item movement report

We have an RMS DB 6 months old, the on-hand quantities on lots of products do not seem to be calculating correctly. When we go into item properties and click on Item Movement since DB was created, the report correctly shows all the purchases minus all the sales and give a total qty on top which is correct. However, in some products this figure is often completely different to the On-Hand quantity.

The only thing that I can think of that is different about the use of this DB is that instead of adding stock through purchases, stock is added by manually adjusting the on hand figure. However, this shouldn't create a difference between on-hand and item movement history.

Reply to
Keith - SRS
Loading thread data ...

Did you ever figure this out? I have the same issue - I do a movement report for all dates, but the on hand quantity does not match. Strange.

Reply to
Jason

Reply to
Keith - SRS

a.dardiry had written this in response to

formatting link
:

Dear All Try to do the next steps to solve this issue

1- Create a synchronization store database worksheet (Style 101). a. Ensure that it?s downloaded to the store and completed. 2- Create a request data upload worksheet (Style 401) from old date (one month for example). a. Ensure that it?s downloaded to the store and completed. 3- Create request full item count worksheet (Style 501). a. Ensure that it?s downloaded to the store and completed

##-----------------------------------------------## Newsgroup Access Courtesy

formatting link
Tax and Accounting Software ForumsWeb and RSS access to your favorite newsgroup - microsoft.public.pos - 36980 messages and counting!##-----------------------------------------------##

Reply to
a.dardiry

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.