cmccormick
Member
Hello JDE Gurus! I need to extract data from the F42119 table and include the OBJACCT and SUBACCT fields as well. Basically I am trying to take detailed sales ledger data + the GL accounts where this data was posted. Right now I am trying to get that GL accounts from the F0911 table but my JOINS between the tables are not working successfully. Has anyone else done this? I only have access to SQL so no JDE tools. Any recommendations are greatly appreciated!
Cheers!
Cheryl
Cheers!
Cheryl