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 sql query equivalent to f74412 table output. If any one us already has the quires, please share with me that will really help a lot.

Thanks in advances.