Is there a script type that I can execute as a use...
# suitescript
s
Is there a script type that I can execute as a user (instead of -system-) that means I can run with a customized sublist (transactions? ) the transacations have excceded 10k, so unfortunately, i'm getting script errors where its not found
b
what does the code look like
s
So just to explain what the issue is a bit more. There is a NetSuite limitation that if the transaction sublist (e.g vendor payment sublist) has more than 10K lines, the additional lines are not available. However, the sublist headers have toggles, and you can customize the sublist as a user, but unfortunately, it seems for MR scripts, it'll always execute as the system user. This means that you cannot customize the sublist and overcome the issue. What I'm saying is running the same snippet of script in the debugger will yield different results (the lines displayed on the sublist is different, and if it doesnt appear on the sublist, it cant be selected.) In this specific case, it seems that a mass update script when executed will run with the user settings... So in the end I refactored the script from MR to mass update. Executing the script as mass update aligned with the same lines that could be tested on the debugger
b
use the vendorbills or bill default values to limit the transactions in your sublist
practice with them in the ui first to see what they do
depending on what your code looks like, you may also have to use the entity or subsidiary default values too
s
its very specific, but there is an AP Account, Vendor, Subsidiary, Currency , Account combination specifically that exceeded 10k because they werent settled, (its a bunch of ap journals debit and credit) the accounts team didnt know that there was a procedure to "net them off" using vendor payment