For inventory items, are there any benefits for defining an item as a subitem of another item? I'd say that the primary benefit is for reporting. NetSuite reports will automatically total/sub-total for each level in the Item hierarchy, including the actual item of course. This allows you to quickly see as much, or as…

Why should we have to ignore this function? I know....we all have been complaining about it for years. Just hope, one year, Netsuite fixes this embarrassment... Was anything said about this in the Suiteworld conference? Bill What I mean is that the functoin doesn't work as advertised. So if you want to export ALL your data…

Do a search in this User Group and you will find many posts stating that "Export Full CSV" doesn't come close to exporting all of your data in NetSuite. Just ignore this function. ;)

To add even more concern to the issue that the Sales Rep cannot access the Customer record AFTER an "other relationship" is created with a Vendor, I have just confirmed with NetSuite Support that it is NOT POSSIBLE to remove or unlink the "other relationship". Also, if you set either of the linked records inactive the…

. . . Is there a way to receive and fulfill individual members of an assembly without having to build an assembly for each order? Thanks, this is way beyond me, but it is a mess right now, and I need to fix it. Julie Julie, There are 4 basic ways to generate inventory for Assembly Items:[LIST=1] [*]Assembly Builds -- which…

I'm planning to use classes to capture sales by Counties in the US. That's approximately 10,000 counties (classes). From what I understand is that the cap for locations is due to performance issues with inventory, bins, sales tied to reporting. Do you know if there is a similar issue with department and classes? Thanks in…

Steve, Welcome to the wonderful world of Assembly Builds! In response to your questions:[LIST=1] [*]We have been using Service Items for Purchase without any problems.[LIST] [*]The value entered on the Purchase Price is correctly used to calculate the Assembly Item asset value[/LIST] [*]If you need to use a purchase price…

Standard procedure is to use a non-inventory, or service item. Do not use Inventory Items unless you are trying to setup a payroll workaround or something. If you just want to hit GL, use a Service item. How do you handle differences in actual hours used/paid for doing the assembly vs what you assumed in the assembly BOM?…

For the case of Assemblies, you don't need to use an Inventory Item, and you really shouldn't (since then you have to worry about creating stock for it). Adding a Service/Non-Inv/Other Charge is the way to go... Well, maybe we should take this discussion to another thread. You may be right Olivier, but we made the decision…

You dont need to use an inventory item for the labour. I think to do this would be confusing. We set up a Service Item for our different types of labour. We coded these to an expense account in the GL for Labour Recovery and put in the purchase price as the hourly / per min rate. We were then able to add the service item…

We use inventory items to model labor costs for our assembly builds.

I'm not sure this is possible, but my bosses would like to make it so. We would like to be able to present an invoice to our customers with our charges summarized. For example: Item A $100 Item B $400 Item C $1000 We would like to be able to account for the 3 items seperately, but we want the customer to see on the…

Please vote for enhancement number 25278. Thanks. Peter Peter, can you please explain the difference between "standard cost accounting" and the method that NetSuite uses/supports? Thanks.

Does anyone know if NetSuite can work with standard cost accounting? Apparently the variance analysis in standard accounting offers some significant benefits in a manufacturing company. I only see LIFO, FIFO and Average Cost as options. If not are there any workarounds? Thanks Preeth Preeth, Can you please provide a…

Customer Record > Info Tab > 'Send Transactions Via' field Field Level Help Reads: Set a preferred transaction delivery method for this customer. . There is a HUGE problem with setting these fields: As soon as you save the transaction (like an invoice), the transaction is sent WITHOUT ANY WARNING. This is very dangerous!…

I think the PO has a "close" button. That will "void" the transaction. -Andrew Does the "Close" button have any purpose other than to "void" the transaction? What about the PO Status? Does a status of "Closed" really mean "Voided"? If so, then I wonder why it is not named "Voided" so as to be much more clear to everyone?

Hi James, Currently, there is no link available that will take you to the list of Purchase orders or any transactions that needs to be E-mailed. However, if you know what's common to your purchase orders, you can email them by batch. Mass update now supports "To be emailed" box and if you can filter out those Purchase…

I would like to request your help if you've voted for enhancement #94013, "Ability to customize the system generated email notifications for Sales Orders, Fulfillments and Invoices." . . . If any UG-goers have feedback on this topic, I would greatly appreciate it. Malin, Thanks for asking for our input. Much appreciated. I…

Hi All, Can anyone tell me how unit cost is stored in Item Records and accessed by Sales Order transaction form? I cannot find the 'Unit Cost' anywhere in the Item or the Sales Order. What is the functionality being used behind the 'Purchase Price'? I found out that it is based on the quantity. Based on which quantity…

Agreed. This need to be changed to by default the include transaction box is checked.

I've written code on Quotes that could be ported to Sales Orders which calculates the Gross Margin per line item. If you're interested, let me know. David, I am interested in your Gross Margin code.

Defintiely doable via suitescript, using a class custom field on the customer record and a before submit SUiteScript to assign it in the sales order. Thanks, -e That's exactly what we are doing. Works great.

I'm a bit confused with how NetSuite voids transactions (e.g. purchase orders, bills etc.) when the 'Void Transactions using Reversing Journal' is disabled. It only updates transaction amount to zero and memo to 'VOID'. For example, if PO status is 'Pending Supervisor Approval', at the time of voiding, NetSuite will update…

Chris, Thanks for your reply. I really appreciate your thoughts and suggestions. Is this a budget or a quota? Its a budget. If it's a budget, what will the actuals be? Since all the Budget to Actual reports are in base currency (of the top level parent in OneWorld), I'm just not seeing those as being particularly useful…

This functionality is coming in version 2009.1 early next year. Thanks, -e Excellent! This will add a lot of effective functionality to the Saved Search feature.

Today, when you use Accept Payments Through Top Level Customer, and create a payment to apply to a sub-customer's invoices, all the payment transaction lines are linked to the parent customer. When you view the customer records, you see the A/R balance for the entire customer 'node'. The proposed enhancement, tentatively…

I can make the item's Name/Code display, but I wanted the internal ID because that is always a unique number. Thanks Marcus, The built-in NetSuite field "Item Name/Number" must have a UNIQUE value. NetSuite will NOT let you save the record with a duplicate value. So you can just use Item Name/Number if uniqueness is your…

How about Home > Set Preferences > Only Show Last Subitem = T? HTH. This does NOT work for us. :( The full hierarchal parent-child path is shown both for selection, and when displayed in VIEW mode for the following: [LIST] [*]Item - Assembly/BOM[LIST] [*]Parent field [*]Custom field that pulls from Item List [*]Members Tab…

I filed a defect case, and NetSuite has classified this as a S2 Defect: Thank you for contacting NetSuite Customer Support. The problem you are experiencing is actively being addressed by our Quality Assurance and Development teams. We are working to implement a resolution to the following issue in your account. Defect…

How about Home > Set Preferences > Only Show Last Subitem = T? HTH. Mark, Looks like a DEFECT to me. Can you please investigate? Thanks.