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. 😂

Hey @Jack Daryl Espiel-Oracle , sorry to dig up this post but I'm having a similar issue over here. Has the functionality changed in the last few years? The SuiteAnswer you mentioned here appears to no longer exist. Would really appreciate the steer. Cheers!

The ability to enter the correct serial numbers into the field manually may be the preferable solution, as it looks like our process is most likely going to require manual generation of Warranty Records going forward.

Oh I see this is for Standard Costing items and all of ours are Average Cost, never mind I suppose. >_< I might go back to my original plan of adjusting the items out and back in at the correct price. The issue with this is that removing inventory only seems to take the last purchase price which I cannot edit. So if I…

That seems to be it, thank you!

Yes, the non reference serial field does in fact accept hashtags and spaces, frustrating. -_-;;

Just noticed smth interesting perhaps… When creating a dataset for other purposes, the test records that were created via the Apps automatic process of creating a record from the invoice have their serial numbers in a field called Serial/Lot. WHere as the manual records I create are Reference Serial/Lot Same with the…

Script answer: /** * @NApiVersion 2.x * @NScriptType ClientScript * @NModuleScope SameAccount */define(['N/currentRecord', 'N/log'], function(currentRecord, log) { function fieldChanged(context) { var rec = context.currentRecord; var sublistName = context.sublistId; var sublistFieldName = context.fieldId; if (sublistName…

Thanks for that. Very helpful!