R12:CE:Bank Account Transfer Validation Failed with Error "The Intercompany Account Generated By The Intercompany Balancing Rules Is Invalid"

http://cashmanagementcm.blogspot.com/2016/12/error-1.html

ERROR

1. null
2. null
3. Intercompany balancing was unable to generate the intercompany account.
4. The Intercompany account generated by the Intercompany Balancing Rules is invalid.
5. The Intercompany account generated by the Intercompany Balancing Rules is invalid.
6. null
7. null
8. Intercompany balancing was unable to generate the intercompany account.
9. The Intercompany account generated by the Intercompany Balancing Rules is invalid.
10. The Intercompany account generated by the Intercompany Balancing Rules is invalid.



CAUSE

Incorrect setup
Customer has Account Flexfield with intercompany flag enabled and Balancing Segment qualifier also enabled.

When the Intercompany Segment qualifier is enabled, then the segment values in the intercompany segment should be a super set of the values in the balancing segment.


SOLUTION

1. When the Intercompany Segment qualifier is enabled, then the segment values in the intercompany segment should be a super set of the values in the balancing segment.

For example:-

Value set of Balancing segment contains 01,02,03

Value set of Intercompany segment should contain 01,02,03.

Intercompany segment should have all the values present in Balancing segment

--------------------------------------------------------------------------------------------------------------------------

1. User has responsibilities having security rules defined so that a code combination which belongs to 'A' is not accessible in the responsibility of 'B' and hence, Intercompany account that was generated becomes invalid.

2. Define a responsibility which has access to both 'A' and 'B' to have a bank account transfer between the two Legal entities.

----------------------------------------------------------------------------------------------------------------------------------

Check for the most common causes which may prohibit the accounting flexfield from being created.

1 - Check for Cross Validation Rules

2 - Check the Accounting Flexfield and ensure the Dynamic Insertion is enabled, allowing the code combination to be derived and generated from the intracompany rule.

Loading Bank Statement Open Interface

http://cashmanagementcm.blogspot.com/2016/02/loading-bank-statement-open-interface.html

Before you can reconcile transactions against a bank statement, you need to enter the bank statement information into Cash Management. If your bank provides account statements in a flat file, using a defined format like BAI or SWIFT940, you can use the Bank Statement Open Interface to load this information into Cash Management.

Prerequisites

Create a SQL*Loader Script.

To load a bank statement into the bank statement open interface:

1. Run the SQL*Loader script against the bank file. This populates the bank statement open interface tables.

2. Verify that the bank statement information was loaded into the open interface tables correctly.
You can use the Bank Statement Interface window to ensure that bank statement header information is correctly mapped to the CE_STATEMENT_HEADERS_INT_ALL table.
You can use the Bank Statement Lines Interface window to ensure that bank statement transaction lines are correctly mapped to the CE_STATEMENT_LINES_INTERFACE table.

The Bank Statement Interface and Bank Statement Lines Interface windows show you the statement header and lines information that populates the open interface tables. You can correct the information using these windows, or you can correct the original bank file and reload it using your SQL*Loader script.







3. Import the bank statement information using the Bank Statement Import program. This transfers the bank information from the open interface tables to the bank statement tables.