System Five Add-Ons & Integrations help simplify the way you do things.
Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.
Copyright © 1984-present
Windward Software Systems Inc.
All Rights Reserved.
Privacy Policy
Here is a list of things that should be done to a DOS data set after it is updated to version 5.35. Please look at Routines to run after upgrade to 5.41.0.23 or greater at the bottom of this article for steps after upgrade to 5.41.0.23 or later. (See table of contents for a quick link)
These instructions need to be performed by a technician or a very skilled technical user. If you are not this person then please contact Windward Technical Support.
query for fixing GL codes < 4 digits: Take a look at the second query as well, the query will let you view what the accounts numbers were before you updated them.
update "Trandata" set Account = '0000' where length(Account) < 4
select * from "Trandata" where length(Account) < 4
These queries are needed for fixing departments errors if customer is no longer running departments: Please note that if you log into the data set with codes that have departments enabled you can run the move departments routine to perform a more thorough fix.
update "Trandata" set department = 0 where department > 0 update "Transact" set Department = 0 where department > 0 update "ARPyment" set Department = 0 where department > 0 update "Invoice" set Department = 0 where department > 0 update "Bill" set Department = 0 where department > 0 update "Cheque" set Department = 0 where department > 0
Query for Deleting Ledger numbers that are less than 4 digits:
delete from "Ledger" where length(AccNO) < 4
It is important to note that after 5.35 all users must make sure they upgrade to at least 5.41.0.23 due to some stock control issues. At that time here are some additional steps that need to be taken: In order to properly correct these issues there are a number of Toolbox routines that need to be run after applying the latest release update.
After updating to Version 5.41.0.23 the following Toolbox Routines need to be run to correct existing data problems.
In the Toolbox, under
Inventory Routines > Stock Control Routines
Run the following four routines:
If Department Transfers and Serial Numbers are in use
Look in the data folder for a file called ‘stockconvert-detail-YYYYMMDD-HHMM.txt’ the Date and Time of the data original conversion are embedded in the file name.
Once completed, I suggest that you also run the Inventory and Purchases > Inventory > Inventory Reports > Inventory Integrity
Report with the following additional item checked:
Fix Inventory Stock Quantities
The ‘Fix Inventory Stock Quantities’ item will recalculate the Stock quantities for all inventory now that the toolbox routines have corrected the stock records.