Dynamics Community Forum Thread Details

Showing the price of an Item based on item select.

Hello Everyone,

I have a requirement to develop a form to show the item price of an item based on the item that is selected. This is what I have done:

1. create a table with 2 fields ItemCode (extendedDataType---ItemID) and ItemSaleprice(this sales price should come form table InventTableModule Price column)

I hava a job that gives me the item sales price here is the code:

static void CheckPriceITM(Args _args)
{
InventTableModule inventTableModule;
InventTable inventTable;
EcoResProduct ecoResProduct;

while select inventTable
where inventTable.ItemId == "105102"
join ecoResProduct
where ecoResProduct.RecId == inventTable.Product
join inventTableModule
where inventTableModule.ItemId == inventTable.ItemId
{

if (inventTableModule.ModuleType == ModuleInventPurchSales::Sales)

{
info(strFmt(" %1", inventTableModule.Price));

}
}
}

My question is, now do i get the job and put it in a way that on the form, when I select an item it shows the price in another control.

Please help, thanks.

MY FORM