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?
Author: Diniya A J
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
Creating a Sales Order saved search and used the document number as a filter. The Show in filter reg
why is the “Show in Filter Region” Greyed Out. need to use the document number as a filter. SOLUTION: As an alternate solution, use the Document Number/ID field instead. To set Document Number as an available filter: Navigate to List > Search > Saved Searches Click Edit next to a Save Search Under the Available… Continue reading Creating a Sales Order saved search and used the document number as a filter. The Show in filter reg
Parent Child Relationship – Invoicing
Is it possible if I create Sales Order against the child customer but invoice it against the Parent Customer?Also In the Enable features I have marked the consolidated Payment check box as true. Solution: no – invoices are to the child customer level, but the consolidated payment feature will allow the invoice to be paid… Continue reading Parent Child Relationship – Invoicing
How to cancel Transfer Order remaining quantity
REQUIREMENT How can I cancel the remaining quantity on TO? For example, Transfer Order quantity is 100 PCS, from Warehouse A to Warehouse B. Warehouse A fulfills 100 PCS, IF quantity is 100. When Warehouse B receive the TO, they check the inventory, there are only 80 PCS, 20 PCS are left in Warehouse A,… Continue reading How to cancel Transfer Order remaining quantity