AX UPLOAD OF PAYMENTS DIRECTIONS
1: COPY & PASTE THE LINES OF SPREADSHEET PROVIDED BY CUSTOMER INTO THE TEMPLATE ATTACHED ABOVE
A: COPY & PASTE CREDIT MEMO & INVOICE NUMBERS INTO COLUMN D
B: COPY & PASTE AMOUNTS INTO COLUMN F(CRE AMT NO – SIGN) & G(INV AMT)
2: DATE WILL BE DAY OF POSTING
3: FILL IN CORRECT CUSTOMER NUMBER
4: PAYMENT REFERENCE WILL BE MONTH & YEAR OF POSTING
5: NEED TO FILL IN DATA FOR EACH LINE ALL THE WAY TO THE BOTTOM OF SPREADSHEET DO THIS BY HIGHLIGHTING DATA ON LINE 2 & 3 AND THEN DOUBLE CLICK ON THE + SIGN BOTTOM RIGHT OF CELL (DO THIS FOR ALL CELLS THAT NEED TO BE FILLED)
6: BEFORE UPLOAD TO AX CHECK FOR DUPLICATE INVOICE NUMBERS THE JOURNAL WILL NOT POST IF THERE ARE DUPLICATES.
A: HIGHLIGHT COLUMN D (INVOICE NUMBER)
B: CLICK ON CONDITIONAL FORMATTING (TOP OF SPREADSHEET)
C: CLICK HIGHLIGHT CELL RULES
C: CLICK DUPLICATE VALUES
E: CLICK OK (ALL DUPLICATES WILL THEN SHOW IN RED)
F: MAKE CORRECTIONS TO CLEAR DUPLICATES
7: MAKE SURE THE CELL FORMAT FOR F & G SAYS GENERAL
A: HIGHLIGHT COLUMN F
B: RIGHT CLICK AND CHOOSE FORMAT CELLS
C: CHOOSE GENERAL
D: CLICK OK
E: REPEAT STEPS A – D FOR COLUMN G
8: CHECK AMOUNT TOTAL TO MAKE SURE YOU BALANCE WITH AMOUNT DEPOSITED
A: HIGHLIGHT COLUMN F LOOK AT BOTTOM OF SPREADSHEET FOR THE WORD SUM SEE COLUMN TOTAL
B: HIGHLIGHT COLUMN G LOOK AT BOTTOM OF SPREADSHEET FOR THE WORD SUM SEE COLUMN TOTAL
C: TOTAL OF COLUMN G MINUS COLUMN F SHOULD MATCH AMOUNT OF DEPOSIT
9: SAVE SPREADSHEET TO H: DRIVE
IN AX - DATA IMPORT EXPORT FRAMEWORK - PERIODIC - PAYMENT INTERGRATION
FOLDER - FIND YOUR FILE SAVED IN YOUR H: DRIVE – OK
THIS MAY TAKE A FEW MINUTES TO COMPLETE WHEN COMPLETE
ACCOUNTS RECEIVABLE - JOURNALS - PAYMENT JOURNAL
JOURNAL - LINES - CONFIRM EVERYTHING IS UPLOADED CORRECTLY - POST
RUN DEPOSIT SLIP - LINES – FUNCTIONS – DEPOSIT SLIP – OK – OK
