Month: October 2021

Process Reconart Files-MR Script Enhancement-Effective Commission Rate Proposal

The map-reduce for processing the Reconart files should be updated. The new enhancement is related to the fetching of the commission rate for the vendor bill and invoice. The script should look at the commission rate from the  Effective Commission Rate table on the vendor record based on the transaction date and the effective from… Continue reading Process Reconart Files-MR Script Enhancement-Effective Commission Rate Proposal

Dunning Letter Updates Proposal

The proposal details the new updates that should be done on the Dunning email templates.  Requirement  Add the email signature below (including the disclaimer) to all their dunning letters. They have 5 dunning letters for the UK and 5 dunning letters for the US. There are few more updates required by SmartSearch: Dunning letters for… Continue reading Dunning Letter Updates Proposal

Proposal For Invoice Template Update

The proposal covers the new updates on the Footer of the invoice PDF template. Requirement  Following are the requirements: On the footer of the invoice PDF template, add more space after Account Name and then align all bank fields on the right. On the footer of the invoice PDF template, if a bank field is… Continue reading Proposal For Invoice Template Update

Common SQL Expressions For Saved Search

Character Functions Function Syntax Description CONCAT CONCAT(char1, char2) returns char1 concatenated with char2 LOWER LOWER(char) returns char, with all letters lowercase UPPER UPPER returns char, with all letters uppercase LTRIM LTRIM(char [, set ]) removes from the left end of char all of the characters contained inset RTRIM RTRIM(char [, set ]) removes from the… Continue reading Common SQL Expressions For Saved Search

Importing Special Language Characters Into Netsuite Through CSV

The first thing you’ll need to do for this type of import is to install Notepad ++.  Many people have heard of Notepad, as it is the standard text editor on many PC computers.  Unfortunately, Notepad doesn’t support these different languages. Let’s get into the steps: Open the .xls or .xlsx file containing the special… Continue reading Importing Special Language Characters Into Netsuite Through CSV

Integration of Google maps in Netsuite

In the era of cloud based business and communication services, integration of services, processes and product has become a necessity for a business to improve its efficiency and productivity. The integration of two major cloud based service providers that don’t requires anyone’s introduction NetSuite and Google Apps has potential to completely change entire work efficiency… Continue reading Integration of Google maps in Netsuite

Saved search to get the contacts of the customer from an invoice.

Requirement – The purpose of this saved search is to run a report on all our contacts and bring in their spend in the past 12 months. The search should display the primary contact of the customer if there is no contact added in the invoice. Solution – Create an invoice saved search including the… Continue reading Saved search to get the contacts of the customer from an invoice.

How to change SKU position

First of all, you should find out which file is responsible for displaying the SKU on the product page. The following layout file for the “catalog_product_view.xml” of the Catalog module is responsible for this: /view/frontend/layout/catalog_product_view.xml/view/frontend/layout/catalog_product_view.xml In order to change this file, you need to copy it to the folder with your theme. It is not… Continue reading How to change SKU position

Published
Categorized as Magento