I have a NetSuite Created search that appears to b...
# administration
m
I have a NetSuite Created search that appears to be restricted to Income Accounts. I need it also to check for Deferred Revenue Accounts. Any insight as to how I may be able to modify this to suffice?
Copy code
CASE WHEN TO_CHAR({transaction.trandate}, 'MON') = 'MAR' and {transaction.account.id} = {incomeaccount.id} AND {transaction.posting}= 'T' THEN {transaction.quantity}  ELSE 0 END
n
Problem is Deferred Revenue Accounts may not be so neatly classified as the Income accounts. One way would be to specify the additional account IDs you want to include like "WHEN {account.id} IN ('221','222','245','331') THEN". You complete formula might be:
Copy code
CASE WHEN TO_CHAR({transaction.trandate}, 'MON') = 'MAR' and ({transaction.account.id} = {incomeaccount.id} OR  {transaction.account.id} IN ('221','222','245','331')) AND {transaction.posting}= 'T' THEN {transaction.quantity}  ELSE 0 END
m
thanks, I'll give it a whirl. If I switch to {deferredrevenueaccount.id} it works but I couldn't combine it for some reason. For now I have split it by month to look at income or deferred which works alright. I'll try your method this weekend and update.