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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Resetting the payment ...
Microsoft Dynamics GP (Archived)

Resetting the payment number in Payments and Receivables

(0) ShareShare
ReportReport
Posted on by Khurram Raheel 85

Hi, I have to reset the payment number and cash receipt number of Payments and Receivable. I have found the SP that is in charge of generating the next numbers, But the SP is so complex and I am new in the ground, Can any one just give me the idea how to solve it. Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,784 on at

    There is absolutely no need to be looking at stored procedures (please don't change the stored proc!) as transaction numbers are all maintainable via the GP client.

    To reset the Payables payment number go to Tools >> Setup >> Purchasing >> Payables Setup >> options and change the Next Payment Number field.

    To change the Receivables cash receipts number go to Tools >> Setup >> Sales >> Receivables Setup >> Options and change the Cash Receipts Next Number.

    You won't be able to reuse a number already used (the window might allow the setting change to be amde but this would be a bad idea) but you could tweak the prefix slightly to allow the numeric element to be set to 1.

  • Khurram Raheel Profile Picture
    Khurram Raheel 85 on at

    Thanks for replying Ian!. The technique you suggested worked well for receivables, But payments issue is still there. I changed the "Next Payment Number" but it did not work. Actually my system has a  form "Manual Payments" that was created for client's requirement. When I load this form, The value that I changed in the "Payables Management Setup" gets lost and replaced with a new number. I can't get how this newly created form is generating the "Next Payment Number"

  • Ian Grieve Profile Picture
    Ian Grieve 22,784 on at

    A custom form could be doing anything.

    You should be able to identify what is being performed on SQL using SQL Profiler which would allow you to see which SQL statements or stored procedures were being called.

  • Khurram Raheel Profile Picture
    Khurram Raheel 85 on at

    Thanks for replying again. I have profiled the entire process. My custom form calls the following Stored Procedures:

    1) Dynamics.dbo.smGetNextNoteIndex

    2). ABC.dbo.pmControlNumberValidate

    They both are pre-defined. So if I must not change these procedures (according to you) What should be my strategy regarding the solution.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans