• JDELIST is celebrating its 20 year anniversary today!
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

customer balances

  1. K

    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...