Step 2: Updating Customer and Vendor databases

Step 2: Updating Customer and Vendor databases

Introduction

Manually update Customer and Vendor details to comply with eInvoicing, or bulk update databases with Zoho's import-export methods 

Update Individual Customer and Vendor Details

  1. Navigate to and edit either a customer or vendor :
    1. for customer details navigate to Sales > customers > select customer > Edit 
    2. for vendor details navigate to Purchases > Vendors > select vendor > Edit 
  2. Open "Custom fields"
  3. Fill in all fields where applicable:
    1. Customer name, Company name and display name - all details pertaining to the customer's identity
    2. Email - the email customers wish to be contacted with 
    3. Phone - Phone number of the customer 
      Ensure all Phone number fields do not contain any spaces or special characters or there will be errors in the eInvoicing process
      Info
      Make sure to also update the "Address" page of the customer profile with all required details as well.
    4. Registration number 
    5. Registration number scheme (select what type of Registration number is being used above)
    6. TIN - your customer's LATEST Tax identification Number. 
    7. MSIC code - identifier for what business category the customer is in 
    8. SST Registration Number and Tourism Tax registration number 
      1. Leave as "NA" if customer does not have these
  4. Review details
  5. Save 
non-mandatory fields are advised to be filled in for better cataloging if possible

Bulk Update Customer and Vendor Details 

NOTE: import / export steps apply to every module, should bulk updating be necessary.

How to export database for bulk updating 

  1. Navigate to either customer or vendor module :
    1. for customer export navigate to Sales > Customers
    2.  for vendor export navigate to Purchases > Vendors 
  2. Open the 3-dot menu on the top right of the page and select Export [module name] 
  3. In the popup menu, select all fields that are necessary 
    1. It is advised to work entirely with the CSV format 
    2. Fill in a password for the document if necessary 
  4. Export 
  5. Open file 
    1. All eInvoice related fields are prefixed with CF. 
    2. Update all relevant fields 
    3. Ensure all number fields are formatted to be plain numbers with no decimals or units. 
    4. Save file in CSV format

How to import database for bulk updating 

  1. Navigate to relevant module :
    1. for customer export navigate to Sales > Customers
    2.  for vendor export navigate to Purchases > Vendors 
  2. Open the 3-dot menu on the top right of the page and select "Import [module name]" 
  3. Select relevant option (if you exported contact persons) and "continue" 
  4. Drag and drop or upload file with the "upload" button 
  5. To add all new eInvoice information to existing customers, select "overwrite customers" and click "next". 
  6. Ensure all fields are assigned their corresponding data
    1. For empty fields that are duplicated of another field in the list, assign the data name that contains "_1" in it (refer to sec.43-50 in the video above)
    2. All eInvoice related fields are labeled CF. same as before, ensure all are matched. 
  7. Click "next", and in the next window ensure no data is missing and there are no errors in the importing
  8. Click "import" 
  9. Ensure all data is present and correct in every profile. 

    • Related Articles

    • Step 1: Installation and Organization Setup

      Introduction Welcome to the eInvoice Malaysia Plugin for Zoho Books, developed by Ooroboros Sdn Bhd. This guide will walk you through the installation, setup, and usage of the plugin to ensure you maximize its benefits and maintain compliance with ...

    • Best Practices for Collecting Customer Information for e-Invoicing Compliance

      As you implement the e-Invoice Plugin for Zoho Books, it is essential to establish a streamlined process for collecting accurate information from your own customers, vendors, and freelancers. This ensures full compliance with Malaysia’s e-Invoicing ...

    • Step 3: Item Master Configuration

      Introduction Configure your Item Master in Zoho Books to align with e-Invoicing requirements. This ensures all product and service data is properly formatted for MyInvois submissions. Unit of measurement with inventory integration The following ...

    • Step 4: Setting up custom views

      Introduction Change the documents that is shown to you for an easier handling experience! Learn how to change the documents shown to you, and create custom filters. How to Find Custom Views in Zoho Books Navigate to database module you need to sort ...

    • Step 0 [ Pre-requisite ] : MyTax Portal Setup (business owner)

      The first-time setup must be completed by the registered business owner. Disclaimer: These instructions are subject to change based on updates or modifications made by LHDN. Start Your Registration Navigate to MyTax Portal (Testing Environment). ...