One approval, and your entire ERP becomes a data source in line with everything else in OpenDIMS. The Business Central app retrieves and sends items, orders, customers, vendors, discounts, and entries — and with the free OpenDIMS extension, also the numbers that Business Central calculates itself. Among them, the stock figure that a webshop can actually vouch for to its customers.

Most integrations between a financial system and the rest of the business end up as a narrow pipeline: item number, name, price — and then nothing more. The Business Central app is built in the opposite direction. It opens Business Central as a regular data source in OpenDIMS, where you decide which fields to include, which way they should go, and what should happen to them along the way.

You authenticate OpenDIMS once with your Microsoft Entra ID login. Then all of the app’s connections share the same access, and you choose for each one which environment and company in Business Central to read from or write to. Both production and sandbox environments work, so you can finish building and testing a flow before it touches operations.

Twelve connections in one app

The app installs a whole set of ready-made connections. You only activate the ones you need:

• Products — the product catalogue, both ways.
• Order-export — as sales orders or sales invoices, your choice.
• Order import — Get orders out of Business Central again, with tracking numbers.
• Customers — Lookup and creation.
• Accounts payable — Vendor master data.
• Delivery notes — what has actually been sent.
• Purchase documents — purchased into OpenDIMS.
• Entries — Ledger, customer, vendor, and item ledger entries.
• Customer discount groups and Item discount groups.
• Sales Price Agreement Lines — the modern price lists.
• Any Business Central table —the emergency exit when what you need doesn’t have its own connection.

The catalogue of goods — both ways

Some companies take care of the product catalogue in Business Central and want it to be further out in webshops and marketplaces. Others fit it in OpenDIMS and want the financial system to keep up. The app can do both, and it can do it simultaneously in different fields.

The number, name, sales price, cost, GTIN, unit, item group, posting groups, and tax groups are kept synchronized. Along the way, you can enrich the goods with what the financial system will never contain: marketing texts, images, translations, categories and everything else a webshop lives on.

The stock figure that a webshop can vouch for

This is the difficult one. An item can be on the shelf and yet be promised away — for a sales order, for an assembly, for a project, for a return on the way back to the supplier. If you sell it again, you have sold it twice.

Business Central calculates that number itself. It’s called gross requirement and covers everything the item is already committed to, across sales orders, service orders, projects, manufacturing, assembly components, and purchase returns. That number has just never come out of Business Central before — it doesn’t exist in the standard API, because it’s calculated the moment someone looks at the item card.

With the OpenDIMS extension, it comes out. Then an honest stock figure for a webshop becomes a simple calculation in your field mapping: beholdning − bruttobehov.

What matters is whose formula it is. It’s Business Central’s own — not one we’ve guessed and have to maintain when Microsoft changes something. If you change the outline in Business Central, the number in the webshop will change as well.

If you prefer to do the math yourself, the individual numbers are there as well: quantity in sales order, in purchase order, in assembly order, in project order, in transit, reserved in stock. And the commodity’s statistics on top — sold quantity, purchased quantity, turnover, commodity consumption, adjustments.

Orders in and out

Orders from an online store, marketplace, or other system can be submitted to Business Central as sales orders or sales invoices. The customer is looked up on the field you choose — email, customer number, phone, name, or CVR/VAT number — and is created automatically if no match is found. You set the standards for currency, customer type and VAT liability.

On the other hand, the order import retrieves orders and invoices from Business Central again, with tracking numbers, so that the webshop can tell the customer where the package is. It requires the free extension.

The entire discount matrix

Discounts are rarely one number. They are a web of agreements: this customer group gets so much on this product group, in this period, in this currency, from this quantity. The app retrieves the entire setup—customer discount groups, item discount groups, and sales price agreement lines—from the modern price lists (BC16 onwards).

Each line comes with its own source, validity period, currency, minimum quantity, and discount percentage, and with the two flags that determine whether one discount can be added on top of another. Lists set up per customer group and mixed lists are handled in the same way, and as a rule, only lines are retrieved from activated price lists. Combined with the webshop app, it provides full discount synchronization all the way out to the customer.

When the field is not there

Sooner or later, every integration comes across a field no one had thought of. A supplier item number, a cost variant, or a field a completely different extension has added to the item card for this particular customer.

Therefore, the app has an emergency exit. Any Business Central table reads any table in Business Central, and with the OpenDIMS extension, the product connector can also see the fields that this installation actually has on its item card — including those that other extensions have added. You don’t have to wait for us to build a connection to your field.

Business Central is just one piece

The app does not stand alone. Business Central can be the source in one flow and the recipient in another, side by side with the other OpenDIMS apps — DanDomain, Shopify, e-conomic, Dinero, Uniconta, REST APIs, and file connections.

This is what makes the difference between an integration and a system: the product can come from Business Central, be enriched in OpenDIMS, sent to three webshops, each with its own language and price list, and the orders can find their way back to Business Central again — without any of it being custom-built.

You decide

• Which environment and company is being read from and written to.
• Which fields are included at all — and which way.
• Whether the order export makes sales orders or sales invoices.
• What happens to each value along the way, with OpenDIMS scripting directly in the field map. Deduct VAT, add shipping, translate a code to the text that the recipient system expects.
• When it’s running—manually, on a schedule, or when something changes.

Get started

Install the app, press the button that gives OpenDIMS access to Business Central, and select Environment and Company. Then the connection is up.

If you need gross requirements, assembly bills of materials, the discount matrix, tracking numbers, or the additional item fields, you can download the OpenDIMS extension for Business Central in the same place. It’s free, it reads only, and it’s installed in Business Central by your own administrator.