Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Journal Entry Number j...
Microsoft Dynamics GP (Archived)

Journal Entry Number jumps back from 134,000 to 11,000 and AP batch stuck posting in Purchasing

(0) ShareShare
ReportReport
Posted on by hersheys 850

I have 2 questions:

1) This has happened in a few occasions where our journal entry number jumps back all the way from 2 years ago. For example yesterday we were at 134,000 and now we're at 12,000 journal entry number. This happened the first time 2 years ago and maybe 5 times since then. The journal entry numbers were supposedly to have been voided. Unfortunately, we processed a batch that had multiple journal entry numbers and that batch picked up the said voided entries. We didn't realize it at that time and posted the whole entire batch which had the supposedly old voided journal entry transactions. Since then every time the system resets the sequence we would have our IT resets it back to where it needs to be. However, he's concerned this is not the best thing to do. Any reason why it would do that or do you have any fix for this?

2) Our AP person has been experiencing her AP batches being stuck in the Purchasing posting cycle. Typically what our IT does is reset the batch to "available" and re-attempt to repost the batch. Any reason why this happens.

Thank you so much for your help.

Mary Anne

*This post is locked for comments

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Journal Entry Number jumps back from 134,000 to 11,000 and AP batch stuck posting in Purchasing

    Mahmoud's response to the AP Batch issue is spot on.  Here is a short list of things IT can check to address this issue - I have seen all of these issues at various points in my career: 1. Dirty Power - not every outlet delivers a consistent source of electricity to machines plugged into it.   www.emersonnetworkpower.com/.../WhatCausesDirtyPower.aspx

    2. NIC failures / bad drivers.

    3. Network cable problems.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Journal Entry Number jumps back from 134,000 to 11,000 and AP batch stuck posting in Purchasing

    As for the journal entry number being changed randomly, I would say that this is a common issue that I have witnessed not only with General Ledger, but with module document numbers as well such as purchasing, manufacturing ..etc. The explanation is not quite short, so I would include Mariano Gomez article for a thorough and comprehensive explanation. This is a pure technical explanation which can be well understood and fixed by you IT   Why does my next document number change randomly? 


    As for the second issue, it is quite common as well and the reasons can be too many. Throughout the posting process, Dynamics GP controls the records being posted (which are technically being transferred from saved to work tables) by several status to manage the posting process such as (marked for posting status, printing, posting ...etc). If any abnormal thing occurs such as network glitch, electricity cut ...etc, which can be generally categorized as (Posting Interrupting), Dynamics GP leaves the batch being posted in a safe place in order to prevent data corruption. The common resolution to this issue is either to go to "Batch Recovery" if the damage was well handled by the system or to go and do the updates being applied by your IT currently in case the interruption was not well handled by the system. Therefore, check your infrastructure as the most possible reason for this issue.

    Your feedback is highly appreciated,

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans