Syncing Sage 300 CRE Service Management PO’s with ServiceTrade Job Items

Derek Torres
Derek Torres
  • Updated

Prerequisites

  • Pixis Manager Console App for Sage 300 CRE.
  • Export Purchase Order Sync.
  • AP Vendor to ServiceTrade Vendors Sync (Required.)

How Sync Works

  1. When you create a PO in Service Management by clicking Task > Purchasing > Enter P.O.
    Screen_Shot_2022-02-21_at_1.07.58_PM.png
  2. Then enter General SM Purchase Order information and click 'Next >'.
    Screen_Shot_2022-02-21_at_1.09.40_PM.png
  3. Then enter Ship To Information and click 'Next >'.
    Screen_Shot_2022-02-21_at_1.10.43_PM.png
  4. Then enter Register information and click 'Next >'.
    Screen_Shot_2022-02-21_at_1.13.08_PM.png
  5. Then select the appropriate print settings and click 'Finish'.
    Screen_Shot_2022-02-21_at_1.15.40_PM.png
    Note: The Pixis Manager Console App syncs “newly created” Sage 300 CRE SM Purchase Order Data with ServiceTrade Job Items.
    Screen_Shot_2022-02-21_at_1.16.55_PM.png
  6. Once you finished creating a PO and the PO has been ‘received’ in Service Management, the Pixis Manager Console App syncs the Parts Vendor item status to ‘received’ and updates the ServiceTrade job Item amounts.

Field Mapping to PO Module

The Pixis Manager Console App syncs the following Sage 300 CRE SM Purchase Data fields with ServiceTrade Job Items with itemsource Parts Vendor

#

Module

Sage300

ServiceTrade

Ins

Upd

Comments

1

SM

Ponbr

Source Reference#

X

X

 

2

SM

Vendornbr

Source Vendor

X

X

 

3

SM

Orderedby

-

 

 

 

4

SM

DateEnter

-

 

 

 

5

SM

Type

-

 

 

 

6

SM

Status

Source.Status

X

X

 

7

SM

Description

Description

X

X

 

8

SM

Transnbr

-

 

 

 

9

SM

Qcredit

-

 

 

Positive or Negative order

10

SM

Amtonorder

Unit Cost

X

X

Total amount by order

Note: The ServiceTrade Sage SM PO Export Task default is to ‘Run’. This automatically syncs Sage SM POs to ServiceTrade Job Items in specified time intervals.

Was this article helpful?

/

Comments

0 comments

Please sign in to leave a comment.