Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Batch could not be created when generating sales journal report 40690

(0) ShareShare
ReportReport
Posted on by

Hi Everyone,

I just setup a new dynamics 2011 installation and we are having issues generating Sales Orders. After data entry the sales journal report prints blank. The following is the error message in event log:

Company ***, shipper S0000002: Batch could not be created. [15129/clsADGBatch]

The sales orders are processed, invoiced and closed but are not sent to AR/IN/GL

This occurs for both stock and non stock items.

Thanks for your assistance

*This post is locked for comments

  • Carolyn Kolpien Profile Picture
    on at
    RE: Batch could not be created when generating sales journal report 40690

    Hello:

    Go ahead and run the following scripts:

    select batnbr from batch where module = 'AR' order by batnbr desc

    select batnbr from batch where module = 'IN' order by batnbr desc

    Make note of the top number in each result.  

    Then go to IN Setup, Options tab and put in the number that you got from the IN script in the “Last Batch Number” field.

    Then go to AR Setup, Other Options tab and put in the number that you got from the AR script in the “Last Batch Number” field.

    Then run your sales journal and let me know if you still receive the same error.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,349 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,029 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans