Create Invoice for Company A, this will result toGL impact: Dr. Accounts Receivable – CompanyA Cr. Sales Accepts customer deposit from Company B, this will result to GL impact: Dr. Cash Cr. Customer Deposit – Company B Create a journal entry that will offset the two and thus allow application of payment and deposit on… Continue reading Charge one customer (Company A) for another customer’s invoice (Company B)
Month: March 2023
Item fulfillment via CSV import > tracking numbers with more than 12 digits (Numeric) are truncated when imported into NetSuite
Here are some ways to edit the csv file to show the correct format of the tracking numbers when imported into NetSuite. Option 1 On the Menu tab of the csv file > click Data > Import External Data > Import Data Locate the csv file that needs to be imported. Double click on the file.… Continue reading Item fulfillment via CSV import > tracking numbers with more than 12 digits (Numeric) are truncated when imported into NetSuite
Create a link to view Transaction search results that uses Group Summary
Create the Transaction Saved Search. 1. Navigate to Reports > New Search > Transactions > Create Saved Search2. On the Criteria tab***Type=Sales Order***Main line = F2. On the Results tab add the formula below.***Insert a new line on top of the list of fields on the Results tab.***Select the field “Formula (Text)”***Set Summary type to “Group”***On the Formula field, copy… Continue reading Create a link to view Transaction search results that uses Group Summary
Pop up user note when customer selected in sales order via Workflow
One option with no coding would be to have a non-stored custom field on the sales order that has source list=entity and source from=customer info. The alert can be done with a workflow. Below are the steps on how to create the workflow that will produce an alert when the client field is edited.1. Navigate to Customization… Continue reading Pop up user note when customer selected in sales order via Workflow
Difference between ?? , has_content , if_exists in freemarker
?? tells if the left hand operand’s value is missing (means it’s null or undefined variable), and gives back false otherwise true (not missing) accordingly. ?has_content is very much like ??, except it also returns false for a 0-length string or empty array, etc.but It doesn’t return false for a 0, boolean false, etc. !… Continue reading Difference between ?? , has_content , if_exists in freemarker
Add a circle in Advanced PDF/HTML Template
The border-radius is a CSS3 property and it is not available in CSS2. The Advanced PDF/HTML Templates only allow for CSS2 properties to be embedded at the moment, so any CSS3 property (including border-radius) will not be reflected in the printout. so use Corner Radius <div style=”width: 150px; height: 150 px; corner-radius: 80px; border: 1px… Continue reading Add a circle in Advanced PDF/HTML Template
Transactions > Customers > Issue Customer Refund > Unexpected Error: Transaction was not complete.
Use the standard form or customize the form and enable the Account form. 1. On the new refund page, check if the Account field is missing.2. If it is, customize the form and check the Account box under the Screen Fields tab > Main subtab.3. Save the form The account field is the bank account used for the… Continue reading Transactions > Customers > Issue Customer Refund > Unexpected Error: Transaction was not complete.
To add a file or folder to a bundle
Make the file or folder available for inclusion in a bundle: Go to Documents > Files > File Cabinet, and select the folder that contains the file or folder. Click Edit for the file or folder, and check the Available for SuiteBundles box.Folders and files with the Available for SuiteBundles option enabled are available on the Select Objects page of the Bundle… Continue reading To add a file or folder to a bundle
Render PDF using Suitelet and Set Filename via SuiteScript
Solution Deploy the following code on a Suitelet: function renderPDF(context){ var serverResponse = context.response; //Gets the response object var testData = ‘TEST BODY’; //Test string to be rendered as PDF var filename = ‘PurchaseOrder_123456.pdf’; //Sample File name to be set when downloaded serverResponse.setHeader({ name: ‘Content-disposition’, value: ‘filename=”‘ + filename + ‘”‘, }); //sets the filename to… Continue reading Render PDF using Suitelet and Set Filename via SuiteScript
ES6+ Features to Adopt in SuiteScript 2.1
SuiteScript version 2.1 is out of beta and beginning on the 2021.1 release, all SuiteScript 2.x scripts will be running as SuiteScript 2.1 by default, so you had better test your existing scripts for any bugs or declare them as v2.0 and wait until a later time to validate. To change your scripts to use SuiteScript v2.1… Continue reading ES6+ Features to Adopt in SuiteScript 2.1