The adjustments and the time taken to stay on top of it....do people really sit down and tackle this full on? I would need a few wet Sundays to fix our number of items showing zero qty in stk with a few cents tacked on as a "value on hand".

I have always had same issue. Do an adjustment against each individual item for exact difference....I gave up after the first 100......

try Item Assemblies as u can purchase these

OK, I have read the wiki reference, thankyou. Maybe a workaround to get me away from this is to use the ROP again as my minimum, manually controlled (pretty painful as no DLE available in MLI for this column) and have my PSL auto calculating with a "0" value entered. The problem with this scenario is that I believe that…

It will be great help to us to understand the root cause. We can definitely use the reorder point calculation in wikipedia as a point of reference.(http://en.wikipedia.org/wiki/Reorder_point) In order to determine the root cause, is it possible for you to elaborate on the example discussed in your post? In your scenario,…

For anyone still trying to make this work that have not seen the other threads: Defect 161788 - Advanced Inventory Management> Reorder Point calculates In-correctly and even to In-active Locations SUMMARY: Reorder Point calculates In-correctly and even to In-active Locations WORKAROUND: None Identified yet They forgot to…

all fine & well...but....we have no need to activate PSL again as this always in the past matched the ROP when the auto boxes were checked. We just cannot see why you want to add the SSL to the reorder point AFTER the auto calculated figure reaches the same qty? The sytem only needs a SSL qty (minimum qty to be held in…

SSL should not ADD to the reorder point. Try considering it as the "min" level of inventory to be kept, in other words, the SAFETY STOCK LEVEL. The reorder point should auto calculate as it does but not be in addition to the SSL, it should observe SSL figure until =>SSL QTY and then disregard until <SSL where it would agin…

still not working on my end :mad:

I need suggestions on how to organize/setup items so that it is easier to find when creating estimates and opportunities. Seems like it is just one big long list in netsuite. In other systems I've used I was able to setup product databases (by vendor) with sub-folders to structure the category of items from that vendor.…

Hi Evan, then we do not have a basic working model as I am spending ridiculous periods of time turning "auto calculate" on/off to try and work around this. If you were to spend time on a MLI live site and try to handle 6000 items by manually opening each one to edit the basic's.....the reorder point, the SSL level (which…

Items with "auto" set for reorder and preferred levels do not work. We have had this issue since the feature was released and even today it is still being worked on by our Netsuite support people. For example, qty to purchase should be 1 (according to the "help" screen) and not 73 as per Netsuite's "order inventory". We…

Easiest way is place an "x" at the end of your existing "items" so you can tell the difference between "old" & "new" after working on them. You need to leave them active until after adjusting the qty's across and it can become confusing otherwise. Also be mindful if you have any "assy items" coming across as "importing" is…

Hi, I see two fields (Tax Code and Purchase Tax Code) in the NetSuite template of importing Items. What are these. Are they applicable for the NetSuite version being user in USA. I also don't see those in the Item Screen of my account. I ll appreciate if any one can help me in this. Thanks, 7HUser you use 1 code for…

Does this feature actually work? I have had no success in 4 years so interested in knowing the secret :confused: I have set the "SS" to= 1 for slow movers but nothing appearing in the "order inventory" report. I do not want to use reorder point & PSL as I want the automatics to cut in when usage is greater than 1. With the…

In 11.0 you can mass update prices to be based on average cost, most recent purchase price or entered cost. So you can create a particular price level that you maintain using the mass update tool, and then assign the customers who should be charged the markup-based pricing to that price level. Thanks, -e Looks like this…

{pricelevel10} is my "distributor" price level which I need to show alongside my "stockist distributor" pricing. This is "pricelevel14" which appears correctly along with relevant qty breaks but am unsure why the formula "currency" {pricelevel10} returns an error? Reading this thread shows me this is the way to do it,…

I have 2 columns which show the 'Pens" a top which usually signify that they are available for DLE.....why can"t I edit these? It has never been different. :confused:

I too have a report going out....just can't find where to switch it off..... found it. Disregard this post

we just use the same as described above w/- multiple pricing. You get a drop down box on the qty column showing the qty options available and just add a new item line for each option. Sure, it loads the estimate & stuffs any pipeline bizzo you have going on but is addresses your immediate question.

http://invertek.com.au/Home/Optidrive-E2-1-Phase/ODE-2-12037-1KB12-01 I may have a workaround, check the above link, you will fins a link to a "User Guide" along with images of 2 more downloads, so 3 in total from the item.

I was pasting hyperlinks into fields to allow PDF downloading of brochures and user guides for each item in the webstore......very messy and time consuming. Looking for a way to just link to the documents from the file cabinet using a custom field. Am I missing something maybe?

we created 2 custom fields for the tech info, 1 for PDF, 1 for DWG files. This is fine except if we choose to show in the store then it shows against all items

the way ours is set up is more wanting different custom fields to show for different ranges of items....so for example a custom field for electric motors will show "rpm" and you would not expect to see that same field on a wingnut..... the solution would be to enable certain custom fields to appear on the website for…

I have same issue. Appears that the non-stock item we have named "MISC" (then we change description & cost to suit) does not get picked up in the COGS when running a P&L by DEPT (DEPT's named for each individual salesperson). Any workaround that is simple?

"Add the condition to check the value of the string field" Sounds easy, but how? Thanks in advance.

are you positive that NS now have this working? For 12 months now we have been working with NS Australia and as of 2 weeks ago (last try) these fields were still not functioning correctly. i.e. sold 1 piece of new item and system tried to purchase 75 pieces......be very interested in knowing if anybody has successfully…

some first hand experience.....you will find no mass update to correct the purchase codes so choose carefully. We set up the purchase tax code on each individual item record, ended up with incorrect codes on some items, stuffed the BAS, got an audit, just avoided a fine, looked incompetent. So far NS has not addressed this…

we gave up ages ago....just wanted the customers name like "Dear Joe Bloggs", the outstanding monies are owed & the $$$$ values, days etc..... was listed as impossible by NS support at that time. Will try again in the new release. A standard form that everyone would want....look forward to it being sorted.

do you not use "Item Receipts" and "Landed Costs"? You would then bump into the issue of not being able to apply the landed costs correctly as NS assumes you will bring all the PO in on a single receipt. Ridiculous as it sounds :(