Vendor/Customer GL Movement Summary?

(0) Share

Report

Posted on by adeel333

487

All I want is one line summary for a particular vendor or customer including opening balance, total debit, total credit and a closing balance. e.g. 1st January to 31st January

Vend1 - Opening Balance as of 1st January - Total Debit - Total Credit - Closing as of 31st January

in one line... What could be the SQL statement or any other way?

*This post is locked for comments

All responses (2)

Answers (0)

adeel333 487 on at

Like (0)

Report

RE: Vendor/Customer GL Movement Summary?

Yes, I have viewed your mentioned pages. But still unable to get my required result in one place. Is it possible for you to write a SQL View / Statement to get it done in one query? Your help will be highly appreciated.
Tristan Clores 2,812 on at

Like (0)

Report

RE: Vendor/Customer GL Movement Summary?

Hi Adeel,

From the looks of it, you'll need a number of SQL Views and then bunch them all together in one.

I can suggest looking at Victoria Yudins page for RM and PM SQL Views where you can start off:

victoriayudin.com/.../payables-sql-views

victoriayudin.com/.../receivables-sql-views

Hope this helps!