Merge duplicate vendors or customers in Microsoft Dynamics 365 Business Central

-

Merging duplicate master records doesn't have to be so scary. In fact, Microsoft Dynamics 365 Business Central has a great tool that makes merging vendors or customers super easy. Once you merge a vendor or customer card all the historical and open transactions are updated and merged together as well.

Steps

Open the vendor or customer card that you want to keep and then select Actions > Functions > Merge With. 


Once the Merge Duplicate window opens, review the information in the Fields table. The information in the Current Value column is what will be the used for the vendor that is kept. If any of the information in the Alternate Value needs to be used, then you can check the Override checkbox. Notice below that I want the Payment Method Code to come over to the merged vendor. 




Once you've reviewed, you're ready to merge. Simply click Merge and then Yes. 


Written by: Kristen Hosman, Microsoft MVP



Comments

Post a Comment

Popular posts from this blog

Applying posted credit memos to posted invoices in Microsoft Dynamics 365 Business Central

-
Image
Applying posted credit memos to posted invoices isn't a hard task to complete in Microsoft Dynamics 365 Business Central. The example I use below is for a vendor credit, but the same process applies to customers.  Version: US Business Central 20.0 Open up the vendors list. Search for vendor that you'd like to apply the credit memo to an invoice for.  Click on Balance field to open up Vendor Ledger Entries window. This will show all the 'open' documents on the vendor ledger. Select the line for the Credit Memo that you want to apply to a posted invoice. Click Process > Apply Entries Within the Edit - Apply Vendor Entries window select the line(s) that you'd like the credit memo applied to.  Click Process > Set Applies-to ID This will put the users name into the Applies-to ID field on the line selected. To post the application select Process > Post Application. Written by: Kristen Hosman, Microsoft MVP
Read more

Send Remittance Advice in Microsoft Dynamics 365 Business Central

-
Image
The easiest way to send a remittance to a vendor is to open the vendor list and click on the vendor you'd like to send the remittance to.  With the vendor selected click on Actions > Functions > Send Remittance Advice.  You will then be welcomed with the Send Document to screen where you can decide how to process the remittance. In my case I want to email the remittance, so I make sure the Email is set to Yes.  Once I click OK, I am able to preview the email that will be sent. You can add emails for who it will be sent to, update the subject and message fields, and add any other attachments that should be sent.  Click send email when ready to send.  Written by: Kristen Hosman, Microsoft MVP
Read more

Dimension Corrections in Microsoft Dynamics 365 Business Central

-
Image
If you've ever coded something to the wrong dimension and noticed after posting don't just assume a journal entry is the only way to fix it. Microsoft has included a Dimension Corrections tool within Business Central and it's pretty easy to use. Let's walk through the process of updating a posted entries dimension where the user forgot to add the dimensions in this case. Same process would apply if you needed to change a posted dimension as well. Within the General Ledger Entries page, select the line for the entry that needs to be corrected, then click on Entry > Correct Dimensions.  Within the Draft Dimension Correction window go ahead and update the description if needed and mark Update Analyses Views if you're using those.  Next section Dimension Correction Changes go ahead and add the updates. In my case my entry is missing two dimensions so I'm going to add each of those in there. Since my dimensions were missing the Dimension Value Code field is blank,...
Read more