MS-SQL quairy + small web script
This project was successfully completed by sadeque for $100 USD in 7 days.Get free quotes for a project like this
Project Budget$30 - $250 USD
Completed In7 days
I want to know if an invoice that i sent recived by the customer. the app recive the information from a specific field in The DB - send it to the Israeli post web page ([url removed, login to view]) and create a table during to the status of the mail.
Te output is a table with 6 colums : DB name, customer name, invoice number, Delivery Tracking number, document total, create date, mail status.
there will be a "refresh" button, and option for auto-refresh by changeable interval time (every 1 hour, 2 hours, 1 day act...). the data will be able to be taken from several DBs.
the colums can be sortable (sort by name, sort by invoce number...)
I'm using SAP B1 (ms-sql DB). there will be an setting menu, and there i"ll configure the server name, DB name, DB password, tables name, field's names. the setting can be exportable and importable. Attached a sample of the table.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online