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'
Note: The ServiceTrade Job Items data with item source "Parts Vendor" is synced to new.glt file in Sage 300 CRE.
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.