Angel Maria P Davis – Page 3

Error when sending email to vendor

When sending payment notification mail by the system an error shows as “Permanent Failure: Bad destination mailbox address” and the mail is not delivered to the recipient. Solution: This error is shown because the mail address does not exist. Update the mail address with a valid mail address. The mail address shows in the vendor… Continue reading Error when sending email to vendor

Set up Inventory Count for items

Inventory count is a feature in NetSuite to track the on-hand item quantities of the item as stock that will reduce overhead costs in the business. Suite answer- 30576, 28061,30577, 28000, 28071 Enable the Inventory count feature Go to Setup > Company > Setup Tasks > Enable Features. Click the Items & Inventory subtab. Check the Inventory Count box. Click Save.… Continue reading Set up Inventory Count for items

Import of bill credit

To import the Bill credit from the raw data prepare the import file in CSV format Sample model To import the file Setup> import/export> Import CSV files Run/ Save and run the import. We can see the import status by checking the job status.

Location import

At the time of data migration, we have to import the locations to the Net suite from the client’s server. To import the location prepare the template for the location. Sample template file. Import the file in to net suite Setup> Import/ export> Import CSV records Select the file that you want to import. Map… Continue reading Location import

Bill Of Material Import

A Bill of Materials (BOM) includes the quantities of raw materials, assemblies, sub-components, and parts needed to manufacture a product. To import the BOM create the BOM template based on the requirement. To import BOM Setup> Import/ Export> Import CSV records. Enter the import type ” Supply chain”, Record Type- “Bill of Material” Add the… Continue reading Bill Of Material Import

Mapping Fields In Journal Entry Import

The mapping of fields is an important step when importing data. When preparing an import file in a single file format, you have to import both line fields and body fields. The sub-list data consists of multiple lines for each sub-list item, you must provide a mapping to identify the record to which the sub-list belongs.… Continue reading Mapping Fields In Journal Entry Import

Saved Search to see if there are any attachments in the record

The client wants to see a field in the saved search to show whether the record is attached with any files or not. If there is an attachment the field should show “Yes” otherwise the field should show “No” Formula CASE WHEN {custrecord_attached_url_case.internalid} IS NOT NULL THEN ‘YES’ ELSE ‘NO’ END

Import of closed A/R or A/P transactions

When we migrate the transactions from the client’s computer there will be some transactions that are closed ones. To add these transactions we have different methods. We can import these transactions as journal entries. When importing the journal records we have to find out which of the accounts should be added for each transaction. Import… Continue reading Import of closed A/R or A/P transactions

Find Employee Center License Users

The client wants the details of the employees that have an employee center license. Solution Download the roles of each employee. From that excel identifies the employees who have only an employee center role. For that use “countif” function. Eg:=COUNTIF(A:A,A2)>1 The file should be as follows. This formula will show the true or false values.… Continue reading Find Employee Center License Users

Adding A Week field In The Workbook

The client wants to add a week field in the workbook. The week format should be week number/month/year Solution Add a formula field to see the week. Add the below formula to see the week number. ‘W’||to_char({trandate},’IW’)||’/’||to_char({trandate},’MON’)||’/’||to_char({trandate},’YYYY’)