• ERP Support
      • Netsuite System Status
  • Quicta Support
Submit a Request
Login
  • Home
  • /
  • Jcurve Support Articles
  • /
  • Set the Revenue Rec Start Date and Revenue Rec End Dates via Script
Jcurve Support Articles / Setup & Customisation

Set the Revenue Rec Start Date and Revenue Rec End Dates via Script

Written by
Manuelito Macalinao
Published on
August 31, 2023 at 9:19:48 AM PDT August 31, 2023 at 9:19:48 AM PDTst, August 31, 2023 at 9:19:48 AM PDT

Scenario

This is applicable if you want toset theRevenue Start DateandRevenue End Dateof the item members based on the item group by using it on aUserEventScript.

Solution

SuiteScript 1.0:

functionchangerevrec(type){var itemCount =nlapiGetLineItemCount('item');nlapiLogExecution('DEBUG','itemCount');var itemname;var itemType;var isGroup ='F';//will serve as a flagvar revrecstartdate;var revrecenddate;//loop to each itemsfor(var i =1; i<=itemCount; i++){ itemname=nlapiGetLineItemValue('item','item',i); itemType=nlapiLookupField('item',itemname,'type');//if end of group item is foundif(itemType==null){ isGroup ='F';}if(isGroup =='T'){if((itemType=='InvtPart')||(itemType =='NonInvtPart')){nlapiSelectLineItem('item',i);nlapiSetCurrentLineItemValue('item','revrecstartdate',revrecstartdate);// Set Start DatenlapiSetCurrentLineItemValue('item','revrecenddate',revrecenddate );// Set End DatenlapiCommitLineItem('item');}}//if start of group item is foundif(itemType=='Group'){ isGroup ='T';nlapiSelectLineItem('item',i); revrecstartdate =nlapiGetCurrentLineItemValue('item','revrecstartdate'); revrecenddate =nlapiGetCurrentLineItemValue('item','revrecenddate');}}
For the SuiteScript 2.0 version, you can check it on SuiteAnswers: 81383 - 2.0 Script set the Revenu
#scripting
#suitescript
#revenue rec start date
#revenue rec end date
Jcurve Support Articles / Setup & Customisation
Back to Top

Stay connected

  • Quick Links

  • About
  • Products
  • Services
  • Industries
  • Insights
  • Referral
  • Privacy Policy | Terms & Conditions
  • ERP & TEMS Agreement
  • Quicta Agreement
© 2025 Jcurve Solutions