AR9.2. When Paying An Invoice With 2 Lines With Different Fund Codes Through Direct Debit , Entries On PS_ITEM_DST Are Not Balanced By Funds. (Doc ID 3035316.1)

Last updated on JULY 17, 2024

Applies to:

Symptoms

  When bills are created with 2 lines, and different fund distribution codes, and Payments are made through Direct Debit , entries on PS_ITEM_DST are not balanced by funds and the system generates the additional entries

on ITEM_DST table with SYSTEM_DEFINED = ‘M’ & ‘T.

Issue can be replicated following the next steps :

1. Go to Banking > Bank Accounts > External Accounts and check the bank USBNK and account DD to have Fund Code always inherit for - Cash-AR - Cntrl-AR - Draft-AR - Disc-AR
2. Uncheck Cash Clearing.
3. On General Ledger>Ledgers>Define Ledger Group for Recording on Balancing Tab – Check IU Balancing Entries and Fund Code Balance.
4. Go to Customers > Customer Information > Create Customer Information for customer 1006 and add direct debit group =group a and direct debit profile id=dd-01 Under Bill to Options Tab

( make sure that you have the MICR information filled in for the customer 1006).

1. Go to Customers > Create Customer Contacts for customer 1006 and choose contact 25.Click on User Profile and make sure we have a userid and password created – User AAA and password AAA.Add allpages permission list to all permission lists.
2. Setup Financial>Installation options>Overall and make the Interunit method Direct.
3. Check the Interunit setup at Setup Financial>Business Unit related>General Ledger>General ledger definition for US001 and US005.
4. Create a bill, two lines and each line with a different fund code and set it to RDY. Use the above customer that has customer portal access and DD profile is setup. ( Billing>Maintain Bills>Standard Billing >Bill entry).
5. Run Single Action Invoice for the above invoice ( Billing>Generate Invoices>Non-consolidated>Single Action Invoice)
6. Check the group in AR.( Ar>Pending Items>External Items>External Item Group Entry ) and set it to Batch priority.
7. Run Ar update ( Ar>Receivable update>Request Receivable Update) and check the item list of the customer 1006.
8. Create Direct debit (AR>Direct Debit>Administer Direct Debits>Create Direct Debits) and run AR_DIRDEBIT
9. Run Ar update and check the group after .
10. When going to correct Posting error>Direct debit , the Inter Unit lines are not balanced and so the system generated Intra Unit lines to balance them (System_Defined in (‘M’, ‘T”)).

More information can be found in the replication document attached.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.