1. Need a SQL queries to get the customer and vendor balances in jde9.1

    Hi Team, I have requirement where i need to create a sql queries to bring the customer and vendor balances. Basically, it will show balances by open items. I have gone though the report R7403B001 and its worktable. But here we do not have access to worktable (f74412). So i am trying to build a...