Revenue recognition schedules track revenue deferred from Accounts Receivable or Order Entry sales transactions. The system generates revenue recognition schedules for applicable posted sales transactions containing items with associated revenue recognition templates.


List Revenue Recognition Schedules

readByQuery

<readByQuery>
    <object>REVRECSCHEDULE</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use REVRECSCHEDULE
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100).

query

Name Required Type Description
DOCENTRYKEY Optional string RECORDNO for the SODOCUMENTENTRY with the revenue recognition schedule to list
STATUS Optional string Status of the revenue recognition schedule. Use N for Not Started, P for In Progress, C for Completed, H for On Hold, D for Terminated, or X for Partially Terminated.
REVRECTEMPLATEID Optional string ID of revenue recognition template
RECMETHOD Optional string Revenue recognition method. Use E for Straight line, S for Straight-line, prorate exact days, P for Straight-line, percent allocation, F for Straight-line, percent allocation, end of period, X for Exact days per period, prorate days, D for Exact days per period, prorate days, end of period, T for Percent Completed, M for Milestone, or C for Custom.

Get Revenue Recognition Schedule

read

<read>
    <object>REVRECSCHEDULE</object>
    <keys>121</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use REVRECSCHEDULE
keys Required string RECORDNO of the revenue recognition schedule to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Hold Revenue Recognition Schedule (Legacy)

hold_revrecschedule

<hold_revrecschedule>
    <recordno>121</recordno>
    <category></category>
    <memo></memo>
</hold_revrecschedule>

Parameters

Name Required Type Description
recordno Required string RECORDNO of a revenue recognition schedule whose status is Not started (N), In progress (P), or Partially terminated (X).
category Optional string Category defining the reason for the hold. Use Collectability, Delivery Commitment, Dispute, Legal, or Cancelled Service.
memo Optional string  

Resume Revenue Recognition Schedule (Legacy)

resume_revrecschedule

<resume_revrecschedule>
    <recordno>121</recordno>
    <adjustpostingday>true</adjustpostingday>
    <memo></memo>
</resume_revrecschedule>

Parameters

Name Required Type Description
recordno Required string RECORDNO of a revenue recognition schedule whose status is On hold (H)
adjustpostingday Required boolean Use true to specify that unposted scheduled journal entries will be entered using the next posting date in the schedule.
memo Optional string  

Terminate Revenue Recognition Schedule (Legacy)

terminate_revrecschedule

<terminate_revrecschedule>
    <recordno>12</recordno>
    <category></category>
    <memo></memo>
</terminate_revrecschedule>

Parameters

Name Required Type Description
recordno Required string RECORDNO of a revenue recognition schedule whose STATUS is either Not Started (N), In Progress (P), Partially terminated (X), or On hold (H).
category Optional string Category defining the reason for the termination. Use Collectability, Delivery Commitment, Dispute, Legal, or Cancelled Service.
memo Optional string  

Update Revenue Recognition Schedule (Legacy)

update_revrecschedule

<update_revrecschedule>
    <recordno>121</recordno>
    <memo></memo>
    <revrecentries>
        <revrecentry>
            <recordno>396</recordno>
            <postingdate>
                <year>2017</year>
                <month>8</month>
                <day>21</day>
            </postingdate>
            <accountno>4010</accountno>
            <trx_amount>4513.89</trx_amount>
        </revrecentry>
    </revrecentries>
</update_revrecschedule>

Parameters

Name Required Type Description
recordno Required string RECORDNO of the revenue recognition schedule to update
memo Optional string  
revrecentries Required revrecentry[] One or more entries to update

revrecentry

Name Required Type Description
recordno Required string RECORDNO of the revenue recognition schedule entry to update
postingdate Required object Posting date
accountno Required string Revenue account number
trx_amount Required currency Total transaction amount for the revenue recognition schedule
cumpercent Optional decimal Cumulative Percent Complete
description Optional string Description

postingdate

Name Required Type Description
year Required string Year yyyy
month Required string Month mm
day Required string Day dd

Reallocate Revenue Recognition Schedule (Legacy)

reallocate_revrecschedule

<reallocate_revrecschedule>
    <recordno>12</recordno>
    <revrecstartdate>
        <year>2014</year>
        <month>10</month>
        <day>31</day>
    </revrecstartdate>
    <revrecenddate>
        <year>2014</year>
        <month>10</month>
        <day>31</day>
    </revrecenddate>
</reallocate_revrecschedule>

Parameters

Name Required Type Description
recordno Required string RECORDNO of the revenue recognition schedule to reallocate
revrecstartdate Required object Start date for the schedule
revrecenddate Required object End date for the schedule

revrecstartdate/revrecenddate

Name Required Type Description
year Required string Year yyyy
month Required string Month mm
day Required string Day dd

List Revenue Recognition Schedule Entries

readByQuery

<readByQuery>
    <object>REVRECSCHEDULEENTRY</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

List the revenue recognition schedule for the SODOCUMENTENTRY whose RECORDNO is 21:

<readByQuery>
    <object>REVRECSCHEDULEENTRY</object>
    <fields>*</fields>
    <query>DOCENTRYKEY = 21</query> <!--From the originating SODOCUMENT-->
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use REVRECSCHEDULEENTRY
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

query

Name Required Type Description
DOCENTRYKEY Optional string RECORDNO for the SODOCUMENTENTRY with the revenue recognition schedule entries to list

Get Revenue Recognition Schedule Entry

read

<read>
    <object>REVRECSCHEDULEENTRY</object>
    <keys>43</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use REVRECSCHEDULEENTRY
keys Required string RECORDNO of the revenue recognition schedule entry to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Post Revenue Recognition Schedule Entries (Legacy)

post_revrecscheduleentry

<post_revrecscheduleentry>
    <recordno>1670</recordno>
</post_revrecscheduleentry>

Parameters

Name Required Type Description
recordno Required string RECORDNO of the revenue recognition schedule entry to post
postcurrencygainandloss Optional boolean Use true to post currency gains and losses based on the date you post the entry
exchratetype Optional string Exchange rate type. Set this parameter when postcurrencygainandloss is set to true.

Unpost Revenue Recognition Schedule Entries (Legacy)

unpost_revrecscheduleentry

<unpost_revrecscheduleentry>
    <recordno>1670</recordno>
</unpost_revrecscheduleentry>

Parameters

Name Required Type Description
recordno Required string RECORDNO of the revenue recognition schedule entry to unpost

Provide feedback