When and why would I merge records within Resolve?
If you've connected Resolve to an accounting platform, you might find some records duplicated in Resolve. This can happen due to various reasons, such as customer direct applications or checkout invoices.
When these records are manually created, you can solve duplications of records with the Merge Records functionality, which essentially converts the manual record into a synced record that links back with your accounting platform.
An example:
- You are integrated with QuickBooks Online
- QuickBooks Online sync process pulls down Customer A from QuickBooks Online into Resolve
- Customer A also starts a direct application via your direct application link
- At this moment, you would see two records of Customer A:
- Customer A
- Source: QuickBooks Online sync (external source)
- Status: Needs credit check
- Customer A
- Source: Direct application (manual)
- Status: Reviewing credit (pending approval) or Enrolled (approved already)
- Customer A
- To address the duplicate records, you should use the Merge records functionality to transfer the link between Resolve and QuickBooks Online to the manually created Customer A record, as it is already in the credit approval status.
- This action will automatically archive the previously linked Customer A record.
How do I merge records?
Merging customer records in the Resolve dashboard
- Find the manually added customer record
- Click on "Merge customer records" under the right-hand kebab menu
- Please note: a warning icon will only appear if:
- You are connected to an external accounting platform
- The customer record is not synced from the accounting platform
Merging invoice records in the Resolve dashboard
- Find the manually added invoice record
- Click on "Merge invoice records" under the right-hand kebab menu
- Please note: a warning icon will only appear if:
- You are connected to an external accounting platform
- You have Auto Bookkeeping turned on
- Invoice record is not synced from the accounting platform
- Until you merge, payments for that invoice aren't written to your accounting platform. See What happens to Auto Bookkeeping when I merge an invoice?
What happens when records are merged?
For invoice and customer records' relationship to your accounting platform:
- The previously synced record is unlinked from the accounting platform and archived
- The link with the accounting platform gets transferred over to the target record
- The target record is now linked to the accounting platform
For customer records from a data perspective:
- Customer name remains the same
- Customer email:
- If the target customer is not credit approved, then the email is transferred from the old record to the new record
- If the target customer is credit approved, then the email is not updated due to security reasons
- Customer AP email:
- If the target customer is not credit approved or if the AP email field is empty, then the email is transferred from the old record to the new record
- If the target customer is credit approved, then the email is not updated due to security reasons
- Address: transferred from old record to the new record
- Phone: transferred from the old record to the new record
- All other associated records and transactions — such as users, payments, invoices attached to the customer record — are transferred from the old record to the new record
What happens to Auto Bookkeeping when I merge an invoice?
If Auto Bookkeeping is on, Resolve skips any payout transaction whose invoice isn't linked to your accounting platform yet, and the payout shows Warning. What a merge does next depends on whether that payout has been paid:
-
The payout was already paid when you merge: Resolve starts writing the missing entries for that invoice as soon as you merge:
- the payments and advances, applied to the accounting platform's invoice;
- the related fee journal entries;
- on every paid payout that includes the invoice.
The journal entry for the payout itself is sent again only if it never posted or failed, so it's never recorded twice.
- The payout isn't paid yet: nothing is written at merge time. The invoice is now linked, so when the payout is marked paid, it syncs in full with the invoice included, as it normally would.
Once the entries post and every transaction on a paid payout is written, its status changes from Warning to Success. This can take a few minutes. If other invoices on that payout are still unlinked, it stays in Warning until those are merged too.
To learn how Auto Bookkeeping records a payout, see Auto Bookkeeping for QuickBooks Online or Auto Bookkeeping for NetSuite.
If you already recorded the payment by hand
Before writing anything, Resolve checks that the invoice in your accounting platform still has enough open balance for all of the invoice's missing payments, across every payout. If it doesn't, or Resolve can't confirm it, Resolve assumes you've already recorded them and skips that invoice's entries, so nothing is booked twice. The payout stays in Warning, and no action is needed.
For example: invoice 1001 for $500 was paid out on October 3. You recorded the $500 in QuickBooks yourself, so QuickBooks shows $0 open on the invoice. When you merge, Resolve skips it, and the payout stays in Warning.
The check covers the invoice as a whole. If the invoice's payments are spread over more than one payout and you recorded only some of them by hand, Resolve writes none of them. Record the rest by hand too.
The check uses the balance from the last invoice sync, which can be up to a day old. So record the payment by hand or merge the invoice, not both on the same day.
If you later reverse your manual entry, wait for the invoice to sync again (usually by the next day), then click Retry sync to [your accounting platform] on the payout. Retry runs the same check. If it can't write anything, it tells you why.
Good to know
-
Dates:
- QuickBooks and NetSuite: the entries are dated on the day you merge, not the original payout date. For example, an October payout merged in November is booked in November. If you need the entries in the original period, change their date in your accounting platform.
- Business Central: entries use the payout's paid date. If that period is closed, Business Central rejects them when you post the batch.
- Failures: if writing an entry fails, the payout shows Failed with Retry sync to [your accounting platform]. The merge itself is never undone. If Retry keeps failing, contact support: we can see the error your accounting platform returned.
- Older payouts: payouts from before Auto Bookkeeping was turned on are never written, as with any other past payout.
- Customer merges don't write bookkeeping entries. Merge the invoice to link it.
- Business Central with automatic posting: the missing entries aren't written. The payout stays in Warning, and you record them by hand.
Comments
0 comments
Article is closed for comments.