You’re offline. This is a read only version of the page.
495
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
*This post is locked for comments
I have the same question (0)
Hi Lionel07!
You can try to use modified() method on form control (or field on data source table).
You need to set auto declaration property of your ItemPrice control to Yes and then in modified() method of ItemNumber control you can set value to ItemPrice control.
Share
Report
All responses (
Answers (
