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.
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.
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.
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.
How To Handle Returned Customer Check with related Deposit
Scenario
Solution
- 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
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.
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.
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.
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.
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.
Write off Bad Debt Through Accept Customer Payments
User is interested in writing Off Bad Debt through Accept Customer Payments page.
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.
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.
Mass Delete Item Records through Inline Editing
To be able to mass delete Item Records using the Inline Editing function.
Quantity Committed is Greater than Quantity On Hand in Reallocate Inventory Page
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.
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.
Create Search for all Customers with no Transactions
Scenario
Solution
2. ClickCustomer
3.Search Title:EnterTitle
Example:Customers With No Related Transactions
4. ClickCriteria
5. ClickStandard
6.Filter:
- SelectStage
- Stage:SelectCustomer
- ClickSet
- Summary Type:SelectSum
- Field:SelectFormula (Numeric)
- Formula (Numeric):Select isequal
- ClickSet
- Formula:EnterDecode ({transaction.number},NULL, 0,1
9.Field:
- SelectName
- Summary Type:SelectGroup
- SelectFormula (Numeric)
- Summary Type:SelectSum
- Formula:EnterDecode ({transaction.number},NULL, 0,1)
Void Bill after Bill Payment/Check is Voided
Preference can be checked by Navigating toSetup>Accounting>Accounting Preferences>GeneralTab >Void Transactions Using Reversing Journals.