905
Hi
How can you upload opening balances in all areas in dynamics financials?
I used the Migrate business data templates to upload the chart of accounts, Customers and Vendors and item. but now need to bring over the balances
Also, for the master data templates provided through the migrate business data under assisted setup doesn't have all the fields for customers, or Vendors, or items. how can I upload the remaining fields too
Thanks
Ola
Just follow these simple steps:-
Step 1 - Extract Data from Your Current System
Step 2 - Prepare and Upload Open Accounts Receivable Balances
Step 3 - Prepare and Upload Open Accounts Payable Balances
Step 4 - Prepare and Upload Inventory Quantity Balances
Step 5 - Prepare and Upload Opening GL Account Balances (Trial Balance)
Hope this solves your problem.
Thank you so much I tried that and it worked
Bill to number should be entered only when it's different from customer number. Meaning only when you send invoices to customer other that one set in customer number, otherwise it should be blank.
Blank value in bill to customer means it's the same customer.
Prepare customer journals expects this field to be empty (blank), so in cases where you have bill-to customer entered and it is the same as customer number you should switch it to blank and this should work.
Ivan
Hi Ivan,
The bill to customer is the same no as customer No , does it have to be blank?
Thanks
Ola
Hi Ivan,
I tried to use prepare journal for trial balance opening balance and vendor and it worked fine, but then I tried to use it with Customers. it says the journal created successfully but it doesn't populate any of the customers in the client list.
The customer list looks fine to me. is there a specific field that I should check. any setup that may be causing this ?
Thanks
Ola
I have seen this several times. In my experience, this is due primarily to a data validation error(i.e. bad characters in a field, field too long etc). The Vendor table is especially touchy with this. I fixed the few data errors that I had, but ultimately had to delete the records and add them back in again thru the edit interface. I was unable to determine exactly why it was not liking the data. Just easier to rekey the few records.
Hi Ola
This is a part of May update which is being rolled out as we speak to existing Financials tenants. I can't tell you when your specific tenant will be upgraded, however this should be completed within few weeks, so keep an eye on this.
Regards
Ivan
Hi Ivan,
Thank you for your reply
I tried to follow the same steps , but when I open General Journal >>actions
I don't see the option prepare Journals that you have in your screenshot
Thanks
Ola
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
