Skip to main content

Exporting and Importing AR Invoices from STAC into Sage 300 CRE

Derek Torres
Derek Torres
  • Updated

Prerequisites

  • Premium or Enterprise Subscription
  • ServiceTrade Onboarding has been completed

Before Exporting Service Trade Invoices

  • The Invoices Status must be ‘OK’
  • Invoice “Start Date” and Invoice “End Date” is based on the invoice Created Date

mceclip0.png

 

Exporting ServiceTrade AR Invoices

  1. Log into ServiceTrade Accounting Connector
  2. Select “AR Invoice Import w/ Reverse Output” 
  3. Select the Invoice Start and End Date
    mceclip0__1_.png
  4. Click Apply Connection.
  5. The STAC Recipe will produce three files:
    • reversal
    • st-updater
    • ar-invoice-import
  6. Save the Download Exports in a secure location.

Screen_Shot_2021-08-19_at_1.12.53_PM.png

Note: The Date/Time stamp format on these files is as follows for easy tracking on data import: “import- yyyymmdd-HHmmss.txt” 

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.