[Adolfo GarzaMember @adolfo_garza]

Using Serverside Suitescript 2.0 you gotta load the apply sublist and get items with apply:”T” like:

var CPRecord=RECORDMODULE.load({type: RECORDMODULE.Type.CUSTOMER_PAYMENT, id: 3382, isDynamic: false,});
var lineCount = CPRecord.getLineCount(“apply”);

for (var i = 0; i < lineCount; i++) {
var isApplied = CPRecord.getSublistValue({ sublistId: ‘apply’, fieldId: ‘apply’, line: i });
if(isApplied){
log.debug(‘Applied found!’, CPRecord.getSublistValue({ sublistId: ‘apply’, fieldId: ‘internalid’, line: i }));
}
}

 

https://pastebin.com/FzXiNeeP

[Adolfo GarzaMember @adolfo_garza]

Try using: https://webservices.netsuite.com/services/NetSuitePort_2018_1

[Adolfo GarzaMember @adolfo_garza]

Try using “salesrep” “anyof” “@NONE@”, at least that’s how it’s done in Suitescript.

[Adolfo GarzaMember @adolfo_garza]

Yeah, you can load any library/file as a string and then run the code using eval.

[Adolfo GarzaMember @adolfo_garza]

Advanced PDF is pretty buggy. I would recommend saving a backup of the template and then switching to code mode and making your edits there. It helps to remove styles and other code that the editor adds, you can use html-cleaner .com for this. Once you have a simplified code you can work on adding back the style.

[Adolfo GarzaMember @adolfo_garza]

@jhonnel_turingan  If you are trying to remove lines from a fulfillment you might want to set ‘itemreceive’ linefield to false instead.

• This reply was modified 6 years ago by Adolfo Garza.

[Adolfo GarzaMember @adolfo_garza]

Check the help section: https://imgur.com/a/jklgAdW

Find the module section and under the module description on a table there’s a column called “Supported Script Types” , that tells you if it applies to clientscripts

[Adolfo GarzaMember @adolfo_garza]

Do you have anything else besides that line of code in your code? Try with log.debug(“request”, context.request.method);

[Adolfo GarzaMember @adolfo_garza]

Do it the other way around. If the order includes an Assembly item then set the result to 1, else 0, then exclude anything over 0.

Column:
Field: Formula(Numeric)
Formula: CASE {item.class} WHEN ‘Assembly’ THEN 1 else 0 END
SummaryType: Sum

Then use a summary filter to define that you want to include only those where the sum is 0:
Field: Formula(Numeric)
Formula: CASE {item.class} WHEN ‘Assembly’ THEN 1 else 0 END
SummaryType: Sum

• This reply was modified 6 years, 3 months ago by Adolfo Garza.
• This reply was modified 6 years, 3 months ago by Adolfo Garza.

[Adolfo GarzaMember @adolfo_garza]

Can you please confirm what you need? I am confused by the first 3 criterias in your post, do all 3 of them need to match? I think it would be helpful if you provide an scenario and then provide a table of what you would like to see in your search results.

[Adolfo GarzaMember @adolfo_garza]

Awesome! Thanks for sharing.

[Adolfo GarzaMember @adolfo_garza]

The code you entered in the lower section doesn’t match the error you described. The error you described says “Cannot find function setLineItemvalue in object nlobjRecord” which has “setLineItemvalue” mispelled, it should be “setLineItemValue”

[Adolfo GarzaMember @adolfo_garza]

Nice. Thanks for sharing!

[Adolfo GarzaMember @adolfo_garza]

This one is tricky. The only way I can think of is doing it by suitescript because that way you can set the sorting of the results by the system notes date and then grab the first result.

• This reply was modified 7 years, 5 months ago by Adolfo Garza.

[Adolfo GarzaMember @adolfo_garza]

He means that you just create the script record, but do not deploy it. Also, that code is for Suitescript 1.0. Here’s a link that explains how to do it in both:
https://ursuscode.com/netsuite-tips/running-client-script-in-view-mode/

[Author]

Posts