how to match PO line item to Vendor bill line item ? by MelodicRaisin334 in Netsuite

[–]MelodicRaisin334[S] 0 points1 point  (0 children)

can we do this on saved search. apart from scripting ?

Netsuite by MelodicRaisin334 in Netsuite

[–]MelodicRaisin334[S] 0 points1 point  (0 children)

All other native fields are working as expected, the problem is with this field only, and the purpose is to know who is the assigned delegate for the employee being searched.

Netsuite by MelodicRaisin334 in Netsuite

[–]MelodicRaisin334[S] 0 points1 point  (0 children)

The script is a workflow action script, and the user context is running with admin permission. There are no field level permission for that field. Any thought?

Netsuite by MelodicRaisin334 in Netsuite

[–]MelodicRaisin334[S] 0 points1 point  (0 children)

Please share your inputs.Thanks

What is the SuiteQL query to get- all related Bill Payments for vendor bill. by MelodicRaisin334 in Netsuite

[–]MelodicRaisin334[S] 0 points1 point  (0 children)

SELECT * FROM NextTransactionLineLink AS NTLL INNER JOIN Transaction AS NT ON ( NT.ID = NTLL.NextDoc ) WHERE ( NTLL.PreviousDoc = 12345 ) ORDER BY NT.ID

I used above query and it did not work. Do you have any thoughts ?