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
- 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.
- Click 'Send to Accounting System'.
- Select 'ServiceTrade Accounting Connector'.
- Click Submit.
- 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.
- Add any of the following columns below to your transactions to verify ServiceTrade invoice data matches.
- 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