There are times where users will create a duplicate customer that then needs to be merged together with another customer. If the duplicated record doesn't have any open or historical transactions then the easy thing would just be delete the duplicate, however if there is already transactions created then you'll have to merge the two records.
To merge two customers in Dynamics 365 Business Central you'll first have to locate the two customer cards. In my case I have Trey Research duplicated as shown below.
Since customer '10000' is the one I want to keep I'll open that customer card and navigate to Actions > Functions > Merge With. Note that only users with the Merge Duplicates permission set can use this functionality.
Within the Merge Duplicate window you will populate the Merge With field with the vender you'd like to merge with. Next step is to review the data and decide if you'd like to override the data with the Merge With customer. Once you've completed your review you can click Merge to complete the customer merge.
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
Steps to reverse a bank account transaction or customer payment in this case. Have you ever entered a customer payment and needed to void it out of the system? If so, this blog is for you! Follow the steps below to learn how to unapply a payment and void/reverse the payment. These steps will void the payment and the invoice will remaining outstanding when completed. Open the Bank Account Ledger Entries window and select the line for the transaction in question. ctrl+alt+Q on keyboard to open the Find entries page, or click on find entries on the Action Bar. Click on the Detailed Cust. Ledg. Entry line Select a line that has 'Application' as the Entry Type and then Unapply Entries on the Action Bar Click Unapply Yes OK Close windows until you get back to the Bank Account Ledger Entries page. Select transaction and then Reverse Transaction from the Action Bar. Reverse Yes OK Written by: Kristen Hosman, Microsoft MVP
Three-Way matching is an Accounts Payable process that is used to verify a vendors invoice by checking it against its corresponding purchase order and receipt. Three-Way Matching Concept Purchase order - authorizes a purchase. Typically an itemized list of types, quantities, and prices of an order as agreed to by the buyer and supplier. The PO has a unique number to associate this order and should be used by the supplier for tracking and invoicing purposes. Delivery receipt - confirms that the items on the purchase order were delivered. Typically completed by someone in the warehouse. Vendor invoice - lists how much the buyer owes the supplier. Should match the agreed upon purchase order and items received. Three-Way Matching Process Typically this process is handled by an Accounts Payable (AP) user. Vendor invoice is sent to AP and that person verifies the delivery receipt in the system prior to entering the invoice. I will go through the basics of this process. Purchase order is issu...
Comments