• Home
  • /
  • Jcurve Support Articles
Articles written by Pattranit Lakhan
Articles written by
Pattranit Lakhan

Role Is Missing Under the Roles Subtab of a Saved Search

Some roles are missing under the Roles tab of a Saved Search.

Read More

Return all Invoices of Sub-Customers based on its Parent Customer in Print Checks and Forms > Invoices

User needs to pull all invoices for a customer and its sub customer, however theCustomerfilter is not available in aOne World Account.

Read More

Search for Entity Bank Details Without Parent Entity

Entity Bank Details are usually created from Customer or Vendor record. This way, the Entity Bank Details record is directly linked to the Customer/Vendor as its Parent Entity.

Read More

Associate Vendor Credit to a Refund in Foreign Currency

If the vendor in a foreign currencysent a refund by cash or check in a currency other than the vendor's currency, user needs to record the deposit in the vendor's currency via a journal entry.

Read More

How To Handle Returned Customer Check with related Deposit

Scenario

A Check is returned due to insufficient funds. The check is related to a Deposit. User does not want to unapply the Deposit on the Payment record nor delete the Payment record.

Solution

1. Unapply thePaymentfrom theInvoice
  • Payment:ClickEdit
  • Go to theApplytab >Applied Tosubtab
  • Invoice: RemoveCheckmark
  • ClickSave
  • Open theInvoiceand note that theStatusof the Invoice should beOpen

2. Create aCustomer Refund
  • Navigate toTransactions>Customers>Issue Customer Refund
  • Customer Name: EnterName
  • Go to theApplytab >Creditssubtab
  • Apply: EnterCheckmarkfor thePaymentthat was unapplied on Step 2
  • Go to theRefund Methodtab
  • Refund Method: Select aPayment Method
  • ClickSave

Note:Below are the transactions that and a sample of what the G/L Impact would look like:1.Invoice> Debit: A/R > Credit: Revenue2.Payment> Debit: Undeposited Fund > Credit: A/R3.Deposit> Debit: Cash > Credit: Undeposited Fund4.Customer Refund> Debit: A/R > Credit: Cash

Read More

Using Terms of Payment

After you have created a term record, you can select that term on invoices and customer records to set payment terms. When you select a term on a customer's record, that term defaults on bills to the customer. You can also set terms on each invoice individually.

Read More

Budgets in NetSuite

You can save estimates of income and expense as budgets for financial planning purposes. In NetSuite, each budget covers a year and permits the entry of an amount per account for each accounting period in the year. Budgets provide information for reports. They do not control actual income and expense.

Read More

Clear Beginning Balance of No Customer/Job in A/R Aging Report

Customer wanted to clear the beginning balance of No Customer/Job in A/R Aging Report throughTransactions > Financial > Make Journal Entries.

Read More

Approval Information Subtab on the Human Resource Tab Is Missing on SuiteApprovals

After installing theSuiteApprovalsBundle on an account, upon moving to the step where it is needed to set upEmployee Approval Information,theApproval Informationsubtab on theHuman Resourcetab is missing.

Read More

Field Group Tab Is Missing When Customizing a Custom Entry Form

One of the possible reasons why the Field Group tab is not available when trying to add or edit a field group on a custom form, is because the user is still using an old version of the custom form that came from a custom bundle.

Read More

Write off Bad Debt Through Accept Customer Payments

User is interested in writing Off Bad Debt through Accept Customer Payments page.

Read More

Resolve Undelivered Emails

To remove an email address from the Bounced Email Addresses list.

Read More

Accepting a Customer Payment to Write Off Bad Debt

After you have entered a journal entry to write off bad debt, the next task is to accept a customer payment.

Read More

Sales Order with Discount Item > Sales Order status is always Pending Fulfillment with No Fulfill button and Cannot be Closed

Sales Order should now beBilled.

Read More

Mass Delete Item Records through Inline Editing

To be able to mass delete Item Records using the Inline Editing function.

Read More

Quantity Committed is Greater than Quantity On Hand in Reallocate Inventory Page

Why is the Quantity Committed appears higher than Quantity On Hand in Reallocate Items page?
The Quantity Committed appears higher than Quantity On Hand is because it already includes the Quantity Picked. This also happens when there are frequent changes made on the Accounting Preference: Fulfill Based on Commitment per Audit Trail of Preferences via Setup > Accounting > Accounting Preferences > More (located at upper right side of the page) > Audit Trail. When the Accounting Preference: Fulfill Based on Commitment is set to Allow Uncommitted, and a Sales Order, from which the quantity is on back order, is fulfilled to Picked Status, the Quantity Committed increases while the Quantity on Hand remains.

Read More

Resolve Users Who are Allowed to Fulfill More than the Quantity on hand When Fulfill based on Commitment setting is set to Limit to Committed

System allows fulfilling of Sales Orders more than current Quantity On Hand even if Fulfill based on Commitment setting is set to "Limit to Committed" and the user is fulfilling items using the Standard Sales Order Form.

Read More

Add AR Aging Summary Report to Home Dashboard

The only way to add the AR aging summary report to Home Dashboard portlet is by way of creating a standard KPI - Receivables. The KPI provides a link to the report. When you click on Today in the KPI, the AR aging summary report opens. The report is not available as a snapshot.

Read More

Create Search for all Customers with no Transactions

Scenario

Create a saved search that will show all customers with no related transactions.

Solution

1. Navigate toLists>Search>Saved Searches>New
2. ClickCustomer
3.Search Title:EnterTitle
Example:Customers With No Related Transactions
4. ClickCriteria
5. ClickStandard
6.Filter:
Note:For every required field use the drop-down menu to select it and once adjusted click Add if
needed.
  • SelectStage
  1. Stage:SelectCustomer
  2. ClickSet
7. ClickSummary
  • Summary Type:SelectSum
  • Field:SelectFormula (Numeric)
    1. Formula (Numeric):Select isequal
    2. ClickSet
  • Formula:EnterDecode ({transaction.number},NULL, 0,1
8. ClickResults
9.Field:
Note:For every required field use the drop-down menu to select it and once adjusted click Add if
needed.
  • SelectName
    • Summary Type:SelectGroup
  • SelectFormula (Numeric)
    • Summary Type:SelectSum
    • Formula:EnterDecode ({transaction.number},NULL, 0,1)
10. ClickSave & Run

Read More

Void Bill after Bill Payment/Check is Voided

Preference can be checked by Navigating toSetup>Accounting>Accounting Preferences>GeneralTab >Void Transactions Using Reversing Journals.

Read More
Read More Articles