Syncing ServiceTrade Job Items with Sage 300 CRE General Ledger Journal Entries

Derek Torres
Derek Torres
  • Updated

Prerequisites

  • Pixis Manager Console App for Sage 300 CRE.
  • Import GL Journal Entry Sync.
  • AP Vendor to ServiceTrade Vendors Sync (optional.)

Prior to Sync

  • The item source needs to be ‘Parts Vendor’.
  • The ServiceTrade job status needs to be ‘Complete’.

Note: The ServiceTrade job items are synced to 'new.glt'

Screen_Shot_2022-02-21_at_12.51.53_PM.png
Note: The ServiceTrade Job Items data with item source "Parts Vendor" is synced to new.glt file in Sage 300 CRE.
Screen_Shot_2022-02-21_at_12.53.55_PM.png

Field Mapping

The Pixis Manager Console App syncs the following data for job items with source "parts vendor" to Sage 300 CRE General Ledger JE.

#

Module

Sage300

ServiceTrade

Ins

Comments

1

GL

Reference2

Job Number

X

 

2

GL

Accounting Date

*Current Date

X

Date of sync

 

 

Transaction Line

 

 

 

3

GL

Transaction Description

Item Name

X

schema: "ST Item Id| ST Item Name"

Example: "ST34573|COPPER REPAIR CPLG- 1"

! will be trimmed by Sage to 30 symbols

4

GL

Account

*mapping

X

based on ST Trades

5

GL

Debit/Credit

Item Quantity * Item UnitCost

X

 

6

GL

Reference1

*Vendor ID

X

gets from ST Company (as Parts Vendor) ExternalID

Note: By default, the ServiceTrade GL Import Task is set to ‘Run’. This automatically syncs ServiceTrade job items data to the Sage 300 CRE GL transaction files in specified time intervals.

Was this article helpful?

/

Comments

0 comments

Please sign in to leave a comment.