Syncing ServiceTrade Invoices with Sage 300 CRE AR Invoices

Derek Torres
Derek Torres
  • Updated

Prerequisites

  • Pixis Manager Console App for Sage 300 CRE.
  • The Import AR Invoices Sync.

For information on creating and managing Invoices click here.

For information on how to configure the 'Send to Accounting System' button to appear on all invoices in ServiceTrade click here.

 

Walkthrough

Video Walkthrough

  1. Create a ServiceTrade Invoice. 
    Note: In this walkthrough, we will be using Invoice # 11653990 and Customer/Company Gotham City Medical Center (GMC) as an example.
    Screen_Shot_2022-02-21_at_11.10.51_AM.png
  2. Click 'Send to Accounting System'.
  3. Select 'ServiceTrade Accounting Connector'.
    Screen_Shot_2022-02-21_at_11.13.06_AM.png
  4. Click Submit.
  5. To verify ServiceTrade invoices have been imported correctly to Sage 300 CRE by:
    • In Sage 300 CRE go to Inquiry > Entries > Transactions >New File > Active
    • Note: The ServiceTrade 'Invoice Creation Date' is assigned as the 'Accounting Date' for the AR Invoice Import.
  6. Add any of the following columns below to your transactions to verify ServiceTrade invoice data matches.
    Screen_Shot_2022-02-21_at_11.14.38_AM.png
    • Adding the Customer column you see that it matches our ServiceTrade Company, GMC (Gotham City Medical Center.)
    • Adding the Invoice column you see that it matches our Invoice # in ServiceTrade, 11653990.

Field Mapping

Sage 300

ServiceTrade

Notes

AR Invoice Number

InvoiceNumber 

“STxxxxxx” Invoice Format 

AccountingDate

TransactionDate

 

ARCustomer

Customer

 

Description

Job.Number

 

Items:

   

Description

Item.Description

 

Amount

Item.Quantity

Quantity  * Amount

 

Item.Price

 

Taxable

Item.Taxable

"Taxable" or "Non-Taxable"

GL Account

 

logic

Note: ServiceTrade Invoices ‘CAN’ 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.

*The ServiceTrade AR Invoice Import Task default is to ‘Run’. This automatically syncs ServiceTrade AR Invoice Data to the Sage 300 CRE AR Invoice transaction files in specific time intervals.

 

Video Walkthrough

 

Was this article helpful?

/

Comments

0 comments

Please sign in to leave a comment.