Deleting duplicate customers

Omer  Al Bargouti
16/09/2019 11:14 PM

Deleting duplicate customers

Before Tuhund we had 11 isolated systems for our two companies and their branches. We have several customers who were customers for more than one branches and therefore had entries in multiple systems. Now after migrating data from old systems to Tuhund ERP, we have several cases of duplicate customers in master records, many with slight difference in names. How do we delete duplicate customers?

17/09/2019 09:40 AM

You can go to crm >> all business entities and merge duplicate records. Merging two (or more) companies into one will merge all their records except ledgers. Ledgers or entities that are removed will be transferred to the entity that is retained (merged with) and under receivable / payable you will see the combined data, however ledgers will be retained as they were. The choice is left to you to leave ledgers as they are, to merge the ledgers as well or to make a journal entry to transfer the closing balance of unwanted to ledgers of the same customer / vendor to the ledger that you want to retain. You will also need to be careful about addresses and contact persons. When you merge one company into another, normally both have addresses and contact persons. Each one could even have multiple addresses and multiple contacts. While merging system will compare each address of one entity to each address of other company. Addresses that exactly match each other will not be duplicated. However, if there is variance in addresses that are supposed to be same, system will not be able to identify them and will retain both addresses. It is the same with contact persons. Therefore, merging companies to remove duplicate company records might result in duplication of a few addresses and / or contact persons. 

As far as deleting is concerned, Tuhund will not give you an option to delete a company record if there are any transactions including inquiries, quotations, proforma invoices, commercial invoices, sales orders, tasks, events, financial transactions or any other kind of record for that matter. Therefore, for any company if you see the delete button and you feel the record is redundant, please go ahead and delete it. It s completely safe.

Still you are still under implementation phase and number of records could be high, I would advise you to raise a service request and our staff will handle the issue in bulk. Please be assured, we will remove nothing without your approval. We will first give you excel file marking all duplicate looking records as well as which records will be removed and which will be retained. 

User Community Home

ERP Interest Groups

Topics : 22|Last Topic : 22/10/2023 10:54 AM
Questions and queries about Accounting a Finance module. Working with cost centers. General Ledger, Accounts receivable, Accounts payable, financial statements, expense claims management, commission payables and receivable claims, Forex, Currency, Assets, Depreciation, Taxes and TDS, etc.
Topics : 14|Last Topic : 31/07/2021 11:09 PM
Information about Tuhund. Tuhund has moved far beyond and is much larger for just being called an ERP.
Topics : 5|Last Topic : 15/01/2023 02:13 PM
Point of sales software, Andriod and IOS applications and other software linked with Tuhund. API for connecting with Tuhund and building applications on top of Tuhund backbone.
Topics : 1|Last Topic : 10/10/2019 09:36 AM
Discussions on ERP in general and comparison of various ERP, their features, working, issues and workarounds
Topics : 5|Last Topic : 25/05/2021 07:24 PM
Questions and queries about Human Resource Management Module
Topics : 17|Last Topic : 02/01/2023 10:21 PM
Questions and queries about Inventory and Procurement Modules. Products and product categorization. Vendors Price Lists, Quotations & Invoices, Requests For Purchase, Requests for Quotes, Purchase Orders, Purchase Invoices, Tenders, Store Management, Locations, Stock. Inventory reports, margin analysis, ageing analysis.
Topics : 2|Last Topic : 26/12/2018 01:46 PM
Questions related to GST, GSTR1, GSTR3B. Issues and problems faced in GST Portal.
Topics : 2|Last Topic : 29/12/2018 11:34 PM
Knowledge sharing, support and help with Project Management Module; Project Schedule Management, Project Scope Management, Project Resource Management, Material Management, Expense Management, Deliverable, Billing and Invoicing.
Topics : 20|Last Topic : 18/01/2023 10:35 PM
All about Sales and Customer Relationship Module. Tasks, reminders and events. Inquiries, opportunities and business leads. Different types of sales targets and key performance indicators.
Topics : 2|Last Topic : 04/09/2020 11:19 PM
We welcome suggestions from our customers, third party users as well as from general public. Our aim is continual improvement of Tuhund. We are not going to stop or slow down development of Tuhund. Please let us know what you are looking for in Tuhund and we will make sure it is added.
Topics : 1|Last Topic : 02/09/2020 11:19 PM
Forum for Tuhund Channel Sales and Implementation Partners to seek clarifications and to exchange knowledge and ideas among themselves and with others.
Topics : 6|Last Topic : 20/03/2022 02:00 PM
Tuhund is a continual development system with a minor release every few days and a major release every couple of weeks. This section aims to keep Tuhund users informed about the developments.
Topics : 7|Last Topic : 25/07/2023 08:05 AM

