Invoice email script-payment

script that triggers only on Create context of Payment ,that will send the emailusing the email template “CTG-Invoice” to anyone with “receive invoice” (on the customerform, under Relationships) checkbox checked and terms not Empty. only send the email in the case of invoice is “Paid in Full”

How to change Product image with swatch colour

The main image of a configurable product changes with the swatch color tiles in Magento 2. However, there are a few settings to check if this doesn’t work out of the box. Update Product Preview Image In the product attribute section in Stores >> Attributes >> Product >> Color, make sure “Update Product Preview Image”… Continue reading How to change Product image with swatch colour

Balance difference in bank accounts in NetSuite and actual bank balance due to currency exchange rate fluctuation

Client came with  the requirement to balance the amount in particular bank a/c in a subsidiary which showed different amount than the actual bank balance in balance sheet  due to the exchange rate variation. Solution: Go to Transaction> Financial > Revalue Open Currency Balance(admin role) Select the period and the subsidiary in which the account… Continue reading Balance difference in bank accounts in NetSuite and actual bank balance due to currency exchange rate fluctuation

Creating Custom Advanced Templates for Pick Tickets

How do we add custom fields to a pick ticket You can modify pick tickets generated from released waves by customizing the advanced print template, Standard Pick Ticket/Pick Report PDF/HTML Template. You can display more fields on a pick ticket, update the field arrangement, and perform other such customizations. If you want to display more… Continue reading Creating Custom Advanced Templates for Pick Tickets

Creating a Custom Pick Ticket Saved Search

Ref : https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_158265656918.html To create a custom pick ticket saved search: Using the Administrator role, go to Lists > Search > Saved Searches.From the Saved Searches list, click the Edit link next to any saved search. On the address bar of the saved search page, replace the id value of the URL with -4389, without changing any other part… Continue reading Creating a Custom Pick Ticket Saved Search

Custom field in Inbound shipment to display item line total

Requirement: Need a custom body field in the inbound shipment record to display the total amount of all the item line amounts. Solution: Create a saved search that results the item line total and source it to a custom field.Create a transaction saved search of type Inbound Shipment. Add a formula(Numeric) field with formula –… Continue reading Custom field in Inbound shipment to display item line total

Purchases Workbook Templates (Suite Analytics Workbooks )

The following standard Suite Analytics Workbooks are available: Purchases (Billed) Workbook Purchases (Ordered) Workbook Purchases (Billed) Workbook The Purchases (Billed) Workbook includes predefined criteria and pivot tables to show we the status of bills received during the last month. These transactions are grouped and pivoted by item and vendor in the corresponding Pivot by Item… Continue reading Purchases Workbook Templates (Suite Analytics Workbooks )

Add subsidiaries to Customer/Vendor record in bulk

To add subsidiaries to customer/vendor records in bulk through CSV import. The subsidiary sublist is not available in the customer record option in import assistant. For that, we can select “Relationships” from Import Type drop-down and select “Customer-Subsidiary Relationship” from the Record Type drop-down. Map Customer name, subsidiary, and an optional External ID(for the customer-subsidiary… Continue reading Add subsidiaries to Customer/Vendor record in bulk