Resetting Voucher Numbers in Progress Versions
Solution ID = KB-87
Goal : Resetting Voucher Numbers in Progress Versions
Module : SLCOPO
Fact 1 : PO
Fact 2 : AP
Symptom 1 : Someone entered an incorrect voucher number and the voucher numbers need to be re-set
Symptom 2 : What can be done if the voucher number gets set too high?
Database : Progress
Cause
It is difficult to get the voucher number set to a lower number. The system is designed to start at an initial value and then increment off that value. If a higher number is entered at any item that becomes the new default value.Fix
There a few options to fixing this problem. Below those options are listed.Option #1
1. Purge the Voucher History. That is found in Purchasing Utilities, Delete Utilities.
By performing this utility, the voucher registers will have no information.
The vouchers will still show though in A/P posted transactions.
2. Reset the next voucher counter stored in the file lasttran. If you have full development
Progress, the following program can be entered and run in Query Editor. Enter the number that should be the next voucher number in the field lasttran.
find lasttran where symix.lasttran-key=5.
display lasttran.
update lasttran.last-tran.
If you do not have full development Progress, the file lasttran must be unloaded through the unload/load utility, which will create a lasttran.d file in the operating system. The voucher number can be edited through vi or DOS editor. Then lasttran must be emptied then reloaded.
Option #2
Obviously, purging voucher history is not a desirable option for many. So there is a way to fix files through Progress or vi editor.
1. Through Progress query editor, the wrong voucher numbers in files vch-hdr, vch-item,vch-dist and vch-stax must be updated. Also, if the transactions were not posted in A/P, aptrx and aptrxd must be updated. If they were posted in A/P, aptrxp must be updated. Use the following query to update the voucher numbers.
for each symix.vch-hdr where voucher > xxxxxxx:
display vch-hdr.voucher po-num.
update voucher.
end.
Run this query for each one of the files listed above, just replace vch-hdr with the appropriate file name. When editing numbers, make ABSOLUTELY SURE THAT THE NEW VOUCHER NUMBERS HAVE NOT BEEN USED ELSEWHERE IN THE SYSTEM.. Symix has big problems with processing records when two or more vouchers share the same number.
The files can also be unloaded through the unload/load utility, but the entire file can only be unloaded. The bad voucher numbers will usually show up at the end of the file. The files can be edited through vi or DOS editor, then emptied, then reloaded.
2. Reset the next voucher counter stored in the file lasttran. If you have full development Progress, the following program can be entered and run in Query Editor. Enter the number that should be the next voucher number in the field lasttran.
find symix.lasttran where lasttran-key=5.
display lasttran.
update lasttran.last-tran.
If you do not have full development Progress, the file lasttran must be unloaded through the unload/load utility, which will create a lasttran.d file in the operating system. The voucher number can be edited through vi or DOS editor. Then lasttran must be emptied then reloaded.
