Discussions
Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
WATCH: Create AR Aging Report & AR Aging Detail Report using Saved Search
This is a How-to video on exposing the Internal ID of the transactions on A/R Aging and A/R Aging Detail reports.
Here are the formulas you can copy and paste:
Formula for Current Open Balance:
- Case When substr({amount},1,1) = '-' and (NVL({daysoverdue}, Round({today}-{trandate}, 0))) < 1 then ({amountremaining}*-1) When substr({amount},1,1) <> '-' and (NVL({daysoverdue}, Round({today}-{trandate}, 0))) < 1 then {amountremaining} else 0 end
Formula for Open Balance = 30 days:
- Case When substr({amount},1,1) = '-' and (NVL({daysoverdue}, Round({today}-{trandate}, 0))) between 1 and 30 then ({amountremaining}*-1) When substr({amount},1,1) <> '-' and (NVL({daysoverdue}, Round({today}-{trandate}, 0))) between 1 and 30 then {amountremaining} else 0 end
Kindly mark "Yes" if you find the reply to your question as helpful. This will aid the community to find the solution/answer much easier. Let's always mark a reply and help the community! ☺️
Shamaine Chan-Oracle | Ask a Guru
Tagged:
1