Dynamics Community Forum Thread Details

How to get last purchased date for all items

Hi Experts;

I am trying to get last purchased date for all items using below X++

While select inventTrans order by ItemId where inventTrans.StatusReceipt == StatusReceipt::Purchased

     join queryInventTable where inventTrans.ItemId == queryInventTable.ItemId
     join inventTransOrigin where inventTrans.ItemId == inventTransOrigin.ItemId && inventTrans.InventTransOrigin==inventTransOrigin.RecId
     && inventTransOrigin.ReferenceCategory == InventTransType::Purch

{

info(strFmt("Item Id %1 Last Purchased Date %2 ",inventTrans.ItemId,inventTrans.DateFinancial));

}

Can anyone update X++ code to get correct information.

Thanks in advance.

static void Job214(Args _args) { InventTable inventTable; InventTrans inventTrans, inventTransExists; InventTransOrigin inventTransOrigin, inventTransOriginExists; int i; while select inventTable order by ItemId exists join inventTransExists where inventTransExists.ItemId == inventTable.ItemId && inventTransExists.StatusReceipt == StatusReceipt::Purchased exists join inventTransOriginExists where inventTransOriginExists.RecId == inventTransExists.InventTransOrigin && inventTransOriginExists.ReferenceCategory == InventTransType::Purch { i++; select firstonly inventTrans order by DateFinancial desc where inventTrans.ItemId == inventTable.ItemId && inventTrans.StatusReceipt == StatusReceipt::Purchased join inventTransOrigin where inventTransOrigin.RecId == inventTrans.InventTransOrigin && inventTransOrigin.ReferenceCategory == InventTransType::Purch; info(strFmt("%1 - %2 - %3", inventTable.ItemId, inventTransOrigin.ReferenceId, inventTrans.DateFinancial)); if (i > 10) break; } }

Quick Links

Leaderboard