/// <summary>
/// Load Invoice Line.
/// 4 amounts
/// AMTTYPE_Payment
/// AMTTYPE_Statement2
/// AMTTYPE_Charge
/// AMTTYPE_Interest
/// </summary>
/// <param name="bs">bank statement</param>
/// <returns>DocLine Array</returns>
private DocLine[] LoadLines(MBankStatement bs)
{
List <DocLine> list = new List <DocLine>();
MBankStatementLine[] lines = bs.GetLines(false);
for (int i = 0; i < lines.Length; i++)
{
MBankStatementLine line = lines[i];
DocLine_Bank docLine = new DocLine_Bank(line, this);
// Set Date Acct
if (i == 0)
{
SetDateAcct(line.GetDateAcct());
}
MPeriod period = MPeriod.Get(GetCtx(), line.GetDateAcct());
if (period != null && period.IsOpen(MDocBaseType.DOCBASETYPE_BANKSTATEMENT))
{
docLine.SetC_Period_ID(period.GetC_Period_ID());
}
//
list.Add(docLine);
}
// Return Array
DocLine[] dls = new DocLine[list.Count];
dls = list.ToArray();
return(dls);
}
/// <summary>
/// Create Facts (the accounting logic) for
/// CMB.
/// <pre>
/// BankAsset DR CR (Statement)
/// BankInTransit DR CR (Payment)
/// Charge DR (Charge)
/// Interest DR CR (Interest)
/// </pre>
/// </summary>
/// <param name="as1"></param>
/// <returns></returns>
public override List <Fact> CreateFacts(MAcctSchema as1)
{
// create Fact Header
Fact fact = new Fact(this, as1, Fact.POST_Actual);
// Header -- there may be different currency amounts
FactLine fl = null;
int AD_Org_ID = GetBank_Org_ID(); // Bank Account Org
bool addPost = false;
//Check For Module
Tuple <String, String, String> aInfo = null;
if (Env.HasModulePrefix("ED008_", out aInfo))
{
addPost = true;
}
else
{
addPost = false;
}
// Posting Work Done For ED008 Module
if (addPost == true)
{
for (int i = 0; i < _lines.Length; i++)
{
DocLine_Bank line = (DocLine_Bank)_lines[i];
int C_BPartner_ID = line.GetC_BPartner_ID();
int C_Payment_ID = line.GetC_Payment_ID();
// BankAsset DR CR (Statement)
fl = fact.CreateLine(line,
GetAccount(Doc.ACCTTYPE_BankAsset, as1), line.GetC_Currency_ID(), line.GetStmtAmt());
if (fl != null && AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
if (fl != null && C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
// BankInTransit DR CR (Payment)
MAccount acct = null;
string tenderType = Util.GetValueOfString(DB.ExecuteScalar("SELECT tendertype FROM C_Payment WHERE C_Payment_ID=" + C_Payment_ID + " AND AD_Client_ID = " + GetAD_Client_ID()));
// Tender Type RIBA
if ("R".Equals(tenderType))
{
int validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_RIBA_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=" + GetC_BankAccount_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (validComID > 0)
{
acct = MAccount.Get(Env.GetCtx(), validComID);
}
if (acct == null)
{
validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_RIBA_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
acct = MAccount.Get(Env.GetCtx(), validComID);
}
}
// Tender Type MAV
else if ("M".Equals(tenderType))
{
int validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_MAV_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=" + GetC_BankAccount_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (validComID > 0)
{
acct = MAccount.Get(Env.GetCtx(), validComID);
}
if (acct == null)
{
validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_MAV_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
acct = MAccount.Get(Env.GetCtx(), validComID);
}
}
// Tender Type RID
else if ("I".Equals(tenderType))
{
int validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_RID_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=" + GetC_BankAccount_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
if (validComID > 0)
{
acct = MAccount.Get(Env.GetCtx(), validComID);
}
if (acct == null)
{
validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT ED000_RID_Acct FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID()));
acct = MAccount.Get(Env.GetCtx(), validComID);
}
}
else
{
acct = GetAccount(Doc.ACCTTYPE_BankInTransit, as1);
}
fl = fact.CreateLine(line, acct, line.GetC_Currency_ID(), Decimal.Negate(line.GetTrxAmt()));
if (fl != null)
{
if (C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
if (AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
else
{
fl.SetAD_Org_ID(line.GetAD_Org_ID(true)); // from payment
}
}
// Charge DR (Charge)
fl = fact.CreateLine(line, line.GetChargeAccount(as1, Decimal.Negate(line.GetChargeAmt())), line.GetC_Currency_ID(), Decimal.Negate(line.GetChargeAmt()), null);
if (fl != null && C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
// Interest DR CR (Interest)
if (Env.Signum(line.GetInterestAmt()) < 0)
{
fl = fact.CreateLine(line,
GetAccount(Doc.ACCTTYPE_InterestExp, as1), GetAccount(Doc.ACCTTYPE_InterestExp, as1), line.GetC_Currency_ID(), Decimal.Negate(line.GetInterestAmt()));
}
else
{
fl = fact.CreateLine(line,
GetAccount(Doc.ACCTTYPE_InterestRev, as1), GetAccount(Doc.ACCTTYPE_InterestRev, as1), line.GetC_Currency_ID(), Decimal.Negate(line.GetInterestAmt()));
}
if (fl != null && C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
}
}
// Default Posting Logic
else
{
// Lines
for (int i = 0; i < _lines.Length; i++)
{
DocLine_Bank line = (DocLine_Bank)_lines[i];
int C_BPartner_ID = line.GetC_BPartner_ID();
// BankAsset DR CR (Statement)
fl = fact.CreateLine(line,
GetAccount(Doc.ACCTTYPE_BankAsset, as1), line.GetC_Currency_ID(), line.GetStmtAmt());
if (fl != null && AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
if (fl != null && C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
// BankInTransit DR CR (Payment)
fl = fact.CreateLine(line,
GetAccount(Doc.ACCTTYPE_BankInTransit, as1), line.GetC_Currency_ID(), Decimal.Negate(line.GetTrxAmt()));
if (fl != null)
{
if (C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
if (AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
else
{
fl.SetAD_Org_ID(line.GetAD_Org_ID(true)); // from payment
}
}
// Charge DR (Charge)
fl = fact.CreateLine(line, line.GetChargeAccount(as1, Decimal.Negate(line.GetChargeAmt())), line.GetC_Currency_ID(), Decimal.Negate(line.GetChargeAmt()), null);
if (fl != null && C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
// Interest DR CR (Interest)
if (Env.Signum(line.GetInterestAmt()) < 0)
{
fl = fact.CreateLine(line,
GetAccount(Doc.ACCTTYPE_InterestExp, as1), GetAccount(Doc.ACCTTYPE_InterestExp, as1), line.GetC_Currency_ID(), Decimal.Negate(line.GetInterestAmt()));
}
else
{
fl = fact.CreateLine(line,
GetAccount(Doc.ACCTTYPE_InterestRev, as1), GetAccount(Doc.ACCTTYPE_InterestRev, as1), line.GetC_Currency_ID(), Decimal.Negate(line.GetInterestAmt()));
}
if (fl != null && C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
//
// fact.createTaxCorrection();
}
}
//
List <Fact> facts = new List <Fact>();
facts.Add(fact);
return(facts);
}
/// <summary>
/// Create Facts (the accounting logic) for
/// CMB.
/// <pre>
/// BankAsset DR CR (Statement)
/// BankInTransit DR CR (Payment)
/// Charge DR (Charge)
/// Interest DR CR (Interest)
/// </pre>
/// </summary>
/// <param name="as1"></param>
/// <returns></returns>
public override List <Fact> CreateFacts(MAcctSchema as1)
{
// create Fact Header
Fact fact = new Fact(this, as1, Fact.POST_Actual);
// Header -- there may be different currency amounts
FactLine fl = null;
int AD_Org_ID = GetBank_Org_ID(); // Bank Account Org
// Lines
for (int i = 0; i < _lines.Length; i++)
{
DocLine_Bank line = (DocLine_Bank)_lines[i];
int C_BPartner_ID = line.GetC_BPartner_ID();
// BankAsset DR CR (Statement)
fl = fact.CreateLine(line,
GetAccount(Doc.ACCTTYPE_BankAsset, as1),
line.GetC_Currency_ID(), line.GetStmtAmt());
if (fl != null && AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
if (fl != null && C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
// BankInTransit DR CR (Payment)
fl = fact.CreateLine(line,
GetAccount(Doc.ACCTTYPE_BankInTransit, as1),
line.GetC_Currency_ID(), Decimal.Negate(line.GetTrxAmt()));
if (fl != null)
{
if (C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
if (AD_Org_ID != 0)
{
fl.SetAD_Org_ID(AD_Org_ID);
}
else
{
fl.SetAD_Org_ID(line.GetAD_Org_ID(true)); // from payment
}
}
// Charge DR (Charge)
fl = fact.CreateLine(line, line.GetChargeAccount(as1, Decimal.Negate(line.GetChargeAmt())), line.GetC_Currency_ID(), Decimal.Negate(line.GetChargeAmt()), null);
if (fl != null && C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
// Interest DR CR (Interest)
if (Env.Signum(line.GetInterestAmt()) < 0)
{
fl = fact.CreateLine(line,
GetAccount(Doc.ACCTTYPE_InterestExp, as1), GetAccount(Doc.ACCTTYPE_InterestExp, as1),
line.GetC_Currency_ID(), Decimal.Negate(line.GetInterestAmt()));
}
else
{
fl = fact.CreateLine(line,
GetAccount(Doc.ACCTTYPE_InterestRev, as1), GetAccount(Doc.ACCTTYPE_InterestRev, as1),
line.GetC_Currency_ID(), Decimal.Negate(line.GetInterestAmt()));
}
if (fl != null && C_BPartner_ID != 0)
{
fl.SetC_BPartner_ID(C_BPartner_ID);
}
//
// fact.createTaxCorrection();
}
//
List <Fact> facts = new List <Fact>();
facts.Add(fact);
return(facts);
}
