Hi.
How do I create a BAQ to mimic the General Ledger Account Summary report but includes the Supplier Name where applicable.
Thank you,
Jon
Hi.
How do I create a BAQ to mimic the General Ledger Account Summary report but includes the Supplier Name where applicable.
Thank you,
Jon
Jon -
I copied your request into CoPilot and here was the result. By the way, this is the topic for this week’s User Group Meeting in Chicagoland. Using AI to build BAQs.
Identify the Necessary Tables: You’ll need to work with the following tables:
GLJrnDtl
: Contains journal entry details.TranGLC
: Provides information about GL transactions.PartTran
: Includes additional transaction details.Join the Tables:
Select Relevant Fields:
Add Supplier Name:
Vendor
.Test and Refine:
You’ll need to also set your criteria in conjunction with the joining of the tables. The fields from all tables can be added to the query display fields.
HTH,
Calvin
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.