Hi

[ramyapriyacsit]

Hi ,

I would like to close a PO created from Scheduled Order,
The Scheduled Order was already de activated with End Effective date for that Line # and Item #.

But, In PO maintanance screen am unable to edit the status field .
How can i close it pls help asap.Thanks.

 

[Kishor Chari]

for each po_mstr where po_nbr = po_nbr exclusive ,
each pod_det where pod_nbr = po_nbr and pod_part = item
exclusive:

Assign
po_stat = 'C'
pod_stat = 'C'.

end.

 

[ramyapriyacsit]

Nope, we dont have access to the back end for querying and for updations.

It needs to be done from front end screens of standard MFG/Pro in Live servers.
Is there any other option ?

Pl reply soon.....Thanks.

 

[Kishor Chari]

If its de activated then whats the reason to change status.?
Are you getting any error.

 

[ramyapriyacsit]

There is PO already created with this De activated Sch order.
Now the user it still able to recieve item with that PO.
my program logic checks for PO close status for receipts.
So i would like to close that particular PO created from Sch order, which should be no longer accessible by anyone.

 

[ramyapriyacsit]

There is PO already created with this De activated Sch order.
Now the user it still able to recieve item with that PO.
my program logic checks for PO close status for receipts.
So i would like to close that particular PO created from Sch order, which should be no longer accessible by anyone.

 

[Kishor Chari]

Crooked Method, do a receipt of the PO in full & then do PO return .

This will mess up supplier performance if you are using it. Plus let a/c know of it that they need to match both the GRN to match it off.

 

[ramyapriyacsit]

Thanks Kishore, i would instruct the same to them,
thanks for quick replies.