1. Go to the ServiceTrade invoice list and search for the list of invoices you want to import into Sage 300 Timberline.
  2. Export that list of invoices from ServiceTrade by choosing Export to Spreadsheet Export Details.
  3. Save the invoice export file to your computer.
  4. Click the 'Choose File' button, then select the exported list of invoices saved to your computer.

Note: Your Sage Timberline external system in ServiceTrade must be named 'sage_timberline'. Invoices imported from ServiceTrade will be mapped to their corresponding customers in Sage Timberline by the company external ID of the customer for the ServiceTrade invoice's job.

Sage 300 Timberline invoice import TXT file:
ServiceTrade invoice update CSV file:
  1. Click on the Sage 300 Timberline invoice import TXT file to download it to your computer.
  2. Import the invoice import TXT file into Sage 300 Timberline.
    3. Was the import completely successful? YES NO
  3. Click on the ServiceTrade invoice update CSV file to download it to your computer.
  4. Mass-update the status of the invoices in ServiceTrade by going to Customer Bulk Import Invoice Update, then selecting the invoice update CSV file.
  5. Review the invoice import error messages in Sage 300 Timberline to address and resolve the errors.
  6. If you had to make any changes to any invoice, job, or customer data in ServiceTrade to resolve the errors, return to the ServiceTrade invoice list and export the list of invoices from ServiceTrade again, then start over.
  7. Otherwise, re-import the invoice import TXT file into Sage 300 Timberline, then click 'Yes' above if the import was successful.
Start over
Start over