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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Posting with multiple ...
Small and medium business | Business Central, N...
Suggested Answer

Posting with multiple countries

(0) ShareShare
ReportReport
Posted on by Posting with multip... 5

Hi, 

In our company, we are using 'Country' as one of our dimensions, which dimension has 8 sub-categories of countries. 

We have a situation where several most of the transactions need to be allocated to different countries. For example, if we receive an invoice of EUR1,000 that is attributed to all the countries - We divide the invoice by 8 countries and post it manually. However, it is getting confusing to understand the transaction's double entry and worst of all, time-consuming since we have to do it for all the invoices that we receive. 

Any suggestions on how we can automize this please? 

Thanks,

Sharon

I have the same question (0)
  • Andy Sather Profile Picture
    Andy Sather on at

    If you don't get further responses to this issue, you may want to raise a support request to Microsoft support via your CSP / Partner.

  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    Couple of ideas for you to assess.

    1. Use the recurring purchasing lines feature and layout a g/l line per country and the relevant dimension. You can set it so the user is asked if the recurring lines should be added or not. You can also have many of these per vendor.

    2. Assuming it’s not an inventory invoice. Setup 8 items of type service. One for each country. Assign the dimensions as needed. Have the general posting setup use the desired expense account. Create a 9th item and use the assembly BOM feature on this item. Add that to the invoice and then use the explode the BOM feature. The added part I’ve done for this recently is to add a % to each BOM line so when you explode the original invoice item it passes a % of the unit cost to the BOM lines.

    3. Have a look at Binary Streams Multi Entity management solution. Does allocations per one global dimension

    4. Similar to 1. Use general journals to post invoices. There are templates you can setup and that might speed up breaking up the lines

    5. Can the split happen after the fact? So use a recurring general journal to reallocate the dimension splits. You could move the balance to another account to get the split and then move it back if needs be

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello,

    I concur with Josh's reply and you might consider using Binary Stream MEM to make this very easy to transact and post between multiple entities. All this pain will go away.

    Thanks,

    Steve

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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans