|
| | | Forum Newbie
Group: Forum Members
Last Login: 10/22/2008 9:07:50 AM
Posts: 4, Visits: 16 |
| | Hi... I am wondering everytime we do Physical inventory in our store I am having this problem. Scanned and Inventory Physical Qty doesn't match. I print the Physical inventory using the Physical Report Detailed form, I am getting different Physical Quantity count between Scanned and Inventory. I already did reconstruct to both main and the remote before i start doing the polling. The procedure that I am doing before the starting the Physical Inventory from the remote are as follows: 1. I reconstruct both the main and the remote 2. remote - regenerate voucher, slip, receipts. from last inventory date to present. then quickpoll from remote 3. main - process in then initialize the remote then quick poll from remote again. I always print on hand Inventory from the main computer and I make sure that it match the on hand from the remote before we start the Physical Inventory. After all the scanning of items from the remote i prepare and update the remote and poll over to the main. From the main i open the Physical Inventory and try to print the the Physical inventory using the Physical Report Detailed form, I am getting different Physical Quantity count between Scanned and Inventory. Is there any problem in our system or its the way i am doing it? Thanks!.
Jolly "Buknoy®" Bakunawa
Millennium Shoes, Inc. |
| |
| | | 
Forum Member
Group: OSRS Employee
Last Login: Today @ 4:04:15 PM
Posts: 572, Visits: 2,792 |
| | Hi Jolly, if you use Clear counts, this will cause the scanned and Phy Qty not to match, as the scanned will not be reset without deleting the inventory. So, if you scanned 500 items and uploaded them to the PI, your scanned and Qty would both be 500. If you cleared counts and uploaded the scanner again, you would have scanned at 1000 and phy qty 500. When polled to the main in this case it will show 500 and 500, and the remote will show 1000, 500. thats my 1st thought on this.
Brett Reed Technical Support
www.OneStepRetail.com
|
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 10/22/2008 9:07:50 AM
Posts: 4, Visits: 16 |
| I am talking about the report of the Physical Inventory. Everything is fine with the scanning of the merchandise at the remote. I polled over to the Main. Retail Pro has the forms to use. I tried same form w/c is the Physical Report Detailed and I tried to print the Report under Scanned and Inventory and match the Physical Qty of both report and doesn't match. That is why I always use the Scanned Physical Qty because it gives me a the right qty based on our Physical count/scanning.
Jolly "Buknoy®" Bakunawa
Millennium Shoes, Inc. |
| |
| | | 
Forum Member
Group: OSRS Employee
Last Login: 12/24/2008 11:33:07 AM
Posts: 138, Visits: 318 |
| | You will need to make sure the main and the remote have the same number of lines of inventory (Tools > RproDB). I observed this same discrepancy when the scanned count went up to 83842 but the inventory lines (in RproDB) were only set to 35,000 in RproDB. The Scanned page will show inventory lines up to 83,842, but the Inventory screen (under RproPI) will only show up to 35,000. The report when printed under Scanned will include all Scanned qtys, including those beyond line 35,000. However, under Inventory, the report will only included scanned qtys up to the max # inventory lines set in Rpro (35,000 in this example). When I increased the number of inventory lines up to 83842, the phys qtys under Inventory matched those under Scanned. Ths happened because the inventory count was taken at a location where the number of inventory lines set in RproDB (83,842) was higher than it was at the Main (35,000). You are right that the physical qty under Scanned will always be right.
Thank you for using the OSD forum! ------------------------------------------------------------------------
Donna Knight System Consultant/Knowledge Base Manager What will you learn about Retail Pro today?
Find out in our growing Knowledge Base of 2000+ informative articles at: http://kb.onestepretail.com |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 10/22/2008 9:07:50 AM
Posts: 4, Visits: 16 |
| But what if the inventory lines from the remote and the main are just the same? Because everytime before I start the Physical Inventory from the remote i always making sure to run the RPRODB and check the data from there if i have the same Inventory lines and also at the Merchandize; Inventory line from the Main. I used to have the same Qty of the scanned and Physical but recently it changed. I cannot see any problem regarding the system aside from this one. I already Reconstruct so many times thinking that I can fixed it that way but it didn't change anything. What are the first thing to do at the main before doing the Initializing the remote. Any special procedure to follow before doing the Physical Inventory on the remote?.
Jolly "Buknoy®" Bakunawa
Millennium Shoes, Inc. |
| |
| | |
Forum Member
Group: OSRS Employee
Last Login: 12/24/2008 11:33:07 AM
Posts: 138, Visits: 318 |
| | You would also want to: 1) Create vouchers for all items you will count during the physical inventory. 2) Complete all transfers. If you are tracking inventory in transit, make sure you mate and match all slips in Tran Verification. 3) Make sure polling is up to date, i.e. you are not missing data from any store. 4) Making sure the inventory lines are the same isn't something we usually recommend before a PI, because it is part of the continuous management of the system. Whenever lines are increased at the Main, you will want to make sure they get increased at the remotes. What I'm curious to know is if there is the same discrepancy between the two reports if you run them at the Main and Remote.
Thank you for using the OSD forum! ------------------------------------------------------------------------
Donna Knight System Consultant/Knowledge Base Manager What will you learn about Retail Pro today?
Find out in our growing Knowledge Base of 2000+ informative articles at: http://kb.onestepretail.com |
| |
| | |
Forum Member
Group: OSRS Employee
Last Login: Today @ 4:04:15 PM
Posts: 572, Visits: 2,792 |
| | |
| | | Forum Newbie
Group: Forum Members
Last Login: 10/22/2008 9:07:50 AM
Posts: 4, Visits: 16 |
| | These are the steps I always do/check before the Physical Inventory from the remote. 1. Quick poll from the Remote to Main 2. Process-In Main and Run--> RPRODB, Check the Inventory line from the remote if it is the same as the Main. 3. Regenerate Remote Receipts, Vouchers and Slips Process out Main then Quick Poll from the Remote. 4. Initialize Remote then Quick Poll again. These are the steps I always do. I always have the Journal of my counting. I making sure that we dont scan anything from the warehouse affecting the Remote on where there is an Inventory at night. We all process our Merchandise in one warehouse and just trasfer them to all the Remote. I got no problem regarding my journal and the Scanned Items from my scanners from the Remote. But after I Prepare the Physical Inventory ready to Poll over to the Main, the next day when I open my Physical Inventory at the Main I always try to print two Reports. One is under the Scanned and the other one is from Inventory. But when I am trying to compare the Physical Qty under Scanned Qty Reports I cannot get any answer about it why there is two different Qty amount between the Scanned and Inventory Report. But as I said I always follow the Scanned Qty amount for my report.
Jolly "Buknoy®" Bakunawa
Millennium Shoes, Inc. |
| |
| | |
Forum Member
Group: OSRS Employee
Last Login: 12/24/2008 11:33:07 AM
Posts: 138, Visits: 318 |
| If the totals are different, something would have to be different on those reports, but a technician is going to need to look at those two reports to tell you what the difference is.
Thank you for using the OSD forum! ------------------------------------------------------------------------
Donna Knight System Consultant/Knowledge Base Manager What will you learn about Retail Pro today?
Find out in our growing Knowledge Base of 2000+ informative articles at: http://kb.onestepretail.com |
| |
|
|