Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Transaction will cause G/L entries to be inconsistent on Job Journal

(1) ShareShare
ReportReport
Posted on by 2
I'm running into an issue with the Job Journal for the last month or two of not being able to post anything, where it did previously. When I try to Preview Posting, I get this warning at the top of the page: /The transaction will cause G/L entries to be inconsistent. Typical causes for this are mismatched amounts, including amounts in additional currencies, and posting dates./
 
The transaction entries listed are only 1 Job Ledger Entry and Res. Ledger Entry. I've tried different jobs and resources, tried keeping the transaction to the minimum set of fields, and tried posting an Item instead of a Resource, all to no avail.
 
It works in a default sandbox, so I don't think it's a code issue, more likely a configuration I messed up somewhere. I've checked the Job and Resource setups, all the posting and config I could identify as related. The only hint of a possibly related issue is that I did set up a Currency at one point recently but have since removed it as we only need the default currency. It could be related to that, but I have no idea where to look to track this down. Nothing is in the error logs, since it can't post.
 
Any help or direction would be greatly appreciated.
  • NelsonC Profile Picture
    NelsonC 282 on at
    Transaction will cause G/L entries to be inconsistent on Job Journal
    Just wondering if anyone has an answer to the above question.  I am getting the same error.  It seems to only be when posting Resources with no impact on the GL only impacting the Job
  • Transaction will cause G/L entries to be inconsistent on Job Journal
    I get the same Message when I try Preview Posting on an Assembly Order. There are no customizations in the database. Posting is possible afterwards.
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 993 Super User 2024 Season 1 on at
    Transaction will cause G/L entries to be inconsistent on Job Journal
    I doubt it has anything to do with the general posting setup because then you would most likely get an error of a missing G/L Account no. somewhere.
    Have you had a developer try to debug what is going on?
    That would be my next step here.
  • Suggested answer
    Transaction will cause G/L entries to be inconsistent on Job Journal
    Inge M. Bruvik, it's possible something was posted with a currency somewhere while I had that set, but I don't see any currency settings on any of the jobs or resources. In fact, the resources don't offer a choice, and the job doesn't allow you to change the currency on a job with existing postings.

    I just tried it all again with a new minimal job, with one job planning line, and a new minimal resource. Same error. My feeling is that it's related to the Gen. Prod. Posting Group setup, though I have tried to ensure it's aligned with the account pattern in the sandbox. I also just tested with a new Gen. Prod Posting Group, same error, so it's seeming less likely that this is the problem.
     
    Other ideas where to look?
     
    Thanks,
    Ken
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 993 Super User 2024 Season 1 on at
    Transaction will cause G/L entries to be inconsistent on Job Journal
    Is it a possibility that you have registered your LCY as a currency and used that on some of the entites involved in your postings?

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans