Configuring NEOSYS Finance System: Difference between revisions
From NEOSYS Technical Support Wiki
Jump to navigationJump to search
(New page: == Deleting unwanted historical unposted batches prior to commencing finance module == This is irreversible so take a backup in case of errors. The process only deletes unposted records. ...) |
|||
| Line 5: | Line 5: | ||
This leaves some NEOSYS generated journals in the current period which have to deleted one by one manually from the Journal Data Entry screen. | This leaves some NEOSYS generated journals in the current period which have to deleted one by one manually from the Journal Data Entry screen. | ||
Change 2008.12 and 0812 to | Change 2008.12 and 0812 to the first period that you want to KEEP! | ||
F5 | F5 | ||
SELECT BATCHES WITH YEAR_PERIOD LT "2008.12" AND WITH UNPOSTED | SELECT BATCHES WITH YEAR_PERIOD LT "2008.12" AND WITH UNPOSTED | ||
DELETE BATCHES | DELETE BATCHES | ||
FLUSH.INDEX | |||
SELECT VOUCHERS WITH YEAR_PERIOD LT "0812" AND WITH LASTACTION "D" | SELECT VOUCHERS WITH YEAR_PERIOD LT "0812" AND WITH LASTACTION "D" | ||
DELETE VOUCHERS | DELETE VOUCHERS | ||
FLUSH.INDEX | |||
UTIL - this prepares maintenance to run the next command | UTIL - this prepares maintenance to run the next command | ||
CHK. | CHK.VINDEX ("0" for all periods and delete all missing voucher entries and clear all empty index records) | ||
FLUSH.INDEX | |||
Notes: | |||
#The instructions say LT 2008.12 or LT 0812 - "LT" means LESS THAN ie NOT including the period mentioned so it is the first period you want to KEEP! | |||
#On older versions of NEOSYS before 2009 use CHK.INDEX instead of CHK.VINDEX | |||
#The WITH UNPOSTED and WITH LASTACTION phrases limit the clearing to unposted vouchers. If you remove these phrases to clear posted vouchers then you must also do CLEARFILE BALANCES which should only be done if there are no posted vouchers. In other words you cannot, with this procedure, clear some posted vouchers and not others. | |||
Revision as of 12:04, 19 May 2009
Deleting unwanted historical unposted batches prior to commencing finance module
This is irreversible so take a backup in case of errors. The process only deletes unposted records.
This leaves some NEOSYS generated journals in the current period which have to deleted one by one manually from the Journal Data Entry screen.
Change 2008.12 and 0812 to the first period that you want to KEEP!
F5 SELECT BATCHES WITH YEAR_PERIOD LT "2008.12" AND WITH UNPOSTED DELETE BATCHES FLUSH.INDEX SELECT VOUCHERS WITH YEAR_PERIOD LT "0812" AND WITH LASTACTION "D" DELETE VOUCHERS FLUSH.INDEX
UTIL - this prepares maintenance to run the next command
CHK.VINDEX ("0" for all periods and delete all missing voucher entries and clear all empty index records)
FLUSH.INDEX
Notes:
- The instructions say LT 2008.12 or LT 0812 - "LT" means LESS THAN ie NOT including the period mentioned so it is the first period you want to KEEP!
- On older versions of NEOSYS before 2009 use CHK.INDEX instead of CHK.VINDEX
- The WITH UNPOSTED and WITH LASTACTION phrases limit the clearing to unposted vouchers. If you remove these phrases to clear posted vouchers then you must also do CLEARFILE BALANCES which should only be done if there are no posted vouchers. In other words you cannot, with this procedure, clear some posted vouchers and not others.
