Receivables Write-off Adjustment

Working With Claim_Create a Write-off Adjustment

1. Sign on using the following information (User should be other then operations)

- User = 01USER

- Password = welcome

Responsibility = Receivables, Vision Operations (USA)

Enter Approval Limits

2. Navigate to the Approval Limits window

(N) Setup > Transactions > Approval Limits

3. Enter the following information:

Field	Value
Username	01user
Document Type	Adjustment
Currency	USD
From Amount	-25
To Amount	25

4. Click (I) Save.

Create the Write-Off Adjustment

5. Navigate to the Transactions Summary window

(N) Transactions > Transactions Summary

6. Navigate to (M) View > Find and enter the following information:

Field	Value
Transaction Number	500875
Ship To Name	Advanced Network Devices

7. Click (B) Find.

8. Click (B) Adjust and enter the following information:

Field	Value
Activity Name	Write-Off
Type	Invoice
Amount	-100

9. Click OK (B)

10. Click (I) Save

Note: The amount is outside of Preparer’s approval limit. Make a note of the following update:

- Pending Adjustments = -100

Note: Invoice type adjustments must make the balance 0. In addition, approval amounts are validated on a line-by-line basis.

Log in as a Different User and Approve the Pending Adjustment

11. Navigate to (M) File > Exit Oracle Applications

12. Click (B) OK.

13. Navigate to the Oracle Applications Home Page.

14. Click (L) Logout.

15. Log in as a New User using the following information:

- User Name = operations

- Password = welcome

16. Click (B) Login and select the following:

- Responsibility = Receivables, Vision Operations (USA)

17. Navigate to the Approve Adjustments window.

(N): ARàControlàAdjustmentàApprove Adjustment

18. Enter the following information:

- Creator = 01USER

- Status = Pending

18. Change Status from Waiting Approval to Approved.

- Status = Approved

19. Click (I) Save.

20. Click (B) Action History.

21. Note the Action History.

22. Close all the windows and return to the Navigator.

23. Follow the preceding steps from 10 to 14 to Exit Oracle Applications and sign in again using 01USER username.

Run the Adjustment Approval Report

24. Select the following responsibility:

Responsibility = Receivables, Vision Operations (USA)

25. Navigate to the Standard Request Submission window.

26. Click (B) OK to submit a single request with the following information:

- Name = Adjustment Approval Report

- Order By = Customer

27. Click (B) OK to accept defaults.

28. Click (B) Submit.

Note: Do not submit another request.

29. Navigate to (M) View > Requests

30. Click (B) Find.

31. Click (B) Refresh Data until the request completes

32. Click (B) View Output.

33. Close all windows and return to the Navigator.

Credit Memo against Invoice in r12 Receivables

Case study for AR Credit Memo against Invoice

1. Navigate to Transaction window

(N) Receivables > Transaction > Transaction

2. Enter the invoice mandatory fields

Field Name	Value
Sources	Manual
Class	Invoice
Type	Invoice
Ship to	Business World (real time customer name)

3. Click Lines (B)

4. We have to select line item, Quantity and price details

5. click on save (B)

7. Optionally we can also check the account details by clicking “distribution”

8. Click on “Complete” (B) to complete your transaction

9. Now we can see the completed check box has been checked.

10. We can also check the printed invoice by clicking print button

11. Check the outstanding balance In below screen

12. Create accounting by navigating tools > Create accounting field

13. Select your option of accounting and click OK

14. View accounting by navigating Tools > View Accounting

15. We can see the accounting entries created by the Transaction

Create credit memo for this invoice and make the balance NIL amount.

16. Navigate to the “Action” button and click “Credit” Button

17. Invoice number selected to raise the Credit memo

18. Ensure that Type is selected for “Credit Memo” else select it

19. Click on the “Credit Balance” button to raise fully credit

20. You will get the conformation message like below, click ok

21. Now we can see that credit amount fully applied to that invoice number 12024

22. Balance got “Zero”

23. Click save (B)

24. Click “Complete” (B)

25. Now credit memo applied and completed.

26. Do the Create the accounting in Tools > create accounting

27. Select how you want to create accounting and click ok like draft or final

28. click OK (B)

29. view accounting from Tools > View Accounting

30. In this screen the accounts get reversed

31. Query the Invoice using invoice number

32. Enter the invoice number and click find button

33. Click the “Details” Button to view the complete balance details

34. Check below screen the balance has been get cleared

35. we can also check in transaction print showing null balance in the end outstanding

Receivables Remit–to Address

Define System Options and Profile Options

1. Navigate to System Option

(N) Receivables > Setup > System > System Options

2. Ensure that “Print Remit to Address” check box checked

Set the profile option

3. Navigate to System profile option window

(N): System Administrator > Profile > System

4. You can only enter information in the alternate name field when defining a Remit-to Address if the profile option AR: Customers – Enter Alternate Fields is Yes.

5. Receivables also uses the alternate name to sort customer names in certain

reports if the profile option AR: Sort Customer Reports by Alternate Fields is Yes.

Create Remit – to Address

6. Navigate to the Remit-To Address Form

(N): Receivables > Setup > Print > Remit To Address > Create Remit-To Address

7. Click on “Create Remit – to Address” (B)

8. Enter the following address details

Field Name	Value
Country	India
Address Line1	No. 1422
Address Line3	Chennai City Center
City	Chennai
Country	India
State	Tamil Nadu
Postal Code	600004

9. Click on “Apply" (B)

10. Re-Query the Remit-To Address

11. After you apply and save you will be returned to the Remit-To Address search window. Enter the country name and select Go

12. Select the Remit – to Address which created

13. Click on “Create” (B) for creating receipt form

14. Enter the following information

Field Name	Value
Country	India
State	Tamil Nadu
From Postal code	600000
To Postal Code	700000

15. Click on “Apply” (B)

16. Data has been saved successfully

Remit – to Address has been created successfully

How to Create Receivables Activity in R12

 

Create Receivables Activity

An activity's type determines whether it uses a distribution set or GL account and in which window your activity appears in the list of values. You can choose from the following types:

Types of Receivables Activity:-

Adjustment

Bank Error

Claim Investigation

Credit Card Chargeback

Credit Card Refund

Earned Discount

Endorsements

Late Charges

Miscellaneous Cash

Payment Netting

Prepayments

Receipt Write-off

Refund

Short Term Debt

Unearned Discount

2. Navigate to the Receivables Activities window

(N) Receivables > Setup > Receipts >Receivables Activity

3. Enter the following details to “Receivable Activity” for “Adjustment”

Field Name	Value
Operating Unit	Vision Operations
Name	Adjustment
Description	Revenue and Tax GL Accounts derived from Invoice
Types	Adjustment
GL Account Sources	Revenue on Invoice
Tax Rate code source	Invoice
Activity GL Account	01-000-1260-0000-000

Technorati Tags:

4. Click on Save (B)

5. Close the form

6. Repeat the same as above by changing the value in “Type” (LOV)

7. Close the form

8. Return to the main menu