Order to Cash Process for Magento and Business Central Merchants
For a Magento store, the order to cash process starts the moment a shopper clicks buy. For the finance team, it ends only when the payment is matched to the right invoice in Business Central. Between those two points sit inventory checks, order syncs, shipments, invoices and bank data, and each one can drift out of step with the others. When the handoffs work, the process is invisible. When they fail, you see it as overselling, orders that never reach the warehouse, invoices that do not match shipments and payments that sit unmatched for weeks.
This article walks through the order to cash process for merchants who run Magento or Adobe Commerce on the storefront and Microsoft Dynamics 365 Business Central as the ERP. We cover each stage in the order it happens, which system should own each step, where syncs usually break and what we check first when a merchant asks why cash is late. If you want the architecture before the workflow, our Business Central Magento integration page explains how the two systems share responsibility. Our Business Central eCommerce integrations overview shows how the same ERP connects to other storefronts. And because stock is the first handoff in the process, our notes on Magento inventory management are worth reading alongside this one.
The short answer
The order to cash process runs from order capture through fulfillment, invoicing, payment and reconciliation. In a Magento and Business Central setup, Magento captures the order and the shopper’s payment intent, Business Central records the sales order, the shipment, the invoice and the cash, and the connector moves the information between them in the right direction. The process stays reliable when each stage has one owner, when status definitions are shared and when partial shipments and partial payments are handled on purpose rather than by accident.
Decisions to make before go-live
Before the first live order flows, four decisions need an owner and a date. Skipping any of them is the most common reason a new connection produces a backlog of exceptions in its first month.
The first decision is who owns each stock number. Business Central should own the physical count, and Magento should display the available quantity. Write that rule down and enforce it, because a team that edits quantities in both systems will eventually see the two disagree.
The second is the status vocabulary. Agree on what processing, shipped, invoiced, complete and closed mean, and on which system is the source of truth for each one. A shared definition takes an hour in a meeting and saves days of customer emails.
The third is the partial shipment policy. Decide whether the business ships in parts, who approves a split shipment and how the invoice follows each part. The answer determines which document type you use on every order.
The fourth is returns. Decide who approves a return, where returned stock goes and when the credit memo is issued. Returns are easy to forget at the start and expensive to untangle later.
Stage one: capturing the order in Magento
The process begins on the storefront, where the shopper selects items, applies discounts, chooses a shipping method and pays. Magento captures the order with its customer, addresses, tax, payment method and line items. At this point, the order is a promise, and the rest of the process exists to keep that promise.
Two decisions made on the storefront shape everything downstream. The first is the customer model. A guest checkout, a registered retail account and a B2B company account each need to land in Business Central as the correct customer record, with the right price group and payment terms. If you leave this to chance, you will spend weeks reconciling duplicate customers. We recommend mapping customer types deliberately before go-live.
The second decision is the order number. The Magento order number should be carried into Business Central as an external reference, so anyone searching either system can find the same transaction. Without it, the finance team and the support team describe the same order in two different languages.
Stage two: sending the sales order to Business Central
Once the order is captured, the connector creates a sales order in Business Central. This is the point where the ERP takes ownership of the financial record. Items, quantities, prices, discounts, tax, shipping method and payment method are mapped from Magento into the corresponding Business Central fields.
Our connector downloads web orders from Magento into Business Central, and it is configured through a settings page that lets you map locations, shipping methods, payment methods, customers, items and discounts without hardcoding them. That matters because the mapping is where most order sync problems begin. A shipping method that exists in Magento but not in Business Central will either stop the order or land it with the wrong charge. Map every method before you turn on live orders, and test each one with a real order. If you are still planning the connection, our steps to connect Magento with Microsoft Dynamics 365 Business Central set out the order of work before any orders flow between the systems.
Check the order at this stage, not later. A sales order that arrives with the wrong customer or the wrong tax is much easier to fix in the first hour than in the last week of the month.
Stage three: checking stock before the promise is kept
Stock is where the order to cash process most often goes wrong, because the storefront and the ERP can disagree about what is available. A shopper may buy a unit that the warehouse has already committed to a phone order, and the order then enters a fulfillment queue that cannot be completed.
The fix is to decide which system owns the physical count, and to send Magento the available quantity rather than the raw on-hand number. Our connector exports real-time inventory levels from Business Central to one or several Magento storefront locations. When open demand is subtracted before the number reaches the storefront, far fewer orders become exceptions that someone has to handle by hand.
Reservations on the Magento side matter here too. When a shopper completes checkout, Magento holds the units against the salable quantity, and the hold clears when the order ships or is canceled. Adobe’s documentation on source algorithms and reservations explains this lifecycle, and it includes a warning worth repeating: on Adobe Commerce Cloud and on-premises projects, the reservation queue consumer has to keep running, or holds never clear and quantities look smaller than they are.
Stage four: shipping and fulfilling the order
Fulfillment happens in Business Central. The warehouse picks, packs and ships the order, and the shipment posts against the sales order. This is where partial shipments enter the picture. A customer who orders twelve units may receive eight today and four next week, and the process has to handle both shipments cleanly.
Microsoft’s guidance on selling products with a customer sales order explains why partial shipments need a sales order rather than a sales invoice. Posting a sales order creates a shipment and an invoice, which can happen together or separately. You can ship a partial quantity by setting the quantity to ship on each line, and the invoice quantity follows from that setting.
Once the shipment posts, the connector sends the shipment and tracking number back to Magento. The customer sees the status change in their account, and the support inbox sees fewer questions about where the order is. Test one partial shipment before go-live. It is the flow where small mapping mistakes become visible to customers first.
Stage five: invoicing what was shipped
The billing step should follow shipments, not orders. Our connector uploads both full and partial order invoices to Magento, which keeps the customer’s account accurate and avoids the most common billing dispute, an invoice for a quantity that never arrived.
Microsoft’s guidance on invoice sales in Business Central makes a point that applies directly here. You must use a sales order rather than a sales invoice when you need to ship only part of an order, when you ship after the invoice is posted, or when a vendor delivers directly to the customer. Choosing the right document type at the start keeps the invoice aligned with what was actually delivered.
Invoice totals deserve a check on the first few orders from each payment method and tax zone. Rounding differences, tax-inclusive prices and discount calculations are easy to verify on a single order and harder to spot in a monthly report. Our connector syncs standard rates, special discounts and complex B2B customer price levels from Business Central, so the totals a shopper sees should match the totals the invoice carries.
Stage six: collecting and matching payments
Payment collection is the stage that closes the order to cash process, and it is where many merchants discover that their systems never quite agreed. Some payments are captured at checkout through a payment method that Business Central records immediately. Others arrive later, through bank transfers or checks, and have to be matched to open invoices.
For immediate payments, the sales invoice closes as fully applied when it posts, as the invoicing rules in Business Central describe. For payments that arrive later, Business Central offers several ways to apply cash, including the cash receipt journal and the payment reconciliation journal. The managing receivables overview describes those options, and the choice depends on how your bank data arrives.
Our advice is to import bank data frequently rather than monthly. Matching is far easier when the payment is still fresh in everyone’s mind. Review the exceptions every day, including short payments, unmatched receipts and payments that arrive without a reference, so they do not pile up at month-end.
Stage seven: keeping order status honest across both systems
Status is the thread that ties the whole order to cash process together. A shopper wants to know whether the order was received, shipped and invoiced. The warehouse wants to know what is still open. Finance wants to know what is paid. If those answers come from different sources, the customer will see one status and the finance team will report another.
Adobe Commerce separates order states, which control how an order moves through the workflow, from order statuses, which communicate progress to people. Its order status definitions state that an order is complete only when it has been created, paid and shipped, and that a closed order has had a credit memo issued and the refund given. Those definitions should match what your team means by complete and closed, or customers will receive messages that do not reflect what happened.
Agree on the status definitions with operations and finance before go-live. Then check that each status change in Business Central produces the right status in Magento, and that a refund or credit memo moves the order to closed rather than leaving it looking open.
Where the process breaks and what we check first
When a merchant asks why cash is late, we work through the process in order, because the cause is almost always upstream of the symptom. In my experience, the cause is rarely the step the merchant points to first. Here is the sequence we use.
Start with the customer. Confirm the Magento order has a matching customer in Business Central, with the right price group and payment terms. A mismatched customer often explains an invoice that looks wrong.
Next, check the order. Confirm the sales order exists in Business Central with the same items, quantities, prices and tax as the Magento order. A missing or altered order explains why a shipment never happened.
Then check the shipment. Confirm the shipment posted, the quantity matches what was picked, and the tracking number reached Magento. A shipment that posted without syncing back to the storefront explains many “where is my order” tickets.
Then check the invoice. Confirm the invoice follows the shipment and carries the correct amount. An invoice for an unshipped quantity explains most billing disputes.
Finally, check the payment. Confirm the payment is recorded, matched to the right invoice and reconciled to the bank. An unmatched payment explains a customer who appears to owe money they have already paid.
Working in this order prevents a common mistake, which is adjusting balances by hand to make a report look right. Fix the cause in the step where it happened, then confirm the downstream records update correctly.
One more check helps when the cause is not obvious. Compare the totals on the Magento order, the Business Central sales order and the invoice, line by line. Differences in tax rounding, discounts or shipping charges look small on a single order and grow large when they repeat across hundreds of orders. A short reconciliation each week catches them while they are still easy to explain.
Returns, refunds and credit memos
Returns belong inside this process, not outside it. A returned item affects revenue, stock and the customer’s balance, and it affects them in the opposite direction from the original sale. Teams that treat returns as exceptions often find that balances drift for months before anyone notices.
In Business Central, a posted sales invoice that the customer has already paid cannot simply be deleted. The correct route is a sales credit memo, which reverses the sale and records the refund against the original entry. Adobe Commerce follows the same principle. An order closes when a credit memo has been issued and the refund has reached the customer, so the storefront status and the ERP record can tell the same story when both are set up correctly.
The practical rule is to keep returns separate from fulfillment. A return is not a shipping problem, and it should not be logged in the same place as one. Give the returns owner the authority to approve a credit, decide whether stock goes back on the shelf and close the matching invoice. When those answers are written down, a return stops being a crisis and becomes a routine step.
Common order to cash mistakes we see
- Mapping a shipping method or payment method late, after live orders have started flowing.
- Invoicing from the original order rather than the shipment, which causes disputes over quantities.
- Letting the storefront and the ERP each edit stock, so the next sync overwrites one of them.
- Leaving partial payments and short payments without an owner, so they age quietly.
- Unassigning a source or changing a stock assignment while orders are still open, which can strand quantities.
- Agreeing on the word “complete” differently in each team, so customers receive the wrong status message.
Measuring the order to cash process
You cannot tighten the process without measuring it, but the measures do not need to be complicated. We track four things for each merchant. Time from order to shipment shows how quickly operations move. Time from shipment to invoice shows whether billing keeps pace. Invoice accuracy, measured as the share of invoices that need correction, shows the quality of the handoff between fulfillment and finance. Time from invoice to payment shows how well cash application and collections work.
Review these monthly against the merchant’s own history. A single slow order is an exception. The same slow step every month is a process problem, and that is the one to fix first.
Reporting that both teams trust
Finance and operations often look at the same process through different reports. Operations watches open orders and unshipped quantities. Finance watches open invoices, aging balances and unapplied cash. The fastest way to end an argument is to give both teams a shared view built on the same order number and the same status definitions.
Build that view around the order, not the document. A single line per order should show whether it was received, shipped, invoiced and paid, with the date of each step. When a manager asks why an order is late, the answer should be visible without opening three systems. Review the view weekly, and keep the list of exceptions short by giving each one an owner and a due date.
Keep the view simple enough that a new team member can read it in five minutes. If it needs a walkthrough every time, people will stop using it, and the arguments will return.
Frequently asked questions
What is the order to cash process?
The order to cash process is the sequence that starts when a customer places an order and ends when the payment is received and matched to the correct invoice. It covers order capture, stock checks, fulfillment, shipping, invoicing, payment collection, cash application and reconciliation. Each stage depends on the accuracy of the stage before it.
How does the order to cash process work with Magento and Business Central?
Magento captures the order and the payment intent. A connector creates a sales order in Business Central, which then records the shipment, the invoice and the cash. Shipments, tracking numbers and invoices flow back to Magento so the customer can see the order status. Each step has one owner, and the connector moves information in the correct direction.
What is the order to cash workflow for a Magento store?
The workflow starts with a Magento order and moves into Business Central as a sales order. Stock is checked against the available quantity, the warehouse ships the order, the shipment posts, the invoice follows the shipment, and the payment is matched to the invoice. Status changes in Business Central update Magento, so the storefront stays consistent with the finance record.
Why does stock matter in the order to cash process?
Stock is the first handoff where the storefront and the ERP can disagree. If Magento shows units that are already committed in Business Central, the order enters a queue that cannot be fulfilled. Sending Magento the available quantity, after open demand is subtracted, prevents many of these exceptions before they reach the warehouse.
When should I use a sales order instead of a sales invoice?
Use a sales order when you need to ship only part of an order, when you ship after the invoice would normally post, or when a vendor delivers directly to the customer. Sales orders create both a shipment and an invoice, and they let you split the quantity across shipments. A sales invoice is simpler when the full order ships at once and no split is needed.
How should partial shipments and partial invoices be handled?
Record each partial shipment against the original sales order, and invoice only the quantity that shipped. The connector should send each shipment and its tracking number back to Magento so the customer sees progress. Test a partial shipment before go-live, because it is the flow where small mapping mistakes become visible to customers.
What is cash application, and why does it matter?
Cash application is the work of matching incoming payments to the invoices they settle. It includes partial payments, short payments and payments that arrive without a reference. Good cash application keeps customer balances accurate and shows exactly which invoices remain open. Importing bank data regularly makes matching much faster.
How do I find out why a customer’s invoice does not match their payment?
Work through the process in order. Check the customer record, the sales order, the shipment, the invoice and then the payment. The first step where the records disagree is usually the cause. Fix the problem in that step rather than adjusting the balance by hand, so the downstream records update correctly.
Do I need software to run the order to cash process?
Not every business does. A small operation with low order volume can run a clean process with clear manual steps. Software becomes valuable when orders arrive from several channels, when invoices must follow partial shipments, or when finance spends too much time matching payments. A connector between Magento and Business Central removes the manual copying between the two systems.
What is the best order to cash software for Magento?
For Magento merchants that use Business Central as their ERP, the right tool is one that maps orders, customers, items, stock, shipments and invoices reliably between the two systems. We would evaluate any option against that test first. The best fit depends on your location setup, your payment methods and how much custom mapping your business requires.
Next steps
If you are planning an order to cash workflow between Magento and Business Central, start with the order of work rather than the software. Decide who owns stock, map customers, shipping methods and payment methods, test a partial shipment and agree on what each status means. Once those decisions are made, the connection becomes a reliable part of the process rather than a source of exceptions. If you want to compare the setup options and plans for your store, the Business Central Magento connector pricing page lays out what is included, and we are happy to walk through the mapping with your own locations, payment methods and products.
Order to Cash Process for Magento and Business Central Merchants Read Post »


















