Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Single Transaction Posting

Posted on by Microsoft Employee

Hi everyone,

in the posting setup we did turn on the option "Allow Transaction Posting" in some areas to let the user post directly a single transaction without having to put it in a batch and then post the batch. We have also the options "Post to General Ledger" and "Post Through General Ledger Files" checked.

The problem that I'm having is that the system automatically creates a financial batch (ie : RECVG00000123) and we need to manually go and post this batch after. I would like to avoid doing this extra step but I'm not able to find out how.

Is there a solution to my problem?

Thanks

*This post is locked for comments

  • Francis Larocque Profile Picture
    Francis Larocque 1,921 on at
    Re: Single Transaction Posting

    You guys are all talking about control, control, control.  Control is the answer to everything and especially to the system's whims.  That same old chorus may ring a bell if your conception of operations or internal control is vague.  What do you control exactly when all you get at ledger level is an old (and disgusting) report showing a GL entry?  How are going to know that a cash receipt was applied to the right documents just by seing a GL entry?  How are you going to assess that customers invoices in a batch correspond to the work done? And so on.  All you can lightly control is very obvious allocation mistakes.  For example, a balance sheet account has been used instead of an expense account.  It is not even possible to drill down any given transaction from any batch at ledger level.  

    Conclusion: you don't control anything anyway so the system should let transactions post through GL -if you want to.  In such archaic environment, budgets are still the best mean of control.  Of course any system has its idiosyncrasies and we get to like them sometimes, but in this case we clearly have to deal with another design mistake.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Single Transaction Posting

    @Francis: it would seem to me that you feel that GP is not the right solution for your organization from the numerous posts you have made on this message board. I am wondering as we speak if you understand the concept and relationships of batch posting vs transaction posting and post to General Ledger vs post through General Ledger. These concepts and the "whimpsical" rationale behind them is what keeps the proper controls in place in a system like GP. Be it as it may, every system in the market has its own little idiosyncrasies and this one happens to be GP's.

  • Verified answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Single Transaction Posting

    No, not possible. Transaction level posting will always generate a batch in GL for later posting - simply put, someone needs to review. This is by design.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Single Transaction Posting

    Proofing by the accounting department!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Single Transaction Posting

    Guys,

    I would consider this as an “application feature” instead of an incorrect application behavior; accounting basics requires having at least one level of review for all transactions, and posting individual transactions will avoid the sub-ledger level review, therefore the system keeps the journal un-posted in the GL for auditing purposes.

    Personally I recommend avoiding the transactional level posting in the first place and force the users to use batches to make sure that the accountants are following the required workflow for transactions review, this will reduce the overheads of fixing application transactions caused by human mistakes.

  • Francis Larocque Profile Picture
    Francis Larocque 1,921 on at
    Re: Single Transaction Posting

    Oh my god!!! Would this system somehow be whimsical?!? This is shocking!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Single Transaction Posting

    Thanks for your replies.

    For my personal knowledge, can someone explain me the "rationale" behind that strange behavior?  

  • Hossam Fathy Profile Picture
    Hossam Fathy 2,597 on at
    Re: Single Transaction Posting

    K Day is right, Post through option only working for posting batch not working with transaction level posting.

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Single Transaction Posting

    When you are doing transaction level posting, no matter what your settings are, it will not post through to the GL (not sure if this is the case in GP2010).  Batches are great, you can print an edit list before posting, so I would recommend using them.

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