| Oracle 10.7 - Receivables Adjustment issue [message #443438] |
Mon, 15 February 2010 15:14 |
simran_bhasin
Messages: 1
Registered: February 2010
|
Junior Member |
|
|
Hello champs...i am in real trouble.
Require help from you guys in Oracle Receivables - Adjustments issue. I am very new to this application, so may not know all the things (or all the things).
I have oracle 10.7 financial application, where user wanted to make an adjustment in receiveables. But somehow the user entered wrong and too many adjustments. Right now there is one pending adjustment is there for amount: 7,410,012.
Here is the output of (Attached: Tbl_structure):
select * from AR_ADJUSTMENTS_ALL
where adjustment_id in
('39559','39560','39599','39600','39943','39944','39945','39946')
order by 1 ;
I made some changes in 1 record and that was :
update ar_adjustments_all
set GL_DATE = SYSDATE --o ld Value 11-Dec-2009 (11-dec-2009 00:00:00)
, STATUS = 'W' -- old Value A
, POSTABLE = 'Y' -- old Value N
where adjustment_id = '39600';
Right now, status is (attached jpg file).
Need your help to adjust the pending adjustments.
Thanks for the help.
Let me know incase you need more information from my side.
Regards,
SP Singh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
