Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / This voucher number al...
Microsoft Dynamics GP (Archived)

This voucher number already exists. Please enter a new voucher number.

(0) ShareShare
ReportReport
Posted on by William Kow 3,795

During the payable transaction entry, there was a network interruption, so after restarted the computer and re-do the entry by entering the same payment voucher number, and then GP prompt the below error message:

This voucher number already exists. Please enter a new voucher number.

BTW, this transaction has not been posted, when query to PM10000 result show one has this transaction, and checked all field content, but do not find any invalid data or special characters.

Have ensure all users logout, delete all the records in Activity, SY00800,SY00801, DEX_LOCK, DEX_Session

then run Checklink, but then it still prompt the same error, when the entry to use the same voucher number again,

This transaction can be found in Smartlist, but when open it, will prompt the same error.

Note: this voucher will not be listed if I search using Inquiry menu (Purchasing > Transaction By Document)

After that I delete the record in PM10000 and re-do Checklink, and then it still prompt the same error when the using the same voucher number.

Please advise and many thanks in advance.

P/S:  Dynamics GP 10 with SP2, SQL server 2005 standard

*This post is locked for comments

  • LynneMosiman Profile Picture
    LynneMosiman 5 on at
    RE: This voucher number already exists. Please enter a new voucher number.

    Thank you for sharing this, Jason.  It's the information I needed to finally solve this frustrating problem.  Much appreciated.

  • Jason Jones Profile Picture
    Jason Jones 55 on at
    RE: This voucher number already exists. Please enter a new voucher number.

    Correction.  I could not see how to delete my previous Reply.

    I struggled with this.  The resolutions related to the PM00400 table and Cjeck Links did not work.  I finally found the settings listed below posted by Victoria Yudin.  I set the PSTGSTUS Status from 60 back to 20 and was able to edit the document in Transaction Entry.  Thanks for nothing MS Customer Source.

    PSTGSTUS (Posting Status) in PM10000:

    10 - transaction being entered for the first time before it has been saved by the user

    20 - saved and unposted transaction

    30 - transaction that is currently posting (realtime)

    40 - posted transaction

    50 - transaction that has encountered an error during posting

    60 - transaction that has been saved previously and had a status of 20 and is now being edited by a user

    70 - transaction that has been posted previously in a recurring batch that still contains unposted transactions is now being edited by the user

  • Jason Jones Profile Picture
    Jason Jones 55 on at
    RE: This voucher number already exists. Please enter a new voucher number.

    I struggled with this.  The resolutions related to the PM00400 table and Check Links did not work.  I finally found the settings listed below posted by Victoria Yudin.  I set the PSTGSTUS Status back to 20 and was able to edit the document in Transaction Entry.  Thanks for nothing MS Customer Source.

    PSTGSTUS (Posting Status) in PM10000:

    10 - transaction being entered for the first time before it has been saved by the user

    20 - saved and unposted transaction

    30 - transaction that is currently posting (realtime)

    40 - posted transaction

    50 - transaction that has encountered an error during posting

    60 - transaction that has been saved previously and had a status of 20 and is now being edited by a user

    70 - transaction that has been posted previously in a recurring batch that still contains unposted transactions is now being edited by the user

  • Suggested answer
    Tariq Aziz. Profile Picture
    Tariq Aziz. on at
    RE: This voucher number already exists. Please enter a new voucher number.

    I compared the problematic transaction with normal one and found differences in 2 columns:

    1. USERID

    2. DCSTATUS

    Updating the User ID to empty and Doc status to 1 helped me.

    update a set USERID = '' , DCSTATUS = 1

    from PM00400 a where CNTRLNUM = 'YOUR_PM_DOC'

  • Gulam Ahmed Profile Picture
    Gulam Ahmed 30 on at
    Re: This voucher number already exists. Please enter a new voucher number.

    Table PM00400 , Field DCSTATUS is set to 0 from 1 when a Payables transaction is opened in Payables Transaction Entry window (Transactions -> Purchasing -> Transaction Entry)  and is reverted back to 1 when it is saved or the window is closed. The following SQL statement works when abnormal shutdown occurs to re-open the voucher.

    update PM00400 set DCSTATUS =1 where CNTRLNUM = 'XXXX' and VENDORID = 'VVVV' and DCSTATUS =0

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: This voucher number already exists. Please enter a new voucher number.

    The PM00400 table is the payables key master table. So given abnormal shutdown yoou could have the same document in payables work, open and history table. The trick is to find the duplicates. You could try deleting that table and then running check links on the entire payables tables. That will recreate the payables key master table. Always create a backup first and do this after hours. If duplicates do truly exist consult with your GP partner or open a case with MS. If you have access to autmated solutions on CustomerSource this script will help.

    mbs.microsoft.com/.../automatedsolutionsR10.htm

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    Re: This voucher number already exists. Please enter a new voucher number.

    Dear All ,

    I have similar issue to the above mentioned but the difference is that there is no error message comes but when i list the vendor report i find open transactions with 0 value in the right column . I tried the above solution but once i run the check links in the database i get message the

        FUL0400001    PJ0805641: This keys record was re-created through check links.

    then i find the transaction comes back again to the table pm00400 !

    what is the issue .

    regards

    Rashed

  • Michael Lupro Profile Picture
    Michael Lupro 335 on at
    Re: This voucher number already exists. Please enter a new voucher number.

    See what you find in the PM00400 PM Key Master Table.  If you find your voucher here, delete it, run checklinks, and that may solve the problem.

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: This voucher number already exists. Please enter a new voucher number.

    Dear All,

    Please ignore my last request, because I managed to find the solution at KB863247 with two SQL scripts. One is to find the affected transaction and the one is to clear the transaction.

    select * from PM00400 where CNTRLNUM = 'XXXX' and VENDORID = 'VVVV'

    delete PM00400 where CNTRLNUM = 'XXXX' and VENDORID = 'VVVV'

    Thank you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans