@dmashburn3 Why/when/how those generate another queue recs..??? My point is

some times

is not a condition, something should happen in order to create new queue recs, if you can define that then you can probably handle the logic triggering another M/R from your Summary stage and passing those new queue recs...

Ah, my retrigger was in the reduce. I'll move it down to summarize and try from there.

Thanks!

@dmashburn3 But you can't re-trigger yourself as far as I know... you need another one...let name it:

the_house_painter_mr

which is going to finish the job!

Does anyone know a way in SuiteScript to tell if a Sales Order has been completely returned? Like how to tell if the Authorize Return button would be showing?

Besides going through all the lines, comparing quantity vs quantities on all returns.

Seems tedious.

Anybody ever face a problem when inventory on hand become zero but the item still have value? few pennies...?

@alien4u dint come across that scenario 🙄

Guys any idea how to trigger a user event script from a scheduled script ?

@samantha Nothing special, Schedule Scripts normally would trigger UE....

@alien4u how do we call UE from Scheduled scripts

execute(scriptContext) {}

method

@samantha what @alien4u is saying is to submit any change to the record from the scheduled script

You don't need to call it... if the Schedule Scripts modify the record the UserEvent script associated with that record would trigger...

you don't even need to change anything, if you did a load and save, it would trigger the UE

@andrewh so if i just simply load that record , then all these methods of UE will be invoked ?

return {
		beforeLoad: beforeLoad,
		beforeSubmit: beforeSubmit,
		afterSubmit: afterSubmit
	};

not when you load, when you save... (you have me second guessing myself on load, but they definitely fire on save)

let me try if it works on saving . thank you

it'll fire on save, if you're not getting the before load when loading from the SS, throw those actions in a function in a custom library that both scripts can call on...

@andrewh sure , that looks like a right approach

I am not sure what I am doing wrong on this payment. I keep getting

You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist.

If I get a -1 from findSublistLineWithValue I create a new payment line on VENDOR_PAYMENT

var paymentLine = payment.selectNewLine({sublistId: 'apply'});

         paymentLine.setCurrentSublistValue({
                   sublistId: 'apply',
                   fieldId: 'apply',
                   value: true
         });
          paymentLine.setCurrentSublistValue({
                    sublistId: 'apply',
                    fieldId: 'amount',
                    value: context.amount
          });
           paymentLine.setCurrentSublistValue({
                    sublistId: 'apply',
                    fieldId: 'refnum',
                    value: context.tranid
                    }).commitLine({sublistId: 'apply'});

Not sure what I am missing.

shouldn't open bills already be in the sublist? I'm thinking maybe you shouldn't be selecting a new line, but looping the apply sublist to find the existing line with the transaction you want

Did you load with

isDynamic; true

?

@ehcanadian yes

@andrewh I had tried that as well, but keep getting -1 back. It's really weird because this RESTlet worked previously. I was able to do something like this and it' just worked.

var linenum = payment.findSublistLineWithValue({
                 sublistId: 'apply',
                 fieldId: 'internalid',
                 value: context.billid
             });

@Carl Jenkins I would assume you have access to some body fields on

context

but I don't think you will have access to all of them, depending on the script type you may need to

load

or use

getValue

...

@alien4u The context in my example is JSON being passed into me via an external system. So, context.entity is a vendorId, context.amount is amount etc..

if your confident you have the correct internal id, try explicitly converting it to a number

@andrewh will give that a shot.

Here is the setup.

//create a new payment for the vendor
var payment = record.create({
    type: record.Type.VENDOR_PAYMENT,
    isDynamic: true,
}).setValue({
    fieldId: 'entity',
    value: context.entity
}).setValue({
    fieldId: 'trandate',
    value: fmt.parse({
        value: context.trandate,
        type: fmt.Type.DATE
    })
}).setValue({
    fieldId: 'autoapply',
    value: 'F'
}).setValue({
    fieldId: 'memo',
    value: context.memo
});

if (context.tranid) {
    payment.setValue({
        fieldId: 'tranid',
        value: context.tranid
    });

}


var linenum = payment.findSublistLineWithValue({
    sublistId: 'apply',
    fieldId: 'internalid',
    value: context.billid
}); 

payment.selectLine({
    sublistId: 'apply',
    line: linenum
}).setCurrentSublistValue({
    sublistId: 'apply',
    fieldId: 'apply',
    value: true
}).setCurrentSublistValue({
    sublistId: 'apply',
    fieldId: 'amount',
    value: context.amount
}).setCurrentSublistValue({
    sublistId: 'apply',
    fieldId: 'refnum',
    value: context.amount
}).commitLine({sublistId: 'apply'});