1. Download text file

1.1 Domestic's text file download from website

(1) Login Kasikorn bank website

(2) On the main page, click "รายงาน" and select "เรียกดูรายงาน"

(3) After list of reports has been shown, select "Special cheque text file"

(4) Select text file that need to download

(5) Save text file as defined folder 

Step:

(1) Open the program

Double click on icon  

(2) Connect to Kasikorn bank's server as following,

(2.1) Click "File" and select "Site Manager"

(2.2) Fill information required in the pop up window

Click  => 

(3) Download text file

In the blank of "Remote site" fill "VNT-adv_provider_outbound" and press enter

On the right hand side will show list of text files from Kasikorn Bank,

Download text file by right click on the file name you need and click "Download",

Text file will go through your site as you can see from left side.

2. Upload text file by open transaction "S_PL0_09000467" (DME Engine : Convert incoming file) in SAP

3. Click  to "Get Variant", then select "VNT_AR_SETTLE"

4. Enter details and upload

(4.1) Z1F_TH_KBANK_DOMESTIC – for upload domestic text file
Z1F_TH_KBANK_OVERSEAS – for upload foreign text file

(4.2) Choose text file for upload to ERP

(4.3) Click  to execute, system will show the result 

5. Check correction of AR auto clearing result by open transaction FB03, then put document number which got after uploaded.

Difference between the total amount in the lines of bank account and amount in bank statement should not be over than 1.00 THB. 

4.1.1 Citi Bank

There is only incoming from domestic customer that can be uploaded.

Step:

1. Download text file

(1) Login Citi Direct website

(2) Extract text file as following steps,

Click All reports => Asia Extended Service => Reporting 

On the screen of window "Search Criteria", continue below selection, 

• "Product Family" select "Collection" 
• "Date" select both From and To 

(3) Select and download file by each Client ID 

SPX - 123885
VNT - 124937 

*** When save text file, "Credit Handoff" can remain the former file name, but for "Deposit Handoff" need to change file name to "Instrument" 

2. Upload text file by transaction Z1F_TH_BAI2

(1) Open transaction Z1F_TH_BAI2

Fill in all the details required

• Bank Account - 50601THB31
• Company Code – Company Code
• Currency – THB

At "File name" select text file to upload 

Fill in all the details required

• Company Code – Company Code
• Currency – THB

Select text file to upload at "File name", then click on execute  

(2) Check the result.

After uploaded, go to check the details in column of "Result". If it is successful, there will be a document number. But if it is not, content will show as "the difference is too large for clearing", in this case, we have to settle AR manually.

T/T incoming – Oversea and Domestic incoming.

Some incoming cannot be uploaded automatically, so AR need to post manually. Generally every incoming from overseas customer will receive credit advice from bank, so AR can record payment based on information on these credit advices. 

Credit Advice – Oversea Incoming 

For incoming from domestic customer, Collection Team will handle providing payment receipt to customer and make copy to AR for clearing, there is information of customer and invoice on these receipt.

Step: Posting Incoming

After download Bank Statement (Internet Banking) from website on daily basis

1. Find corresponding AR in credit advice or payment receipt and open data in SAP to find more details.

Overseas

 Copy invoice numbers which show on credit advice and open in transaction FB03 

If there is no invoice number, copy customer name which show on credit advice to find corresponding AR in SAP by open transaction FBL5N 

Domestic

 Check payment receipt provided by collection team, and check corresponding invoices by open transaction Z1F_TH_PMTRCPT_DISP 

Fill information required

• Company Code – Company Code
• Customer Number – Customer Code (Can pass)
• Receipt Number – Check from receipt provided by collection team
• Receipt Year – Year of receipt issuing

Click execute  

2. Use transaction F-28 to clear related AR open items (in case of customer invoices have been generated).

Fill in all the details required

• Document date – Payment Receiving Date
• Type – DZ
• Fill in Company code, Period, Currency/Rate, Reference, Doc. Header text, Clearing text
• Bank Data
  • Account -G/L account of incoming bank
  • Amount- payment amount in Local / foreign currency
  • Amount in L/C – payment amount in local currency (if any)
  • Bank Charge – amount charged (if any)
  • Value Date – same as posting date and document date
  • Text- same as clearing text
• Open Item selection
  • Account – customer code
  • Account Type – D (for incoming transaction)

Click "Process Open items" after filling in all the details. 

3. Select invoices that match with incoming payment by double click on the amount.

4. If transaction contains bank charge or other financial expense, "Not assigned" box will show remaining amount.

5. To process "Bank charge", Click  button. Then fill in other line items.

