Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Transaction Entry
Finance | Project Operations, Human Resources, ...
Suggested answer

Transaction Entry

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

During the course of the month we have financial batches the fail. At the end of the month I spend nearly an entire day either updating the TRANSACTION DATE, or the ACCOUNT NUMBER or both to get the batch to run. I cannot figure out how to get these to clear without hanging up. 

I understand this may not be fully clear. I am not sure exactly how to explain this. I need to update the TRANSACTION DATE in the example below to 1/1/2022 to get it to clear. It wouldn't be so bad if there were a couple, but I have to work through hundreds of transactions consuming an entire day. Anyone have any ideas how to get these to clear?

pastedimage1643649262501v1.png

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,134 on at
    RE: Transaction Entry

    I agree with Richard.  Definitely print the edit list to see if it gives you any clues.

    [A date difference between 12/31/2021 and 01/01/2020 could simply be a User Date/Posting Date process that needs to be corrected to account for timing differences between an entry being created and the date it is for.]

    The Reference in your screenshot looks like it could be coming from an add-in product or someone is using a reference system that could point back to the source of the problematic transactions.  [Do you see patterns in the references/types of transactions that are requiring correction that could also provide a clue.  If these entries are coming from a subsidiary ledger, changing them before posting could be creating out of balances that will be a reconciliation nightmare.]

    [I have a few clients who use Integration Manager for JE imports and end up with orphaned lines in the GL Transaction Line table, but never invalid ones that are visible in the Transaction Entry window.]

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Transaction Entry

    You appear to have a serious problem here. Does this happen on all your workstations? If you print the edit list does it reflect these errors? You cannot save a transaction without  dates and account numbers so there must be something more to this story. Do you have any customizations or third-party products?

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

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans