Card State in the Credit Cards subtab of the Financial tab in the Customer Record

1.    UnknownThis state is used once the credit card is created or updated. 2.    OKThis state indicates, that the last authorization was successful and the card is absolutely valid. 3.    InvalidThis is the situation once a credit card expires and is replaced by a card with a different PAN. Payments cannot be processed but this card can still… Continue reading Card State in the Credit Cards subtab of the Financial tab in the Customer Record

Subtotal For Transactions Search

1. Navigate to Reports > Saved Searches > All Saved Searches > New.2. Choose Transaction.3. Under Criteria tab > Standard subtab, set Main Line = T.4. Click the Results tab > Columns subtab, set the following:    – Document Number    – Formula (Currency)         Formula = {amount} – nvl({taxtotal},0) – nvl({shippingamount},0)        Label = Subtotal    – Amount (Tax Total)    – Amount5. Click Save & Run. NOTEPlease make sure that you are selecting the correct CONSOLIDATED EXCHANGE RATE under the result section.

Create a Link that Opens a New Email Message with Default Email Template

Navigate to Home > Set Preferences > General tab > Defaults section to check Show Internal IDs. Click Save.  Navigate to Lists > Employees > Employees. Take note of the Internal ID of the Employee record where you want the message to be stored. Navigate to Documents > Templates > Email Templates. Take note of the Internal ID of the Email Template you want to use.  Navigate to Customization > Centers and Tabs > Center Links. Provide a Label (e.g. New Email Message). For the URL, use… Continue reading Create a Link that Opens a New Email Message with Default Email Template

Proposal For Custom Page to Send Invoice Email

Proposal summary The proposal summarizes the details about the custom suitelet page which helps the user to preview invoice print and send mail to the user based on the invoice record. It includes email template creation and automatic email sending for specific customers. Prerequisites Macrofin needs to ensure that all the invoice via checkbox in… Continue reading Proposal For Custom Page to Send Invoice Email

Develop the Label PDF template

OTGN-776 Develop the Template as per the given mockup and dimensions The number of IFs in the print document will be based on the number of IFs selected in each pagination. And the print will have multiple pages for the same IF based on the number of pallets in  the Pallet information sublist.  Need to… Continue reading Develop the Label PDF template

TimeSheet is not updating for a particular employee

Scenario One of the users is trying to input the weekly timesheets but the system is not saving and giving the error message. For the rest of the employees, there is no issue and the timesheet is able to save successfully. Solution Checked the employee record. Under the Human Resouce subtab, there is a field… Continue reading TimeSheet is not updating for a particular employee

Vendor Name is Not populating in the Sales Order item line

The client has recently reported an issue where the PO vendor name is not populated when the user selects an item. There is no script is used for the value population. Solution We have checked the item where the client reports the issue. In the item record, there us a subtab named “Purchase and Inventory”… Continue reading Vendor Name is Not populating in the Sales Order item line

Unbilled Cost report in project management.

Question In the project management, The “Unbilled Cost report” shows only the approved expense report whereas the “Unbilled Time report” shows both approved and unapproved times. Is this a standard behavior of Netsuite? Is it possible to show an unapproved expense report in the Unbilled cost report? Answer Per checking, this is the behavior of… Continue reading Unbilled Cost report in project management.

Transfer PDF From Inventory Adjustment

We need to generate a transfer form print from the inventory adjustment. Our Solution  In the NetSuite standard, we are not able to generate the standard printout for the Inventory adjustment  record. This can be achieved by creating a script for adding a custom button named print transfer order in the inventory adjustment record for… Continue reading Transfer PDF From Inventory Adjustment