Page 1 of 1

Statement of Accounts for Vendors

PostPosted: Wed Jul 13, 2011 3:45 pm
by zulqarnainhabib
I am using default US Chart of Accounts with Adempiere. Vendor Prepayments are sent to account code 12510 and Liability is sent to 21100.
My problem is when I want to see a complete statement of a Vendor which should show all transaction of a Vendor from both 12510 and 21100.
I tried creating a report hierarchy which includes just both of the above mentioned accounts. I run Statement of Accounts and selected supplier in the parameter form, kept Account field empty and selected newly created Report Hierarchy but it did not work. It just brought all transactions where the selected vendor was used and not just two given accounts.

I will be thankful if someone can help me in doing this.

Habib

Re: Statement of Accounts for Vendors

PostPosted: Thu Jul 14, 2011 11:10 am
by globalqss
Hi Habib, I think you can define in the new hierarchy an account to group 12510 and 21100, and report filtering just on that account.

i.e. you create in the account tree a new summary account called "Vendor SoA" with code VSOA.
in the hierarchy you group 12510 and 21100 under the VSOA account.
on the report you choose the hierarchy and filter to just report VSOA account

I haven't tried it, just an idea.

Regards,

Carlos Ruiz

Re: Statement of Accounts for Vendors

PostPosted: Fri Jul 15, 2011 10:07 am
by zulqarnainhabib
Thanks