Requirement Formula columns are all named the same internally, which is why you can’t directly get their values individually. For instance, if you have two Formula (Numeric) columns in your search, both internal column names will be “formulanumeric”. Therefore, using getValue(‘formulanumeric’) will get only the first formula value. Solution
Month: March 2022
Item Cost Changes for Selective POs
Requirement We need to ability to select the purchase orders for updating the line-level item cost. We need to update the none of PO status closed, canceled and billed PO’s with the new item rate when it is being updated in the item record. But this should not update the item cost for all the… Continue reading Item Cost Changes for Selective POs
Item Cost Auto Update in Open POs
REQUIREMENT The requirement is that need to update the none of PO status closed, canceled and billed PO’s with the new item rate when it is being updated in the item record. SOLUTION Client script for to check if the item rate is changed in Item Record A custom record is created to store the… Continue reading Item Cost Auto Update in Open POs
Sales Order Customization
Requirement We need to create a new button in the sales order and if the user clicks the button, a new sales order will open and the body fields will be populated from the parent sales order (Except some fields like date). User will enter the item lines manually and save the child sales orders.… Continue reading Sales Order Customization
Double Entry of the Same Customer PO
Requirement Need to prevent the double-entry of the same Customer PO. We can prevent this by using a client script. We can show an alert message while trying to save the record This alert also prevents the user from saving the sales order record.To check the double entry, we will check if there are any… Continue reading Double Entry of the Same Customer PO
Customize Item Fulfillment Email
Requirement Need to add a field into the customize fulfillment email for eg: Tracking Numbers Solution Navigate to Setup > Accounting > Customize Fulfillment Email. Copy the Default Text and paste it in the Customization box. Remove {7} in the Customization box. Add the following to the Item Fulfillment codes: Tracking numbers:<br> <%=getCurrentAttribute(‘salesorder’,’linkedtrackingnumbers’)%><br><br> 5. Click Save.
Saved search code to consider top level parent customer
Requirement We need to consider customer that are top level parent in saved search . Solution Following code snippet provides the saved search code to consider the parent level customer.
Hide Buttons On View mode of a record
Requirement We need to hide some buttons on view mode of the draft invoice on Employee Center Role. Solution
Adding hyperlink in saved search column
Requirement Add a hyperlink in saved search to open the particular purchase order. Solution Following code snippet is a saved search code having hyperlink that open up a purchase order.
CSV Import of journal entry error message: The amounts of this journal entry must balance by location.
There are two possible reasons why a CSV results to an error: “The amounts of this journal entry must balance by location”. Enable the preference Allow Non-Balancing Classifications in Setup > Accounting > Preferences > Accounting Preferences > General Tab > Classifications. Checking this box means that the user prefers NetSuite to not require Journal Entries to balance… Continue reading CSV Import of journal entry error message: The amounts of this journal entry must balance by location.