Keywords

#access #accounting #accounts #activity #adapter #admin #advance #ageing #agent #aging #amount #analysis #android #api #app #application #approval #assets #attachment #attendance #automatic #backup #balance #balancesheet #bank account #bank #bar code #barcode #bi #boe #bonded #bounce #branch #browser #business development #business intelligence #calculation #campaign #cart #cash #categories #change #charts #chat #cheque #claims #clearing #comments #commission #companies #company #compliance #configure #consolidation #consumption pattern #contractor #control #conversation #conveyance #coordinates #cost #costcenter #courier #credit note #credit #crm #csv #currency #custom duty #customer #customers #customization #customized #dashboard #data import #data #database #date #default #delivery charges #delivery #depreciation #discount #discussion #disk #document #documents #download #drill down #drive #duplicate #e-commerce #e-invoicing #elevate #email address #email client #email message #email #employee #entries #epf #escalation #evidence #excel #exchange #expense #export #failure #filter #filters #finance #financial year #forwarding #function #group #gst rate #gst returns #gst #hsn #image #import #indent order #indent sale #information #inquiries #insert #install #instructions #integration #inventory #invoice #journal #kilometer #language #leads #ledger balance #ledger #license #limit #link #live #loading #location #locking #login #logout #logs #macbook #machine #management #maps #margin #marketing #mass mail #master #migration #mobile #module #newsletter #number #odometer #online #opening balance #order #outbox #overtime #packing list #partner #payable #payment #payroll #pdf #performance #petty cash #picture #pnl #point of sales #policy #portal #pos #prefix #price list #price #printer #printing #process #procurement #product #products #profit #proforma invoice #project #promotional #purchase invoice #purchase order #purchase #qr code #quotation #rate #reading #receivable #recipient #reconciliation #register #report #repository #request #requirement #requisition #resource #retail #return #revenue #revision #rfq #rules #saas #sac #salary #sales return #sales #salesmen #sample #schedule #scope #search #section #selection #sensitive #sensors #server #service #services #settings #share #sku id #sku #sms #software #space #statement #sticker #stock #storage #stuck #subledger #support #synchronize #system #target #tasks #tax invoice #tax liability #tax #tcs #tds #template #thermal #topics #tracking #transaction #upload #url #user #value #vat #vendor #vouchers #warehouse #warranty #wbs #website #widget #worker #zones
Tuhund Logo
TUHUND®
Home About us Modules CRM HR SALES BI SERVICES MANAGEMENT INVENTORY MANAGEMENT ACCOUNTING AND FINANCE PROCUREMENT PROJECT MANAGEMENT ERP ADMINISTRATION DATA REPOSITORY API & SUB PORTALS Careers Community Blog
M Home Schedule Demo About us Community Blog
CRM HR SALES BI SERVICES MANAGEMENT INVENTORY MANAGEMENT ACCOUNTING AND FINANCE PROCUREMENT PROJECT MANAGEMENT ERP ADMINISTRATION DATA REPOSITORY API & SUB PORTALS Careers
API Documents
Request Demo