Data Analysis
Budget: $30 – $250 USD
I need to a C# Windows Desktop project that does the following:
Inputs:
1. Directory Path to paid Invoices (dirPaidInvoices)
2. File Path to an Invoices.xlsx file (fileInvoiced)
3. File Path to a csv file (fileRxLog)
The above inputs will be set and persisted on the dialog so the next time the application opens it populates the fields automatically. The program will do the following:
1. Read all files from dirPaidInvoices and its subdirectories. If the file is a pdf file (e.g., Invoice 172948 PO 02607-0000255590.pdf) extract the invoice number (e.g., 172948) as well as the PO number (02607-0000255590). If the file is an excel file, read the Invoice Number column as well as the PO Business Unit* and PO Number*, which combined are the PO number.
2. Read the fileRxLog file and extract the Rx number and PO from the memo field.
3. Combine the above lists into a single list that has the corresponding Rx Number, Invoice Number, Date, PO Number, and Total Amount, and save it to the fileInvoiced file
Sample files will be provided upon acceptance of the job.
Inputs:
1. Directory Path to paid Invoices (dirPaidInvoices)
2. File Path to an Invoices.xlsx file (fileInvoiced)
3. File Path to a csv file (fileRxLog)
The above inputs will be set and persisted on the dialog so the next time the application opens it populates the fields automatically. The program will do the following:
1. Read all files from dirPaidInvoices and its subdirectories. If the file is a pdf file (e.g., Invoice 172948 PO 02607-0000255590.pdf) extract the invoice number (e.g., 172948) as well as the PO number (02607-0000255590). If the file is an excel file, read the Invoice Number column as well as the PO Business Unit* and PO Number*, which combined are the PO number.
2. Read the fileRxLog file and extract the Rx number and PO from the memo field.
3. Combine the above lists into a single list that has the corresponding Rx Number, Invoice Number, Date, PO Number, and Total Amount, and save it to the fileInvoiced file
Sample files will be provided upon acceptance of the job.