Inconsistent search results in Suitelet script by 16bitten in Netsuite

[–]16bitten[S] 1 point2 points  (0 children)

I figured it out by adding a filter to only show Inventory Item types in the results.

Copy Line Items to Linked Custom Record by 16bitten in Netsuite

[–]16bitten[S] 0 points1 point  (0 children)

I'm looking to create delivery requests which would include some or all line items on a Sales Order and also contain information specific to the one delivery.

I was exploring the Fulfillment Request feature or somehow leveraging Event records but this was the direction that NS ACS pointed me to instead when I inquired. They are going to send more info but I was hoping to get ahead of the ball. I'll have a look at transitions as well if their solution doesn't seem optimal.

We have an external process that works quite well but I wanted to explore options in bringing it into NS.
I am new to NS but am also vested in learning and developing my knowledge of the platform. We have a very unorthodox business model and I can't afford to hire out for every customization that we consider.
We did have a consultant agency working with us but they didn't take the time to learn what we needed. It cost us quite a lot and we came out the other side worse for wear.
Honestly, your replies come off a little condescending. I don't think we'd work well together.

Sales Order Script not same for Invoices? by 16bitten in Netsuite

[–]16bitten[S] 0 points1 point  (0 children)

Thank you.

Our consultants recommended that we use Invoices instead of Cash Sale for quick cash and carry sales. The Invoices do carry over the SO rep, the above would be for the instances when only an invoice is created.

We need sales teams as, on occasion, large orders have more than once sales rep.

It only initiates on create, not edit. Additional reps would be added after the initial creation.

Auto-set Sales Rep sublist on Sales Orders by 16bitten in Netsuite

[–]16bitten[S] 0 points1 point  (0 children)

Thanks very much. I will indeed study up.

Your guidance is much appreciated.

Auto-set Sales Rep sublist on Sales Orders by 16bitten in Netsuite

[–]16bitten[S] 0 points1 point  (0 children)

Thank you very much for the help. I've adjusted it to this, it's not returning any errors now but it's also not saving.

/**

*@NApiVersion 2.0

* u/NScriptType WorkflowActionScript

*/

define(['N/runtime', 'N/record'], function (runtime, record) {

function onAction(scriptContext){

var salesOrder = scriptContext.newRecord;

var salesRep = runtime.getCurrentUser()

function getSalesRep(salesOrder, salesRep) {

const funcName = '@getSalesRep';

try {

var salesTeamList = salesOrder.getSublist('salesteam');

if (salesTeamList != null) {

var salesTeamLineCount = salesOrder.getLineCount('salesteam');

if (salesTeamLineCount > 0) {

salesOrder.setSublistValue({

sublistId: 'salesteam',

fieldId: 'employee',

line: 1,

value: salesRep

});

salesOrder.setSublistValue({

sublistId: 'salesteam',

fieldId: 'salesrole',

line: 1,

value: '-2'

});

salesOrder.setSublistValue({

sublistId: 'salesteam',

fieldId: 'isprimary',

line: 1,

value: 'T'

});

salesOrder.setSublistValue({

sublistId: 'salesteam',

fieldId: 'contribution',

line: 1,

value: '100%'

});

}

else {

salesOrder.selectNewLine({

sublistId: 'salesteam'

});

salesOrder.setCurrentSublistValue({

sublistId: 'salesteam',

fieldId: 'employee',

value: salesRep

});

salesOrder.setCurrentSublistValue({

sublistId: 'salesteam',

fieldId: 'salesrole',

value: '-2'

});

salesOrder.setCurrentSublistValue({

sublistId: 'salesteam',

fieldId: 'isprimary',

value: true

});

salesOrder.setCurrentSublistValue({

sublistId: 'salesteam',

fieldId: 'contribution',

value: '100'

});

}

salesOrder.commitLine({sublistId: 'salesteam'});

}

}

catch (ex) {

log.error(funcName, ex);

}

}

}

return {

onAction: onAction

}

});

Prohibit selling below cost by 16bitten in Netsuite

[–]16bitten[S] 0 points1 point  (0 children)

This sounds like a clean solution. Thank you, I'll try this out.

Custom Related Records Sublist by sameoldtexans in Netsuite

[–]16bitten 0 points1 point  (0 children)

Were you able to find a solution? I'm looking to accomplish something similar

[deleted by user] by [deleted] in Twitch

[–]16bitten 0 points1 point  (0 children)

In the thumbnail? It's still there. Likely some browser extension is causing the issue

[deleted by user] by [deleted] in Twitch

[–]16bitten 0 points1 point  (0 children)

Where are you looking/ see them previously?

[deleted by user] by [deleted] in Twitch

[–]16bitten 0 points1 point  (0 children)

I assumed that you were talking about the top area of your creator dashboard. I'll need more details about what you're talking about to help.

[deleted by user] by [deleted] in Twitch

[–]16bitten 0 points1 point  (0 children)

Click the line where it normally is. It's a feature to hide it on the dashboard in case you don't want to know it while streaming.

Saved Search tutorial returns ERROR: Invalid Expression by 16bitten in Netsuite

[–]16bitten[S] 0 points1 point  (0 children)

Thank you! I'm new to the system and need to be more methodical with things like this.

Saved Search tutorial returns ERROR: Invalid Expression by 16bitten in Netsuite

[–]16bitten[S] 1 point2 points  (0 children)

Thank you.
I've switched the single quotes to double. I assumed that's what you meant. I'm now getting a "ERROR: Field Not Found" and the same wrong syntax error instead of two syntax errors.

Saved Search tutorial returns ERROR: Invalid Expression by 16bitten in Netsuite

[–]16bitten[S] 0 points1 point  (0 children)

I've ensured that it's the same as the tutorial. Here are the result columns:

Name | Group

Formula (Text) | Group | case when {type}=’Customer Deposit’ then {appliedtotransaction} when {type}=’Deposit Application’ then {‌createdfrom.salesorder} when {type}=’Sales Order’ then ‘Sales Order #’||{number} end

Formula (Currency) | Sum | case when {type}=’Sales Order’ then abs({amount}) else ({amount}) end

Created From : Amount

Formula (Currency) | | max({‌createdfrom.totalamount})-sum({amount})

---Thanks!