/// <summary> /// Gets the average monthly consumption of an item /// This method considers the logical store /// </summary> /// <param name="itemId"></param> /// <param name="storeId"></param> /// <param name="month"></param> /// <param name="year"></param> /// <returns></returns> public Int64 CalculateAMC(int itemId, int storeId, int month, int year) { GeneralInfo info = new GeneralInfo(); info.LoadAll(); int range = info.AMCRange; Int64 cons = 0; IssueDoc iss = new IssueDoc(); int yr = year;// (month > 10) ? year - 1 : year; DateTime dt1 = new DateTime(yr, month, DateTime.DaysInMonth(yr, month)); DateTime dt2 = dt1.AddMonths(-range); range = iss.GetAvailableNoOfMonths(itemId, storeId, dt2, dt1); cons = iss.GetIssuedQuantityByDateRange(itemId, storeId, dt2, dt1); Int64 AMC = cons / range; return AMC; }