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.