Jesna John – Page 7 – knowledgebase JJ

Update a custom field automatically on time record when an invoice is created for Billable time

Requirement We need to update a custom field on time record, when an invoice is created for Billable time. Solution To achieve this result:Create a Transaction Line Field on the Time Tracking Record with Type = List/Record of Transaction, Applied To = Time, Display Type = Disabled Create a User Event Script deployed on Invoice with After Submit Function that stamps the Custom Transaction Line Field value with the created Invoice Number. The function will… Continue reading Update a custom field automatically on time record when an invoice is created for Billable time

Issue : Uncertainty in populating sublist values

Issue As per the requirement, the project task needs to be auto populated in Timesheet only when a project is selected and the project has only one project task. Client script field change was used the in scripts, but found an uncertainty in populating the project tasks. The project tasks populated correctly except in few… Continue reading Issue : Uncertainty in populating sublist values

Creating child sales order from a sales order

Requirement We need to create a child sales order from parent sales order. The child sales order must open in new tab when clicked on a button in parent sales order. And should populate with basic body fields. Solution

Project Task Auto Population In Timesheet

Requirement We need to populate the corresponding project task in the timesheet when the user selects the project. The population will only take place if the project has one project task. Solution We can create a client script and a suitelet script to populate the project task. When a project is selected in a time… Continue reading Project Task Auto Population In Timesheet

Downloading a file in PDF format from suitelet page

Requirement We need to download an invoice pdf from the listed invoices when clicking on the link provided against each line of invoices in suitelet page. Solution We can provide a suitelet link as download link. While clicking on the link, that particular invoice is downloaded in pdf format. This can be done by using… Continue reading Downloading a file in PDF format from suitelet page

Issue when suitelet page redirects to Netsuite Login

Issue The suitelet page will redirect to netsuite login page when open by clicking on suitelet URL Solution The suitelet page will open without redirecting to Netsuite Login page when the returnExternalUrl is set to true while calling the suitelet script from any other scripts. Following is the code snippet to set it true.

EDI Possibility in NetSuite

Requirement The client has a new requirement to check the possibility of integrating EDI with NetSuite. They need to have an opportunity to get them to invoice via EDI. At present they have a reasonably manual system where they compare the Bluescope invoice that comes through each day (samples attached) with the coils taken off… Continue reading EDI Possibility in NetSuite

Getting values from a saved search formula column

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

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