@Mike Thanks, I’m having better luck with BAQ than I was with Erp.BO.GLPeriodBalSearchSvc.
BAQ seems fast enough when we are gathering a limited amount of data (single period, single company, etc).
I’m really confused by the structure of the data that I’m getting out of BAQ. Do you use GLPeriodBal? Does it have all balances, including any accounts without movement in a given period? I cannot figure out the structure of that table. Did you have any documentation to help you to interpret that internal database schema? I guess I was initially avoiding BAQ because of the chance to misinterpret that internal data. Presumably the other (Erp.BO) api would provide more user-friendly results.
We are new to Epicor. It is our first month using the product. I’m wondering if the missing accounts need to be filled in by doing some special operation (closing the periods, or performing a GL period refresh, or creating a special fiscal period with a number of zero, or some such thing) In this forum I have found some references that suggest using GLPeriodBal for general ledger, but they aren’t total explicit about how to form it into a trial balance. Any help would be appreciated.