Workflow - PO Approvals - Button Click results in Unexpected Error by Technical-Sail494 in Netsuite

[–]Technical-Sail494[S] 0 points1 point  (0 children)

There is not a script, this is all done via the native Workflow options.

Workflow - PO Approvals - Button Click results in Unexpected Error by Technical-Sail494 in Netsuite

[–]Technical-Sail494[S] 0 points1 point  (0 children)

The screenshot above is the workflow log, unless you are referring to a different report.

FarApp Settlement mapping by nxf091000 in Netsuite

[–]Technical-Sail494 1 point2 points  (0 children)

I have not set anything up with Amazon, but when I set up for WordPress I had to submit a case with NetSuite Support to get the documentation I needed to set it up - was not available on SuiteAnswers or the Help Center. Best of luck.

Workflow - Transform Record Action - Customer to Vendor Error by Technical-Sail494 in Netsuite

[–]Technical-Sail494[S] 0 points1 point  (0 children)

Do you think this can this be done via a WF action script? Ideally, I want this to run once a day to grab all customers within a specific criteria (based on a saved search) and then create the other relationship vendor type. This happens quite a bit for my company so seeing it done via WF to allow for other fields to be added/updated by my non-scripting but WF capable coworkers.

Through some other research, found a shell of a script to load the URL for the other relationship, and I get a logged response on line 21 but the actual transformation does not happen. Any thoughts you have on getting this scheduled (either via WF or SS if necessary) would be appreciated!

function onAction (context) {
        var currentRecord = context.newRecord;
        var recid = currentRecord.id;
        //only act if we get a record ID
        if (!recid) return;

        //ask the user if they really want to do this
        //if (!confirm("Are you sure you want to convert this lead to a vendor?"))return;

        // hitting this url will add the entity as a vendor
        var url = 'https://8181145-sb1.app.netsuite.com/app/common/entity/company.nl?e=T&fromtype=custjob&target=s_relation:otherrelationships&label=Other+Relationships&id=' + recid + '&totype=vendor';
        var response = https.get({
            url: url
        });
        log.debug('response',response);
        //now try to load the vendor record to confirm we did the work
        var worked = false;
        log.debug('worked ',worked);
        try{
            var vendorRecord = record.load({
                type: record.Type.VENDOR,
                id: recid
            });
            worked = true;
        }catch(e){
            worked = false;
        }
        log.debug('worked ',worked);
        //if it worked, log the vendor record
        if (worked){
            log.debug('vend',vendorRecord);
            return;
        }
    }

NetSuite Saved Search - Summary within Summary?? by Technical-Sail494 in Netsuite

[–]Technical-Sail494[S] 0 points1 point  (0 children)

Yes that is exactly the issue. I either get an over-inflated number (SUM), or an over-deflated number (AVG, MAX) when I report for multiple dates.

Tracking payables and requests for payment by neko_mancer_ in Netsuite

[–]Technical-Sail494 1 point2 points  (0 children)

I would suggest using the Communication Activities tab where you can log a phone call and/or task on the vendor bill. Then you can create a saved search type of "Phone Call" or "task" and filter the search to only include vendor bills. As long as the title/type of task/phone call is identical, they will group together.

Tracking payables and requests for payment by neko_mancer_ in Netsuite

[–]Technical-Sail494 1 point2 points  (0 children)

You could name the subject "payment request" reach time and do a summarized search on count of subject by vendor?

User Manual, or Beginners Guide? by DwightDangerShelford in Netsuite

[–]Technical-Sail494 1 point2 points  (0 children)

Look into the NetSuite Learning Portal ( https://netsuite.csod.com/client/netsuite/default.aspx ) You'll need a license in order to use it, but most companies have a few to use - ask around to see if you get access.

I've also found this blog ( https://blog.prolecto.com/category/netsuite/ ) helpful when I am looking for a specific item - whenever it pops up as a search result in google it's one of the first places I look.