unable to generate voucher number

[graceinthegarden]

We are getting an error message everytime we open Payables, Transaction
Entry. "Unable to generate voucher number". You can't close the transaction
entry window, you can't delete or clear so we end up ctrl-alt-del to get out
of Dynamics. We are running Dynamics GP 9.0. Any one else ever run in to
this? We have voucher numbers set up in the payables system, and the next
number to use seems valid.
--
grace

[Mariano Gomez]

Grace,

You say "seems valid", have you verified this? Run the following query
against your database:

select * from pm00400 where cntrlnum = (select ntvchnum from pm40100)

If this query returns a value then you will need to run the following query
to correct:

select max(convert(int, cntrlnum)) + 1 from pm00400

This result is what you will need to enter in the PM Setup window padded by
the number of zeroes you are using currently on your voucher number string.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com

[jav]

We have this happen every once in a while. We do a lot of integrations of AP
invoices and for some reason the voucher numbers get set to an old number in
the Payables setup window. Basically, I have to go find out what the next
voucher number needs to be by clicking on the magnifying glass (lookup)
screen on the Payables Transaction Entry screen and sort by the voucher
number. Add one number to the voucher number and update the next Voucher
number in the Payables Setup screen.

To get out of the screen by not having to Ctrl-Alt-Delete, just have your
user select a different voucher using the magnifying glass (lookup).

[Mariano Gomez]

Grace,

Furthermore, have you checked to see if your AP voucher is padded with
enough zeroes so the voucher number can roll over adequately? For example if
your voucher number is set to 4 characters then the maximum number you can
have is 9999, the system will have issues rolling over to 10000 because the
voucher number was not define as a 5 character string.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com