Didn't work unfortunately. Issue seems to be that Number of Orders just doesn't have any value so when I did that I just got 1 line of 0. Perhaps it's on NetSuites end to check the functionality of this field.

I'll give it a whirl. Thank you both, for your insightful and helpful responses.

Ran into the same issue and this thread was the first search that comes up. I managed to make a scripting solution for it. It will update the To Location field correctly. The issue appears to be that NetSuite has labeled the fields wrong on implementation. Ideally, you should aim to fix the labels of these fields first but…

No, I need to get the text value so I'm going to have to create a second search. I think I need to move past this problem for now and revisit it later, as having the related purchase on my warranty record isn't necessary, I can just search for it manually with the serial number if need be. I'll likely revisit this after…

Sure thing, I've attached my script where I log out the value of inventorydetail.inventorynumber which comes out as the internal id of the serial number. Stored in the variable foundSerialNumber @Nicole Mendoza-Oracle has provided extensive breakdown of this already over in this thread where I first encountered the error…

I think what I may need to do is use the first search just for the customer and subsidiary, get the id of the inventory number record and run a second search on the inventory number record?

That all makes sense, but I think it's particular to my case as to why inventoryDetail.inventorynumber isn't suitable. What inventoryDetail.inventorynumber returns is a list of numbers which are the internal id's associated with the serial numbers in that list, not the actual text of that serial number. So it can be used…

Mm, I see.. tricky. Thank you for that, very insightful. I'll take another crack at it tmr.

Thanks Angelica. It looks like it might be a bit tricky to implement. I'll have to sit on it for now as I'm quite busy with other tasks, but I can see the potential. Thank you for that.

Hey Richard. Yes the other filters are working correctly. There are only 2 sets of sales orders with that subsidiary customer combo on the system. The first does not have serial numbers of the items on the item receipt I am using to populate the serial filter and the second one does. But after running the script, it looks…

Searching for a solution to the problem in another thread.

Still encountering an issue which I've lead onto a new topic. As it's more specific and the question for this topic is still answered. Or perhaps the answer to this thread is wrong and inventorydetail.inventorynumber is not the correct field to use, as it's looking for the ID of the serial number and not the name of it?

Thanks John. Yea we're also purchasing the items directly from suppliers in some instances and I have the items and system set up as such to be able to. I'm just not seeing the option to specify what revision is being purchased without using the above mentioned steps and fields enabled which is what's leading me into…

I think I have it. inventorydetail.inventorynumber Which I learned from the record browser for Inventory Detail. It mentions the types of search filters that can be used, I think that's it? // Search for the associated invoice var salesOrderId = findAssociatedSalesOrder(serialNumber); if (salesOrderId) { var invoiceName =…

Never mind, I can't remember what I was trying at first but it appears it didn't need formatting at all. It should have worked as an IS08601 formatted type as this is what uploaded correctly: "2034-05-16T07:00:00.000Z" the only difference between that and my custom format to ISO 8601 being that the default logs out as…

Below is the snippet of code that loops through to and gets the serial number from the receipt. Also attached the full code of my currently incomplete project for reference as to how it's used. // Retrieve item details from the Item Receipt's line items var lineCount = itemReceipt.getLineCount({ sublistId: 'item' });…

By scripting the warranty creation, you can get around the error that is thrown and continue to upload serial numbers using invalid characters. You can find an example of my code here

Oh, I got it! It's a different inventorynumber id, receiptinventorynumber. The issueinventorynumber is the list of serial numbers you might select when assigning which items you are selecting on an item fulfilment. Just going to test this on my main script and update that as the answer.

Yea, I was away yesterday. I managed to get the script working to be able to overwrite the inventory status of each of the saved items. But I still cannot get issueinventorynumber to log with a value, they're all still coming out blank. Does this look like what you wanted me to try and replicate? I've attached the script I…

I've attached my code, which now appears to recognize that there are 6 separate serial numbers that it needs to count, but perhaps it's not assigning them correctly to the serialNumbers variable. I tried using receiptInventoryNumber instead of issueInventoryNumber to no success, but noticed that untitled changed to…

Thanks @Richard James Uri-Oracle. Just to double check, are you sure? I don't know how to visualize it in my head but I'm reading that the serial numbers are inside of the inventoryassignment sublist. Is inventoryassignment not within inventorydetail subrecrod? Or are those two separate things? Inventorydetail is on an…

Thanks @Patrick Fresnosa-Oracle , this lead me to the answer. After checking the Consolidated Exchange Rates, the values were completely out of sync. In the wrong direction entirely even. I think this is indeed what I had been checking every period and was forgetting this time. Lists > Accounting > Consolidated Exchange…

Your fine, no worries :)

Yes, if the item only exists in UK records and inventory then the reports in £ all appear correct.

Nevermind. A simple log tells me it's running. I was just expecting something to go wrong. Apparently nothing is wrong but nothing is being created. Will continue~

It's not just be the reports, sorry I should have expanded this earlier. To expand on my examples, here's a purchase order worth £60, but following that the related record for one of the items shows it on the purchase order as instead being worth £12 million

Thanks Niks, after following the instructions, I don't think there appears to be any costing calculation or errors being run on my Inv Valuation Report.

Still an ongoing issue to date. Thank you for this! Glad I found it.

Ah, I found this article. All solved~ It mentions that the centre is defected and the link is missing but the url can be entered directly into the browser instead.

Ah, that's very unfortunate to hear. I'm going to have to come up with my own solution to this… Thanks for the confirmation though! I don't think I'll bother writing a request for it. Nothing on there ever seems to get implemented. Even the most upvoted one is over a decade old. 😂