The journal has master bills.   

  1. Go to global transactions
  2. Search cust ref field 4
  3. Download the global transaction report 

 

 

 

TO FIGURE OUT WHICH MASTER BILL WAS SHORPAID FOR THE OA – YOU WILL NEED TO DO A PIVOT TABLE USING THE  GLOBAL TRANSACTION DATA THAT YOU DOWNLOADED. IT IS THE FASTEST AND SIMPLEST WAY TO DO IT

 

 

YOU CAN THEN COPY THE VALUES AND COMPARE IT TO THE PAYMENT

HERE IS EASY TO SEE WHICH ONE IS EITHER SHORT PAID OR OVER PAID.


NOTE: USE "SHOW ALL" FILTER IN GLOBAL TRANSACTIONS. THIS WILL PROVIDE THE FULL LIST OF INVOICES UNDER A MASTERBILL AND YOU'LL BE ABLE TO IDENTIFY SHORT/OVERPAYMENTS FASTER IF THE AMOUNTS MATCH WITH WHAT HAS BEEN CLOSED DUE TO OFFSETS, WRITE-OFFS OR PREVIOUS PAYMENTS. (if this works there is no need to look for the MB invoice in Synergize)


700045174MB – OA REASON MASTER BILL $7,023.72

 







ON ACCOUNT TERMS

REASON FOR OA

PD2X

Duplicate invoice paid

DUPLICATED PAYMENT

U

Unidentified payment or invoice open in subsystem

UNIDENT

PWO

Invoice written on/off

WRITTEN OFF

TKBK

(Takeback) Credit applied to invoice

TAKE BACK

OFFSET

Invoice offset with another

OFFSET BUT CREDIT BEING TAKEN

UNK

Not sure how to apply invoice or how was applied

 

BANKFEE

Bank wire fee with deposit date (mmddyy)

 

CHQ

Full payment amount put ON ACCOUNT with cheque #

 

MB

Master Bill

 

 

 

 

 

 

 

YOU CAN VIEW THE MB IN ZYNERGIZE AND FIND THE MISSING INVOICES.


IF THE MASTER BILL IS UNDER OR OVER YOU NEED TO CREATE AN OA - WE CAN ASK TRIMAC FOR THE BRANCH IF WE DO NOT KNOW WHICH INVOICE IS MISSING FROM THE MB.


 IF WE KNOW THE INVOICE WE NEED TO PROCEED TO FIND THE BRANCH NUMBER (NEW PROCESS SHARED BY TRIMAC)

 


TEMPLATES