How to Upload AR Invoices and Payments that were not uploaded using the standard method: Check Invoicing

This upload process allows you to upload all customer documents that are missing within Fidesic, and it will check to see if they are duplicates and upload missing.

There are times when you forget to upload invoices or payments using the built in integration. You have the ability to upload these invoices directly to Fidesic using the "Check Invoicing" feature. 

Generating the Correct Report and PDFs

To upload invoices to Fidesic, you will need a spreadsheet of the missing invoice data. If you are using Dynamics GP, you can use SmartList to build this spreadsheet. 

Spreadsheet Requirements (csv, xls, xlsx): 

• Required fields:
  • "Customer Number", "Document Type", "Document Number", "Document Date", "Document Amount"
• Optional fields:
  • "Due Date", "Originating Subtotal", "Tax Amount", "Trade Discount Amount"

Check Invoicing Template 

You will also need a PDF copy of all invoices handy. 

 

Generating the Smartlist

Navigate to smarlist builder from the main MS Dynamics GP Menu. Then pick sales, and transactions by customer. 

 

You can also filter the contents of this report using the Search Option. This import supports up to 1 calendar years worth of transactions. It also is good practice to only includes customers where you are having variance issues. 

Make sure to check that the "Maximum Records" is large enough to include all relevant transactions. 

Navigate to Check Invoicing

Under the settings menu, select Import Files.

 

From this page you will select "Check Invoicing" from the drop down menu

Uploading Missing Invoices 

From the check invoicing page you'll have a "choose file" button that will allow you to select the spreadsheet you generated in step one above. 

After you've selected the spreadsheet, it should begin uploading immediately.

 

Attaching PDFs

After you've clicked submit, you'll be taken to a page that allows you to upload PDF attachments to each invoice in the spreadsheet. To do so, click "Choose Files" on each invoice and you'll be able to select the missing PDF from your local computer. If the pdf names all match the invoice numbers, you can upload all attachments at once from the top "Choose Files".

After you've uploaded the necessary attachments, check the box next to the invoice and you can click "submit" to upload invoices with their PDFs attached.