Hi Lori,

Accounts Payable has the ability to import invoices from a comma separated text file, so you can format the spreadsheet and save it as text to import. You can find more information about this process by going to Account Payable, Help, Help Topics, Index tab, and enter "Import" in the search.

There is additional information in our knowledgebase:

How do I import invoices into Accounts Payable? (43423) 

There are also add-on solutions that can make this easier - Office Connector is an excel based reporting tool for Sage 300 CRE that also has the capability to import in several applications (including Accounts Payable). Also Sage Paperless allows you to scan, store, and approve invoices and then send them to Accounts Payable. If you are interested in a demo of either of these, let me know!

Thanks!

I did go through the help files and found some information on importing.  However, in my Accounts Payable module, there is no "Import" in the Tools.  I am working on getting with our administrators to find out if this just a permissions issue.