Monday, March 31, 2014

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

clip_image002

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.

clip_image004

clip_image006

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

Field

Value

Activity Name

Write-Off

Type

Invoice

Amount

-100

9. Click OK (B)

clip_image008

clip_image010

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

clip_image012

clip_image014

18. Change Status from Waiting Approval to Approved.

- Status = Approved

clip_image016

19. Click (I) Save.

20. Click (B) Action History.

21. Note the Action History.

clip_image018

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

clip_image020

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

clip_image022

32. Click (B) View Output.

clip_image024

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)

clip_image002

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

5. click on save (B)

clip_image004

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

clip_image006

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

clip_image008

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

clip_image012

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

11. Check the outstanding balance In below screen

clip_image015

12. Create accounting by navigating tools > Create accounting field

13. Select your option of accounting and click OK

clip_image017

14. View accounting by navigating Tools > View Accounting

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

clip_image019

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

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

clip_image021

17. Invoice number selected to raise the Credit memo

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

clip_image023

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

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

clip_image025

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

22. Balance got “Zero”

23. Click save (B)

clip_image029

24. Click “Complete” (B)

25. Now credit memo applied and completed.

clip_image032

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)

clip_image034

29. view accounting from Tools > View Accounting

30. In this screen the accounts get reversed

clip_image037

31. Query the Invoice using invoice number

clip_image039

32. Enter the invoice number and click find button

clip_image042

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

34. Check below screen the balance has been get cleared

clip_image046

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

clip_image049

Sunday, March 30, 2014

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

clip_image002

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.

clip_image004

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.

clip_image006

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)

clip_image008

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)

clip_image010

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

clip_image012

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)

clip_image014

16. Data has been saved successfully

clip_image016

Remit – to Address has been created successfully

Saturday, March 29, 2014

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:-

clip_image001 Adjustment

clip_image001[1] Bank Error

clip_image001[2] Claim Investigation

clip_image001[3] Credit Card Chargeback

clip_image001[4] Credit Card Refund

clip_image001[5] Earned Discount

clip_image001[6] Endorsements

clip_image001[7] Late Charges

clip_image001[8] Miscellaneous Cash

clip_image001[9] Payment Netting

clip_image001[10] Prepayments

clip_image001[11] Receipt Write-off

clip_image001[12] Refund

clip_image001[13] Short Term Debt

clip_image001[14] 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:

clip_image003

4. Click on Save (B)

5. Close the form

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

clip_image005

7. Close the form

8. Return to the main menu