I want to know how to get this report data TrialBalanceReport

Epicor ERP 10
, ,
1

i’m looking at this report but i don’t understand how to get its data?

image
image1920×773 102 KB

:thinking: :thinking:
image
image1751×1921 184 KB

however, according to the data shown, I know there is a data line that does not meet the requirements according to my company’s business so I want to know how to get the data for this report so I can check why there is a data line If you don’t meet the business requirements, it will still be displayed on the report

image
image3071×1565 240 KB

image
image3464×416 281 KB

image
image3378×426 174 KB

:smiling_face_with_three_hearts: :smiling_face_with_three_hearts:
Thank you very much! Have a nice day

2

The Data Definition Code is GLTBRpt but…
no way to tell where the detail data is coming since it uses a calculated table.

If you have access to EpicCare, there are quite a few Knowledge Base articles related to Trial Balance that might help you get started.
Possibly KB0109057 " Finding the out of balance journal in a Trial Balance using a SQL script"?

1 Like