I need your point of view about this and please advise,
My client have made a request to generate Ageing Report thru their SharePoint 2007, FYI all invoice was scan and upload to sharepoint and save as PDF file under Document Library. During the scan, certain information will capture automatically
and save it into field that we defined inside the Web Form.
Below is the basic input we capture:
Vendor Code, Vendor Name, Invoice Number, Invoice Date, Currency, Invoice Amount
Report Requirement (display list and group of:)
- Vendor Code, Vendor Name, No. Of Invoice, Total Payable, Ageing 0-30, Ageing 30-60, Ageing 60-90, Ageing>90
So my question is, what is the best platform to create this Ageing Report??
because when i try to design the report thru Visual Studio (Reporting Services), i can't identified which database should i connect and which table is store all the invoice information in SharePoint.
Any idea guys?? anybody have implemented it before??
View Complete Post