IMOrderHed and IMOrderDtl

Dhanalakshmi · July 17, 2020, 5:03am

How to access IM Tables from BPM in Epicor 10.
Have anyone tried this and please let me know the use of IM Tables in Epicor.

Regards,
Dhanalakshmi.

Arul · July 18, 2020, 6:18am

In Epicor 9, we can access from BPM without any issue. But In E10, I couldn’t.

Dhanalakshmi · July 18, 2020, 7:49am

I got the solution we can call using the BO Object SOPOLinkSvcContract and using the methods GetRows, GetOrderDtl…

Thanks for the response… Hope this helps…

Arul · July 19, 2020, 4:36am

Thanks @Dhanalakshmi . I used to update IMCustomer in E9. This give an idea.

Dhanalakshmi · November 20, 2020, 5:21am

I am able to access the tables IMOrderHed and IMOrderDtl using the BO Object SOPOLinkSvcContract. But it didn’t return any rows. Is there any other way to access the tables so it return rows?

bool morePages = false;
string whereClauseIMOrderHednew = “Company =‘MJP’”;

Erp.Contracts.SOPOLinkSvcContract hICPOLinkSvc = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.SOPOLinkSvcContract>(Db);
Erp.Tablesets.SOPOLinkTableset hICPOLinkTS = new Erp.Tablesets.SOPOLinkTableset();

hICPOLinkTS = hICPOLinkSvc.GetRows(whereClauseIMOrderHednew, “”, “”, “”, 0, 0, out morePages);

foreach (Erp.Tablesets.IMOrderHedRow IMHRow in hICPOLinkTS.IMOrderHed)
{
foreach (Erp.Tablesets.IMOrderDtlRow IMDtRow in hICPOLinkTS.IMOrderDtl)
{
}
}

Dhanalakshmi · November 26, 2020, 8:02am

SOPOlinkeSvcContract getrows not returning a value when try to pass Company in the where condition getting an error Input String is not in correct format.
bool morePages = false;
string whereClauseIMOrderHednew = “Company =‘EPIC03’”;

Erp.Contracts.SOPOLinkSvcContract hICPOLinkSvc = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.SOPOLinkSvcContract>(Db);
Erp.Tablesets.SOPOLinkTableset hICPOLinkTS = new Erp.Tablesets.SOPOLinkTableset();

hICPOLinkTS = hICPOLinkSvc.GetRows(whereClauseIMOrderHednew, “”, “”, “”, 0, 0, out morePages);

Jonathan · November 26, 2020, 9:45pm

Seems fine unless those quotes are somehow different from the normal quote.

’ - Normal Quote
‘ - Quote you pasted

Dhanalakshmi · November 27, 2020, 7:25am

i have checked the Quotes by placing the Code in Visual Studio and as per your suggestion changed to Normal Quotes and Checked still not returning the results

whereClauseIMOrderHednew = “Company =‘MJP’”;

Dhanalakshmi · November 27, 2020, 7:46am

Thanks it worked…