FROM AMOUNT_DR Not Populated Correctly on AR_DISTRIBUTIONS_ALL for Receipt Application from Post Quick Cash Application (Doc ID 2043154.1)

Last updated on AUGUST 11, 2015

Applies to:

Oracle Receivables - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When running Create Accounting the Receipt Application Generated from Post Quick Batch will not Process to General Ledger


Steps to Reproduce:
Responsibility:  Receivables Manager
Navigation:

Example

1. Generated Invoice Number: 13649
    Currency: CAD
    Exchange Rate: .90
    Amount: 318.00
    Posted Invoice

2. VERY IMPORTANT OR YOU WILL NOT REPRODUCE THIS ISSUE

 2a. Setups that need to be in place for this issue.

  Access System Administrator Responsibility
  Profile>System
  Query: AR: Always Default Transaction Balance for Applications
  Ensure this is Set to Yes

  Access Receivables Responsibility
  Setup>System>System Options
  Accounting Tab:
   Create Detailed Distributions  NEEDS TO BE UN-CHECKED.
 
 SAVE

3. Access Receivables Responsibility
    Setup>System>System Options
    Receipts>Batches
    Batch>Type:  Manual-Quick
    Currency:  CAD
      Type User
      Rate:  .94
    Control: 1
    Amount : 300.00
 
     Click on Receipts
     Receipt Number:  Rct 13649
     Amount: 300.00
     Apply to:  13649

  SAVE

  Batch Number: 900029 Generated
  Receipt Number: Rct 13649 Generated

4. Run Post Quick Cash Batch.
    Allow this to complete.

5. Access Receivables Responsibility
    Receipts>Receipts
    Query Receipt Number:  Rct 13649
    Click on Apply Button.
      You will see receipt is applied to Invoice in amount of 300.00

  Important:
        In order to do the following steps you have to have the profile set to yes from Step 2
        Profile: AR: Always Default Transaction Balance for Applications: YES

  5a. Uncheck the application check box for the receipt application
  5b. Tab over to the amount applied and change this to 318.00. 
        This will make this Overapplied.
        DO NOT SAVE
        Tab down to next line.
        Apply To : Receipt Write off:  
        Tab over and -18.00 will be generated.
        Under Activity LOV: Select Receipt Write off.
        SAVE

 6. Run Create Accounting
    Control>Request>Run
    LOV : Create Accounting
    p_application_id    :222
    p_ledger_id         :1
    p_process_category  :RECEIPTS
    p_end_date          :06-DEC-13

    SAVE


 7. Receipt will not post to General Ledger

 

 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms