Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Forcing General Business Posting Groups on Journals

(1) ShareShare
ReportReport
Posted on by 25
I have inherited a system where the General Ledger Posting Group has been set up to represent different plants across the company.
 
In order to start tracking cost by plant I want to make sure that every journal created and posted requires a General Ledger Posting Group to be identified.  Further, I also want to limit which the accounts the plants can post into (some accounts are set up for only the larger plants).
 
My goal was to use the G/L Account Card Set-up to identify which plants can post to an account (Picture Below) thus forcing all entries to have a code and limiting the plants that can use the accounts.  Unfortunately it doesn't appear I can use Multiple Criteria in this section, I can only choose a single plant (Plant1) and not multiple (Plant1..Plant2 or Plant1&Plant2 or Plant1|Plant2).
 
How else can I achieve my two goals?
 
Thank you
 
  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,824 Super User 2024 Season 2 on at
    Forcing General Business Posting Groups on Journals
    Our vendors are mixed.  We have services that look after all 3 plants and other vendors that are involved in 1 or 2 plants
     
    If purchase invoices are posted against these vendors, the current setup is really prone to errors. For example, if the default Gen. Bus. Posting Group for Vendor 1 is Plant 1, and an invoice with this vendor is posted, by default the Gen. Bus. Posting Group will come from the vendor and be for plant 1. But what if the expenses are supposed to be for plant 2, and someone forgets to change the Gen. Bus. Posting Group, your GL entries would be incorrect. 
     
    Unless your vendor's don't have default Gen. Bus. Posting Groups?
     
    Based on the rest of your reply, I get the feeling that I am stuck, under the current set-up; we will always be susceptible to missing General Business Codes because the intent and the use of the posting group section don't match.  With dimensions it was easy, I made the "Department" dimension mandatory on all accounts.
     
    Yes that's correct. Here's what I can think of:
     
    • If your journals have approval workflows turned on - you could make the workflow criteria to require having a Gen. Bus. Posting Group, so it would become mandatory that way, and its not something I would recommend. But there's not much you can do with Purchase Documents. 
    • Another thing you can do is change your department dimensions to include the plant. Lets say IT Equipment is 1 dimension. You could change it so you have 3 instead: IT Equipment - Plant 1, IT Equipment - Plant 2, IT Equipment - Plant 3. But this will require modifying all the department dimensions, plus modifying your existing reports if you have any that are based on the department dimension. 
    • The onus is put on the purchasing group, or the payable admins to ensure all documents/journals created have all the required data. 
    • But really as mentioned best practice is creating a new dimension. If your company is not using all 8 dimensions I don't think it would be a big deal to add 1 more to signify what plant it is. Maybe its something that can be done down the line in a few months...
     
     
    Valentin Castravet
    Zander ERP Services
     
     
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    Forcing General Business Posting Groups on Journals
    Hi,
     
    the original requirements couldn't be met to limit posting per plants due to the way BC handles posting. a good way to identify which plant make what posting is to use dimensions per previously suggested. Still dimension is a big topic. I suggest to check out how to set up and use dimensions. there are plenty resource out there. 
     
    hope it shed some light for your situation
    Jun 
  • CU01081542-1 Profile Picture
    CU01081542-1 25 on at
    Forcing General Business Posting Groups on Journals
    Thanks for writing back Valentin,
     
    I agree the set-up is not ideal.
     
    To answer your questions first:
     
    The company currently uses posting groups for invoices and customers.  We also use Items for our inventory and sales.  These are all set up and seem to be working well.  For my purpose, I am looking into the vendors/payables side of things.  There are no set-ups for vendors and expenses, all coding for expenses are driven by the purchase order which is entered manually.  Between the purchasing group (creating the POs) and payable administrators (posting the invoices) it's on these people to make sure all entries have a Gen. Business Posting Group to identify the plant expense and a dimension which identifies department within the plant.  Multiple times one or the other is forgotten.  General journal entries are the same, again an area where either the General Business Posting Group or Department was forgotten in booking accruals or correcting mistakes.
     
    From the internal notes I have read, the Business Posting Group was chosen as the identifier for each plant because management looks at each plant as it's own "business"...thus the "Business posting Group" was chosen.  We have 2 plants going on 3 with future planning for more.
     
    Our vendors are mixed.  We have services that look after all 3 plants and other vendors that are involved in 1 or 2 plants.  Each plant making different goods makes them different and require specialized products and services (chemical resistant PPE, specialized extinguishers, etc); but there are some basics where they are all the same (IT equipment, Air conditioning/HVAC, safety materials, admin supplies, etc).
     
     
    Based on the rest of your reply, I get the feeling that I am stuck, under the current set-up; we will always be susceptible to missing General Business Codes because the intent and the use of the posting group section don't match.  With dimensions it was easy, I made the "Department" dimension mandatory on all accounts.
     
  • Suggested answer
    Yasas Profile Picture
    Yasas 56 on at
    Forcing General Business Posting Groups on Journals
    Hi,
     
    I think Dimension will fulfill your requirement. Please follow the below link to learn about Dimension in Business Central.
     
     
    BR,
    Yasas.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,824 Super User 2024 Season 2 on at
    Forcing General Business Posting Groups on Journals
    To answer that, can you please provide more details about the transactions you're booking:
    • You mentioned journals, are invoices used as well?
    • Do you use Items or G/L Accounts?
    • How many plants do you have? Do you have to create new plants or the number is fixed?
    • Do you have vendors that are tied to a specific plant? i.e. a specific vendor only provides services to 1 plant only. That's the only reason I can think a Gen. Business Posting Group would be tied to a plant and were setup to be used for reporting.
     
    It makes sense you're new and don't want to rock the boat, but from the information so far, the setup you inherited is a little strange. 
     
    Typically Gen. Business Posting Groups are assigned to a customer/vendor card, and Gen. Prod. Posting Groups are signed to item cards. The combination of the posting groups on the customer/vendor + item on a transaction will tell the system what G/L Accounts to post to. That's the main purpose of posting groups.
     
    If you're using G/L Accounts instead of items to book an expense, then the Gen. Bus. Posting Group setup on the G/L Account card is used in rare cases without going into too much detail, to tell the system where to post rounding amounts and things like that. If your G/L Account cards didn't contain posting groups, then most probably you have no transactions that had those entries in the past. But if you're adding the posting groups to the G/L Account card, and in the future you do have some transaction that will use the posting group on the GL Account Card, you could invariably post to a G/L Account you did not want to. So that's the reason you would populate a Gen. Business Posting Group on the G/L Account card, its not make it a requirement to use a Gen. Business Posting Group. Also, having a Gen. Business Posting Group on the G/L Account is simply setting up the default posting group for that G/L Account, its the same as manually adding to a journal on each transaction. I am mentioning this because adding a posting group that's not required/there by default can lead to the same issue I mentioned before, you could have some amount going to a G/L Account you did not want to.  
     
    However, posting groups can used for reporting as well. But there are some limitations, as opposed to using dimensions. For example, you can't make them a requirement, or allow using them with a specific G/L Account. It's also somewhat more difficult to create custom reports with them. A basic example of using them for reporting would be having domestic and foreign customer. You would have a domestic and foreign Gen. Business Posting Group assigned to your customers, and then in your Revenue account you could look at the entries that have the domestic or foreign as the Gen. Business Posting Group. But in this case the Gen. Business Posting Group was assigned to the master data used in the transaction, it wasn't added manually on a per transaction basis.
     
  • CU01081542-1 Profile Picture
    CU01081542-1 25 on at
    Forcing General Business Posting Groups on Journals
    Thank you Valentin.
     
    Are there any other options available?  Being new, I am hoping to keep within the current parameters where the business continues to rely on the current Gen. Business Posting Group for plant identification.  I don't know if creating a new dimension which mimics a current field will be acceptable to everyone (it's repetitive).
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,824 Super User 2024 Season 2 on at
    Forcing General Business Posting Groups on Journals
    Dimensions will do exactly what you're looking for as they can be used for reporting and restrictions like you're looking for. 
     
    Valentin Castravet
    Zander ERP Services

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