i have written the logic in this i get the item transaction as per date but i want to show the date by date one by one on which the transaction not done so it will automatically show the uper value
for example transa date 21/04/2016 qty 2000 and next trans date is 24/04/2016 qty 1200
so code will run like this 21/04/2016 -2000
22/04/2016 - 2000
23/04/2016 -2000
24/04/2016 - 3200
like this i want to show on info
static void itemtransactionvinay(Args _args)
{
InventTrans InventTrans;
int qty,onHandTotal,c,i,diff;
ItemId ItemId;
TransDate start, finish;
InventTable InventTable;
;
start = str2date("04/21/2016", 213);
finish = str2date("06/23/2016", 213);
{
i++;
{
while select InventTable where InventTable.ItemId=="D0001"
join InventTrans where InventTrans.ItemId == InventTable.ItemId && InventTrans.DatePhysical >= start
&& InventTrans.DatePhysical <= finish
&& (InventTrans.StatusIssue==StatusIssue::Deducted || InventTrans.StatusIssue==StatusIssue::Sold || InventTrans.StatusIssue==StatusIssue::OnOrder || InventTrans.StatusIssue==StatusIssue::None
|| InventTrans.StatusReceipt == StatusReceipt::Purchased ||InventTrans.StatusReceipt == StatusReceipt::None )
{
qty += InventTrans.Qty;
ItemId = InventTrans.ItemId;
info(strFmt("ItemId::%1---Date::%2---qty::%3", ItemId,InventTrans.DatePhysical,qty));
start+=1;
}
}
}
}
