/** * After Save * @param newRecord * @param success * @return success */ protected override bool AfterSave(bool newRecord, bool success) { if (!success) { return(success); } if (!UpdateCbAndLine()) { return(false); } if (GetVSS_PAYMENTTYPE() == X_C_CashLine.VSS_PAYMENTTYPE_Payment && GetC_BPartner_ID() > 0) { MCash csh = new MCash(GetCtx(), GetC_Cash_ID(), Get_TrxName()); Decimal amt = MConversionRate.ConvertBase(GetCtx(), GetAmount(), // CM adjusted GetC_Currency_ID(), csh.GetDateAcct(), 0, GetAD_Client_ID(), GetAD_Org_ID()); MBPartner bp = new MBPartner(GetCtx(), GetC_BPartner_ID(), Get_Trx()); string retMsg = ""; bool crdAll = bp.IsCreditAllowed(GetC_BPartner_Location_ID(), Decimal.Subtract(0, amt), out retMsg); if (!crdAll) { log.SaveWarning("Warning", retMsg); } else if (bp.IsCreditWatch(GetC_BPartner_Location_ID())) { log.SaveWarning("Warning", Msg.GetMsg(GetCtx(), "VIS_BPCreditWatch")); } } return(true); }
/** * Create Line Reversal * @return new reversed CashLine */ public MCashLine CreateReversal() { MCash parent = GetParent(); if (parent.IsProcessed()) { // saved parent = MCash.Get(GetCtx(), parent.GetAD_Org_ID(), parent.GetStatementDate(), parent.GetC_Currency_ID(), Get_TrxName()); } // MCashLine reversal = new MCashLine(parent); reversal.SetClientOrg(this); reversal.SetC_BankAccount_ID(GetC_BankAccount_ID()); reversal.SetC_Charge_ID(GetC_Charge_ID()); reversal.SetC_Currency_ID(GetC_Currency_ID()); reversal.SetC_Invoice_ID(GetC_Invoice_ID()); reversal.SetCashType(GetCashType()); reversal.SetDescription(GetDescription()); reversal.SetIsGenerated(true); // reversal.SetAmount(Decimal.Negate(GetAmount())); //if (GetDiscountAmt() == null) //// SetDiscountAmt(Env.ZERO); //else reversal.SetDiscountAmt(Decimal.Negate(GetDiscountAmt())); //if (GetWriteOffAmt() == null) // SetWriteOffAmt(Env.ZERO); //else reversal.SetWriteOffAmt(Decimal.Negate(GetWriteOffAmt())); reversal.AddDescription("(" + GetLine() + ")"); return(reversal); }
/** * Get Cash Journal for currency, org and date * @param ctx context * @param C_Currency_ID currency * @param AD_Org_ID org * @param dateAcct date * @param trxName transaction * @return cash */ public static MCash Get(Ctx ctx, int AD_Org_ID, DateTime?dateAcct, int C_Currency_ID, Trx trxName) { MCash retValue = null; // Existing Journal String sql = "SELECT * FROM C_Cash c " + "WHERE c.AD_Org_ID=" + AD_Org_ID // #1 + " AND TRUNC(c.StatementDate, 'DD')=@sdate" // #2 + " AND c.Processed='N'" + " AND EXISTS (SELECT * FROM C_CashBook cb " + "WHERE c.C_CashBook_ID=cb.C_CashBook_ID AND cb.AD_Org_ID=c.AD_Org_ID" + " AND cb.C_Currency_ID=" + C_Currency_ID + ")"; // #3 DataTable dt = null; SqlParameter[] param = null; IDataReader idr = null; try { param = new SqlParameter[1]; param[0] = new SqlParameter("@sdate", TimeUtil.GetDay(dateAcct)); idr = DB.ExecuteReader(sql, param, trxName); dt = new DataTable(); dt.Load(idr); idr.Close(); foreach (DataRow dr in dt.Rows) { retValue = new MCash(ctx, dr, trxName); } } catch (Exception e) { if (idr != null) { idr.Close(); } _log.Log(Level.SEVERE, sql, e); } finally { dt = null; } if (retValue != null) { return(retValue); } // Get CashBook MCashBook cb = MCashBook.Get(ctx, AD_Org_ID, C_Currency_ID); if (cb == null) { _log.Warning("No CashBook for AD_Org_ID=" + AD_Org_ID + ", C_Currency_ID=" + C_Currency_ID); return(null); } // Create New Journal retValue = new MCash(cb, dateAcct); retValue.Save(trxName); return(retValue); }
/** * Parent Cosntructor * @param cash parent */ public MCashLine(MCash cash) : this(cash.GetCtx(), 0, cash.Get_TrxName()) { SetClientOrg(cash); SetC_Cash_ID(cash.GetC_Cash_ID()); _parent = cash; _cashBook = _parent.GetCashBook(); }
/** * Get Cash (parent) * @return cash */ public MCash GetParent() { if (_parent == null) { _parent = new MCash(GetCtx(), GetC_Cash_ID(), Get_TrxName()); } return(_parent); }
//Amit 10-9-2014 - Correspity Work public static MCash Get(Ctx ctx, int AD_Org_ID, DateTime?dateAcct, int C_Currency_ID, int C_CashBook_ID, int C_DocType_ID, Trx trxName) { MCash retValue = null; // Existing Journal String sql = "SELECT * FROM C_Cash c " + "WHERE c.AD_Org_ID=" + AD_Org_ID // #1 + " AND TRUNC(c.StatementDate, 'DD')=@sdate" // #2 + " AND c.Processed='N'" + " AND EXISTS (SELECT * FROM C_CashBook cb " + "WHERE c.C_CashBook_ID=" + C_CashBook_ID + " AND cb.AD_Org_ID=c.AD_Org_ID)"; // #3 DataTable dt = null; SqlParameter[] param = null; IDataReader idr = null; try { param = new SqlParameter[1]; param[0] = new SqlParameter("@sdate", TimeUtil.GetDay(dateAcct)); idr = DB.ExecuteReader(sql, param, trxName); dt = new DataTable(); dt.Load(idr); idr.Close(); foreach (DataRow dr in dt.Rows) { retValue = new MCash(ctx, dr, trxName); } } catch (Exception e) { if (idr != null) { idr.Close(); } _log.Log(Level.SEVERE, sql, e); } finally { dt = null; } if (retValue != null) { return(retValue); } // Get CashBook //MCashBook cb = MCashBook.Get(ctx, AD_Org_ID, C_Currency_ID); //if (cb == null) //{ // _log.Warning("No CashBook for AD_Org_ID=" + AD_Org_ID + ", C_Currency_ID=" + C_Currency_ID); // return null; //} MCashBook cb = new MCashBook(ctx, C_CashBook_ID, trxName); if (cb == null) { _log.Warning("No CashBook"); return(null); } //Get Closing Balance of Last Record of that cashbook //sql = @"SELECT EndingBalance FROM C_Cash WHERE IsActive = 'Y' AND C_CashBook_ID = "+ C_CashBook_ID // + " AND c_cash_id = (SELECT MAX(C_Cash_ID) FROM C_Cash WHERE IsActive = 'Y' AND C_CashBook_ID = " + C_CashBook_ID+ ")"; sql = @"SELECT SUM(completedbalance + runningbalance)AS BegningBalance FROM c_cashbook WHERE IsActive = 'Y' AND c_cashbook_id =" + C_CashBook_ID; decimal beginingBalance = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, trxName)); // Create New Journal retValue = new MCash(cb, dateAcct); retValue.SetC_DocType_ID(C_DocType_ID); retValue.SetBeginningBalance(beginingBalance); retValue.Save(trxName); return(retValue); }
private bool UpdateCbAndLine() { // Update Cash Journal if (!UpdateHeader()) { log.Warning("Cannot update cash journal."); return(false); } // Update Cashbook and CashbookLine MCash parent = GetParent(); MCashBook cashbook = new MCashBook(GetCtx(), parent.GetC_CashBook_ID(), Get_TrxName()); if (cashbook.GetCompletedBalance() == 0) { cashbook.SetCompletedBalance(parent.GetBeginningBalance()); } cashbook.SetRunningBalance(Decimal.Add(Decimal.Subtract(cashbook.GetRunningBalance(), old_ebAmt), new_ebAmt)); //if (cashbook.GetRunningBalance() == 0) //{ // cashbook.SetRunningBalance // (Decimal.Add(Decimal.Add(Decimal.Subtract(cashbook.GetRunningBalance(), old_ebAmt), new_ebAmt),cashbook.GetCompletedBalance())); //} //else //{ // cashbook.SetRunningBalance(Decimal.Add(Decimal.Subtract(cashbook.GetRunningBalance(), old_ebAmt), new_ebAmt)); //} if (!cashbook.Save()) { log.Warning("Cannot update running balance."); return(false); } DataTable dtCashbookLine; int C_CASHBOOKLINE_ID = 0; string sql = "SELECT C_CASHBOOKLINE_ID FROM C_CASHBOOKLINE WHERE C_CASHBOOK_ID=" + cashbook.GetC_CashBook_ID() + " AND DATEACCT=" + DB.TO_DATE(parent.GetDateAcct()) + " AND AD_ORG_ID=" + GetAD_Org_ID(); dtCashbookLine = DB.ExecuteDataset(sql, null, null).Tables[0]; if (dtCashbookLine.Rows.Count > 0) { C_CASHBOOKLINE_ID = Util.GetValueOfInt(dtCashbookLine.Rows[0] .ItemArray[0]); } MCashbookLine cashbookLine = new MCashbookLine(GetCtx(), C_CASHBOOKLINE_ID, Get_TrxName()); if (C_CASHBOOKLINE_ID == 0) { cashbookLine.SetC_CashBook_ID(cashbook.GetC_CashBook_ID()); // SI_0419 : Update org/client as on cash line cashbookLine.SetAD_Org_ID(GetAD_Org_ID()); cashbookLine.SetAD_Client_ID(GetAD_Client_ID()); cashbookLine.SetEndingBalance (Decimal.Add(Decimal.Add(Decimal.Subtract(cashbookLine.GetEndingBalance(), old_ebAmt), new_ebAmt), cashbook.GetCompletedBalance())); } else { cashbookLine.SetEndingBalance(Decimal.Add(Decimal.Subtract(cashbookLine.GetEndingBalance(), old_ebAmt), new_ebAmt)); } cashbookLine.SetDateAcct(parent.GetDateAcct()); cashbookLine.SetStatementDifference(Decimal.Add(Decimal.Subtract(cashbookLine.GetStatementDifference(), old_sdAmt), new_sdAmt)); if (!cashbookLine.Save()) { log.Warning("Cannot create/update cashbook line."); return(false); } return(true); }