Hi All,
A Req, PO and receipts is created for $150.
However the amount billed is $125.
Now I would like to change the Receipt amount to $125 from $150 by returning $25 which is not allowing me to do that.
System is not recognizing the recipt or PO number.
Note: PO is finally closed.
Appreciate your early relpy.
Receipts Correction
-
- Posts: 74
- Joined: Tue Jul 10, 2007 10:02 am
- Location: India
-
- Posts: 4
- Joined: Fri Sep 07, 2007 10:06 am
- Location: United Kingdom
when the po is finally closed you cannot do anything with it. you should only finally close a po years after everything has been transacted.
I'll update this topic with a script on how to re-open a finally closed po but it is unsupported at oracle.
(do you match to receipt in invoicing?)
thanks
Tracy
I'll update this topic with a script on how to re-open a finally closed po but it is unsupported at oracle.
(do you match to receipt in invoicing?)
thanks
Tracy
-
- Posts: 4
- Joined: Fri Sep 07, 2007 10:06 am
- Location: United Kingdom
First create tables to back up po_headers_all, po_lines_all po_line_locations_all and po_distributions_all.
If you use inventory then you also need to update mtl_supply as well as the following:
If you don't have inventory installed then all you need to do is:
1) Log In to SQL*PLUS as the APPS user
sqlplus apps/pwd
2) Find PO_HEADER_ID:
select PO_HEADER_ID
from PO_HEADERS_ALL
where SEGMENT1 = '';
3) Update CLOSED_CODE from FINALLY CLOSED to CLOSED:
a)
update PO_HEADERS_ALL
set CLOSED_CODE = 'CLOSED'
where PO_HEADER_ID =
and CLOSED_CODE = 'FINALLY CLOSED';
commit;
b)
update PO_LINES_ALL
set CLOSED_CODE = 'CLOSED'
where PO_HEADER_ID =
and CLOSED_CODE = 'FINALLY CLOSED';
commit;
c)
update PO_LINE_LOCATIONS_ALL
set CLOSED_CODE = 'CLOSED'
where PO_HEADER_ID =
and CLOSED_CODE = 'FINALLY CLOSED';
commit;
d)
delete from PO_ACTION_HISTORY
where OBJECT_ID = &OBJECT_ID
---object_id is the po_header_id
and ACTION_CODE = 'FINALLY CLOSE';
commit;
4) Navigate to the Purchase Order Summary form. Query the PO.
On the toolbar, select Special > Control. Open the PO.
==============================================
Ive used this script without a problem.
remember review the note though if you have inventory fully installed you need to also update mtl_supply.
Once you have fixed the PO get the users to understand that finally closing a PO is not recommended until you're sure there will never be anything more to action on the PO. (we don't finally close ours for 3 years ..... )
can you let me know if this helped.
Tracy
If you use inventory then you also need to update mtl_supply as well as the following:
If you don't have inventory installed then all you need to do is:
1) Log In to SQL*PLUS as the APPS user
sqlplus apps/pwd
2) Find PO_HEADER_ID:
select PO_HEADER_ID
from PO_HEADERS_ALL
where SEGMENT1 = '';
3) Update CLOSED_CODE from FINALLY CLOSED to CLOSED:
a)
update PO_HEADERS_ALL
set CLOSED_CODE = 'CLOSED'
where PO_HEADER_ID =
and CLOSED_CODE = 'FINALLY CLOSED';
commit;
b)
update PO_LINES_ALL
set CLOSED_CODE = 'CLOSED'
where PO_HEADER_ID =
and CLOSED_CODE = 'FINALLY CLOSED';
commit;
c)
update PO_LINE_LOCATIONS_ALL
set CLOSED_CODE = 'CLOSED'
where PO_HEADER_ID =
and CLOSED_CODE = 'FINALLY CLOSED';
commit;
d)
delete from PO_ACTION_HISTORY
where OBJECT_ID = &OBJECT_ID
---object_id is the po_header_id
and ACTION_CODE = 'FINALLY CLOSE';
commit;
4) Navigate to the Purchase Order Summary form. Query the PO.
On the toolbar, select Special > Control. Open the PO.
==============================================
Ive used this script without a problem.
remember review the note though if you have inventory fully installed you need to also update mtl_supply.
Once you have fixed the PO get the users to understand that finally closing a PO is not recommended until you're sure there will never be anything more to action on the PO. (we don't finally close ours for 3 years ..... )
can you let me know if this helped.
Tracy
Who is online
Users browsing this forum: Ahrefs [Bot], Google [Bot] and 4 guests