D365ConsultantDivision of Sataware
Talk to an expert
D365ConsultantDivision of Sataware
Enterprise to Business Central

QuickBooks Enterprise to Business Central, without losing the inventory detail.

Companies moving from QuickBooks Enterprise to Business Central usually leave for operational reasons, not accounting ones: stock across several sites, assemblies, sales orders that need allocating, or a family of company files that must be combined every month. Those are exactly the features that need the most care in the move, so this page is about them.

Locations and bins
take over from Advanced Inventory sites
Assembly BOMs
replace inventory assembly items
Many companies
in one Business Central environment
Notebook, tablet and bag on a wooden table

Enterprise features and their Business Central counterparts

Stock

Advanced Inventory

Sites, bin locations, and serial or lot numbers in Advanced Inventory map to Business Central locations, bins and item tracking codes. Business Central goes further, with transfer orders and warehouse documents, but you choose how much of that to switch on.

  • βœ“Sites to locations
  • βœ“Bins to bin codes
  • βœ“Serial and lot numbers to item tracking
  • βœ“FIFO preference to item costing method
Build

Inventory assemblies

An inventory assembly item and its component list become an item with an Assembly BOM. Builds become assembly orders, which can also be triggered from a sales line when you assemble to order.

  • βœ“Assembly BOMs
  • βœ“Assembly orders
  • βœ“Assemble to order on sales lines
Price

Price levels and price rules

Price levels and Advanced Pricing rules are rebuilt as sales price lists and line discounts, which can target one customer, a customer price group or every customer, each with start and end dates.

  • βœ“Customer price groups
  • βœ“Price lists with date ranges
  • βœ“Quantity breaks
Fields

Custom fields

Enterprise custom fields have no automatic home. Each one is matched to a standard field, dropped, or added through a small AL extension. We list them all and ask which are still used.

  • βœ“Match to standard fields
  • βœ“Retire unused ones
  • βœ“Extend only what earns its place

Several company files, one Business Central environment

Many Enterprise users run a separate company file for each legal entity, because one file holds one set of books. Month-end then means exporting each file to Excel and combining them by hand, with intercompany balances eliminated in a spreadsheet.

In Business Central, every legal entity is a company inside the same environment. Users switch between them without signing out, master data can be copied from one company to another, and intercompany transactions are sent from one company's journal or document to the partner company's inbox. Consolidation into a group company is a standard feature.

The migration question is sequencing. Moving every file on the same cutover date keeps intercompany balances in step, but it concentrates the risk. Moving one entity first gives the team a rehearsal, at the cost of a stretch where intercompany balances cross between QuickBooks and Business Central. We lay out both options with the balances involved and you choose.

Calculator, pencil and yellow sticky note on a desk
Calculator, pencil and yellow sticky note on a desk

Inventory valuation: decide before the first item loads

QuickBooks Enterprise
Business Central
Default costing
Average cost
Chosen per item
FIFO
Company-wide preference with Advanced Inventory
Costing method on each item card
Other methods
Not offered
LIFO, Standard and Specific as well
Freight and duty
Usually added to cost on the bill
Item charges assigned to receipts
Revaluation
Inventory adjustment
Revaluation journal
Cost updates
Recalculated on posting
Adjust Cost - Item Entries batch job

Clean-up worth doing inside Enterprise first

  • βœ“Run the Verify and Rebuild data utilities, so file integrity is checked before extraction.
  • βœ“Resolve negative inventory. QuickBooks allows selling stock it has not received; negative opening quantities cannot be valued sensibly in the new system.
  • βœ“Close or cancel stale sales orders and purchase orders, and receive anything that has physically arrived.
  • βœ“Make inactive the customers, vendors and items with no recent activity, then decide whether they come across at all.
  • βœ“Count the stock. A physical count on or just before cutover gives opening quantities you can defend.
  • βœ“Reconcile inventory to the balance sheet, so item-level value matches the inventory asset account.

Moving stock without losing a count

  1. 1

    Stop goods moving

    Pick a cutover point after the last shipment of the day and before the next receipt, so no stock is in transit between the two systems.

  2. 2

    Export quantities by site and bin

    Quantities on hand come out of Enterprise by site, bin, lot and serial number, then are checked against the physical count sheet.

  3. 3

    Post opening quantities with cost

    Business Central receives the stock through an item journal, one line per item, location and bin, with the unit cost that makes the total agree with the inventory account.

  4. 4

    Recreate open orders

    Open sales orders and purchase orders are entered again as documents, so allocation, picking and receiving carry on the next morning.

  5. 5

    Prove the valuation

    The Business Central inventory valuation report is compared with the inventory account balance and with the QuickBooks valuation summary at cutover. All three must agree.

QuickBooks Enterprise migration questions

We already run inventory in QuickBooks Enterprise. Is Business Central overkill?

Sometimes it is. If one warehouse, no assemblies and a single company describe you, Enterprise may still be enough, and a move buys more setup than you need. The case for Business Central gets stronger with several locations, assembly or light manufacturing, multiple legal entities, or a need for approval workflows an auditor can follow. We will tell you plainly if we think you should stay.

Can Business Central handle our barcode scanning?

Business Central works with scanners that type into a field, and its mobile app can scan barcodes with a device camera. Warehouses that want dedicated scanning workflows usually add an AppSource app built for that. We look at how you scan today and recommend the simplest option that fits.

Do all our company files need to move at the same time?

No. Each file becomes a Business Central company and can go live on its own date. Moving together simplifies intercompany balances; moving in sequence lets one team learn the system before the others. The right answer depends on how much trade happens between your entities.

What about our memorized reports?

Memorized reports do not transfer. Most standard reports have an equivalent in Business Central, and its financial reporting feature rebuilds your income statement and balance sheet layouts. For management packs, Excel layouts and Power BI replace the exports many Enterprise users rebuild by hand every month.

Where does our payroll go?

US payroll is not part of standard Business Central. Keep your current provider and post a summarized entry into Business Central after each pay run, imported from a file or through a connector if the provider offers one. Payroll history and year-end forms stay with the provider.

Talk to us about your project.

Tell us what you run today and what has to change. A senior consultant replies with a written next step.

Get started

Start with a scoping conversation.

Thirty minutes with a senior consultant - not a sales call. We look at how you run today, tell you plainly whether Business Central is the right fit, and give you an honest sense of scope, cost and timeline before you commit to anything.

What happens next
1
We review your enquiry
A consultant reads it before the call - no discovery questionnaire to fill in.
2
30-minute scoping call
Your processes, your current systems, and the gaps that matter most.
3
Written summary & estimate
Indicative phases, licence counts and a cost range, in writing within three days.
Reply within one business day
NDA signed before discovery on request
No obligation, no cost for the scoping call
Microsoft-certified consultants only
Request your scoping call
Four fields. A consultant replies within one business day.
No cost
Your details stay with our consulting team - never shared, never added to a mailing list.