hello
You currently use an ERP package built on Oracle that has minimal flexibility for reporting.
you've adapted to using Excel (via ODBC) to pull data for reports, although this is very limited in functionality and cumbersome to manage.
YouI've developed a small PHP page that will allow for retrieval of some data, although I'm looking to expand this to a wider variety of reports and tools. I currently have a project in mind for an AR Reporting tool to be used by Sales. We currently use an Excel pivot table (sample attached) although the notes field on the end is just a text field and not tied to specific rows (the sample is flattened just to show the layout of data). I'd like to have this built in a web interface with the AR data being pulled from the DB and then having a notes field that a sales rep could update. Once notes are entered, the form would then be saved to a different table than where the AR data was pulled.
Please send me your contact
then, we can discuss about your project with more closely
thanks