Response mapping

You can add response mappings to capture data returned from an import within your flow. For flows that have multiple imports, response mappings allow you to insert the response data of an import back into your source record so that you can reference that data in subsequent steps of your flow. For example, if an… Continue reading Response mapping

Published
Categorized as Celigo

Variant Images in Email

Proposal Summary  This proposal is for updating the date from related case record to Sales order record   Requirement     In the Buy & Ride script you created, is there any way to associate an image with the variant that’s shipping? We are referring to the email  template custemailtmpl_12_3550840_514 (screenshot A below).  Screenshot A  So, using the… Continue reading Variant Images in Email

addToViewContextDefinition

addToViewContextDefinition( view_id, property_name, type, callback ) Adds a property to the context data of a view. The property can then be referenced in templates. If the property already exists in the context data of the view, it is updated. For example, if a view has a property called ‘thumbnail’ and you pass ‘thumbnail’ in the property_name argument, then the return… Continue reading addToViewContextDefinition

Ways to Customize NetSuite Income Statement Reports

Filtering by Date To apply this filter, follow these steps: Select the Customize button Customize the dates that want by selecting the “from” and the “to” of the preferred period or date Select the Refresh button, so that data shows the current period or the period that are interested in. 2. Filtering by SubsidiaryThis filter… Continue reading Ways to Customize NetSuite Income Statement Reports

Entering Vendor Prepayments:

Go to Transaction tab > Payable > Enter Vendor Prepayment   In the Payee field, select the respective vendor from the dropdown list.  The Currency field autofill’s with the default currency for the vendor. We can change this value if there is more than one currency for the payee. This field is available when using the Multiple Currencies feature. … Continue reading Entering Vendor Prepayments:

Vendor Prepayments

Enabling the Vendor Prepayments Feature:  Go to Setup > Company > Setup Tasks > Enable Features.  Click the Accounting subtab.  In the Basic Features section, verify that the A/P box is checked.  In the Advanced Features section, check the Vendor Prepayments box.  Save. Configure the Default Vendor Prepayments Account:  We can configure the vendor prepayment account at the company level. If we are using NetSuite One World configure the account at the subsidiary level. Account… Continue reading Vendor Prepayments

Creating Saved Search to Replicate the Sales by Customer Summary Report

Navigate to List > Search > Saved Searches > New Click Transaction Search Title: Enter Title Click Criteria tab Click Standard subtab Filters: Select Type: Select any of Select Cash Sale, Credit Memo, Invoice, Journal Select Account Type Account Type: Select any of Select Income, Other Income Select Main Line Main Line: Select Yes (to include JEs select Either) Select Shipping Line Shipping Line: Select No Select Tax LineTax Line: Select No Select COGS Line COGS Line: Select No Click Results tab Select Name Summary Type: Select Group Select Amount Summary Type: Select Sum Click Save & Run

Set up a basic auth connection to NetSuite

CAUTION: With the release of API version 2021.1, NetSuite does not allow new accounts to connect to a Restlet via basic authentication. This auth type is now marked “To be deprecated – do not use.” If you’re still using basic authentication, you’ll need to change your authentication method to a more secure method. Two additional NetSuite… Continue reading Set up a basic auth connection to NetSuite

Published
Categorized as Celigo

Uploading Private SSH Keys

You can store and manage your keys on the Keys page. Keys with or without passphrase are accepted. To upload a new key: Go to Setup > Company > Preferences > Keys. At the top of the page, click the Create New button. In the New Private Key window, on the Details tab, enter a descriptive name for this key in the Name field.… Continue reading Uploading Private SSH Keys