Question, what happens if you receive/ship item in one period, receive bill for landed costs next period, if previous period is closed how does the costs "follow" the items ? One approach is to use estimated landed costs that are applied to the Item Receipt record immediately or shortly after item receipt. When you receive…

Thanks Mark.

Definitely do an inventory adjustment. If this is a new implementation there is a specific process you should follow to ensure that you get this right. Let me know if you need some guidance. Mark Mark, Would you mind sharing the "specific process" that you mentioned? Thanks.

Please vote for the following ERs: [LIST] [*]Enhancement 57198:- Units of Measure > Support Assembly / Bill of Material Items [*][COLOR=black]Enhancement 78188L - Ability to use Units Of Measure with Serialized Inventory and Lot Numbered inventory[/COLOR][/LIST][COLOR=black]If you use these type of Inventory Items, then…

However I also have to say that I don't think ER# 781888 is going to be of much use without some other fundamental changes to lot numbered inventory. So... anyone who wants to vote for these....I encourage you to search for and vote on some of the other ERs related to UOMs and lot numbered inventory, too. Cecelia, Thanks…

Scott, Neither Assembly/BOM nor Lot Numbered Inventory Items can have UOM in NetSuite. From the Help system Assigning Units of Measure to Items, here are the Item types that can have UOM:[INDENT]Inventory Non-Inventory for Purchase Non-Inventory for Resale Non-Inventory for Sale Other Charge for Purchase Other Charge for…

So, how would we use this field? Do we enter the custom field names, comma delimited? And then what does the system do with this?

On an error, the form should take you back to the pre-filled form where the user can change the error and then resubmit without having to re-key in all the information. This has been a best practice on Web U/I for over 10 years. NetSuite should be embarrassed for allowing their designers/programmers to be this sloppy. If…

I have submitted a ER request for this: Case# 710597 -- ER: Allow Units of Measure (UOM) for All Inventory Item Types Please add Units of Measure (UOM) for all Inventory types, including: 1. Assembly/BOM 2. Lot Numbered Assembly/BOM 3. Lot Numbererd Inventory Item UOM are currently provided for Inventory items, but not for…

Cecelia, Is there a problem with Assembly Builds using FIFO if you only build and don't unbuild?

I've never come across negative Available on Netsuite How did you get there? Those weren't actual numbers from NetSuite. I was simply trying to illustrate the qty counting as different events took place. NetSuite probably limits the Available to 0 when the item is back-ordered. Although a negative Available would be useful…

There would also be a more general 'stock' production order, to produce finished goods that are not yet allocated to a particular sales order. When built, these finished goods would go into inventory, and commit to any back orders that do not already have a work order.. Malin, Thanks for the reply. So I'm still not clear…

Because from this sales order's perspective, those items are/were available. It probably makes a little more sense when you edit - it tells you how many you can order on this sales order. Thanks, -e Evan, I understand your logic, but only after you explained it to me. ;) For me, and perhaps Cecelia, it's not intuitive. I…

James - I think you will be much happier when our 2008.1 release comes out in the first half of next year. With that release, we will have commitment of member items of assemblies through automatic creation of work orders. Evan, This sounds great! Would this be the same or similar to a Production Order, which would:…

This is just base price? If so then that information should be available through system note search. You could group by month and take the maximum price (as an arbitrary choice if the price changed more than once in a month). You could also use the "keep" function in a formula to find the "last" price for that month…

Hi JMU, How well do you know CR? I did one very similar although it was for the sale price of an item, but I had help, and it was a while ago. You know what they say, if you don't use it all the time. In Excel, it would be pretty easy, but nobody seems to like Excel anymore.:o Angela, thanks for the suggestion. I like…

To clean up these items to reflect an actual value of zero is to make two adjustments, (that are not in balance) to net to zero. Angela, Another great primer on inventory mgt! :D You should really consider writing a white paper (for sale) detailing the procedures, tips and tricks you have learned in dealing with NetSuite…

p.s. JMU - if you do put that list together, I'd love to get a copy of it. Cecelia, Thanks for pointing out additional "factors" to consider when dealing with lots. I'll be glad to share the list as soon as I have it in readable order. Still collecting data/inputs at this point. You probably saw this, but just in case…

Miguel, What a great list of the potential downside of using lot numbering! :D This is true of many features in NetSuite: They have a definite advantage, but there can be unintended consequences, which NetSuite often fails to clearly state in advance. :( I have been thinking about putting together a table of Pros and Cons…

I was just trying to explain how it happens, and, technically, in both situations, how is NS at fault for not knowing what an errant employee is up to? cleaning up the system for errors made in data entry can be headed off, if there is some training in data entry. ;) OK, it must be a full moon so I'll jump into this mess…

I'm no inventory expert, so I've been following this thread trying to learn from you guys, and to figure out what works and what doesn't in NetSuite. After Cecelia's last post I decided to test this out for myself, just so I could clearly see what's going on. So here's the surprise: I was able to add a new custom field to…

Vendor Name has been added in edit mode for purchase transactions for 2008.2. Thanks, -e Evan, This sounds good. A few questions... [LIST=1] [*]Is "Vendor Name" the same as the Vendor's Item Name/SKU? [*]Will this apply to POs, PO Receipts, and Bills?[/LIST]Thanks.

This is a highly requested item that is currently considered in the next release. We are planning on creating a page that will allow user to view the hierarchical levels in a bill of materials. This page will display the quantity per immediate assembly and quantity per top level assembly for each member. Peter, This is…

We're on 11.0.6 as well. How can that be? Steve, I'm not sure -- a question for NetSuite. I just double-checked. Created a NEW "Service for Sale" item, and it definitely is showing fields for quantity pricing under the Pricing tab. Hope you can figure it out.

I just noticed that multiple quantity based pricing does not apply for Services - why? Steve and mco, We are currenty using quantity pricing for "Service for Sale" items. We are running Ver 11.0.6 So I'm not sure why it's not showing up for you.

We do a sale at zero price, fulfill it, invoice it, and then issue a credit, with location of the credit being the receiving warehouse. We do all of this under a separate class "inventory transfer" so that we can isolate these transactions.. Brian, This sounds very interesting, but I have one question. Doesn't this result…

This is great news Evan! We can really use it. I hope you can get it finished and fully tested in time for 2009.2.

There are two related enhancement requests: 56393, for a general transfer workflow including a transfer request, shipping step, etc.; and 39086, specifically regarding shipping paperwork for transfers. No guarantees at this point but this is something I'm strongly considering for next year's major release. Malin, Does Ver…

If this feature DID get attention, hopefully it also received: [LIST=1] [*]The ability to customize the form/record [*]SuiteScript support [*]SuiteTalk support[/LIST] Agreed. We urgently need all 3 of these features.

Yes, but one print button would not be the fully baked solution that many users are asking for... The feature we're designing will generate a proper picking ticket and have transfers go through a real fulfillment/receipt process with your sales orders/purchase orders. Did this expanded Inventory Transfer feature make it…