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

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...

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 , ...

Oracle Purchasing – Receipt Accounting

Oracle Purchasing – Receipt Accounting (Accrue On Receipt and Accrue at Period End) Inventory Accruals: Inventory and Purchasing provides visibility and control of accrued liabilities for inventory items. Purchasing automatically records the accrued liability for the inventory items at the time of receipt. This transaction is automatically recorded in the general ledger at the time of receipt. The inventory expense is recorded at delivery if Standard Delivery is used and at receipt if Direct Delivery used. Expense Accruals: Purchasing optionally accrues un-invoiced receipts of non-inventory items when a period is closed. Purchasing automatically creates a balanced journal entry for each receipt un-invoiced at period end which can be reversed at the beginning of the next period. Navigation: India Local Purchasing > Oracle Purchasing > Setup > Organizations > Purchasing Options Difference between 'Accrue On Receipt' and 'Accrue at Per...

Sreekanth Reddy Pothula's Oracle ERP Blog

Search This Blog