Based on NetSuite Help Guide via the following navigational path below:
Accounting : Revenue Recognition : Using Revenue Recognition : Working with Revenue Recognition Schedules : Reviewing the Revenue Recognition Schedules List
Status – The amortization status can be one of the following:
- Not Started – No revenue has yet been recognized.
- In Progress – Some revenue has been recognized, but not all.
- Complete – All revenue has been recognized for this schedule.
Alternate SQL Query:
(select case when sum(decode(IS_RECOGNIZED,'No',1,0)) = count(1) then 'Not Started'
when sum(decode(IS_RECOGNIZED,'No',1,0)) < count(1) then 'In Progress'
else 'Complete' end
from REVRECSCHEDULELINES RSL where RS.SCHEDULE_ID = RSL.SCHEDULE_ID) Status
from REVRECSCHEDULES RS