Skip to main content

How to unreserve the purchasing document in the same period in which the document originally got reserved?



As per the functionality, when an unreserve action is taken in a purchasing document, encumbrance reversal will happen in current GL period considering the system date. If you want the reversal to happen in the same period in which the document originally got reserved, you can use the check box "Use Document GL Date to Unreserve" so that the reversal will happen based on GL date entered in PR/PO distributions. 

 

This check box would be available only when doing Unreserve/Cancel/Final close where you can manually enable it and get the encumbrance reversal in the same period in which it got created.
But if you perform a Reject action on the PO or Return the PR or delete the lines which are in Incomplete,Reserved status, this check box will not be available. In such cases, you may need to set the profile option “PO:Use Document GL to Unreserve” to Yes so that the encumbrance reversal will happen automatically in the same period in which it got created.

Note: 
This unreserve action or the encumbrance reversal will happen based on the GL date of purchasing documents only when that past PO period and past GL period is in Open status. If that PO/GL period is already closed, then the reversal would happen only in the current period based on system date in-spite of this profile option being set to Yes. 

But if the profile option “PO:Validate GL period” is set to No, then the reversal would happen in that past period even if the GL period is closed provided the PO period is opened.

Comments

Post a Comment

Popular posts from this blog

SQL Query to extract Oracle Purchase Order Information

SELECT   poh.po_header_id,    poh.type_lookup_code PO_TYPE,   poh.authorization_status PO_STATUS,   poh.segment1 PO_NUMBER,   pov.vendor_name SUPPLIER_NAME,   povs.vendor_site_code Location,   hrls.location_code Ship_To,   hrlb.location_code Bill_to,   pol.line_num ,   msib.segment1 Item,   pol.unit_price,   pol.quantity,   pod.amount_billed Amount,   pod.destination_subinventory,   ppf.full_name Buyer_Name,   poh.closed_Code  FROM   PO_HEADERS_ALL poh,   PO_LINES_ALL pol,   mtl_system_items_b msib,   PO_LINE_LOCATIONS_ALL poll,   PO_DISTRIBUTIONS_ALL pod,   po_vendors pov,   po_vendor_sites_All povs,   hr_locations_all hrls,   hr_locations_all hrlb,   per_all_people_f ppf,   po_line_types polt WHERE   1                         =1 AND polt.line...
Post a Comment
Read more

Query to find Operating Unit, Business Group and Legal Entity Information

SELECT   DISTINCT   hrl . country ,                  hroutl_bg . name              bg ,                  hroutl_bg . organization_id ,                  lep . legal_entity_id ,                  lep . name                    legal_entity ,                  hroutl_ou . name              ou_name ,               ...
Post a Comment
Read more

How To Enable / Disable Forms Personalization Option

Forms Personalization gives great flexibility to execute custom business logic without performing so much of technical work. To start forms personalization navigate to Help -> Diagnostics -> Custom Code -> Personalize But many time when we click on personalize it give below error  " Function is not available for this respnosibility. Change responsibilities or contact your System Administrator " To Enable access to forms personalization function we need to set below profile option.  -  Utilities:Diagnostics -> Yes / No It determines the diagnostics option is enabled for a user / responsibility or site, depending on the level profile option is set. Navigate to System Administrator -> Profile -> System Query for your user / responsibility for which you want to provide access. Set the value to 'Yes' , If you want allow access to forms personalization Since we change the profile option please change the respons...
Post a Comment
Read more