Hi Ivy, Maybe I am missing something, but we need to assign the landed cost template to the item record before we can add it to the PO. When I tried an item import there was no field for landed cost.

Hi Ivy, I am trying to update the items on a PO with a different landed cost template, I thought it would be pretty easy, but I was wrong yet again. Here is a sample of csv that I am using , the mapping, and the result. Please help.

Wow you ROCK! It works exactly as I hoped. Thank you so much Ivy!?

Hi Ivy, I have it working, but the rate seems to be coming up in our default currency instead of the USD with the vendor is setup to. How do I fix that? Here is a shot of the PO and the results of the search.

First, you are awesome, just saying. I was about to try creating the saved search because I think that would be very beneficial long term for these changes. (BTW it is more about updating existing items on a PO). I though it would be a good Idea to add the internal ID to the purchase order main screen (not printable just…

Hi Ivy, Hopefully this is what you wanted.

Hi Dominica, We are so close!! I can't thank you enough! I ran into a couple things and I don't want to break it because it is working. First, we have customers that have terms accounts that we need to exclude. We also have situations where the sales rep forgets to create a customer deposit completely. We also have…

Hi Ivy, Gotcha, I will be more careful next time with screenshot. Yes this meets all the criteria, it should be on the list for sure. I am not sure if I set something up wrong?

Hi Ivy, I hope you are well. It has been such a crazy year, I did not realize that our saved search was actually not working correctly. We have an item (64646) that is zero with nothing on order in our Calgary branch, but it is not showing on the report? Did I do something wrong??

Hi Dominica, Yes when the Sales order total is different than the deposit amount. They should always match with the few exceptions that are listed in the criteria. Thank you for such a quick reply!

Oh Ivy, you are like a wizard or something! Thank you so much, that seemed to do it. I will test a few things to make sure, but I think you nailed it! How did you get so good???

Hi Ivy, Thank you for your quick reply! I must be doing something wrong though. Here is a screenshot of my criteria, but it only produces 4 items. There was 50 items out of stock. I think the issue is I am trying have both When available stock in inventory location is 0 + When available was below the inventory location…

WooHooo!!! You are awesome Ivy!! It worked perfect, thank you so much. I am curious though, the edit toggle on the search has disappeared now. Do you know why that is?

That did it! You rock Ivy! Thank you so much!

Hi Ivy, That is awesome, you know so much!! I did find that I have to take out a couple things because several items that are out of stock in a specific inventory location, did not show up any more. I removed: The transaction type and the formula from the criteria. and the Transaction: Date field. Once I did that the full…

Hi Joy, It was for something different, but here it is. I was trying to see the lost sales due to stock outs. What I could think of for this matter is for us to have a saved search that would show us the Daily average Sales prior two months wherein the Item has no available in the said location. This would, however, can…

Perfect! Thank you!!!

Hi Joy, I found a work around if anyone ever asks about this again. I was able to make them inactive with a mass update. It might not be the correct way, but it works. Thanks for your help! Dallas

Hi Ivy, I understand the limitations, I am not trying to change it. I would like to understand how your other customers work with it on a day to day basis. I am sure there are a lot of people using demand plan, I want to change our internal process to match what others are doing. For example how would a purchaser work with…

Hi Ivy, I get that, but for 1 supplier with 26 items, I get 26 transfers. That's just 1 supplier, how do people work with it? We have several thousand items and have weekly transfers? It's not about the lot sizing method, its about having a different transfer for every single item. regardless of vendor.

Hi Ivy, Thank you for finding that, I appreciate it. Still make this very very difficult. How do other people work with demand plan? There must be something I am missing because I don't have time to review hundreds of transfers pre week. I read the new Inventory Management Manual release Feb 10, 2021, but there is no…

Hi Ivy, Thank you very much for finding that for me, I did add my vote to the enhancement request. Please let me know if you have any other suggestions that might help, maybe something completely different I haven't thought of. Regardless, thank you for your help. ? Dallas

Hi Ivy, Thank you for getting back to me so fast! I did try that, the only issue is having it still order in the required multiples. For this item we buy it in Pallets of 80 units, when I change to Period of supply, it orders exactly what is required. Is there a way of having minimum order sizes and still Periods of…

That is great! Thank you so much!

Hi Herdi, Is there a way to get the fields from item360 as fields in a saved search? I am now looking at product lines and trying to establish the average monthly sales during the months of April to October. For all items, not just ones with no stock on hand. I tried playing with your formula, but failed to get it to work.…

Thank you Herdi for looking into it! I think in the mean time I will try to create a out of stock report each day and save it. I appreciate your help. Warm regards, Dallas

Hello Herdi, I am hoping my last message made sense, I wish we could do a zoom meeting or something. I feel bad bugging at each step when you have already helped so much. Please let me know if that would be ok? Thank you, Dallas

Ok sweet. that makes sense, and it is the the correct amount. So this gives me the daily average over 2 month, but how do I know how how long it has been out of stock to calculate the lost $$? Not sure why the screen shots are not coming through, but what you did worked as you intended. Warm regards, Dallas

Hi Herdi, Thank you again for taking the time! I was able to make it work, but the results seem strange. Is the result a dollar amount or a number of units? I just want to make sure I did it right. Here are the results from my search: I selected "B60" to test as I know it is out of stock. I looked at it and I can see the…

Hello Herdi, Sorry for the delay getting back to you. I am still fairly new to custom reports and searches in NetSuite and I was not able to get the saved search to work. Would you mind breaking down steps 1 and 2 a little more? I wasn’t sure which type of search to choose, I attempted item. Thank you again for taking the…