Purchasing Batch Invoice Posting

[huntemw]

We receive report message:

"No unused Payable Vouchers can be found"

When trying to Post a Purchasing Batch(Origin: PurchasingI nvoice Entry)

--
mwh

[Frank Hamelly, MCP-GP, MCT, MVP]

Go Tools>Setup>Purchasing>Payables and click the 'Options' button.
What is your Next Voucher Number?

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com

[Mariano Gomez]

A few questions:

1) How long is your voucher number in accounts payable?
2) What is the next voucher number under Payables Management Setup?
3) If you go to the Payables Transaction Entry screen and try to enter a new
invoice voucher, do you get the same error?

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

[huntemw]

The next voucher# was 1195 however there are the voucher numbers 1195, 1196,
1197 etc already exitst in the POP30300 table (there are on voucher#s in the
POP10300 table). Running queries show what look like anomalies in the table.

VCHRNMBR DEX_ROW_ID GLPOSTDT
53 526158 2008-10-08 00:00:00.000
60925 80456 2002-12-26 00:00:00.000
500150 512034 2008-08-11 00:00:00.000

I tried setting the next voucher# to 500151(one more that the largest
number) . That didn't help.

mwh

[Mariano Gomez]

Aha! I knew it! Run the following query against your company database:

select MAX(cntrlnum) from Pm00400

Increment this value by 1 and plug it in your PM setup window. Make sure you
pad the number with zeroes, enough for the system to roll over without giving
you an error.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

[huntemw]

Thanks.

Were able to reset it to a "good" number with leading zeros. No more problems

Thanks again.
--
mwh