Two Methods of Bank Receipt for MFT Invoice

Two methods of bank receipt for MFT invoice

(1)Finance->AR transaction->Bank receipt from AR invoice

separated receipt–for invoice currency USD & RMB分開收款沖帳

(2)Finance->AR transaction->Bank receipt –advance receipt

combinedreceipt–for invoice currency USD & RMB 同時收款分開沖帳

Finance->AR transaction->AR Doc matching-Famt 沖帳

case1:

Agent CNSHA001, KWEI029QKE-CNSHA export BL 751505338289

USD invoice 7501510INV01090 =>USD 100 (RMB635)

RMB invoice 7501510INV01111 =>RMB2080

(1) Finance->AR transaction->Bank receipt from AR invoice

(I) RMB invoice –receipt: choose Rec Curr: RMB

Tick invoice, Press “Process Receipt”, go to next page for bank receipt

Press “Save”

Receipt 7501510BRCT00001generated

Receipt 7501510BRCT00001Detail PDF show up in IEby auto

Finance->AR reports->RCT/PAY/INV/DR/CR report

(II) USD invoice–receipt:choose Rec Curr: USD

Tick invoice, Press “Process Receipt”, go to next page for bank receipt

Press “Save”

Receipt 7501510BRCT00002generated

Receipt 7501510BRCT00002Detail PDF show up in IE by auto

Finance->AR reports->RCT/PAY/INV/DR/CR report

Finance->AR reports->Outstanding report–TSL

Outstanding only: N (means not only outstanding)

From date/To date (means AR date, including invoice date , receipt date)

BL 751505338289

USD invoice 7501510INV01090 =>USD 100 (RMB635)

RMB invoice 7501510INV01111 =>RMB2080

Both invoices have collected and balanced.

Receipt details also show out in outstanding report tail.

Finance->AR reports->Statement of Account(AR)

BL 751505338289

USD invoice 7501510INV01090 =>USD 100 (RMB635)

RMB invoice 7501510INV01111 =>RMB2080

Case2:

Agent CNSHA001, KWEI029QKE-CNSHA export BL 751505336308

USD invoice 7501510INV01098 =>USD 50 (RMB317.5)

RMB invoice 7501510INV01084 =>RMB1560

(2) Finance->AR transaction->Bank receipt –advance receipt

Cash/Bank details: choose Bank code(with currency), input pay mode,

Ifbank code is bank type, pay mode choosechq or EFT or cash and chq/DD/EFT number input chq or EFT number (cash can skip the column ).

Bank code(with currency,bank mode) / Pay mode / chq/DD/EFT number
Drawer bank’s name, branch / chq/DD/EFT date / Clear date
Bank mode:Bank / Cash / skip / Receipt date / Default is Next date of Receipt date
CHQ or EFT / Must input
Bank mode:Cash or Collection Cash / Cash / skip
Bank mode: Collection Cheque / CHQ or EFT / Must input / Receipt date / Default is Next date of Receipt date

(A) input first record for RMB invoice 7501510INV01084 =>RMB1560

Allocation details:

Allocation code: AR

currency : RMB (invoice currency) , press ”Tab”, exchange rate 1 by auto

Foreign Amount: input Loc amount

Press “Allocation Details”, input AR code and AR group, press “Tab” to exit

(B)Add another record for USD invoice 7501510INV01098 =>USD 50 (RMB317.5)

Allocation details:

Allocation code: AR

currency :USD(invoice currency) , press ”Tab”, exchange rate 6.35 by auto , the ex rate fetch as receipt date from daily currency master.

Foreign Amount: input USD amount

Press “Allocation Details”, input AR code and AR group, press “Tab” to exit

Press “Save”, will generate bank receipt

Match question popup =>If Yes, invoice match continue. If No, will not match and exit.

Press “Yes”, will go to match invoice

bank receipt number 7501510BEFT00003 generated

Press OK , then go to match invoice

Choose7501510BEFT00003one record with RMB currency for matching RMB invoice

RMB invoice 7501510INV01084(RMB1560)

Match Foreign amount : input RMB invoice local amount, press Tab and press “Save” to finish .

Match finished , screen will refresh clear.

Finance->AR transaction->AR Doc matching-Famt

For matching USD invoice 7501510INV01098(USD 50) (RMB317.5)

Input Party(AR code):SHA00796, Doc type:MBRCTEFT , Doc number:7501510BEFT00003 ,Currency: USD, press “Tab”to show ex rate 6.35 by auto

Press “Fetch Details”

Match Foreign amount : input USD invoice Foreign amount

press Tab and press “Save” to finish .

Finance->AR reports->Outstanding report –TSL

Finance->AR reports->Statement of Account(AR)

BL 751505336308Invoice matched

USD invoice 7501510INV01098 =>USD 50 (RMB317.5)

RMB invoice 7501510INV01084 =>RMB1560