Skip to main content

Exporting and Importing AR Invoices from STAC into Sage 300 CRE

Derek Torres
Derek Torres
  • Updated

Importing AR Invoices into Sage 300

Video Walkthrough

  1. Login to the Sage 300 CRE Company for which you want to import records.
  2. Open Account Receivable. 
  3. Click Tools.
  4. Then click Import AR Invoice.
  5. Click “...”on the Import file line.
    mceclip0-2-.png
  6. Browse to the location of your saved AR Import .txt file.
  7. Select the location of the ARREJECT.TXT file
  8. Click the Start button.
  9. Verify the AR Import File is Imported correctly.
    1. Click Inquiry.
    2. Click Entries.
    3. Click Transactions.
    4. Click New File.
    5. Click Active. mceclip1.png
      Note: The ServiceTrade Invoice Date is assigned as the Accounting Date for the AR Invoice Import.
  10. To verify that your import moved data successfully, add any of the following columns to your transactions and verify ServiceTrade Invoice Data. Example Below:
    • Accounting Date 09-08-2021
    • **Invoice ST-10384714
    • Sage Job 20-121
    • Location (Extra) 100
    • Cost Code Division 21-000 
    • Credit Account 21-4003
  11. Once import data is verified, click Tasks.
  12. Then click Post Entries.

Note: ServiceTrade Invoices are imported into Sage 300 CRE with an “ST” before the invoice number. This invoice numbering sequence is independent of the AR invoice number sequence in Sage 300 CRE AR settings.

Video Walkthrough

Was this article helpful?

/

Comments

0 comments

Please sign in to leave a comment.