Thought as much. Thanks for confirming.

Do I do an unbuild order and then a build order? Do I have to mark all of the components coming out of it and then all of the components going back into it? Seems a little tedious.

Sorry @Angela Bayliss, I'm not using Intercompany Cross-Subsidiary Fulfillment and I'm not asking new questions related to the initial post. I'm just answering JKLFU who has hijacked this thread, haha. I do intercompany transactions where our subsidiaries sell equipment to each other, not to customers. So we create a…

I should have clarified, I meant non inventory as in anything that is not inventory. Meaning that non-inventory, description, discount, kit/package, markup, other charge, payment and service, all of these item types cannot be used when creating an intercompany PO and further will not work in the manage intercompany sales…

An intercompany order cannot be created with non inventory items. You have to edit those in after you create and pair the orders.

https://community.oracle.com/netsuite/english/discussion/comment/16863664#Comment_16863664 Hey JKLFU, We put a customer tag on the bill from carrier company, and recharge the receiving subsidiary at the quarter end via billable expense. You could also consider creating a non-inventory item called Shipping Costs. You'd have…

This proved as a fix for the following error I was having when user was attempting to update asset records via CSV: {"type":"error.SuiteScriptError","name":"INPUT_ERROR","message":"This role does not have permission to edit Asset record.","id":null,"stack":["Error"," at Object.create (/SuiteBundles/Bundle…

Sorry, must have been blind. I have the requestor join fields and they appear to be working for most records. Thanks!

https://community.oracle.com/netsuite/english/discussion/comment/16862637#Comment_16862637 Is requestor for you employee but labeled differently? As I don't have requestor join fields. I can get employee to work as a filter and employee… name as a column is working but only on certain record types like expense reports but…

https://community.oracle.com/netsuite/english/discussion/comment/16862796#Comment_16862796 Looks good! Tysm~

https://community.oracle.com/netsuite/english/discussion/comment/16862725#Comment_16862725 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 https://us.v-cdn.net/6032262/uploads/3UR57DEC6CJD/warranty5.txt @Nicole Mendoza-Oracle has provided extensive breakdown of this…

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. https://community.oracle.com/netsuite/english/discussion/4493583/n-search-filter-expecting-numeric-value-was-removed-as-non-numeric-value-wa-was-provided

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. https://us.v-cdn.net/6032262/uploads/HG6OEEJVTY9K/warranty2.txt // Retrieve item details from the Item Receipt's line items var…

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. https://us.v-cdn.net/6032262/uploads/N2LLH731WNJN/warranty2.txt I tried using receiptInventoryNumber instead of…