I created an application with Visual Studio Lightswitch.
I would like to connect this application with SAP (R3).
I need a connector that will allow me to get the following data from SAP for each client:
1) Customer data (Name, address, zip code, city, region, country, accounting service phone and fax and email, client SAP code, client accounting code (if different), SIREN/SIRET n°, VAT n°, invoicing currency, payment term, risk level, authorized outstanding, real outstanding, unauthorized outstanding, vendor’s name related to the client account, Manager’s name responsible of the production for the client account, collection agent name related to the customer account)
2) All contact person data (name, first name, phone, fax, email, position, service in which they work, language, gender) of the client
3) All the opened invoices, debit notes and unmatched payment (unmatched writings), with their amount, maturity date, and the customer account number related to the invoice. (financial part)
These data will be transfer on a table of my application that will be made of an excel sheet type.
I also need to push some data to SAP.
I will have a table with 3 columns: customer code, invoice number, comment. This table looks like an excel sheet.
I need only to enter the comment that I made in my application into the right place in SAP. (Looking for the invoice, and adding the new comment to the existing comment in the case “comment” (the last comment should be read first in the case and not erasing the former ones).