To get the internal id of item using function,
Author: Nancy Enasu
Sync inventory from NetSuite to FAIRE
There exists prebuild flow “NetSuite Inventories to Faire Inventories” in Celigo to sync Inventories from NetSuite to FAIRE. This is how the celigo flow looks like. In export, add Name, Description, Connection, Search id, Record Type, Export Type The hook is given below. In Import side, add Name, Description, Connection, and other details. Mapping Please… Continue reading Sync inventory from NetSuite to FAIRE
Bill generated via bulk Purchase Orders
To create bill against bulk Purchase Orders, you can follow these steps. Navigate to Transactions > Payables > Bill Purchase Orders You can choose the Purchase Orders that you need to bill. Please note that the vendor, subsidiary, and currency are all the same. Submit it. The resulting bill will show all item details in… Continue reading Bill generated via bulk Purchase Orders
Image URL to custom field
Create two custom fields in item records. One is to store the image URL (freeform text) and another which is an inline HTML field. In HTML field, give default value as ‘<img src=’||{id of first field||’/>’ Here custitem197 indicate the id of freeform text. Add the image URL in first field and save item record.… Continue reading Image URL to custom field
Date time format
Use the code below to increment the time by 3 hours to get the new time. If the date created is of the format 2023-07-21 11:56:27, then the time changes to 2023-07-21 14:56:27 If the date created is 2023-07-21 22:56:27, time changes to 2023-07-22 01:56:27
Saved Search-Available filters
Create a Save Search Provide the required criteria On the results tab, add required columns On Available Filters, add the required filters Save the search. Filters display on top of search results.
Make a copy scenario
record.submitFields
Expense limit and Expense Approval limit
Approval Routing feature is used to set up a hierarchy of supervisors and approvers who will approve purchase and expense transactions before they are processed. Expense Limit – The amount the employee can expense without supervisor or approver approval. In some cases, expense report bypasses supervisor approval. This is because if the amount is less than… Continue reading Expense limit and Expense Approval limit
Set default value for custom field
To set default value for custom fields, Select the custom field to set default value. Add required fields (Label, id, type, applies to) Under Validation & Defaulting tab, add the default value. NB: The Store Value should be unchecked.