Non Admin users not able to see the field values in EcoResProductPerCompanyListPage form

Finance and Operations/AX Developer Forum
21

Hi , i changed to ECORESPRODUCT table but still same issues only … one item is avilable in 3 legal entitys . but it was showing values only in which legal entitys i m imported the values to insert in table that legal entity only showing in all users

22

Can you show your code after the change? Did you also updated the existing data with inventTable.Product. (It looks your data has been updated with inventTable.RecID)

23

select forUpdate ecoResProduct where ecoResProduct.DisplayProductNumber == itemId;

if(ecoResProduct)
{
importedLines++;
qty = xlsCells.item(row,3).value().double();
sPrice = xlsCells.item(row,4).value().double();
ttsbegin;

// inventTable.AGDQty = qty;
// inventTable.AGDSellingPrice = sPrice;
// inventTable.update();

select forupdate ASAP_ItemDetails where ASAP_ItemDetails.EcoResProduct == ecoResProduct.RecId;
if(ASAP_ItemDetails)
{

importedLines++;
ASAP_ItemDetails.AGDQty = qty;
ASAP_ItemDetails.AGDSellingPrice = sPrice;
ASAP_ItemDetails.update();
}
else
{
ASAP_ItemDetails.clear();
ASAP_ItemDetails.ItemId = ecoResProduct.DisplayProductNumber;
ASAP_ItemDetails.AGDQty = qty;
ASAP_ItemDetails.AGDSellingPrice = sPrice;
ASAP_ItemDetails.EcoResProduct = ecoResProduct.RecId;
ASAP_ItemDetails.insert();
}
ttscommit;
}

24

Why do you need to select it for update?

Do you already have the related data? (since you were using inventTable.RecId)

have you changed the display methods also?

25

I have only item id … price nd qty newly import from excel aginst this item id … so update in new table and view in all compnay for this item id as per ur hints change the table from invettable to ecoresproduct table

26

Does that mean your issue has been resolved or do you still have the issue?