Wellyntong Red Ribbon

Never mind…. i checked, and found out that the "SO.getLineItemValue('item', 'woid',i)" does work if you replace the "getLineItemValue" with "getSublistValue". Sorry about that. This case can be closed.

Yes, Ivy, I already compared two records, one that does show up, and one that doesn't, and cannot find the reason. I also looked at two records not showing up, and they do not seem to have any problems in the Date, status or items. Thank you for your efforts, Ivy.

Ivy, I just use the "Default" view of the WCL. Originally, the criteria is set like here: … I order for the specific transaction to show up (it is more than one), I have to change that parameter to "false"… Here are the fields included the result tab: Date Print Type Payroll Batch Document Number Transaction Number Name…

Thank you for your reply, Nicole. "WCL" are "Work Order Close" Netsuite native transaction type. So, no… This is not a custom tansaction record

Thank you John.... While you replied, I did get to that field, however, what I would like is to show the actual unit hat shows up in the Item. In this case the "Primary Unit Type" is showing "US WEIGTH", which points to table "Units Type". That is were the value "lb" that shows up in the item, is coming from, because it is…

Update: Found: PRIMARY UNITS TYPE and PRIMARY STOCK UNIT which point to the "Units Type" table. In that table there is a flag indicating which one is the "preferred" one, showing in the "baseunit" field, in the item. However, still unable to show it in the saved search. Any hints will be appreciated.

Guys, I decided to go another route to resolve this issue. What I did was to call the suitelet from the client script, passing all the needed parameters, and do the sublist population in the suitelet itself. Not sure it is the best approach, but at list I have the results I need for now. Thank you for all your efforts.…

Ok… I think there may be a confusion here… The client script is not even deployed… it is just the module used to set the actions to be talen when the user changes any field in the form… In any case, I think I found the reason for the problem…. The type of sublist is “LIST”, and seems that those cannot be changed via a…

Hu?… Not sure about the “Preferred checkbox of the custom form”…where/how do I do that in a Suitelet serverwidget created form? As far as submitting the case to Netsuite, I might have, but no… The scripts are mine, and they are not completed, by the way… I just want to overcome this one step of displaying the appropriate…

Richard… Thank you for the advise. In this case, the variable is a whole sublist record, as you can see in the code I provided. I tried initializing as the documentation says: using the currentRecord.selectNewLine API, however, that does not resolve the issue. The error occurs in the “currentRecord.commitLine” API. I do…

Ok... I am creating my own suitelet, however, I am facing a new problem. Here are the source codes for the suitelet and the client script, respectively: The "TSM - Available Locations.txt" client script is supposed to populate the sublist in the "TSM - Custom Create Inv Count Page.txt" suitelet. However, I get: If I remove…

How about in 2023?

Thank you for the advise, Richard. In this case, I am the inhouse developer, and I will check on the Suite Answers article. I may be able to complete this task, since I have done a couple already, however, I just wanted to make sure I was not working on something that wasn't even possible. There is a possibility, thou,…

I was only wondering if one cannot create his own Suitelet to replace this screen... Is that even possible?...

You're welcome, Richard.

OK, ladies and gentlemen, I have an update: What happened was that I did not need to specify a "directory", again, in the "sftpConnection.upload" function. In other words, this worked: sftpConnection.upload({ //directory: location, ---> COMMENTED file: fileObj, replaceExisting: true }); ... and this worked with no…

Richard, I am the SuiteScript owner, in this case. Since I am able to complete the Connection.download using the same credentials, corresponding passwordGuid, and the same site hostkey, I am honestly believing that those parameters are not going to be the problem. I cannot provide them in the source I provide here for…

Ok, Richard.... Here is the source: //**************************************************************************** //** Connects to the Truecommerce sftp site and exports the Stock Status CSV //** files from the File Cabinet //**************************************************************************** /** *@NApiVersion…

Richard, Here is a picture of the code with line numbers:

Thank you, Richard.... Here is the new source, with your proposed changes: //**************************************************************************** //** Connects to the sftp site and exports the Stock Status CSV //** files from the File Cabinet…

Ok.. Here is an update: I modified the code to include "fileType: file.Type.CSV" in line 28, however, the error still showed up. I have now tested with a PLAINTEXT file, and the error persists. Also, just in case it is useful to know, the file is 2.15 MB in size.

Richard,. Thank you for looking at this. Here is a picture showing the source with line numbers:

Yes, Dominica, it is a custom field. I have now contacted the developer, and they will le us know how to proceed. Just in case it is of any use for you, here is the field name: "CUSTOMTRANSACTION_MAINACCOUNT_106", bundle: 423371 by BIT. Thank you for your assistance. :-)

Thank you for your collaboration, Dominica... I figured most of the fields are "default" values. However, with this one being "required", and our implementation having it empty, we wanted to be sure we are not missing some functionality, and also we need to know the meaning of the field, since there is no help for it , up…

I appreciate your help greatly, John. Now... The reason I have not replied to the last post is that, simultaneously with my question here, I also submitted a ticket via the support Netsuite site. They came back with instructions to resolve the issue, and I followed them. The issue has been resolved via those instructions,…

Thank you for your prompt response, John... Now... I am not the warehouse manager, neither an expert with the manufacturing operations, so I am not sure how to proceed with the "Reallocate Items" screen, (see screen shot attached)...Should I just go ahead and make the "Quantity Committed" from the rest of the WO to zero?