public VAdvantage.Model.MJournal CreateJournalHDR(MRevenueRecognition revenueRecognition, MRevenueRecognitionPlan revenueRecognitionPlan) { journal.SetClientOrg(revenueRecognitionPlan.GetAD_Client_ID(), revenueRecognitionPlan.GetAD_Org_ID()); journal.SetC_AcctSchema_ID(revenueRecognitionPlan.GetC_AcctSchema_ID()); journal.SetDescription("Revenue Recognition Run"); journal.SetPostingType("A"); int C_Doctype_ID = Util.GetValueOfInt(DB.ExecuteScalar("Select C_Doctype_ID From C_Doctype Where DocBaseType='GLJ'")); journal.SetC_DocType_ID(C_Doctype_ID); int GL_Category_ID = Util.GetValueOfInt(DB.ExecuteScalar("Select GL_Category_ID From GL_Category Where CategoryType='M' Order by GL_Category_ID desc")); journal.SetGL_Category_ID(GL_Category_ID); journal.SetDateDoc(DateTime.Now); journal.SetDateAcct(DateTime.Now); DateTime?Today = DateTime.Now; C_Period_ID = Util.GetValueOfInt(DB.ExecuteScalar("Select C_Period_ID From C_Period pr INNER JOIN ad_clientinfo cl ON cl.ad_client_id = " + GetAD_Client_ID() + " INNER JOIN c_year yr ON (yr.c_year_id = pr.c_year_id" + " AND cl.c_calendar_id=yr.c_calendar_id) Where " + GlobalVariable.TO_DATE(Today, true) + " between StartDate and EndDate")); journal.SetC_Period_ID(C_Period_ID); journal.SetC_Currency_ID(revenueRecognitionPlan.GetC_Currency_ID()); int C_ConversionType_ID = Util.GetValueOfInt(DB.ExecuteScalar("Select C_ConversionType_ID From C_ConversionType where IsDefault='Y'")); journal.SetC_ConversionType_ID(C_ConversionType_ID); journal.SetTotalCr(revenueRecognitionPlan.GetTotalAmt()); journal.SetTotalDr(revenueRecognitionPlan.GetTotalAmt()); journal.SetDocStatus("DR"); journal.SetDocAction("CO"); return(journal); }