How to Create and Apply AR Credit Memo - Oracle EBS R12

https://receivablesar.blogspot.com/2019/06/how-to-create-and-apply-ar-credit-memo.html

Please Copy Paste the below URL in your Browser

https://drive.google.com/open?id=1FF5GbvQpJUnmlQjBCYOk8lAVNVL3mvkL

How to default Draft Accounting and disable Final & Final_Post button on Transaction Workbench and Receipt Workbench

https://receivablesar.blogspot.com/2019/05/how-to-default-draft-accounting-and.html

Please copy paste the below URL in your Browser

https://drive.google.com/open?id=1DW9j7DloqbvmC7-mcbF_2EjNa4y4P1gA

APP-AR-11228: Please define all Periods in which Revenue is to be recognized or credited.

https://receivablesar.blogspot.com/2019/04/app-ar-11228-please-define-all-periods.html

Period Type Issue

Period Type not match with the Calendar Period Type

Oracle AR Period Close and Reconciliation

https://receivablesar.blogspot.com/2019/04/oracle-ar-period-close-and.html

Before Period Closure:

Check list Items	Oracle Processes
Ensure that all AR interfaces are Processed	Run Custom Interface Processes
Ensure that there is no data in AR Invoice Interface and if there is any data, import the same	Auto Invoice Import program
Ensure that all the Interfaces from OM or Service Contracts or AGIS modules are Processed
Ensure that all Transactions are in Complete status and Accounted and transferred to GL	Create Accounting
Ensure that receipt API's or Auto Lock Box interface (if any) are Processed
Ensure that there are no Exceptions for the Period under Subledger Exception Report	Oracle Subledger Exception Report
Ensure that any Pending Adjustments are either approved or Rejected
Ensure that Revenue Recognition Process is Run	Revenue Recognition
If you are using Cash Management Module, Reconcile AR Receipts with Bank Statements	Bank Reconciliation Process

Close the Period, if there are Exceptions, then you have an Option of Running "Unaccounted Transaction Sweep" Program to Sweep the Transactions to Next Period.

After Period Closure:

Internal Reconciliation:

For Example

Previous Month Aging Report	1,345,905.00
+ Current Month Transaction Register	16,500.00
+ Current Month Adjustment Register
+ Current Month Invoice Exceptions Report
- Current Month Applied Receipt Register
- Current Month Unapplied and Unresolved Receipts Register
= Current Month Aging Report	1,362,405.00

External Reconciliation:

Aging Report (As of last Day of the Month) should be equal to corresponding GL Account Inquiry Balance.
AR to GL Reconciliation Report.

Some Common Reasons for Reconciliation issue between AP and GL:

AR related Journal entries are deleted in GL before Posting

Manual entries are passed directly in GL using AR Receivable Account

AR related Transactions are transferred to GL  but not yet Posted

AR related Journals are Updated (for some reason) in GL before Posting

Revaluation Journals in GL

AR related Journal are Reversed in GL after Posting

AR related Journals Stucked in GL Interface for some Reason

Receipts Accounting in Oracle - Oracle EBS R12

https://receivablesar.blogspot.com/2019/04/httpsreceivablesar.html

Here below is the two types of the Receipts.

·         Standard Receipts:

Payment (such as cash or a check) that you receive from your customers for goods or services. Also known as cash receipts.

·         Miscellaneous Receipts:

The document that records payment received unrelated toreceivables, such as investments, interest, or refunds.

========================================================================

Accounting for Miscellaneous Receipt:

Cash	DR
Miscellaneous Cash		CR

Miscellaneous Cash Account is defined in Receivable Activities

Name: Miscellaneous Income

Type: Miscellaneous

GL Account Source: Activity GL Account

Activity GL Account: (01-001-222-33) Miscellaneous Cash Account

Cash Account is Defined in Receipt Classes > Bank Accounts

======================================================================= 

Accounting for Standard Receipt:

1. When you enter a Receipt without a Customer

Cash	DR
Unidentified Cash		CR

Cash Account and Unidentified Cash Account is defined in Receipt Classes.

2. When you select a Customer on the same Receipt

Unidentified Cash	DR
Unapplied Cash		CR

Unidentified Cash Account and Unapplied Cash Account are defined in Receipt Classes.

3. After Applying a Transaction on Receipt

Unapplied Cash	DR
Account Receivables		CR

Unapplied Cash Account is defined in Receipt Classes and Account Receivables Account is defined in Transaction types.

4. When Complete Receipt is entered at once. With Customer and Transaction Applied on the spot.

Cash	DR
Account Receivables		CR

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

Standard Receipt (on Account):

Receivables let you apply a receipt with an existing on-account credit to close one or more of your customer's open debit items. ... When the customer remits payment or $400, you can simultaneously apply this receipt with the on-account credit to close both the open invoices and their on-account credit.

In case of an On-Account receipt, there is no identified invoice against the receipt. Advance money is received from the customer and the invoice for the same can be raised at a later date.

Enter the Receipt with a Customer and select On Account in the Apply to Field, if the Invoice will have to be received in the Future or the Invoice is Unidentified or Advance has been received from Customer and the Invoice for the same can be received in the Future.

Cash	DR
On Account Cash		CR

Cash Account and On Account Cash Account is defined in Receipt Classes > Bank Account

When Invoice is Received or Identified for a particular Receipt then you can uncheck On Account and select the Particular Receipt.

On Account Cash	DR
Account Receivables		CR

On Account Cash Account is defined in Receipt Classes and Account receivables Account is defined on Transaction Types

How to Disable Delete Button on AR Header

https://receivablesar.blogspot.com/2017/07/how-to-disable-delete-button-on-ar.html

How to Disable Delete Button on AR Header

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

WHEN-NEW-RECORD-INSTANCE
RGW_FOLDER

Type: Property
Block
RGW_FOLDER
DELETE_ALLOWED
FALSE

FRM-40735 POST-QUERY Trigger raised unhandled exception ORA-06502

http://receivablesar.blogspot.com/2017/06/frm-40735-post-query-trigger-raised.html

When you try to query that bank account, nothing is returned.
This happens after adding a new bank to your Receipt Method
The error message is :

FRM-40735 POST-QUERY Trigger raised unhandled exception ORA-06502

To reproduce this issue,
Using your Receivables responsibility
Navigate to Setup / Receipts / Receipt Classes
Query your receipt class and receipt method.
Click on Bank Accounts button.

If there is more than one bank account, you may see one bank account, but
cannot see the newly added bank account.

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

Issue is happening because the size of the BANK_BRANCH_NAME field is larger
than supported. The Bank Branch Name can only be 60 characters long.
In this case, the customers bank branch was in Arabic language and was taking more
than the supported number of bytes.

To resolve this issue, change the bank branch name to a new value that is equal to
or less than 60 characters

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

In my case Account Name Length was 71. So I minimized and the Issue got Resoved