web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Payables Document A un...
Finance | Project Operations, Human Resources, ...
Suggested answer

Payables Document A unique document number could not be found. Please check setup.

(0) ShareShare
ReportReport
Posted on by Tim Wappat 5,703

GP: Version 18.4.1361 (2021)

Just upgraded GP to the above version. All is good except for payables. Users tried an EFT payment run.

When trying to process remittances the error "A unique document number could not be found. Please check setup."  pops up after/same time as the "Process Payables Remittance" opens. 

After this further attempts to process payment results in  An error occurred. Contact your system administrator to verify data. 

Does anyone recognise this issue and point me in the right direction?

pastedimage1663676968894v1.png

Tim Wappat

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Payables Document A unique document number could not be found. Please check setup.

    I would start by going to Tools->Setup->Purchasing->Payables and click the Options tab. Check the value for next payment number. Does it have a valid value?

  • Tim Wappat Profile Picture
    Tim Wappat 5,703 on at
    RE: Payables Document A unique document number could not be found. Please check setup.

    It looks valid to me.

    :(

    Tim

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Payables Document A unique document number could not be found. Please check setup.

    If you try to enter a manual payment do you get the same message?

  • Tim Wappat Profile Picture
    Tim Wappat 5,703 on at
    RE: Payables Document A unique document number could not be found. Please check setup.

    Update...


    Manual payments are running fine - just EFT payments.

    pastedimage1663685743296v1.png

    So I got some time on this and looked at the scripts and the error seems to be around GenerateNextEFTNumber 

    The Next EFT payment number field for that chequebook was empty, but that seemed reasonable as it was selected to use chequebook numbers instead. However I put a number into that field and set it to "Use EFT Numbers". This then allowed me to "Print Checks" and as you can see from screen shot it has advanced the number. 

    I now wonder if I turn it back to "Use Cheque Numbers", will it behave as expected? - next experiment. 

    However in the meantime I've got a way to pay suppliers via EFT, but using its own numbers. The checque numbers are not used by anyone afaik, so this may be a solution. 

    Also gonna run check links and reconcile payables tonight and see if that raises anything... 

    For information, follows is the Script log when trying to "Print Checks" follows...

    'GenerateNextEFTNumber of form PM_Print_Computer_Checks', table 'CM_Checkbook_MSTR', "0000000000000001012343295", 0

               'PM_Number_Inc_Dec', "", 1

    ... lots of stuff then...

        '[481] on form [-46]', script '[22095]', 0, 0

                           'SaveCurrentFormTrigger', 2567, 0, "SY_Error_Message"

                               'IsWebClient()', 0

                       'ProductNameSubstitution()', "", "A unique document number could not be found.  Please check setup."

                       'SY_Error_Message WIN PRE on form SY_Error_Message'

           'SuppressException', 0, 0, 2, 0, 240, 1, -9, 2, 2504, 7, ""

               'IsServiceMode()', 0

           'PM_Unmark_Checks of form PM_Print_Computer_Checks', "4901", "XPM_Cchecks", "0000000000001636234322", 0

           'Warning_Dialog', 7, "", "", "", 0, ""

               'IsServiceMode()', 0

               'ProductNameSubstitution()', "", "An error occurred. Contact your system administrator to verify data."

           'PM_Print_Computer_Checks l_Dummy Print ResetCheckNum_CHG on form PM_Print_Computer_Checks'

               'ResetNextEFTNumber of form PM_Print_Computer_Checks', "Bankdedacted", "0000000000000001012343295", 1

                   'PM_Number_Inc_Dec', "0000000000000001redacted", 1

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Payables Document A unique document number could not be found. Please check setup.

    I wonder if you were to scan the PM00400 and sorted on DOCNUMBR if it might show some old EFT number that is out of sequence. I believe both the cheque number and the EFT number go into that column. Plus I wonder if the EFT number needed something otherwise it would not have know where to start. I know whenever I first setup EFT for clients it defaults to EFT000000001.

  • Suggested answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Payables Document A unique document number could not be found. Please check setup.

    Hey Tim,

    What you are going to need to do is look at PM00400 for the Checkbook being used and see what number your highest number is and adjust the setup to be one number higher. You can try the statement below to do this.

    Select * from PM00400 where doctype = '6' and chekbkid = 'enter checkbook' order by docnumbr desc

    Review you the Document Numbers for the Numbering convention. (Don't be surprised if you see multiple conventions as people can enter any number they want if you allow it).

    Determine the numbering convention you want to use and look at those. Then in the Setup (Sounds like you are using EFT Number so the EFT Checkbook Maintenance) you can adjust the numbering there to be what you want to use and +1 the highest number used.

    I also recommend you max out with leading 0;s so you don't end up hitting a max number due to no leading zeros and have this error crop up again. Example would be EFT000000001234.

    If you need assistance to determine what your highest number is and what we can set it to, please open a support case so we can take a look at your data together.

    I hope this helps!

    Thank you!

    Brandon | Microsoft Support Engineer.

  • Tim Wappat Profile Picture
    Tim Wappat 5,703 on at
    RE: Payables Document A unique document number could not be found. Please check setup.

    Brandon,

    Thanks for your input. Its almost correct.

    The explanation is here:

    timwappat.info/.../Dynamics-GP-Payables-A-unique-document-number-could-not-be-found-Please-check-setup

    TL;DR

    You need a a value for Next EFT Payment Number, even if its not in use as the Dex script is calling the GenerateNextEFTNumber even if you have "use cheque numbers" selected.

    Tim.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,177

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 860 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 593 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans