Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Bill Heiberger]

During sales order entry, we’re receiving a posting error message ‘Number sequence GL003 has been exceeded’.  We have multiple companies within D365 and this error is specific to only one particular company.

Any thoughts on the error or how to resolve?  

#FinanceandOperations
#Functional??

——————————
Bill Heiberger
Augeo Affinity Marketing
St. Paul MN
——————————

[Ian Gorman]

Filmed for 2012, but applicable to F&O and will resolve your issue:

https://organicax.com/2017/04/28/number-sequence-has-been-exceeded/

——————————
Ian Gorman, PMP, MCSE
Senior Consultant
——————————
——————————————-

[Jeff Austin]

Bill,

I don’t know if this would work in D365, but we have a job that runs nightly that compares the current value of a number sequence against it’s max and sends out an alert if it exceeds a specific threshold.

We run the following SQL to determine if there are ANY sequences to report and if so, launch another job that pulls all of them and alerts via email.  

@Threshold INT = 90 — threshold for number sequence consumption
IF (
SELECT TOP 1 NumberSequence
FROM [AX2012R3_PROD].[dbo].[NUMBERSEQUENCETABLE]
WHERE ROUND(((CONVERT(REAL,([NEXTREC]-[LOWEST]))/(CONVERT(REAL,[HIGHEST]-[LOWEST])))*100),1) > @Threshold
) IS NOT NULL
    BEGIN
          Do Some Stuff
     END

This doesn’t help your current situation, but may be of use in the future if you can get it to work with D365.

Jeff

——————————
Jeff Austin
Application Specialist 5
Bush Brothers & Company
Knoxville TN
——————————
——————————————-