Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Financial batch Entry - Actual batch Total

Posted on by Microsoft Employee

Hi,

In the Financial batch Entry window for General Entry type of batches, the Actual Batch Total shows an addition of both Debit and Credit totals of each transaction entry.

Therefore in realistic terms it it always showing double the actual totals of the transactions assigned to that batch.

can someone explain the reasoning behind this please?

*This post is locked for comments

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Financial batch Entry - Actual batch Total

    It is not a simple answer however, the answer is 'that is how the developers insured that they have collected the right data' when they were building the batches.

    Knowing that the number on the summary screen is 'double' the debit value gives you a quick verification of the batch content.

    However, using that value does not validate any data entry or ensure that the data entered is correct for your purpose.  It is really not that important a value and over the 20 years we have been doing this, have never been asked to deal with or change the value.  We have for the past 20 years simply told our clients to 'ignor the value' as it really does not tell you or help with the content of the batch beyond knowing that the value shown is double the value of the debit or credit for the total batch.

    Not sure that this helps, but it is my two bits on the matter.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Financial batch Entry - Actual batch Total

    This is how the batch total is designed, to show the absolute values of both; debit and credit.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Financial batch Entry - Actual batch Total

    That is exactly my question.

    The batch total is 800, whilst journal total transactions in 400.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Financial batch Entry - Actual batch Total

    Batch total is simply the absolute value of the amounts entered, this is how it was initially designed.  So if there is a journal with $ 400 credit and $ 400 debit, the batch total is 800.

    Your feedback is highly appreciated,

  • Mehtab Hassan Profile Picture
    Mehtab Hassan 80 on at
    RE: Financial batch Entry - Actual batch Total

    Hi,

    in GL Batches it is showing the total Sum of your Debit and credit side,because when you going to Prepare financial statements you will need the amount of that GL level entry for any specific account not the difference or nil amount,thats why it is showing you total amount not the differnece.i hope this answer will help you to understand this.

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Financial batch Entry - Actual batch Total

    If it showed the net then for a correctly balanced journal it would show 0.

    It would be better if there were two fields (Debit and Credit), but this is not something that has been done. Might be worth checking on Connect and suggesting this.

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