/// <summary>
/// Skip creating postings for this Org.
/// Requires setOnlyOrgs (MReportTree requires MTree in Basis)
/// </summary>
/// <param name="AD_Org_ID"></param>
/// <returns>true if to skip</returns>
public bool IsSkipOrg(int AD_Org_ID)
{
if (GetAD_OrgOnly_ID() == 0)
{
return(false);
}
// Only Organization
if (GetAD_OrgOnly_ID() == AD_Org_ID)
{
return(false);
}
if (_onlyOrg == null)
{
_onlyOrg = MOrg.Get(GetCtx(), GetAD_OrgOnly_ID());
}
// Not Summary Only - i.e. skip it
if (!_onlyOrg.IsSummary())
{
return(true);
}
if (_onlyOrgs == null)
{
return(false);
}
for (int i = 0; i < _onlyOrgs.Length; i++)
{
if (AD_Org_ID == Utility.Util.GetValueOfInt(_onlyOrgs[i]))
{
return(false);
}
}
return(true);
}
/// <summary>
/// Is Period Open for Doc Base Type in selected Organization
/// </summary>
/// <param name="DocBaseType">document base type</param>
/// <param name="dateAcct">accounting date</param>
/// <returns>error message or null</returns>
/// <date>07-March-2011</date>
/// <writer>raghu</writer>
public String IsOpen(String DocBaseType, DateTime?dateAcct, int AD_Org_ID)
{
if (!IsActive())
{
_log.Warning("Period not active: " + GetName());
return("@C_Period_ID@ <> @IsActive@");
}
MAcctSchema as1 = null;
if (AD_Org_ID > 0)
{
as1 = MOrg.Get(GetCtx(), AD_Org_ID).GetAcctSchema();
}
else
{
as1 = MClient.Get(GetCtx(), GetAD_Client_ID()).GetAcctSchema();
}
if (as1 != null && as1.IsAutoPeriodControl())
{
if (!as1.IsAutoPeriodControlOpen(dateAcct))
{
return("@PeriodClosed@ - @AutoPeriodControl@");
}
// We are OK
DateTime today = DateTime.Now.Date;
if (IsInPeriod(today) && as1.GetC_Period_ID() != GetC_Period_ID())
{
as1.SetC_Period_ID(GetC_Period_ID());
as1.Save();
}
return(null);
}
// Standard Period Control
if (DocBaseType == null)
{
log.Warning(GetName() + " - No DocBaseType");
return("@NotFound@ @DocBaseType@");
}
MPeriodControl pc = GetPeriodControl(DocBaseType, AD_Org_ID);
if (pc == null)
{
log.Warning(GetName() + " - Period Control not found for " + DocBaseType);
return("@NotFound@ @C_PeriodControl_ID@: " + DocBaseType);
}
log.Fine(GetName() + ": " + DocBaseType);
if (pc.IsOpen())
{
return(null);
}
return("@PeriodClosed@ - @C_PeriodControl_ID@ ("
+ DocBaseType + ", " + dateAcct + ")");
}
/// <summary>
/// This function is used to get Accounting Schema either binded on Organization or Primary Accounting SChema
/// </summary>
/// <param name="ctx">ctx</param>
/// <param name="Ad_Client_ID">AD_Client_ID</param>
/// <param name="AD_Org_ID">Org ID</param>
/// <returns>C_AcctSchema ID</returns>
public static int GetDefaultActSchema(Ctx ctx, int Ad_Client_ID, int AD_Org_ID)
{
MAcctSchema acctSchema = null;
if (AD_Org_ID > 0)
{
acctSchema = MOrg.Get(ctx, AD_Org_ID).GetAcctSchema();
}
if (acctSchema == null)
{
acctSchema = MClient.Get(ctx, Ad_Client_ID).GetAcctSchema();
}
return(acctSchema.GetC_AcctSchema_ID());
}
//Amit
/**
* Standard Constructor
* @param ctx context
* @param C_Cash_ID id
* @param trxName transaction
*/
public MCash(Ctx ctx, int C_Cash_ID, Trx trxName)
: base(ctx, C_Cash_ID, trxName)
{
if (C_Cash_ID == 0)
{
// setC_CashBook_ID (0); // FK
SetBeginningBalance(Env.ZERO);
SetEndingBalance(Env.ZERO);
SetStatementDifference(Env.ZERO);
SetDocAction(DOCACTION_Complete);
SetDocStatus(DOCSTATUS_Drafted);
//
DateTime today = TimeUtil.GetDay(DateTime.Now);
SetStatementDate(today); // @#Date@
SetDateAcct(today); // @#Date@
//String name = DisplayType.getDateFormat(DisplayType.Date).format(today) + " " + MOrg.Get(ctx, GetAD_Org_ID()).GetValue();
String name = String.Format("{0:d}", today) + " " + MOrg.Get(ctx, GetAD_Org_ID()).GetValue();
SetName(name);
SetIsApproved(false);
SetPosted(false); // N
SetProcessed(false);
}
}
} // setC_Charge_ID
/// <summary>
/// Calculate Tax
/// </summary>
/// <param name="windowNo"></param>
/// <param name="columnName"></param>
private void SetTax(int windowNo, String columnName)
{
int C_Charge_ID = GetC_Charge_ID();
log.Fine("C_Charge_ID=" + C_Charge_ID);
if (C_Charge_ID == 0)
{
SetAmt(windowNo, columnName);
return;
}
// Check Partner Location
int C_BPartner_Location_ID = GetC_BPartner_Location_ID();
log.Fine("BP_Location=" + C_BPartner_Location_ID);
if (C_BPartner_Location_ID == 0)
{
SetAmt(windowNo, columnName);
return;
}
// Dates
DateTime?billDate = GetDateInvoiced();
log.Fine("Bill Date=" + billDate);
DateTime?shipDate = billDate;
log.Fine("Ship Date=" + shipDate);
int AD_Org_ID = GetAD_Org_ID();
log.Fine("Org=" + AD_Org_ID);
MOrg org = MOrg.Get(GetCtx(), AD_Org_ID);
int M_Warehouse_ID = org.GetM_Warehouse_ID();
log.Fine("Warehouse=" + M_Warehouse_ID);
Boolean isSOTrx = GetCtx().IsSOTrx(windowNo);
//
int C_Tax_ID = Tax.Get(GetCtx(), 0, C_Charge_ID, billDate, shipDate,
AD_Org_ID, M_Warehouse_ID, C_BPartner_Location_ID, C_BPartner_Location_ID,
isSOTrx);
log.Info("Tax ID=" + C_Tax_ID + " - SOTrx=" + isSOTrx);
if (C_Tax_ID == 0)
{
//ValueNamePair pp = CLogger.retrieveError();
//if (pp != null)
//{
//p_changeVO.addError(pp.getValue());
//}
//else
//{
//p_changeVO.addError("Tax Error");
//}
}
else
{
base.SetC_Tax_ID(C_Tax_ID);
}
SetAmt(windowNo, columnName);
}
/// <summary>
/// Is standard Period Open for specified orgs for the client. For best
/// performance, ensure that the list of orgs does not contain duplicates.
/// </summary>
/// <param name="ctx"></param>
/// <param name="AD_Client_ID"></param>
/// <param name="orgs"></param>
/// <param name="DateAcct">accounting date</param>
/// <param name="DocBaseType">document base type</param>
/// <returns>error message or null</returns>
/// <date>07-March-2011</date>
/// <writer>raghu</writer>
public static String IsOpen(Ctx ctx, int AD_Client_ID, List <int> orgs, DateTime?DateAcct,
String DocBaseType)
{
if (DateAcct == null)
{
return("@NotFound@ @DateAcct@");
}
if (DocBaseType == null)
{
return("@NotFound@ @DocBaseType@");
}
MAcctSchema as1 = MClient.Get(ctx, AD_Client_ID).GetAcctSchema();
if (as1 == null)
{
return("@NotFound@ @C_AcctSchema_ID@ for AD_Client_ID=" + AD_Client_ID);
}
if (as1.IsAutoPeriodControl())
{
if (as1.IsAutoPeriodControlOpen(DateAcct))
{
return(null);
}
else
{
return("@PeriodClosed@ - @AutoPeriodControl@");
}
}
// Get all Calendars in line with Organizations
MClientInfo clientInfo = MClientInfo.Get(ctx, AD_Client_ID, null);
List <int> orgCalendars = new List <int>();
List <int> calendars = new List <int>();
foreach (int org in orgs)
{
MOrgInfo orgInfo = MOrgInfo.Get(ctx, org, null);
int C_Calendar_ID = orgInfo.GetC_Calendar_ID();
if (C_Calendar_ID == 0)
{
C_Calendar_ID = clientInfo.GetC_Calendar_ID();
}
orgCalendars.Add(C_Calendar_ID);
if (!calendars.Contains(C_Calendar_ID))
{
calendars.Add(C_Calendar_ID);
}
}
// Should not happen
if (calendars.Count == 0)
{
return("@NotFound@ @C_Calendar_ID@");
}
// For all Calendars get Periods
for (int i = 0; i < calendars.Count; i++)
{
int C_Calendar_ID = calendars[i];
MPeriod period = MPeriod.GetOfCalendar(ctx, C_Calendar_ID, DateAcct);
// First Org for Calendar
int AD_Org_ID = 0;
for (int j = 0; j < orgCalendars.Count; j++)
{
if (orgCalendars[j] == C_Calendar_ID)
{
AD_Org_ID = orgs[j];
break;
}
}
if (period == null)
{
MCalendar cal = MCalendar.Get(ctx, C_Calendar_ID);
String date = DisplayType.GetDateFormat(DisplayType.Date).Format(DateAcct);
if (cal != null)
{
return("@NotFound@ @C_Period_ID@: " + date
+ " - " + MOrg.Get(ctx, AD_Org_ID).GetName()
+ " -> " + cal.GetName());
}
else
{
return("@NotFound@ @C_Period_ID@: " + date
+ " - " + MOrg.Get(ctx, AD_Org_ID).GetName()
+ " -> C_Calendar_ID=" + C_Calendar_ID);
}
}
String error = period.IsOpen(DocBaseType, DateAcct);
if (error != null)
{
return(error
+ " - " + MOrg.Get(ctx, AD_Org_ID).GetName()
+ " -> " + MCalendar.Get(ctx, C_Calendar_ID).GetName());
}
}
return(null); // open
}
