Physical Inventory

(0) Share

Report

Posted on by Community Member

Need help on doing a physical inventory the last time we did it items that were in negative stayed in negative and did not correct the ones that were not in store. When we started physical we put everything at 0 and then scanned inventory in.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Jeff @ Check Point ... 13,382 on at

Like (0)

Report

RE: Physical Inventory

OR

enter this into a query;

ALTER DATABASE "databasename" SET RECOVERY SIMPLE

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Physical Inventory

Thank you Shawn I will try this I hope this works. :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Physical Inventory

wow nice to see MS support here ;) welcome

Was this reply helpful? Yes No
Shawn Meade on at

Like (0)

Report

RE: Physical Inventory

Also, on top of Jeff's suggestion, I have seen an issue like this that was caused by an SQL option that was set to bulk logged instead of simple for the recovery model.

For this, go into SQL Server management studio (you can find the express version online for free) and then right click the database then go to properties. Go to the options tab and then check the recovery model to ensure that it is set to "Simple".

Best Regards,

Shawn with Microsoft Retail Support.

Was this reply helpful? Yes No
Jeff @ Check Point ... 13,382 on at

Like (0)

Report

RE: Physical Inventory

Did you do two PIs? One that zeroed things and then do another only counted PI?

To create a zero, do a new PI, accept the defaults and then a calculate and commit it, that zeros everything. Next do your preferred option of entering in counted items and then calculate and commit. That will leave things at 0 unless you counted them.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Physical Inventory

Hi Andrew,

We have a simple to use handheld solution that will allow you to perform physical inventory count. It will allow you to count the items in the store and reconcile with RMS using the built in physical inventory count feature.

It is very easy to use and setup and you can be counting away in a matter of minutes! Please call me so I can help you get started.

Thx

Shawn

Prime Retail Solutions

646-706-7600 xt: 101

Was this reply helpful? Yes No