Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Balance Brought Forward (BBF) entries have multiple lines for the same account

Posted on by 2,469

An oddity in our BBF (balance brought forward) journal entries was brought to my attention today.

In each BBF entry since we've been on GP, there are a few accounts that have multiple lines in the journal entry. For example, the BBF entry might look like this:

 Account 1   $x.xx

Account 2 $x.xx

Account 2 $x.xx

Account 3 $x.xx

Account 4 $x.xx

The sum of the multiple entries for each account add up to the correct ending balance for that account. The questions are, why are the account balances being broken up into two separate lines on the journal entry, and what do those values represent?

*This post is locked for comments

  • Sagi88 Profile Picture
    Sagi88 2,250 on at
    Re: Re: Re: Re: Re: Balance Brought Forward (BBF) entries have multiple lines for the same account

    Hi.

    Another scenario where this usually happens in when you are using multicurrency.

    The opening balances are brought forward from their original currency, (1 BBF per currency), so that revaluations can continue.

     

  • bcool Profile Picture
    bcool 2,469 on at
    Re: Re: Re: Re: Balance Brought Forward (BBF) entries have multiple lines for the same account

    No issue...it just seems weird. And one of the accounts is an inventory account. I understand how additional entries are made if you post to a closed year, but wouldn't they have different JE numbers? The ones I'm looking at have the same JE number.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Re: Re: Balance Brought Forward (BBF) entries have multiple lines for the same account

    I just looked through our data and, yes, I see several accounts that are appearing more than once in the same BBF entry.  Interestingly this happened more often on older version of GP (prior to the year 2002). 

    Most often I see the Retained Earnings account being doubled up.  This makes sense, as it will happen any time a P&L account is updated after the fact.  For example, if my post-year closed adjustment had 5 P&L accounts, I see Retained Earnings 5 times in the BBF journal entry.  You can get more detail on this if you search in the Account Transactions SmartList for that JE # - you will see the original transaction as well as the BBF transaction resulting from it. 

    It can also happen if the same account is actually typed (or created by a transaction) on two different GL distribution lines.  For manually entered transactions this is sometimes done to enter a different reference for each amount or make it easier to separate amounts, even though they are going to the same account.  Transactions that are created from subledgers can also sometimes have this depending on how they are entered and your posting settings.

    Just curious why you are asking - is this causing some sort of issue?  Or are you just wondering?

  • bcool Profile Picture
    bcool 2,469 on at
    Re: Re: Balance Brought Forward (BBF) entries have multiple lines for the same account

    But would they have the same JE #?

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Balance Brought Forward (BBF) entries have multiple lines for the same account

    Bud, the reason for this typically is that entries are made to the closed year after it is closed.  When that happens, GP will not change the existing BBF, but will instead create an additional entry for the new amount that needs to be brought forward.  Thus the multiple BBF entries for the same account.  Hope that helps.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans