IHC Incoming External Bank Statement

[lim_josephine]

Hi,

This is regarding IHC Centralized Incoming Payment.

I have configured 3 path:

1. IHC Account Determination from Payment Notes

Bank Area Account Number Payment notes

IHC            300010                123456

2. Set Up Account Determination for Incoming Payment

Bank Area      House Bank     Account ID     FI Account in IHC            Header Acct for Central Incoming Payment

0001               CIT10               CIMYR              100010                                   100010

3. Define Transaction Types for Incoming Payment

Bank Area   External TT    Credit/Debit          Transaction Type 

IHC               NMSC          Credit Memo            CP

IHC               NMSC              Debit                    CP

While upload CIT10 bank statement with payment notes 123456, IHC payment order "CP" is created with Payer = 100010 and Receipient = 30010

I have 2 questions:

1) When we try to post the CP Payment order it failed with error "Generation of payment items - Offset Item - failed"

Below is the list of message with Green & Red status:

Green - Source transaction currency amount: 1000.00 MYR

Green - Account currency amount 1000.00 MYR to be posted for items - Payer

Green - Posting MYR made to original account OffsetAcct 300010

Red - Generation of payment items - Offset Item - failed

Red - Payment order IHC/0000000589/2015 was not posted

Green - Posting MYR made to original account Payer Account 100010

Green -*--- Final Posting: Internal payment order

Transaction type EXTRCP was transferred with posting attribute FINP

2) If we want to maintain a range of payment notes in "IHC Account Determination from Payment Notes",instead of maintaining one by one how should it be maintained in field "payment notes". Eg: from 000001 to 123456

Please share your experience.

Cheers.

J

[former_member251898 · Accepted solution]

Hi,

Please check the attribute of Transaction Type that you assigned in Posting Data - Make Basic Setting for Payment process Selection for this Specific Transaction type CP.

Normally you need to configure as below for incoming payment through IHC (Debit memo)

Bank Area	Final	Payer	Credit	CP	0001	0001	Zyyy (Credit)
Bank Area	Final	Counterparty	Debit	CP	0001	0001	Zxxx (Debit)

I have never used this functionality with Payment notes to determine the External parties, though. If the above is not the roote cause, would you expand the error message and share the details with the error message "Red - Generation of payment items - Offset Item - failed"?

Cheers

Taro

[lim_josephine · Accepted solution]

Hi,

The issue is resolved.

It is due to the same bank key setup in more than one Bank area, hence during bank statement upload it is unavailable to identify the Subsidiary and hence posted to against Header Account for Centralized Incoming Payments

[Former Member]

Hi Asephine,

We are in talks of implementing IHC Incoming Payments.

We are stuck at bank statement received from the bank.

How to identify the correct format for the bank statement so that we get to the know for which company code the payments are directed.

What are the solutions implemented by the bank on their system for the same.

Please advise.

You Can also email me at marora14@gmail.com

Regards,

Manish