Syncing Sage 300 CRE AR Invoice Payments with ServiceTrade Invoice Payment Details

Adam Gurley
Adam Gurley
  • Updated

Prerequisites

  • Pixis Manager Console App for Sage 300 CRE
  • Export AR Invoice Payment Sync 

Walkthrough

Video Walkthrough

  1. In Accounts Receivable
  2. Select Tasks > Enter Cash Receipts.
  3. Select the entry view you want to use.
  4. In the Deposit Information window, enter the deposit information and click "OK."
  5. In the Deposit Items window, select the deposit item type and enter the customer, amount, and other deposit item information.
  6. In the Cash Receipts Selection window, highlight the open invoice(s) for this customer that you want to apply the cash receipt toward.
  7. Click Finish to return to the Cash Receipts window.
  8. Click Save Line > Finish Cash Receipts to return to the Deposit Items window..
  9. If you are finished entering deposit items, click Finish to exit Enter Cash Receipts.

Sage300_AR1.png

Sage300_AR2.png

Fields mapping:

Sage300

ServiceTrade

Notes

Invoice

InvoiceID

 

Customer

CustomerID

 
 

paymentMethod

 
 

Source

 

Amount

Amount

 

Reference

ReferenceNumber

 

“Applied”

Status

 

Deposit Date

TransactionDate

 
     
     
     

 

 

Notes:

  • Negative deposit and deposit item amounts cannot be synced with ServiceTrade.
  • The ServiceTrade AR Payment Task default is to ‘Run’. This automatically syncs Sage 300 CRE AR Invoice Payment Data to the ServiceTrade Invoice Payment Details in specified time intervals. 

Video Walkthrough

Was this article helpful?

/