Fixed price item promotion

Go to Lists > Marketing > Promotions > New. Select Fixed Price Item Promotion from the SuitePromotions category. Enter a name and description for this promotion. Check the Inactive box if you want to make the promotion inactive but not deleted. If this box is checked the promotion will not be available for selection on a transaction. Enter a start… Continue reading Fixed price item promotion

SuiteQL Query Tool

The SuiteQL Query Tool is a NetSuite native application that can be used to run SQL queries directly within a NetSuite instance. With this free Suitelet, you can create and run SuiteQL queries, save queries to your File Cabinet, load queries from a shared hosted query library, and much more. The tool also includes the… Continue reading SuiteQL Query Tool

Adding Surcharge Line Item on Invoices

User wants to add Tariff Surcharge Line Item on Invoices. Create a new Markup Item Record Navigate to Lists > Accounting > Items > New New Item > Item Type Select Markup Item Name/Number: Enter Item Name/Number Rate: Enter Rate (e.g. 10%) Note: A percentage discount must be followed by a % sign. A dollar amount should be entered as a positive number. Click Accounting tab Account:Select Account Name Click Save Create an Invoice Record Customer:Select Customer… Continue reading Adding Surcharge Line Item on Invoices

Subsidiary Address in Packing Slip PDF

To fetch the subsidiary address field in the Packing slip PDF, we can use the “subsidiary.mainaddress_text” where the mainaddress_text is the internal id of the address field in Subsidiary record. On saving the Advance PDF template, an error will be thrown but proceeding with Save will fetch the value properly in the PDF.

Item Fulfilment link in Bill Credit

Item Fulfilment created from Supplier Return Authorization need to be displayed in the associated Bill Credit as links. The only link between the Supplier Return Authorization, Packing Slip, and Bill Credit is the SRA number. As we could not link the Packing Slip directly with Bill Credit, created a saved search which lists the Packing… Continue reading Item Fulfilment link in Bill Credit