My Oracle Support Banner

AR9.2.When An Invoice Is created With 2 Lines With Different Fund Codes And Payment Is Made Through Direct Debit, Entries On ITEM_DST Are Not Balanced By Funds In MSS Database (Doc ID 3011672.1)

Last updated on MARCH 20, 2024

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

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, in MSS database.

Issue can be replicated using the following 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).
  5. 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 . And add allpages permission list to all permission lists.
  6. Setup Financial>Installation options>Overall and make the interunit method Direct.
  7. Check the interunit setup at Setup Financial>Business Unit related>General Ledger>General ledger definition for US001 and US005.
  8. 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).
  9. Run Single Action Invoice for the above invoice ( Billing>Generate Invoices>Non-consolidated>Single Action Invoice)
  10. Check the group in AR.( Ar>Pending Items>External Items>External Item Group Entry ) and set it to Batch priority.
  11. Run Ar update ( Ar>Receivable update>Request Receivable Update) and check the item list of the customer 1006.
  12. Create Direct debit (AR>Direct Debit>Administer Direct Debits>Create Direct Debits) and run AR_DIRDEBIT
  13. Run Ar update and check the group after .
  14. When going to correct posting error>direct debit the ar update is creating accounting entries but the customer is saying that the Inter Unit lines are not balanced and so the system generated Intra Unit lines to balance them (System_Defined in (‘M’, ‘T”)).

For more information, please check the replication document attached.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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