3957393 Newbie

Just because of the setup of our accounts I've had to do it in a very slightly different way, but all up and running now so all good. Putting this in a subtab/sublist on the item record is a great idea which I hadn't considered before & may make inventory investigations much easier to navigate for supply chain team. Thanks!

Hi Olivier, I had originally been trying to limit this to hits on the accounts we use for Inventory Assets but noticed certain transactions weren't appearing. I've since realised that by filtering out the COGS line I was filtering out the impact of item fulfillments - now that I've added it back in it all looks ok. Thanks!

Additionally - the reason for needing to do this is an inability to display "created by" as a field on a standard inventory activity report - so if someone has a suggestion for this instead that would also be a big help.

Sure - but when I set COGS line to false on the search I lose the item fulfillment impact on the asset accounts

Thanks, this is actually really helpful to me too - hadn't realised you could pull multiple lines from a sublist like this within a single line on a search formula.

Hi Jenny, I don't think there's an easy way to do this through saved searches. I did some related work at one company a while ago though where they were trying to measure reaction times to messages, total time customer waiting for replies, and a number of other measures that weren't easy to pull from a saved search. I just…

Hi Jarrod, Try: {debitamount}-{trancostestimate}-NVL({quantity}*0.3,0)-({debitamount}*0.2) Seems to work for me if I substitute fields that we use. Last parentheses maybe not necessary but I like to group it visually. No need for the "END" (was this just a copying error? only would need that if it was a case statement or…

Hi Jarrod, So the correct value is displaying line by line if you drill down but not in the summary? Could it be to do with the criteria of the search, eg. are you filtering to main line, or including lines that may have missing/negative quantities?

Thanks a lot for pointing me in the right direction, I will vote for the enhancements and keep hassling NetSuite! Cheers, Will

Hi Erik, You can access the list of items through the "pricing..." related field in a customer search, but through this interface you can't access whether the item is inactive. You could use scripting to do this however, if you create a scheduled script that runs two searches... 1. Create a saved search that looks for…

Out of interest, once I made the values for date and customer dynamic values drawn from the input form, it runs like a dream. Thanks again for your help

Thanks guys!! That seems to have worked - looks like it may be too big to run anyway, but I'm no longer getting the error. Will try to adjust from here. Cheers! Will

Hi Ivan, Two things: 1. Are the two fields already in the body of the Bill, or just on the PO? If you are not displaying 'custbody7' and 'custbody8' as custom fields on the Bill, you will need to use your script to load the PO and get the values from there (your script as it is will be looking for the values of these…

Hi Srujana, Looks like in this line you're saying replace Addr2 with Addr1 if it is not null? if(Add2 != null){ Add2 = Add1.replace(/\s/g, "+"); Cheers, Will

One last note - if a record has the netsuite standard field {class} on it, you'll be able to filter a search to just the currently logged in user's class by using search criteria Class & "mine", but if you are using a custom field that contains the "class" list/record, you'll need to recreate it using something like the…

sorry, clarification. For the above to work you'll need to use: TO_NUMBER({custrecord_class_field.internalid})-TO_NUMBER({user.class}) Cheers, Will

Hi Kumar, Use a "Formula(Numeric)" field on your search criteria to only present the search results that match the Class for that user. Here is the formula and the comparison value, this is one way to do it. I have used {custrecord_class_field} to represent your custom record class field, just replace this with the ID of…

Thanks very much Olivier - I will give it a try!

Thanks for the guidance Oliver. Here's what I ended up with - might be a bit messy as I wrote in a hurry - but I have tested a few scenarios and seems to work. function beforeSubmit(type){ //set TO location variable var fromLocation = nlapiGetFieldValue('location'); //cycle through items, get itemId var numberOfItems =…

Thanks for all your help Olivier. I have actually been working already on all the problems you brought up, I think adjustments to run one search are not too hard, same goes for the if(null), but I am having real trouble checking for the item type. It seems like all of the functions I could use for this require item type as…

Just out of interest, as this may be useful to other people - have written a few further improvements to speed up this script: When looping through the search results to match the item ID, the loop is broken when when the ID is matched, Setting value was happening repeatedly for one item in old script, now only happens…

Having trouble - I think I can run the search, but struggling to get the right value out. Here is my code, i am very much a coding beginner so apologies if it doesn't make sense. I have put question marks below where I don't know how to select the value: function beforeSubmit(type){ //set TO location variable var…

Here's the code I ended up with: """ function beforeSubmit(type){ //set TO location variable var fromLocation = nlapiGetFieldValue('location'); //cycle through items, get itemId var numberOfItems = nlapiGetLineItemCount('item'); for (var i = 1; i <= numberOfItems; ++i) { var itemId = nlapiGetLineItemValue('item', 'item',…

Hi John, I would suggest same as Olivier. We have used this a lot for certain employee lists, in much the same way as you have a list of sales reps. If you put a checkbox on the employee record eg. "is employee Type A" - then on your list custom field configuration, under sourcing and filtering in the sublist - add Filter…

Hi Savini, Do you have more detail on the custom field? It could be to do with the configuration. When I create a custom field for accounts, I'm able to select it as a filter in a financial report (under the subfolder for "Account (Line)" in any of the parent folders). Is the data type of the field a list/record? Are there…

Hi Savini, See my previous post. Do you have more info on the configuration of the custom field? When I try to test this, it works for me and I am able to pull the custom field in to reports.

Hi Latha, However you define what the COGS% is, all you should have to do is define a search with a single grouped results column that returns the value you want. Eg. 1. Create a saved search with the criteria you want, (accounts are equal to desired accounts,etc.) 2. Add whatever detail results columns you want. Then add…

Not the cleanest way but you could create a search looking for the last six months of sales and then use a case formula to return the amount only if the transaction is in the last month. For example, transaction search filtered to date is after six months ago, two fields returned in results: - Amount (grouped to SUM)…

Hi Vicki, Could you just turn off the standard notification entirely and then send fulfillment emails for the orders you select, based on a search/script/workflow? There are a number of ways you could do this, and after initial setup time, this would make it much easier to control down the track. Another alternative if you…

Hi Johanne, Thanks for your quick response! Have emailed you some of the errors - let me know if you don't receive them. Cheers, Will