Hi,
I have created a report by using Sales Invoice Line table.
Later, my customer asked to show the return records also in the report after listing out all the invoice records.
So i included Sales Credit memo line table also in the report
The problem here for me that i need to have the same filterations in both the tables . ie if the user flters a date in Sales Invoice line then the Credit memo table also needs to be filtered by that date.
I can show only Sales Invoice Line Dataitem for the filtration puropse . Whatever filteration i make in the Sales Invoice Line table, it needs to be filtered in the Sales Credit Memo lline table also.
How can i achieve this.?
Thanks in advance
0
Comments
2)Another option would to use the customer ledger entries. there you have both credits & invoices & posting dates, etc. (Unless you need to filter on items? is that the case? or are you just looking for totals?)
http://www.BiloBeauty.com
http://www.autismspeaks.org
Thanks for the reply.
I will check your options
Infact i thought of incorporating any new idea in the existing report rather than creating an entirely new report.