How can I migrate the outstanding details for my customers from Quickbook to D365 Business edition?
What I can find from the video is how to migrate the Customer Master but how about the outstanding details.
Can I migrate the transaction details for year 2017 (from Jan to Oct) to D365 ?
Hi, AJ,
Thanks for your response!
I'll try and let you know if I success!
Thanks!
Ella
Hi Ella,
I can’t speak to the lack of videos on this but here are some steps to get you going.
“Sales Journal” and “Purchase Journal” are pages that you can find using the search icon in D365. These are just like General Journals, but they allow for the recording of a Sales or Purchase Invoice or setting Open AR and Open AP balances, and records it with an appropriate source code so it’s easily traceable.
You will first be presented with a list of batches, and if there isn’t one, you can create one. Then edit the Batch and you will be presented with a journal entry screen. The first line of your entry will have Document Type Invoice, Account Type Customer (or, if using Purchase Journal, set Account Type to Vendor), set the Document no., Posting date, Description as “Opening Balance”, set the appropriate Debit or Credit amount.
If setting Open AR (or Open AP on Purchase Journal) set the Balancing Account Type to G/L Account, and Balancing Account No. to the Accounts Receivable Account (or to the Accounts Payable Account on Purchase Journal).
When done, click Post and you will be done.
For opening G/L Balances, go to General Journal, pick a batch or create a new Batch, Edit the Batch and start populating the lines with a Posting Date, Document no., Account Type G/L Account, Type the Account No., set Description to Opening Balance, and plug in the Debit or Credit Amount, then move to next line and repeat process using the same Document No. and Posting Date. D365 will look for your transactions (credits and debits) to total to 0 for the Document No. and Posting Date combination.
Then Post and you are done.
Repeat the same process with a unique Document No. and Posting Date combination for net changes to G/L Accounts by month or quarter.
If you use Edit in Excel from the General Journal, Sales Journal or Purchase Journal pages, you can easily copy and paste from another source and publish multiple rows of information at once without manually filling it all in.
If using ‘Configuration Package’ (click the Search icon and type in this word), you would export a template for Gen. Journal Line, and then populate with Opening G/L Balances, Net Changes to G/L, and Open AP / Open AR. This is more complex and I won’t be able to type out all the steps here. But your partner should be able to help, and you may be able to find Documentation on this by clicking on the Help icon in D365.
I hope this helps. If it does, please verify by clicking “Yes” next to “Did this answer your question?”
Hi, AJ
First of all, thank you for respond to my question!
I understand D365 allow me transfer customer master as you mentioned on your first four paragraphs. And I tried that, it works
But most of my question is regarding migrate opening G/L balance, G/L transactions, Open AP and Open AR by open invoices.
I can't find any video on YouTube telling me how to do these.
I notice that you explain something on your last paragraph but can you give me more details since I don't understand how can I make a batch in the purchase journal or a batch in the Sales Journal. Where can I find the Purchase or Sales Journal.
Thanks!
Ella
Hi Ella,
There may be some videos on YouTube, but it’s a very simple process to import Customers. You can either use the QuickBooks Data Migration app from Microsoft (it’s free and you can add it from AppSource, which you can get to by searching for Extensions Marketplace in D365), or by using the Edit in Excel functionality from the Customers list page, or using Configuration Packages (RapidStart).
Of the three, Configuration Packages is what I usually recommend because it has data validation, error handling, and guidance on field types and sizes. Next is Edit in Excel, as it allows you to reorganize the fields in the template and add/remove fields that may not be showing on the template by default. The QuickBooks Data Migration app is the simplest to use but also the most rigid and basic, and missed many important fields that exist on the Customer Card and you may be interested in using.
On a related note, I recommend using the “Standard Data - Suite Production” option when creating a new company since this will populate underlying setups and allow you to move directly to importing customers, etc.
If you are cannot find the requisite videos or if the help documentation from Microsoft isn’t sufficient, you can engage a partner to help you: go to the AppSource website and click on Consulting Services and look at the ones for D365 for Financials Business Edition. Here, you will find many different partners like us who can provide training and guidance on data migration.
Finally, around migrating transactions, you can migrate opening G/L balances, G/L transactions, Open AP and Open AR from either the Configuration Packages (by importing into the Gen. Journal Line table) or by using Edit in Excel to import into a batch in the General Journal, a batch in the Purchase Journal or a batch in the Sales Journal. But you don’t have the ability to recreate/reimport Sales or Purchase transaction detail from QuickBooks into D365.
If this answers your question, please verify by clicking “Yes” next to “Did this answer your question?”
Share
Report
All responses (
Answers (
5,754
