Gavrah Rabba Red Ribbon

Thanks all for your responses. I really appreciate the help.

Thanks for following up.

Do you know if the … Records Browser: https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2024_1/script/record/customer.html field ID is {lastsaledate} …. is available in the NetSuite API?

Hi @Red Velasco-Oracle Thanks very much for your follow up. @Pierre_Plourde answered my main question by stating "because the system currently requires fields to be stored for inclusion in a new saved search, it’s not possible to include a specific custom field in another saved search at this time." I am left with two…

@Pierre_Plourde , thanks for your reply. It is strange. Perhaps some other guru can help with this mystery. If I find a solution I'll be sure to post it. Really appreciate your help!

Hi Again, I checked the NetSuite Records Browser and I saw two fields: "last sales date" and "last order date". (I assume last sales date represents fulfilled orders while last order date represents open, unfulfilled orders.) I tried setting up a custom field for "last order date" similarly to "last sale date" but I am…

@Pierre_Plourde , thanks for your help. I have the custom field defaulted from {lastsaledate} and it is working. I very much appreciate your response. Two questions: The custom field display as "YYYY-MM-DD HH:MM". Is there a way to truncate the time and reformat as MM/DD/YY? 2. We’re currently working on integrating with…

Thanks again. Does this mean we can’t reference a “Not Stored” custom field, which is defaulted from another saved search, in our saved search results? And the only way is by running a saved search that would copy the value to a "Stored" custom field? I wonder… Do you know the fieldname for the native "Date Of Last Sale"?…

Thanks so much for your speedy reply. I set the custom field to "Not Store" so that it can dynamically get the value when I run the search. I wonder why that wouldn't work. What is the fieldname for the native "Date Of Last Sale"? I tried defaulting it through a formula, but I don't see that field listed. (see following…

Thanks @MTL_MIA for this detail. It is great. It looks like something we can work with. The main point is that the Sales Order is really in the Sales and Stock UM (strips) but for display purposes the system uses the custom conversion factor to show the quantity, prices, etc. in the base UOM (feet). The only limitation I…

Thanks for your response. For two strips the SO quantity would be 32. Yes, if the entered quantity is 35 we would like the system to bump it up to 48. We don't achieve that now. We would like that to happen. When running a report of total open ordered quantity for this item we would need to have NetSuite consider the…

We do not sell a fraction of a unit. We exclusively sell whole units of this product. Here’s a specific example. We deal with wooden strips that we purchase, stock, and ship in 16-feet lengths. Our inventory, purchasing, and shipping quantities are always measured in full 16-foot strips. So if we have a quantity 1 on hand…

Hi. I greatly appreciate your response. While the work-around for printing the stock unit seems viable, we also need to ensure that the quantity displayed on the pick ticket is converted and accurately reflects the Stock Unit of Measure not the Sales UOM. Is that possible? Could you guide me on customizing the pick ticket…

Thanks. So what I understand is that Transfer Orders cannot be part of Transactions To Consider when calculating historical demand and predicting future demand. Thanks for your help.

Thanks very much for your reply. That would work and I may end up actually doing it. However, I was hoping that we can somehow enter the historical demand figures into NetSuite so that NetSuite would do the future demand calculation (avg or linear regression, etc.) for us. This way we can get the future demand plan figures…

Thanks. Not all employees who have credit cards are licensed users in NetSuite. Does every cardholder need to be a licensed user or can they be listed as an employee without NetSuite access?

Understood. Thanks very much for your help.

Hi. Thanks for your reply. That didn't work. The import is performed automatically - not by any specific user but it seems that the email is sent to the user who set it up.

Thanks so much. Exactly what I needed to do. It works perfectly!

I don't see the "Did this answer the question?" button.

Wow! Amazing! Thanks so much for your detailed answer. It works perfectly. Much appreciated.

Hi, Thanks. I meant the header but I guess the lines as well if possible.

It worked out ok. I deleted the adjustment that was out of sequence and reran it. Thanks again for your help!

Oh wow! I think you answered the question. They were both on the same day and they were run about 10 minutes apart. I will try to rerun and let you know. Thanks.

Thanks for your help. I couldn't wait so I had the adjustments entered manually for now. I will follow up if this happens again. I really appreciate your help on this.

Negative.

Thanks for your response. Indeed we do not have the Bin Management feature turned on. I mapped our lot # to Serial/Lot# as you suggested (see attached screenshot) but I am still getting the same error (Please enter value(s) for: Serial/Lot Number). Any other ideas?

Thanks. One item was not a lot-numbered item and another had a negative adjustment. It worked fine after I eliminated these two lines. Thanks again for all your excellent support.

Thanks again for all your help. I am now getting a new error - "You cannot create an inventory detail for this item.". Any idea what that could be? Attached is a screenshot of the csv file and the import mapping. I really appreciate all your help.

I don't see the "Issue Inventory" and "Receipt Inventory" numbers in the csv field mapping screen. However, I do see "Serial/Lot Number" and mapped accordingly. I am getting an error "Please enter value(s) for: Serial/Lot Number". I am trying to import one item and the Lot Number value for the item is "ABC123". Any idea…