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! Click here to watch and learn more!
Attention: Customers with NetSuite Electronic Bank Payment (EBP) SuiteApp, version 2020.2 QA (ID 315896) must UPDATE (do NOT uninstall) their bundle to the Production version 2022.1 (ID 416781) by December 31, 2022. Note: If users fail to manually update the Electronic Bank Payments SuiteApp within the given time window, this version of the SuiteApp (ID: 315896) will be deprecated and the account will not be updated to Leading version (2022.1) of the Electronic Bank Payments SuiteApp. Please refer to the campaign email sent to impacted customers for more information.
Update your Profile with your Support type to get your Support Type badge.
Don't miss out on our Question of the Week! You only have until June 08, 2PM EST to comment your answers and earn rewards! Click here for more details.
Join the NetSuite Referral Program and get rewarded for introducing your peers to the NetSuite community. ⭐️ https://lnkd.in/eYXGYfC9
Don't miss out on our Pop Quiz! You only have until June 08, 10:20AM EDT to comment your answers and earn rewards! Click here for more details.
Drumroll please...registration for #SuiteWorld 2023 is now OPEN! See you in Las Vegas October 16-19 to celebrate 25 years of NetSuite with even more learning, more networking, and more fun! The show will sell-out (again), so grab that Early Bird $300 discount and reserve your spot today!
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:
2