Error: “Negative Bill Payment Is Not Allowed” on Bill Payment When Applying a Credit to a Bill With Smaller Amount

This is the expected behavior of NetSuite. Negative Bill Payments are not allowed. In order to save the Bill Payment, the user will need to edit the Vendor Credit Payment Amount to be lower or equal to the Vendor Bill Amount (maximum to zero out the Vendor Bill). Click View Vendor Bill Click Make Payment Click Apply tab Apply: Enter Checkmark by Bill… Continue reading Error: “Negative Bill Payment Is Not Allowed” on Bill Payment When Applying a Credit to a Bill With Smaller Amount

Enabling Negative Inventory Validation

To enable negative inventory validation: Go to Lists > Enhanced Validations > Enable Validations > New. On the Enable Validations/Default Discount page, select Negative Inventory Validation in the Transaction Validation Type field. In the Transactions with Validation/Default Discount field group, select the transactions where you want the validation to apply. Click Save.

Adding Items to a Check

Items are goods and services that you acquire. When you write a check, you can add items from the list of items you set up. To add items to a check: Go to Transactions > Bank > Write Checks. On the top of the Check page, enter information about the payee, dates, the amount of the… Continue reading Adding Items to a Check

Limitations for Creating Transactions

When creating a transaction, the total number of lines per transaction should not exceed the following limits: Transactions with more than 1,000 lines may negatively affect Netsuite’s performance or cause timeouts. Type of Transaction Line Limit Details Expense Allocation Schedules 10,000 Creating Expense Allocation Schedules Journal Entries 200 Journal Entries Revenue Recognition Journal Entry 1,000… Continue reading Limitations for Creating Transactions

Charge one customer (Company A) for another customer’s invoice (Company B)

·        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)

Concatenate 3 fields on the results of a Saved Search

To concatenate 3 fields on the results of a saved search, do the following: 1. Create a saved search, List > Search > Saved Searches > New. 2. You may select any search type, for this example select Customer. 3. Navigate to the Results tab and add the field “Formula (Text)” and enter the following as the value of… Continue reading Concatenate 3 fields on the results of a Saved Search

Unapply the Payment applied to an Invoice and reverse the impact of the Payment record

User creates a payment record and applies it against an invoice but later on the payment becomes invalid. To resolve, user needs to follow below steps: I.             Unapply the Payment from the Invoice record 1. Pull up the Payment record on edit mode. 2. Under Apply tab > Invoices sub tab, unmark the Apply box for the invoice it was applied to. 3. Hit Save button. II.          Reverse the… Continue reading Unapply the Payment applied to an Invoice and reverse the impact of the Payment record

Format and Specify Rounding of Formula(Numeric) on Saved Searches

You want to create a sales search and divide your sales amount by 3. You want the result to use the format 999,999.9999 1.       Lists > Search > Saved Searches > New : Search Type= Transaction 2.       Criteria tab a.       Type = Invoice b.       Main Line= True 3.       Results tab a.        Name b.       Number c.       Amount d.       Formula (Numeric) ; Formula: To_char({amount}/3,’999,999.9999′) 4.      Save and Run 5.       Sample Preview: Name Number… Continue reading Format and Specify Rounding of Formula(Numeric) on Saved Searches

Include Shipping Cost in the Return Authorization

Shipping Cost of orders are not carried over into the Return Authorization screen. Currently, it is still an enhancement under issue # 102685: Return Authorizations > Would like to carry the Shipping Cost into the Return Authorization when issuing the Refund. The reason why the behaviour is like this is because technically we cannot receive again… Continue reading Include Shipping Cost in the Return Authorization