Monday, March 31, 2014

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