There is an inventory Item: Inventory Item – NetSuite (Bloom & Grow Ltd) Item Name: TK-KYTE-STORM internal ID:420619 This particular item is not appearing in the results when conducting a Saved Item Search. This item satisfies all the condition mentioned in the criteria Saved Search : pricing 2: Results – NetSuite (Bloom & Grow Ltd)… Continue reading Inventory Item not showing up in Saved Search
Author: Praiselyn Fiana D
Sales Report by Sales Territory
Requirement :User would like to create a new Sales Report by Sales Territory, Sales Rep and Partner. Solution: Navigate to Reports > New Reports Select Sale Order Transactions On the New Sales Order Transactions Report page, set the following: Metric = Aggregate Amount Report Format = Matrix Component = Customer/Job Field =Account Number Column = Customer/Job Click More Customization On… Continue reading Sales Report by Sales Territory
Sales Tax Liability by Tax Item Report
The Sales Tax Liability by Item report shows sales tax liabilities that have accrued for the date range selected and the amounts due as payable at the end of that date range and these liabilities are grouped by tax code. The following columns are included in this report: Tax Rate – this column shows the percentage… Continue reading Sales Tax Liability by Tax Item Report
Error “This record doesn’t exist”
We have successfully installed and configured FEFO Lot Assignment SuiteApp in NetSuite Account. We have also created test sales order an item fulfilments. Sales Order – NetSuite (Bloom & Grow Ltd) However, these Sales Order records are not visible for another user who is using Operation Executive CNHK role. They are getting the message, “This… Continue reading Error “This record doesn’t exist”
Search for Custom Duties applied in Item Receipt.
Requirement: User need a report that shows computation of the custom duties added to an item through Item Receipt Transaction to help better understand the breakdown of costs of inventory and a summary of landed costs. Solution A saved search can be customized to show total landed cost assigned to an item receipt transactions. Navigate… Continue reading Search for Custom Duties applied in Item Receipt.
Encountering error while Assigning and Fulfilling using FEFO Lot Assignments Suite App
“We have installed FEFO Lot Assignments SuiteApp and configured the same. However, when we click “Assign and Fulfil” button in Sales Order, we are getting an error message, “The script for assignment and fulfillment failed. Please try again.” Could you please check and let me know what function hinders the running of script or where… Continue reading Encountering error while Assigning and Fulfilling using FEFO Lot Assignments Suite App
“You can only cancel orders without shipped fulfillments.”
Scenario: While cancelling the Sales Orders users are getting this message, even though no fulfilments are associated By design, only Sales Order with Pending Approval status can be Cancelled. However, when a Customer Deposit with Fully Applied status is found on the Sales Order, the system will not allow the order to be cancelled. Solution Please… Continue reading “You can only cancel orders without shipped fulfillments.”
Receive an expiration warning when a lot is about to expire.
To set the preference to receive an expiration warning, Go to Setup > Accounting > Preferences > Accounting Preferences (Administrator). Click the Items/Transactions subtab. In the Days Before Lot Expiration Warning field, enter the number of days in advance of a lot item’s expiration to receive a warning.
Concurrency in NetSuite
Concurrency in NetSuite refers to the ability of multiple users to access and manipulate data in the system simultaneously without conflicts or data inconsistency issues. NetSuite employs several mechanisms to ensure concurrency, including locking mechanisms and record-level security. Locking mechanisms in NetSuite control access to records and prevent multiple users from making conflicting changes. When… Continue reading Concurrency in NetSuite
Vendor Quantity Pricing Schedule missing in the Item Record
The pricing schedule does not appear it is most likely that there is no assigned Units Type and Units. Go to the Vendor Record > Financial > Pricing Schedules Click on the Pricing Schedule Click Edit Select a value in the Units Type and UnitsNote: Make sure that these match with that of the item record Click Save