** Bank Charge – GL 6590900000

** Other financial expenses – G/L 6599000000

Fill in all the details required

• Amount – Amount charged
• Tax Code – T2
• Business Place – Based on different company
• Assignment – T/T bank name
• Text – same as clearing text

6. Click "Document Simulate"

7. Click  "Save" for post [Get the document number] 

4.3 Advance Payment

Step:

 1. Open transaction F-29

Fill in all the details required

• Document date – Payment Receiving Date
• Type – DZ
• Fill in Company code, Period, Currency/Rate, Reference, Doc. Header text
• Customer
  • Account – customer code
  • Special G/L Ind – Put "A (Down payment)"
• Bank Data
  • Account -G/L account of incoming bank
  • Amount- payment amount in Local/foreign currency
  • Amount in L/C – payment amount in local currency (If any)
  • Bank Charge – amount charged (if any)
  • Value Date – same as posting date and document date
  • Text- same as clearing text

2. Click "New Item" 

Fill in all the details required

• Amount – Invoice Amount
• Tax Code – TC
• Bus./sectn – Based on different company
• Assignment - TD Standard Order
• Text – same as clearing text

3. Click "Document Simulate"

4. Click "Save"  for post [Get the document number]

5. Dispute for advance case

4.4 Post Date Cheque

Step: 

1. Open transaction F-21 or F-04 or FB05

Fill in all the details required

• Document Date – Cheque Receiving Date
• Type – DZ
• Fill in Company code, Period, Currency/Rate, Reference, Doc. Header text, Clearing text
• First line item
  • PstKy – 09
  • Account – Customer Code
  • SGL Ind – C

2. Press enter to go to next page

Fill in all the details required

• Amount – Amount in Cheque
• Due on – Cheque Due Date
• BusPlace/Sectn – Based on different company
• Fill in Assignment, Text
• Next line item
  • PstKy – 15
  • Account – Customer Code

3. Press enter to go to next page

Fill in all the details required

• Amount – Amount in Cheque
• BusPlace/Sectn – Based on different company
• Bline Date – Cheque Due Date
• Fill in Assignment, Text

4. Click "Document Simulate"

5. Click "Save"  for post [Get the document number]

Step:

1. Use transaction F-32 to clear advance payment received posting with related AR open item.

Fill in all the details required

• Account – Customer code
• Clearing date – Payment Receiving Date
• Fill in Company code, Period, Currency/Rate,
• Open item Selection
  • Special G/L Ind – Put "A (Down payment)"

2. Click "Process open items"

3. Select invoices that match with advance incoming payment by double clicking on the amount.

4. Click Document Simulate

5. Click  "Save" for post [Get the document number]

Step:

1. After receive incoming from bank who support for discount, record payment by transaction F-21

Fill in all the details required

• Document Date – Payment Receiving Date
• Type – DT
• Fill in Company code, Period, Currency/Rate, Reference, Doc. Header text, Clearing text
• First line item
  • PstKy – 40
  • Account – G/L account of incoming bank

2. Press enter to go to next page

Fill in all the details required

• Amount – Incoming amount
• Value Date – Payment Receiving Date
• Fill in Assignment, Text
• Next line item
  • PstKy – 19
  • Account – Customer code
  • SGL Ind - C

3. Press enter to go to next page

Fill in all the details required

• Amount – Invoice amount
• Bus. Area – Based on different company
• Fill in Assignment, Text
• Next line item
  • PstKy – 40
  • Account – 6530000000 (Interest charged from discount)

4. Press enter to go to next page

Fill in all the details required

• Amount – Amount charged
• Business Place – Based on different company
• Business Area – Based on different company
• Cost center – Based on different company
• Fill in Assignment, Text

5. Click "Document Simulate" 

6. Click  "Save" for post [Get the document number] 

4.6.2 Return payment to bank

Step:

1. After make payment to bank, record outgoing by transaction F-04

Fill in all the details required

• Document Date – Payment paid Date
• Type – DT
• Fill in Company code, Period, Currency/Rate, Reference, Doc. Header text, Clearing text
• First line item
  • PstKy – 50
  • Account – G/L account of outgoing bank

2. Press enter to go to next page

Fill in all the details required

• Amount – Outgoing amount
• Value Date – Payment Paid Date
• Fill in Assignment, Text

3. Click "Choose open items"

Fill in all the details required

• Company Code
• Account – Customer code
• Account Type – D
• Special G/L ind – C

4. Click "Process open items", then select items

5. Click "Document Simulate"

6. Click  "Save" for post [Get the document number]