My Stuff
Comments
-
A suitable fix. Thanks @Wee Ming ~!
-
I think I have it. By adding &xml=t to the url I was able to inspect the item receipt further and found the following fields in existence. One of these likely works, more than likely the amount one.
-
Ah ok, so it will fix itself at the next quarter. Though I am still curious if you know what might have caused this to begin with?
-
One of my users just got this notification emailed to them. This is me looking at the script in question that it warned them on the error. I'm not sure what caused it to trigger, 12 min after I ran the script you suggested that fixed my issue at 4:17. Should I be concerned?
-
https://community.oracle.com/netsuite/english/discussion/comment/16864160#Comment_16864160 This solved the original issue, thanks! Where did you find the answer and what is it that the script actually does? Based on the execution log it 'migrates assets with new and depreciating status' to the depreciation schedule? I…
-
OK, no I don't know if this Retrieve Asset Vales script works. It's throwing the same error on all of my other assets that have been generated normally and don't have the transfer location issue. Here's FAM000736 as an example. No issue transferring.
-
Oh, actually it didn't succeed. It completed, but there was a map error(?). map error FAM000750 {"type":"error.SuiteScriptError","name":"INVALID_ASSET_ID_FORMAT","message":"The specified Asset ID either does not exist or has an invalid format.","id":null,"stack":["Error"," at Object.create (/SuiteBundles/Bundle…
-
https://community.oracle.com/netsuite/english/discussion/comment/16864157#Comment_16864157 Attempted that just as you suggested it, haha. No success I'm afraid. I don't think the error has changed at all. {"type":"error.SuiteScriptError","name":"SSS_MISSING_REQD_ARGUMENT","message":"load: Missing a required argument:…
-
At this point, I'm fairly certain it's the last purchase price.
-
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