Project - Supplier Invoicing

Summary

Automated system to import invoice data from multiple supplier feeds in to the company accounting system for payment.

Receive supplier invoice data in XML and CSV formats. Both formats could be either a company prescribed schema or supplier prescribed schema. Validate the file to ensure they can be opened and meet the agreed schema. Validate the invoice data and if valid import in to company CRM system. Allow non-valid invoice data to be reviewed, and where possible accepted.

Notify suppliers of any schema validation/data validation failures to allow them to correct and resubmit the data.

Architecture

Windows service running automated tasks to process data feeds and import data to invoicing system. MVC website as interface to system status and issue resolution.

Infrastructure

Dedicated windows server and sql database.


Technologies

  • c#
  • entity framework
  • ado
  • windows service

Methodologies

  • n-tier architecture
  • automation