Thanks Mr. Rupert for the reply but my problem is that I dont know from which all tables I could get the data. I am trying to use or APInvHed, GLPerBal and GLOpnBal but I am not able to make a link between the tables. I don't know whether I am using the right tables or not.
I want to have in the report Posting date; Posting Ref Number; Supplier Invoice Number; Supplier Invoice Date; Debit; Credit; Balance (Which is a cumulative total of the Dr. side or Cr. Side)
Hope that you would be able to give me some help.
Regards
Sreejith J
________________________________
From: Rupert Murray <r.oo@...>
To: sreesvantagedoubts@...
Sent: Thursday, September 15, 2011 3:08 PM
Subject: Re: How to prepare Supplier Statement of Accounts?
 The best way
to get your data is to first isolate the field and table names within
customisation function. once you have these go back to your BAQ and
see if you can successfully link. If not get as much of the BAQ
information as possible and add ODBC links to your report data within
Crystal (RH side only)
[Non-text portions of this message have been removed]
I want to have in the report Posting date; Posting Ref Number; Supplier Invoice Number; Supplier Invoice Date; Debit; Credit; Balance (Which is a cumulative total of the Dr. side or Cr. Side)
Hope that you would be able to give me some help.
Regards
Sreejith J
________________________________
From: Rupert Murray <r.oo@...>
To: sreesvantagedoubts@...
Sent: Thursday, September 15, 2011 3:08 PM
Subject: Re: How to prepare Supplier Statement of Accounts?
 The best way
to get your data is to first isolate the field and table names within
customisation function. once you have these go back to your BAQ and
see if you can successfully link. If not get as much of the BAQ
information as possible and add ODBC links to your report data within
Crystal (RH side only)
[Non-text portions of this message have been removed]