Electronic processing of supplier invoices

The core of the solution is the process-controlled processing of invoices. Since many small and medium-sized suppliers cannot guarantee the transmission of invoices in EDI format (Electronic Data Interchange), the processing of text, csv and Excel files is forced. The technical basis of the solution is the Microsoft SQL Server, which already acts as a database for the systems involved. With the help of SQL Server Integration Services (SSIS), the invoice files are read in, validated and imported into an apron system of the merchandise management system Navision. Here the invoice verification can be carried out by the accounting department. Microsoft Access is used here as a pure front-end application, via which the specialist departments can intervene in the processing and export the invoices to the merchandise management system. All functional logics are treated as abstraction layers via the database.