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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / RM40401 Sequence numbe...
Microsoft Dynamics GP (Archived)

RM40401 Sequence number getting overwritten

(0) ShareShare
ReportReport
Posted on by DominicBeland 332

HI,

One of our client is having an issue where the RM sequence number gets overwritten with a new number.  This happenend 3 times since the beginning of 2018.  We suspect there is a  a sequence of events that causes the sequence number to be overwritten.

There is a third party that generates it's own sequence number and when it goes into the RM, it usually just does as if a user typed a totally new number in the Document Number field.

Usually this doesn't affect the RM40401 numbering sequence.  But it looks like there is something that forces the new numbering.  Has anyone encountered such a problem in GP ?

*This post is locked for comments

I have the same question (0)
  • Frank_Heslin Profile Picture
    Frank_Heslin 895 on at

    In a test environment I would try disabling the 3rd party product & see if that resolves the issue.  If it does resolve it, then I would contact the 3rd party vendor to get them involved.

    If that doesn't resolve the issue, then I would run a trace while processing a transaction to get a log file to review.

  • DominicBeland Profile Picture
    DominicBeland 332 on at

    My problem is that I'm unable to recreate the issue.

    My client is generating thousands of invoices per month with the third party.  why is there 1 invoice out of them that forces the new numbering? 

    Looking at the SQL logs from a trial software that the client won't buy we saw that the Sequence number in the RM40401 went from 14012 to 14013 back  to 14012, then to 14013 back to 14012 and then BOOM 2106509 (new numbering)

    It looks to me a sequence of manual events.

    I tried to put a Trigger on the RM40401 but this causes GP RM transaction window to cause an error as soon as it looks for the next number.

    Is there a way to create a trigger without causing the error in the GP window?

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

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July 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