https://netsuiteprofessionals.com logo
Join Slack
Powered by
So anyone figure out a way to report next approver...
# general
b
So anyone figure out a way to report next approver using SuiteApprovals where you use a Group instead of a Hierarchy? I cant seem to nail down the Next Approver field and unsure if its even a reportable field
k
Is there a visible field on the record you can click on?
I'm sure you tried this - but what happens if you click on it - and take it's internal ID and shove that into results on a saved search?
b
I tried shoving it into a formula text field and got an Invalid Expression error
k
invalid expression? or field not found?
invalid expression seems odd.
b
message has been deleted
k
wrap it in brackets
{
also - "custpage" probably means it won't work.
b
Yeah I swear it isnt my first day lol but yeah doing that resulted in a Field Not Found error
k
if you scroll to the bottom of your fields list - do you get any joins?
b
I do, but thats part of the problem with what I am seeing with the SuiteApprovals bundle. It appears that none of those fields are anywhere to be found
k
Ok - well, the records have to exist somewhere haha
Have you considered looking through your custom records list to see if there is anything that could apply that you could reverse engineer the search (i.e. not use a transaction search?)
Copy code
Viewing Approval History
Approval details are tracked for records that are routed for approval using the SuiteApprovals workflow.

Supported records using SuiteApprovals include an Approval History subtab that contains the following:

Approval Action

Action Owner

Date of Action

Approval Status

Approver Type

Next Approver

Remarks

To view approval history for a record:
Open the corresponding list page for the record you want to view:

Journal Entry — Go to Transactions > Financial > Make Journal Entries > List (Administrator).

Expense Report — Go to Transactions > Employees > Enter Expense Reports > List (Administrator).

Purchase Order — Go to Vendor Dashboard > Transactions > Enter Purchase Orders > List (Administrator).

Requisition — Go to Transactions > Purchases > Enter Requisitions > List

Sales Order — Go to Transactions > Sales > Enter Sales Orders > List (Administrator).

Vendor Bill — Go to Vendor Dashboard > Transactions > Enter Bills > List (Administrator).

For engineering change orders, refer to Viewing Approval History.

Click the View link for the record you want to view.

Click the Approval History subtab.
Record title is probably "Approval history"
b
Yeah I unfortunately in a saved search cannot find Approval history
I can see it in the UI looking at a transaction but even when I go to edit a record it disappears
a
unfortunately there’s not a great way around this, it’s one of the major SuiteApprovals limitations. If it works for you, I believe there is a custom portlet that comes w the SA bundle which has things pending your approval, but iirc it’s limited to a certain record type so it doesn’t always work. The next workaround we tried was a script (I think it was a beforeLoad UE) running on the record that captures the value from the custpage field and sets it into another/normal field that can be used in saved searches. However, that only sort of works - it only works if SA identifies the approver while the user is still looking at the page, if it takes longer (it’s a back end process so sometimes it takes a minute or so) and the user is no longer on the record, the script won’t be able to copy the value. Our last option was just giving up on SA and making a custom workflow lol because this and other limitations are a major inconvenience.
b
Yikes that was what I was afraid of
c
We re-engineered to use a combination of email aliases to alert approval groups -- e.g. quality@work-is-hell.com and then roles for the allowed approvers.
b
How did the system know when it went from the first group or approvers to the second group for a particular PO?
3 Views
Open in Slack
PreviousNext
Powered by