Articles tagged #OR
Articles tagged
#OR

Custom Role With Full Workflow Permission Could Not See Specific Workflow

There are scenarios when a Custom Role with full Workflow permissions is not able to view a specific Workflow. A possible reason for this is that the Workflow runs on a Record Type where the Custom Role does not have permission on. This article shows how to verify if the Custom Role affected has permissions for the Record Types configured on the Workflow.

Read More

Use Display in Web Store Field as a Condition Using Workflow

Use the Display In Web Store field as a condition on a Workflow for a Return User Error Action

Read More

Customize an A/R Aging Summary Report to Show Results for Specific Accounts Receivable Account(s)

To customize an A/R Aging Summary Report to Show Results for Specific Accounts Receivable Account(s) in NetSuite, perform the following steps:

Read More

Vendor Prepayment Application

After you enter a prepayment for a vendor, you must apply the prepayment against your vendor bills. Applying a vendor prepayment posts in the general ledger. The Prepayment account is credited, offsetting the Accounts Payable account. The application decreases the total amount you must pay to your vendor. If the prepayment application does not cover the total amount of the bill, you still need to complete the bill payment.

Read More

Block Custom Role User to Edit Item Rate on Sales Order When Custom Price Level Is Used

User with access to create a Sales Order has also the access to change the Unit Price in Sales Order's Line Item when Price Level is set to Custom.By choosing the Custom Price Level, user can replace the existing price to the custom one. Currently,Enhancement43422is logged for the ability to restrict custom roles to edit Price Level.

Read More

Rate Column on Sales Order Is Grayed Out

This article discusses on how to change the Rate on a Sales Order record.

Read More

Display Line Item Rate When Fulfilling Sales Orders

There are scenarios where users want to source the Item Unit Price (Rate) of an Item from their Sales Order form to the Item Fulfillment form. This can be achieved by creating a Transaction Line Field applied to the Item Fulfillment form.

Read More

Estimated Unit Cost in Inventory Adjustment for New Location (Multi-Location Inventory)

Scenario

When adding New Quantities viaInventory Adjustmenton a New Location, note that theEst. Unit Costwill default toZero. As there are no historical transaction yet for the Item on that Location, it is expected behavior that the Average Cost on that Location is Zero. Est. Unit Cost defaults to the Average Cost of the Item per Location and not the Average Cost on the Item Level. This means that the Item's Average Cost on the Item Level will not carry over to the New Location. The Average cost on the Item Level is the Average Cost of the Item across all locations. This is documented under the field help for the Average Cost on the Item. "This field displays the current average cost of the item across all locations. Using the weighted-average method, the average cost is calculated as the total units available during a period divided by the beginning inventory cost plus the cost of additions to inventory."

Solution

To be able to addCoston theItemon theNew Location, change theEst. Unit Coston theInventory Adjustmentfrom zero to a positive amount.

Read More

Payment Holds for Vendor Bills FAQs

Is the Payment Hold checkbox tracked in the System Notes?
Yes. System Notes logs when the Payment Hold checkbox is marked or unmarked.
Is the Payment Hold checkbox available in Saved Searches and Reports?
Yes. It is available in Saved Searches and the Open Bills Report.
Can the Payment Hold checkbox be set in the Vendor record?
No. It is a standard field in the Vendor Bill form. It is not available in the Vendor record form.
Can the Payment Hold checkbox be set to True by default on all Vendor Bills when they are created?
No. But it can be scriptable to set as True by default since it is on an existing record. It is also available for updates through workflows.
Is the Payment Hold checkbox available for Inline Editing?
No. It is not available for Inline Editing.
Can a Bill that has been partially paid be put on payment hold?
Yes, a payment hold can be put on a Bill with a status of either Pending Approval or Open. A Bill that is partially paid retains an Open status.
How to unmark the Payment Hold checkbox for Vendor Bills posted on a Closed Period?
Currently, there is no preference set to unmark the Payment Hold checkbox for Vendor Bills posted on a Closed Period. The period must be reopened in order for users to unmark the checkbox. However, this is not recommended. An alternate solution is to enable the Allow Non-G/L Changes since the Payment Hold checkbox is a non-affecting GL field. To enable Allow Non-G/L Changes: 1. Using an Administrator role, navigate Setup > Accounting > Manage Accounting Periods 2. Click the Closed period 3. Mark the Allow Non-G/L Changes box 4. Click Save Enhancement 329195 was filed in regard to this functionality. Note: To search and vote for Enhancement see 10054 Voting for Enhancements.

Read More

Create Expense Report Saved Search When Expense Report was Paid

User wants to pull out the date when an expense report was actuallypaid.

Read More

Saved Search > Expense Report with line attachment

In an existing Expense Report Saved Search, want to add the line attachment.

Read More

Create Rolling Sales Order Amount Saved Search/Report

Users may want to create aRolling Sales Order Reportfor forecasting and analyzing purposes based onSales Orders'Datefield with preferredSales Order Status.

Read More

Create Saved Search Version of Sales by Customer Report

Create a Saved Search version of Sales by Customer Report. The purpose of this will be to bypass certain customization limitations experienced in reports. Saved Search will allow for greater customization flexibility to best fit the user's business needs.

Read More

Saved Search for Item Usage

The user wanted to create a report that will show the total quantity of items used as Components and/or on Sales.

Read More

Create Custom Role That Is Able To Enter Memorized Transactions

An Administrator would like to have a custom role that able to enter memorized transactions.

Read More

Purchase Price Amount in Saved Search Results Is Different From the Amount on the Item Record

The Purchase Price Amount in the Results of a Saved Search is different from the amount on the Item Record.

Read More

Print Inventory Detail Using Source Code View in Print Packing Slip

Print the Inventory Detail column on the Packing Slip using the Source Code View.

Read More

Remove Parent Name and Display SubCustomer Name Only in Sales Order

When creatingSales Transactions such as Sales Orders for a Child Customer, the name displayed in the Customer field of the Sales Order is usually in this format:

Read More

Sample Functions of TO_CHAR

Please see table below for sampleFormula, andResultsof using differentParametersofTO_CHAR. These are just samples and the use is not limited to the list below.

Read More

Generating an Intercompany Sales Order

Before you can generate an intercompany sales order, you must create an intercompany purchase order.

Read More
Read More Articles