/// <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;
}