Author: Diniya A J

STANDARD COST IMPORT SETUP

REQUIREMENT: Context: The client is using a Standard Cost for both the Assembly and Inventory (its components). The count of Assembly is around 1k, the count of Inventory (RM) is around 3k. Concern: I need to perform Inventory Adjustments to the newly imported Assembly and Inventory (RM); however, upon saving Inventory Adjustment transaction I get this error: “Inventory… Continue reading STANDARD COST IMPORT SETUP

Apply dashboard appearance to all users

REQUIREMENT: I am as administrator and i have setting dashboard for employee center type, I’d like to apply this dashboard to all employee center. how to do it ? ANSWER: Currently, without the SuitePeople HR module, NetSuite does not support publishing dashboards to Employee Center users. There is a known Enhancement : 537835 Setup >… Continue reading Apply dashboard appearance to all users

How to include Journal in Purchases By Vendor Report?

REQUIREMENT: Curious if anyone else has run into this and/or has a solution. I ran a Purchases By Vendor report and realized that Journal Entries were not included (I was looking at a particular vendor that I do not necessarily create Bills for, but know we have expense recorded through JEs). I also included the… Continue reading How to include Journal in Purchases By Vendor Report?

WIP and Inventory Costing

Requirement: NetSuite help says that an item with FIFO/LILO costing method is not compatible with manufacturing WIP. Is this just from a costing standpoint? If I take an item master that has a FIFO costing method, this is confirmed because the WIP box at the inventory location section is grayed out. Items masters assigned the… Continue reading WIP and Inventory Costing

Syntax for days until a future date function in Analytics dataset

Need to create a function in an Suite Analytics dataset that will calculate the days between TODAY and a future date for a dashboard inventory availability tracker. The future date is a transaction field. Simple functions like {Current_Date}-{Future_Date} dont work & looking for options took me on a circular journey through CASE statements, CAST statements… Continue reading Syntax for days until a future date function in Analytics dataset

Move WHT columns on Vendor bill

Want to move these columns to the left, how to do it ? Answer: At the moment, this functionality is currently unavailable. The ability to move or re-order the Expenses and Items subtabs is currently tracked under Enhancement 58415: Customize Transaction Forms – interchange the position of Expenses subtab and Items subtab.

Inventory Valuation report showing the valuation by Lot Number

Customize the Inventory Valuation report and add a column to show the valuation per lot number, but don’t see this column available. Answer: The reason why you aren’t seeing any column to show the valuation per lot number is because it is a current system limitation, thus a standard behavior in the system. This is… Continue reading Inventory Valuation report showing the valuation by Lot Number

Can’t find the Budget Category List & Multiple Budget feature in oneworld

Can’t find the Budget Category List & Multiple Budget feature in OneWorld. To create a budget category, navigate to Setup > Accounting > Setup Tasks > Accounting Lists > New, and choose Budget Category from the list. Solution: Please note also that Multiple Budgets feature is an add-on module which is part of the Advanced… Continue reading Can’t find the Budget Category List & Multiple Budget feature in oneworld

Custom Field on Quota

Enhancement 182053 Transaction > Forecast/Quota > Establish Quota > Ability to customize the Establish Quota Page and be able to add custom fields