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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Acthist <> gltran
Microsoft Dynamics SL (Archived)

Acthist <> gltran

(0) ShareShare
ReportReport
Posted on by Albert Zuniga 285

I am experiencing an intermittent problem where the Accthist table does not equal the Gltran table. This happens periodically. The last time was 6 months ago. 

I have been able to isolate the problem down to one batch from the most recent occurance. It appears to be a problem during the posting process of the batch. In both Batch and GLtran tables there is a field that determines wether or not a batch has been posted. (Batch.status = 'P', Gltran.Posted = 'P')  In this case the batch gets posted and the Gltran.Posted is set to "P" but batch.status wasnt. Batch.status remained 'U'.(unposted) Now the batch is shown as unposted and avialable to be posted even though it has already been posted and the accthist table have been updated. It ends up getting posted again and the accounthist table gets hit twice. On the second time it gets posted the batch.Posted field gets set to "P".

The Version is 6.50.3050 which is 6.5 sp2

Nothing on customer source on any bug fixes. Any ideas on how this happens or how to prevent?

*This post is locked for comments

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hello Albert,

    The updating of the batch status to P is one of the last steps in the posting process.  So there could have been an interruption in the process and the system never got to the step where it updates the batch status to P.  

    I ran a test on a U status batch where I had updated the Posted field in GLtran to P.  I then ran the posting process and the batch did update the account balance anyways.  I would think that if the Posted field in GLtran is a P, the posting process should return an error.  I will submit a bug to development on this issue and will update you with the bug number.  I can't say when a correction in the program might occur as bugs are addressed in order of priority and this situation isn't one that we see very often.  I agree that it challenges the integrity of your database and will assign the bug the highest severity that I can.

    Thank you for bringing this to our attention.

  • Suggested answer
    Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hello Albert,

    I have submitted bug number 22995 to bring this issue to the attention of our develoment staff.  Please let me know if you have additional questions on this topic.

  • Albert Zuniga Profile Picture
    Albert Zuniga 285 on at

    Carolyn,

    Thanks for your response. Is there any way a can follow up with the development staff in case they find a solution? Is that something that will be communicated via customer source?

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Albert,

    I have no idea when this bug would get corrected.  If you want to check back in several months through the forums on the status of the bug that is an option.  You can also open a support case to inquire about the bug and it will be a no-charge case.  It will speed up a reply if you keep the bug number handy.

  • Darren Magel Profile Picture
    Darren Magel 60 on at

    Hi Albert,

    I'm experiencing the issue. Same version Did you ever receive a resolution to this?

    Darren

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Darren,

    I submitted a bug for this issue however it won't be corrected for some time.  SL 2011 was just released and it was not addressed in that version.  I know Albert was using version 6.5 SP2.  I don't know if this same problem happens in version 7.0 or in SL 2011.  I could only make it happen by changing the status of a posted batch back to U.  I haven't seen that during posting, the batch posts but doesn't get set to P.  There could be a network interruption before the system can set the batch status to P.

  • Darren Magel Profile Picture
    Darren Magel 60 on at

    Hi Carolyn,

    Thanks for the response. You mention that "There could be a network interruption before the system can set the batch status to P."

    This client has a "unique" network set-up and it has been my suspicion that the network is the root of the problem as I haven't had this issue with any of my other clients. After re-reading the previous posts this may be a different situation as both the batch record and the gltran record have a status of "P" but the accthist records aren't being updated at all. Sorry for the confusion. Can you shed any light on what may be causing this?

    Darren

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Darren,

    Sorry for the delay in my response.  I'm not sure what would cause the system to not update the Accthist records.  Since the last operation performed is to update the status of the batch to P, I would think that if the system is getting that far in the process, the Accthist records would be updated.  Does this happen with every batch or is it just a few batches here and there.  Is there any pattern as to when it happens?

  • Darren Magel Profile Picture
    Darren Magel 60 on at

    Hi Carolyn,

    My turn to apologize for the delay.

    I do have some additional details.

    All the batches are PO receipt batches that are not automatically releasing into inventory (this is something new as in the past they always released automatically. They changed something awhile back, possibly a setting, but don't remember what.

    It appears to be a problem for all users.

    Thanks again.

    Darren

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Darren,

    It depends on what the Purchase For or Receipt For value is.  If they are choosing Non-Inventory Goods, no inventory batch will be created.  There is no overall setting that controls the creation of an inventory batch from purchasing.  Let me know what you find.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans