The customer return process in NetSuite involves several key steps: 1. Issuing Return Authorization (RMA): This is the initial step where you authorize the customer’s return request. You can initiate an RMA through various methods: Directly from a sales order or invoice by clicking “Authorize Return.” Creating a new return authorization form. The RMA form… Continue reading Customer return process in NetSuite
Month: March 2024
Transformation 2.0: Modes
There are three modes you can use in Transformation 2.0. The modes are available in a dropdown near the top, left-hand side of the screen. Three modes Modify the Input This mode is useful when you want to make simple targeted changes to source records but keep everything else in the source records as-is. Create… Continue reading Transformation 2.0: Modes
Error Management Recomendations in Celigo
Case: I am getting ready to do a batch upload of roughly 5,000 records. I am planning to fail certain records (appropriately) if they are missing certain information from our source system, but its difficult for me to identify exactly how many records might fail. My question is what is the best way to fail… Continue reading Error Management Recomendations in Celigo
Not updating a line when the value of Qtypickpackship field is not empty.
In the for loop, just get the value of the field and check if it is empty or not and continue if it is not empty. for (j=1; j<=lineCnt; j++) { var qtyPickPackShip = recSO.getLineItemValue(‘item’, ‘quantitypickpackship’, j); … Continue reading Not updating a line when the value of Qtypickpackship field is not empty.
Solution proposed to add a discount field in line level Sales Order
To address the need for applying unique discount values to each line item, we can introduce a custom field for transaction lines. This field will allow for the entry of distinct discount amounts for each item. Utilizing a script, we can then transfer these individual discount amounts to a new line discount item, which will… Continue reading Solution proposed to add a discount field in line level Sales Order
Create a custom sublist in related records of inventory item
To create a sublist of all sales order related to that item under related records of Inventory item record, do the following – Create a transaction search with type as sales order and necessary details as results. Add ‘Item’ in available filters and save the search. Now, Goto Customization -> Forms -> Sublists Select the… Continue reading Create a custom sublist in related records of inventory item
Alternate solution to view Return Authorization in Invoice record
Initially create a subtab for transaction forms, Goto Customization → Forms → Subtab. Select transactions, Enter the name for subtab Choose parent as Related Records. Save After that create a saved search for linked return authorization of corresponding invoice. Make sure the search is available as list view. Now, goto Customization → Forms → Sublists.… Continue reading Alternate solution to view Return Authorization in Invoice record
Filter the results in saved search using text
For example, if you want a saved search of sales order with orders created in specified month as mentioned as text, do the following – Create a saved search Goto available filters subtab, add Formula(Text) as an available filter Now, in criteria subtab add Formula(Text) Save the search Now search for the month Note –… Continue reading Filter the results in saved search using text
BLOCKCHAIN
A blockchain is a distributed database that maintains a continuously growing list of ordered records, called blocks. These blocks are linked using cryptography. Each block contains a cryptographic hash of the previous block, a timestamp, and transaction data. A blockchain is a decentralized, distributed and public digital ledger that is used to record transactions across… Continue reading BLOCKCHAIN
Feature to enable to base search results for popup lists on keywords
To view the record popup when you search a keyword in it, you have to enable a feature. Goto Home icon -> Set preferences -> Under Analytics subtab -> POPUP SEARCH USES KEYWORDS. Check this box to base search results for popup lists only on keywords that start with and include all the search terms entered. Popup… Continue reading Feature to enable to base search results for popup lists on keywords