D365 Financials customer/vendor Import from GP

(0) Share

Report

Posted on by Community Member

I have imported my customers and vendor master records from Dynamics GP - along with came the open account balances that were imported as an open invoice for the account balance. I am still using my GP system for processing receipts against those balances. I would like to export my customer/vendor data to excel and clear those balances. If I do that, will the invoice that was created be null and void or need I credit/debit memo out each and every "invoice" that was created at import? If I do that I will have GL affect that I do not want. Any suggestions?

Categories:

Data Migrations

I have the same question (0)

All responses (1)

Answers (0)

Jennifer Ranz Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Sandra,

I just want to make sure I understand what you are looking to do. Are you trying to account for the new totals against your customers and vendors in D365? What you could do is create a new invoice or credit memo depending on the new balance to bring that customer/vendor back in balance.

For example Aaron Fitz $1000 outstanding balance at the time of the import.. Now Aaron Fitz has a $400 balance because you entered a receipt in GP. You could enter the pmt into D365 manually and apply it to the outstanding balance and now Aaron Fitz has a $400 balance in D365. I am guessing you also want to affect GL so you would want to make sure you are posting to the correct accounts in D365.

The other option you would have is to redo the migration in a new company and then the export would pull the new customer/vendor balances from GP and would import with the new amount of $400 but you would essentially be starting over in D365 and I am not sure what other type of transactions you have entered that would need to be redone.

thanks
Jen

Was this reply helpful? Yes No