Ngutak - ngatik report Dynamics AX 2009, akhirnya nemu juga caranya memilah report berdasarkan batasan tanggal
public void executeSection()
{
PurchTable _PurchTable;
;
select firstonly RecId from _PurchTable where
_PurchTable.OrderAccount == VendTable.AccountNum;
if(_PurchTable.RecId)
{
super();
while select * from _PurcHline group by
_PurcHline.PurchId, _PurcHline.ItemId , _PurcHline.VariantId where
_PurcHline.VendAccount == VendTable.AccountNum &&
_PurcHline.DeliveryDate >= dtFrom &&
_PurcHline.DeliveryDate <= dtTo && _PurcHline.PurchStatus != (PurchStatus::Backorder || PurchStatus::Canceled) { element.execute(1); } } }
{
PurchTable _PurchTable;
;
select firstonly RecId from _PurchTable where
_PurchTable.OrderAccount == VendTable.AccountNum;
if(_PurchTable.RecId)
{
super();
while select * from _PurcHline group by
_PurcHline.PurchId, _PurcHline.ItemId , _PurcHline.VariantId where
_PurcHline.VendAccount == VendTable.AccountNum &&
_PurcHline.DeliveryDate >= dtFrom &&
_PurcHline.DeliveryDate <= dtTo && _PurcHline.PurchStatus != (PurchStatus::Backorder || PurchStatus::Canceled) { element.execute(1); } } }
