<@U01E037GJ84> I don't think so. I've created my o...
# accounting
m
@Netsuite Tragic I don't think so. I've created my own aging using custom fields sourced from saved searches to achieve this and was even able to access them on the customer statement.
n
I was thinking the same, already created a summary search on Amount Remaining.
m
Beware with amount remaining it's always a positive value even for credits. You can do something like
{amountremaining} * CASE WHEN {amount} > 0 THEN 1 ELSE -1 END
n
Yep, I used a Decode {type} to deal with that. Ended up with 5 aging periods, 10 saved searches as we have some Parent customers. The 5 x formula fields for the consolidated.
m
The problem with just checking the transaction type is journals might be credits or debits.
n
True that