HOW-TO

How to import invoice records from a CSV into Sage 300 CRE

Short answer

Yes. Use Accounts Payable > Tools > Import Invoices with a comma-delimited text file in the Variable or Fixed layout. Fix rejected rows and re-import them. Importing does not post the invoices.

Last checked

Importing bills from a CSV means loading many supplier bills into your accounting system from one spreadsheet instead of typing each one.

The Sage 300 CRE way

Where to find it: Accounts Payable > Tools > Import Invoices

  1. Build a comma-delimited text file in the Variable or Fixed layout. Print the layout from the Import Invoices window.
  2. Enter the import file and a rejected records file name, then click Start.
  3. Fix rejected rows in the rejected file and import that file.
  4. Post the imported invoices. Importing does not post them.

Limits in Sage 300 CRE

  • Text file only, one row type for the invoice and one for each distribution.
  • The file is not deleted after import and the task does not warn if you import it twice (duplicates are rejected).

Good to know in Sage 300 CRE

  • Version 25.2 added Default Payment Type to the import layout.

Common mistakes

  • Forgetting to post after the import, because importing does not post.
  • Fixing rejected rows in the original file instead of the rejected records file.

More help

Sources

Last checked 2026-10-19. Confidence: confirmed.

Common questions

What file does Import Invoices need?

A comma-delimited text file in the Variable or Fixed layout. Print the layout from the Import Invoices window. Each file has one row type for the invoice and one for each distribution.

Does importing post the invoices?

No. Post the imported invoices afterwards. Rejected rows go to the rejected records file, which you fix and import again.

What if I import the same file twice?

The file is not deleted after import and the task does not warn you. Duplicates are rejected, but rename or move the file anyway.

Can Pulsify import a CSV of bills?

No. Pulsify reads invoice documents. Forward each invoice to your Pulsify address and approve it.

Pulsify setup guides

Want this done for you?

Book a call to see how Pulsify handles supplier bills in Sage 300 CRE.