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 : 16|Last Topic : 14/01/2020 11:03 PM
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 : 12|Last Topic : 09/03/2020 11:53 PM
Information about Tuhund. Tuhund has moved far beyond and is much larger for just being called an ERP.
Topics : 4|Last Topic : 10/04/2019 11:32 AM
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 : 3|Last Topic : 15/12/2019 11:19 AM
Questions and queries about Human Resource Management Module
Topics : 14|Last Topic : 25/11/2019 08:42 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 : 18|Last Topic : 01/02/2020 07:43 AM
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 : 1|Last Topic : 12/12/2018 12:57 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 : 4|Last Topic : 28/07/2019 11:19 PM

Keywords

#access #accounting #accounts #activity #adapter #admin #advance #ageing #agent #aging #amount #analysis #android #app #application #approval #assets #attachment #attendance #automatic #backup #balance #balancesheet #bank account #bank #barcode #bi #boe #bonded #bounce #branch #browser #business development #business intelligence #calculation #cash #change #charts #chat #claims #clearing #comments #commission #companies #company #compliance #configure #consumption pattern #control #conversation #conveyance #coordinates #cost #costcenter #courier #credit note #credit #crm #currency #custom duty #customer #customization #dashboard #data #database #date #default #delivery charges #delivery #depreciation #discount #discussion #disk #document #download #drill down #drive #duplicate #elevate #email address #email client #email message #email #employee #entries #epf #evidence #excel #exchange #expense #failure #filters #finance #financial year #forwarding #function #group #gst rate #gst returns #gst #import #indent order #indent sale #information #inquiries #install #instructions #integration #inventory #invoice #journal #kilometer #ledger balance #ledger #license #limit #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 #outbox #payable #payment #payroll #pdf #performance #petty cash #picture #pnl #point of sales #pos #prefix #price list #price #printer #process #procurement #product #products #profit #proforma invoice #project #promotional #purchase invoice #purchase order #purchase #quotation #rate #reading #receivable #recipient #reconciliation #register #report #request #requirement #requisition #resource #retail #revenue #revision #rfq #rules #saas #salary #sales return #sales #salesmen #sample #schedule #scope #search #section #selection #sensitive #sensors #server #services #settings #share #sms #software #space #statement #sticker #stock #storage #stuck #subledger #support #synchronize #system #target #tasks #tax invoice #tax liability #tax #template #therefore #thermal #topics #tracking #transaction #user #value #vat #vendor #vouchers #warehouse #warranty #wbs #widget #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
Request Demo