Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Error creating inventory transactions

Posted on by 3,900

Hi everyone-

All of a sudden, users are receiving an error when doing inventory transactions. 

In RMA/Entry Update > click the Process button and select Inventory Scrap, this error appears:

pastedimage1672947581680v1.png

In Inventory > Transactions > Transaction Entry. Select Adjustment, this error appears:

MicrosoftTeams_2D00_image-_2800_1_2900_.png

If I select Variance instead, the next number appears just fine. Same for inventory transfers and assembly transactions.

What is causing these errors? Running GP 18.4.1384 on SQL Server 2016.

Thank you.

Joe

Categories:
  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Error creating inventory transactions

    Thank you Juan and Shannon for your help!

    It was the numbering sequence -- ran out of numbers! All of the numbers between 0001 and 9999 were finally used up. GP has been filling in gaps in the sequence, but the next number showing in Inventory Control setup was already used. I changed the next number to 10,000 and all is fine again.

    Joe

  • Suggested answer
    Shannon Aune Profile Picture
    Shannon Aune on at
    RE: Error creating inventory transactions

    Hi Joseph,

    Did something happen to cause the next document numbers to be blanked out? Have you verified the next document numbers are populated for RMA (Field Service > Setup > Field Service > Service Setup > Return button, Next RMA Number). Also, for Inventory check the next document number there as well (Inventory >> Setup >> Inventory Control). You will need to find the highest document number that was used in Inventory and RMA, you can run a smartlists to see what the highest document number used was.

  • Verified answer
    Juan Bonilla Hn Profile Picture
    Juan Bonilla Hn 55 on at
    RE: Error creating inventory transactions

    Hello,

    This has happened to me recently and I think your problem is that the numeric correlative of the transaction exceeded the maximum number that was defined. Go to the inventory control window and increase the numeric correlative to the type of transaction in which you have a problem.

    Greetings.

  • Juan Bonilla Hn Profile Picture
    Juan Bonilla Hn 55 on at
    RE: Error creating inventory transactions

    Hello,

    This has happened to me recently and I think your problem is that the numeric correlative of the transaction exceeded the maximum number that was defined. Go to the inventory control window and increase the numeric correlative to the type of transaction in which you have a problem.

    Greetings.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans