Have anyone tried linking PORel with TranGlc table to get GL information in E10.2.600? . In E9, same BAQ takes less than 20 seconds but in E10 it takes more than 20 minutes. Linking is PORel.Company = TranGlc.Company, PORel.PONum = TranGlc.Key1 , PORel.POLineNum = TranGlc.Key2 and PORel.PORelNum = T…

Try removing the PORel.Company = TranGLC.Company join condition. There are other queries where having the Company condition causes the query to time-out, while removing it lets the query run in seconds. If the BAQ is not cross-company and not external, there should be no problem with removing the Co…

Thanks a lot. Indeed it improved performance by miles. I have removed the company criteria from POHeader, PODetail, PORel and TranGlc and query execution is less than 2 seconds. Removing Company from related tables like Vendor, PurTerms and PurAgent added more time (7 times ). It’s more like a trial…

Another thing epicor does they also join on the keys they don’t use Key4, Key5, Key6 (this is in PORel code) I wonder if itll improve it more. row.Company == company_ex && row.RelatedToFile == relatedToFile_ex && row.Key1 == key1_ex && row.Key2 == key2_ex && row.…

Last week I had another performance issue with few BPMs on JobMtl Data Directive where I used Wizard Design Query condition to find JobHead linking ttJobMtl. When I changed from Wizard Design Query to Code is valid condition using C# code, Job Scheduling time reduced from 5 minutes to 20 seconds.

Its because the wizard joins ttJobMtl to JobHead and that is a big performance issue, epicor doesnt plan to address. [image] Joining "TT" records to regular DB records in BPMs Experts' Corner I wonder if Epicor will ever change their underlying generated code. I still see…

BAQ - Linking PORel with TranGlc

Epicor ERP 10

hkeric.wci (Haso Keric) September 21, 2020, 12:38pm 6

Its because the wizard joins ttJobMtl to JobHead and that is a big performance issue, epicor doesnt plan to address.

Topic		Replies	Views
Anyone successfully create a BAQ linking TranGLC to PartTran? Epicor ERP 9	5	3897	February 17, 2017
BAQ timeoutException Error - TranGLC table Epicor ERP 10 e10 , sql , epicor , baq	11	1227	August 5, 2020
Linking in the GL account from PO Tracker > Rel > Detail Epicor ERP 10 baq	1	633	October 20, 2023
Gl baq Epicor ERP 10 e10	18	7521	March 2, 2023
Linking GL Account to BAQ Epicor ERP 9 baq	7	1270	July 23, 2024

BAQ - Linking PORel with TranGlc

Related topics