an error attempt has been made to enter a null value in to a column that require a data please correct to ensure that only valid values are entered for the column

Error:

an error attempt has been made to enter a null value in to a column that require a data please correct to ensure that only valid values are entered for the column

Solutions:

Please Validate the receipt class definition in bank account tab bank charge account is defined properly.

Responsibility:  Receivables
Navigation:  Setup > Receipts > Classes

1. Query Receipt Class used in Receipt creation
2. Check for the Payment Method
3.  Go to Bank Accounts > Account should be defined for bank charges

How to Void Transactions in Receivables

Overview:

Receivables lets you make a debit memo, credit memo, on-account credit, invoice, or chargeback invalid by updating the transaction type.

You can void a transaction only if the following are true:

· it does not have any activity against it

· it has not been processed by the Revenue Recognition program

· it has not been posted to your general ledger

1. Login oracle application Home page

Define a Transaction Type

2. Navigate to Transaction Type window

(N): Setup> Transaction > Transaction Type

3. Enter the following information

Field	Value
Name	Void
Class	Invoice
Transaction Status	Void
Creation Sign	Any sign
Printing Option	Print
Receivables Account	01-000-1210-0000-000
Revenue Account	01-420-4110-0000-000

Note:

Set Open Receivables to ‘No’

To void a transaction

4. Navigate to Transaction Summary window

(N): Transaction > Transaction Summary

5. Query the transaction which you want to ‘void’

6. Find by entering Transaction Number and ship to address

7. Click open (B)

8. Select the Transaction type as ‘Void’

9. Click yes in decision popup window

10. Select payment term

11. Click Save (B)

12. Click complete (B)

13. Close the form

14. Return to the main page

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.