web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

using General Product posting groups for non balancing department entry

(0) ShareShare
ReportReport
Posted on by 5

what we are trying to do is when using a general product posting group to do an entry, we want the expense to go to the account listing, but always to a certain department that is listed on the account, while the opposite side of the entry would not have the same department.

for example:   when posting bank fees through AR, we want the expense to go to expense account - department 800 while the credit would go to the cash account, which does not have a department.

Dynamics wants to put both the debit and credit to department 800, but we do not want the cash account to have multiple departments.

how do we get dynamics to not balance the departments out?   We just use departments on the P&L and not on the balance sheet, so they really shouldn't be balanced.

i believe our department dimension is set up as a global dimension. 

I have the same question (0)
  • Suggested answer
    Bilal Haider Profile Picture
    414 on at

    Hi,

    Have you assigned the Dimension on Account Type level ? You can remove dimension value from the balance sheet account.

  • Suggested answer
    Bilal Haider Profile Picture
    414 on at

    Or if you have already removed the dimension value from Balance Sheet account then may be it is coming if you are balancing these entries in a single line in journal. Try to use different lines for p&L and Balance sheet account on journal

  • BDH1 Profile Picture
    5 on at

    we have removed the dimension value from the balance sheet - and since it is using the general product posting groups, it is coming over as a single line in the journal, so dynamics is balancing the dimensions (both balance sheet and income statement) - which we do not want.   so it will not post correctly.    We do not want to go in after every transactions to manually remove the balance sheet dimension.  

  • Suggested answer
    Bilal Haider Profile Picture
    414 on at

    Dimension value cannot come from the Product Posting Group and you can split this transaction into two lines even if you are using Product posting group in any of the line or in both lines.

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,573

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 773 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 760 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans