Hi Mark, You could indeed use a script to drilldown into all the sub components of a given assembly, figure out the total member cost, and then update the item's cost. We have already created a script for other customers that does exactly that, minus the auto-updating of the item's cost field - that last part is a piece of…

the "file" tab shows in "item assy" by default....did you set up a custom field for both or only for the "item" :confused: It does not show as a "Custom"field but as a "Tab" in "assy items". So....why does it not show as available for "items"?

[quote=PartnerSLC]When you set up the custom field to load the file into did you specify which item types were enabled? Have added the new tab, how do I now show the files on the website when drilling down in the item?

If you show the columns or "Reorder Point" & "PSL" in your general item screen, do u see values in them? I am guessing but have you entered a "minimum" qty in your reorder point to get started? Otherwise you will need to wait until 3 month or greater to genertate enough sales history on each item (this is if you left a…

Rebecca, same topic, different issue....how do you handle your landed costs when the freight/duty bill comes in with consolidated deliveries? We have say 3 factories supply goods across say 10 Purchase Orders but receive only 1 freight bill (includes duties etc). Takes too long to try & split the single bill across…

since the auto inventory management has a known defect I am adjusting manually the min/max levels daily....as it does not allow DLE it takes fooorrrreeevvvveeeerrrrrr :mad:

Preferred Vendor may be a little tricky if using "Multiple Vendors", as you would only have a single field showing for the selection :)

I think they are the same as price columns and not editable :(

Hi, the thing is a dead set lemon for us and has caused overstocking of ridiculous items.....like trys to order 250 of an item we have not even sold 1 of. The thing has been faulty since day 1 for us (3 years & counting). We recently had them reopen the case and it is lodged as a defect. Something I believe to do with the…

price/base price, min/max qty's, would be fantastic!

:) would be a big enhancement as there is no "landed cost" for new items and pre-existing until purchased and landed.

the script has alread been done for this and working well inside our account. The issue now is how to mass update sell prices from the new 'AVG" custom field as it relates to the old "AVG" field.

the idea is to delete the min/max values in the location in question. Leaving it at "0" will have it auto calculating again. Hope this helps :)

With regard to issue 135903, one of our QA engineers looked at the items specified and determined that there was insufficient sales order history for them in the analysis interval to calculate lead time/reorder point/preferred stock level. (The analysis interval as specified under Set Up Inventory Management- as mentioned…

an update....apparently the "Save As"function is corrupting the items auto reordering levels. I assume from this that the history is adding from the original item. This would mean that we need to add any new items "fresh"....sounds too time consuming to me. Gets better by the day! I hear NS board (wherever they sit) have…

also interested.... [EMAIL="brett@invertek.com.au"]brett@invertek.com.au[/EMAIL]

I don't understand this as we need =>"0" to have the "auto-calculate" field do any calculations. Therefore, I can have min=0, max=0 for location "X" and "null" for location "Y". Have a talk to Gav at NS Support as he assisted us with the determining how the beast calculates......needs a numeral or zip happens.

same issue here...we disabled a location completely and we can see the min/max levels are still seeing the values from the inactive location. A lot of manual work to zero them out. We found we had to delete any entry in the min/max (not just zero) because if you uncheck the auto min/max boxes and then come back later and…

Defect 135903 - Advanced Inventory Management: Calculated values for Lead Time, Preferred Stock Level and Reorder Point are two high and unrealistic SUMMARY: Calculated values for Lead Time, Preferred Stock Level and Reorder Point are two high and unrealistic WORKAROUND: None This may slow you down a little before letting…

check the forum, we have been issued a "DEFECT"notice by NS for this feature. After years of screwing with the settings, receiveing many different suggestions from NS,we have finally proven to them the feature is not working correctly. Be mindful that "assy items" auto calculate and so do the "member items" therefore…

won't fix it....we have tried that ages ago and I can state as fact that the figures it calculates are "bogus". We have shown NS where it seems to calculate the "member items" as well as "assy items" therefore overstocking you as the "member" can be used in say 50 different "item assy's" as well as by itself....multiply…

Yes on all counts. 1. If you turn off auto-calculate later for a particular item, it will revert to the value you previously manually entered. 2/3. Existing items are off (but you can enable them in bulk with Mass Update.) New items will default on. 4. Yes. Each location's RP and PSL are calculated separately based on…

Is there sales history for this item dating prior to the beginning of the 6 month historical analysis period? If not, NetSuite assumes there's not enough data to be accurate and cuts the interval in half (3 months in this case,) and if there's no history before the beginning of that window, it aborts calculation entirely.…

e had Gav @ Netsuite support working with a test account and said he has been waiting for feedback from the States, over many weeks now and we have been asking for assistance for more months than I care to remember. :( Netsuite have a log in we supplied to our account and have been monitoring it live as well.....NS cannot…

I have had this feature on & off over the last 12 months with no success so quite interested to see somebody else giving it a whirl. This week for example, with Netsuite Support involved, we have changed DPSL from 1 day to 30 days and back to 1 day, DLT from 90 days to 150 days and tonight back to 30 days. We have forced…

Case Number 638221 shows we have an item example with 36 sold in 6 month period so reorder value should be 0,2, or 1 or 0 acceptable, not the 14 it tries to order. We have preferences set to "1 day of stock" calculated over "6 month period" for this example so accoding to your "help" screens should be 6 (months) * 30 days=…

James, any chance of seeing how you have your settings in "Inventory Management Preferences as we cannot get it working our end? I trilled it again an a handful of items, NS suggests ordering $60k of product....I have changed every setting and forced the update and see no changes at all in qty it wants to order. Ideally I…

Brett- To the best of my knowledge the feature is functioning correctly. Submit & Update schedules an update for that night (not immediately), but it looks from one of your posts above that you already discovered that. I don't see any recent support cases about this on your account, so I can't comment much further without…

Is there sales history for this item dating prior to the beginning of the 6 month historical analysis period? If not, NetSuite assumes there's not enough data to be accurate and cuts the interval in half (3 months in this case,) and if there's no history before the beginning of that window, it aborts calculation entirely.…

can you email me the cost please? Hi Folks, Regarding the issue of having a different value in the item receipt (i.e. from the original PO) then in the vendor bill. We actually created a suite script to fix that. If a user modifies the cost of the item on the vendor bill, we track back the inventory receipt and change it…