Changing the phone number in the saved search link(URL), provides the accurate result as per the Contact(s) with the corresponding Phone number. This can be done by adding phone number as an available filter while creating the saved search. Then we can fetch the required contact information just by changing the phone number in the… Continue reading How to get a contact from a contact search by editing the phone number in the url
Author: Jismol Johnson P
How to disable the sub list in Payment record
Handle white space
Whitespace placed before any symbol inside the handlebars will cause an error. Correct: {{expression}}{{dateFormat}} Incorrect: {{ expression}}{{ dateFormat}} // note the leading whitespace Error: {{expression {{field}} // second set of opening braces seen as new expression
Approve Customer Payments
When a customer payment has a payment hold or is waiting to be validated outside of NetSuite, the payment is saved with the Unapproved Payment status. You can find a list of unapproved customer payments on the Unapproved Customer Payments Register page by navigating Setup > Accounting > Manage G/L > Chart of Accounts.
Currency changing in Profit and Loss Report
We have checked the possibility to change the OX Group Global (Consolidated) currency from AUD to GBP by keeping OX Group Global subsidiary currency as AUD in the income statement/Profit and Loss Report. As per the standard limits of NetSuite the said requirement is not possible. As an alternative solution we can try by creating… Continue reading Currency changing in Profit and Loss Report
Error in printing Picking Ticket
When we try to print picking ticket from Sales Orders with ‘Billed’ status an error message as shown below. This is because of the NetSuite behavior.It is not possible to print the picking ticket from sales orders with ‘Billed’ status. When we try to print picking ticket from sales orders with status other than ‘Billed’… Continue reading Error in printing Picking Ticket
Billing sync (NetSuite-Magento)
The Billing flow “NetSuite Billing to Magento Invoice Add” data flow exports Invoices from NetSuite to Magento. The data flow exports fully/partially billed orders in NetSuite as invoices in Magento. STEPS 1.Generate cash sale from Item Fulfillment in NetSuite. 2.Restrict the saved search criteria with ‘eTail Order Billing exported’ 3. Perform mapping in the flow… Continue reading Billing sync (NetSuite-Magento)
How to display the quantity available in each location separately in the saved search
To display the quantity of an item in different locations separately in the Item Saved Search result, we can apply the Formula in the saved search as shown below. In this way we will get the quantity stored in each location separately.
How to update the Related Products in Magento using NetSuite-Magento Integration
To update the related products field in Magento using a custom flow ‘NetSuite Related Item to Magento Linked Product’, need to add a new import step in the flow. STEPS 1.Create a new import 2.In the new import step, add the API Name, Operation, SKU as it is for updation. 3.Then the mapping is performed… Continue reading How to update the Related Products in Magento using NetSuite-Magento Integration
How to fetch multiple Item Records in a custom flow for syncing related items.
To fetch multiple item records in a custom flow which is created to sync related items of an item record in NetSuite as Linked Product in Magento, we can use handlebar expression in the import steps as shown below. In this way we can fetch multiple item records in the flow.