Script to add items with zero quantity to Count

Close any open Counts -> run the script below -> log out of all orders and log back in -> Open a new Count and you will see all items.

In order to fix the above issue, we have created a SQL script to run on the computer which has All Orders installed.

1. Login to All Orders as Admin
2. In All Orders do File - Maintain
3. Click the 'Advanced' Tab
4. Press the 'Run DB Command' button
5. Cut and paste the following into the box
------------------------------
delete from CompanyPreference where PreferenceName='GetAllItemsOnCount'
;
insert into CompanyPreference (PreferenceName,PreferenceValue) values ('GetAllItemsOnCount','1')
--------------------------------
6. Press the 'Run' button
7. You will get a message 'Command completed successfully'
8. X out of the window
9. Close file Maintenance window

Should you get a message other than 'Command completed successfully' please report it to us.

To turn that setting back off follow the steps above but run this script instead
------------------------------
delete from CompanyPreference where PreferenceName='GetAllItemsOnCount'
;
insert into CompanyPreference (PreferenceName,PreferenceValue) values ('GetAllItemsOnCount','0')
--------------------------------