Dear All,
Kindly find the document to have an breif about Oracle Inventory in R-12.
Click Me - R-12 Oracle Inventory Overview
Thanks & Regards,
S.Grace Paul Regan.
Tuesday, March 4, 2008
Monday, March 3, 2008
Receiving: Returns and Corrections
Q1. Is it possible to perform Returns for Internal Shipments (Inter-Org and Internal Order)?
A: No, it is not possible to perform Returns on Internal Shipments. You need to reverse the original process if you want to return an internally ordered item. You have to create an internal requisition for the item in the source organization, and then process that order back to the source organization.
Q2. Is it possible to perform Returns/Corrections for RMAs?
A:The Returns/Corrections for RMAs that are delivered to Inventory is not supported if the customer has file poxrcv.odf version higher than or equal to 115.52.
Q3. Can I return/correct a cancelled PO line or shipment to a vendor?
A: It is not possible to return/correct a cancelled PO line or shipment.
As a workaround the following can be performed:
For Inventory Item:
Enter a 'Miscellaneous Issue' in Inventory Module against this Item. This will correct the quantity in inventory.
For expense item:
Enter adjustment directly in GL, or credit memo to cancel accruals.
Please note: The Cancel Action (and Final Close) in the PO Summary form is an irreversible action. A warning message is displayed indicating no futher transaction activity will be allowed if the Cancel action is selected. The warning message provides an opportunity for the User not to continue with the Cancel. Oracle development does not support any datafixes on cancellation and finally closed (user actions) since there are double verifications done while proceeding on this action.
Q4. Can I change the line status of PO to "Closed for Receiving" and then query the PO in Returns/Corrections Form to correct them?
A: The customer should NEVER change the status of the cancelled/finally-closed line without development's consent via a bug.
Oracle Development may not provide a datafix for explicitly cancelled lines because of "user errors".
Q5. I cannot do returns/adjustments for an un-ordered receipt. Why?
A: Adjustments and/or returns to vendor on unordered receipts can only be done after the receipt has been matched to a Purchase Order. Verify this has been done.
Q6. Can Returns/Corrections be performed when the deliver_to person is not active?
A: Returns/Corrections are not allowed if the deliver to person is not active. You have to re-activate the employee to perform returns/corrections.
Q7. I am not able to return an item under serial control. What should I do?
A: Check whether the Serial Number is available in the subinventory and organization.
Thanks & Regards,
S.Grace Paul Regan
A: No, it is not possible to perform Returns on Internal Shipments. You need to reverse the original process if you want to return an internally ordered item. You have to create an internal requisition for the item in the source organization, and then process that order back to the source organization.
Q2. Is it possible to perform Returns/Corrections for RMAs?
A:The Returns/Corrections for RMAs that are delivered to Inventory is not supported if the customer has file poxrcv.odf version higher than or equal to 115.52.
Q3. Can I return/correct a cancelled PO line or shipment to a vendor?
A: It is not possible to return/correct a cancelled PO line or shipment.
As a workaround the following can be performed:
For Inventory Item:
Enter a 'Miscellaneous Issue' in Inventory Module against this Item. This will correct the quantity in inventory.
For expense item:
Enter adjustment directly in GL, or credit memo to cancel accruals.
Please note: The Cancel Action (and Final Close) in the PO Summary form is an irreversible action. A warning message is displayed indicating no futher transaction activity will be allowed if the Cancel action is selected. The warning message provides an opportunity for the User not to continue with the Cancel. Oracle development does not support any datafixes on cancellation and finally closed (user actions) since there are double verifications done while proceeding on this action.
Q4. Can I change the line status of PO to "Closed for Receiving" and then query the PO in Returns/Corrections Form to correct them?
A: The customer should NEVER change the status of the cancelled/finally-closed line without development's consent via a bug.
Oracle Development may not provide a datafix for explicitly cancelled lines because of "user errors".
Q5. I cannot do returns/adjustments for an un-ordered receipt. Why?
A: Adjustments and/or returns to vendor on unordered receipts can only be done after the receipt has been matched to a Purchase Order. Verify this has been done.
Q6. Can Returns/Corrections be performed when the deliver_to person is not active?
A: Returns/Corrections are not allowed if the deliver to person is not active. You have to re-activate the employee to perform returns/corrections.
Q7. I am not able to return an item under serial control. What should I do?
A: Check whether the Serial Number is available in the subinventory and organization.
Thanks & Regards,
S.Grace Paul Regan
Sunday, March 2, 2008
How do users delete the receipts made in error?
Users cannot delete a receipt once it is made, however users can perform either a
'Correction' or a 'Return' to the receipt dependant upon the nature of the error
made when performing the receipt:
Return To Vendor - This is typically done if you do not want the shipment received
from the vendor (for example, vendor over-shipped, or items received were damaged
or wrong color, or you just don't want to receive that shipment at this time). You can return
the shipment for the full amount.
Correction - This is typically done when you wish to correct an error made when receiving
a shipment (for example, you physically received 9 but put down that you received 10).
Both methods above ensure that correct accounting adjustments are made when performing
either a return or a correction.
Thanks & Regards,
S.Grace Paul Regan
'Correction' or a 'Return' to the receipt dependant upon the nature of the error
made when performing the receipt:
Return To Vendor - This is typically done if you do not want the shipment received
from the vendor (for example, vendor over-shipped, or items received were damaged
or wrong color, or you just don't want to receive that shipment at this time). You can return
the shipment for the full amount.
Correction - This is typically done when you wish to correct an error made when receiving
a shipment (for example, you physically received 9 but put down that you received 10).
Both methods above ensure that correct accounting adjustments are made when performing
either a return or a correction.
Thanks & Regards,
S.Grace Paul Regan
Thursday, January 3, 2008
Closing Inventory Period
Oracle Inventory uses accounting periods to group material transactions and work in process transactions for accounting purposes. So normally these deatils are grouped for a month and the transaction details are posted to GL.
An automatic general ledger transfer is processed when you close an accounting period.
1. Material Transaction
=======================
The Material Transaction includes miscellaneous issue, sales order issue, or cycle count adjustment.
2. WIP Transaction
==================
Resource transaction Lists resource transaction details.
Overhead transaction Lists overhead transaction details.
Outside processing Lists outside processing transaction details.
Cost update Lists cost update transaction details.
Period close variance Lists transaction details for period close variance transactions for expense jobs and certain instances of repetitive schedules.
Job close variance Lists job close variance transaction details.
Closing a Period
================
You can close the earliest accounting period with a status of Open or Error.
Before you close a Inventory period make sure you have noticed all the pending transactions that is showing for the particular accounting period that you have chosen to close, to find the pending transactions (navigation)
1.Inventory Superuser > Accounting Close Cycle > Inventory Accounting Period >
Pressing the pending button in the bottom left corner of the screen !
2. After Choose the Pending button. The Pending Transactions window appears
Resolution Required: Displays the number of unprocessed material transactions,
uncosted material transactions, and pending WIP costing transactions existing in
this period. These must be resolved before the period is closed.
Resolution Recommended: Displays the number of pending receiving transactions,
pending material transactions, and pending shop floor move transactions existing
in this period. You can close the accounting period, however, after it is closed
these transactions cannot be processed.
See
Unprocessed Transaction Messages
One of the following messages appear if there are unprocessed transactions:
Pending receiving transactions for this period
When you use Purchasing, this message indicates you have unprocessed purchasing transactions in the RCV_TRANSACTIONS_ INTERFACE table. These transactions include purchase order receipts and returns for inventory. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your receiving value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Unprocessed material transactions exist for this period
This message indicates you have unprocessed material transactions in the MTL_MATERIAL_TRANSACTIONS_TEMP table. You are unable to close the period with this condition. Please see your system administrator. Inventory considers entries in this table as part of the quantity movement.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
Pending material transactions for this period
This message indicates you have unprocessed material transactions in the MTL_TRANSACTIONS_INTERFACE table. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your inventory value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Uncosted material transactions exist for this period
This message indicates you have material transactions in the MTL_MATERIAL_TRANSACTIONS table with no accounting entries (Standard Costing) and no accounting entries and no costs (Average Costing). You are unable to close the period with this condition. These transactions are part of your inventory value.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
Pending move transactions for this period
This message indicates you have unprocessed shop floor move transactions in the WIP_MOVE_TXN_INTERFACE table. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your work in process value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Pending WIP costing transactions exist in this period
This message indicates you have unprocessed resource and overhead accounting transactions in the WIP_COST_TXN_INTERFACE table. You are unable to close the period with this condition. These transactions are in your work in process value, and awaiting further processing.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
After you have checked all the pending transactions and after clearing all the mandatory pending transactions and again once again check for any pending transactions, Once you are sure that you are ready to close the inventory period you can come back to the main inventory accounting periods page in the right end corner press the change status button in the pop up window select Close and be sure that INVENTORY PERIOD CLOSED CANNOT BE REOPENED (This is a irreversable process), Take extra care while closing inventory period.
Thanks & Regards,
S.Grace Paul Regan.
An automatic general ledger transfer is processed when you close an accounting period.
1. Material Transaction
=======================
The Material Transaction includes miscellaneous issue, sales order issue, or cycle count adjustment.
2. WIP Transaction
==================
Resource transaction Lists resource transaction details.
Overhead transaction Lists overhead transaction details.
Outside processing Lists outside processing transaction details.
Cost update Lists cost update transaction details.
Period close variance Lists transaction details for period close variance transactions for expense jobs and certain instances of repetitive schedules.
Job close variance Lists job close variance transaction details.
Closing a Period
================
You can close the earliest accounting period with a status of Open or Error.
Before you close a Inventory period make sure you have noticed all the pending transactions that is showing for the particular accounting period that you have chosen to close, to find the pending transactions (navigation)
1.Inventory Superuser > Accounting Close Cycle > Inventory Accounting Period >
Pressing the pending button in the bottom left corner of the screen !
2. After Choose the Pending button. The Pending Transactions window appears
Resolution Required: Displays the number of unprocessed material transactions,
uncosted material transactions, and pending WIP costing transactions existing in
this period. These must be resolved before the period is closed.
Resolution Recommended: Displays the number of pending receiving transactions,
pending material transactions, and pending shop floor move transactions existing
in this period. You can close the accounting period, however, after it is closed
these transactions cannot be processed.
See
Unprocessed Transaction Messages
One of the following messages appear if there are unprocessed transactions:
Pending receiving transactions for this period
When you use Purchasing, this message indicates you have unprocessed purchasing transactions in the RCV_TRANSACTIONS_ INTERFACE table. These transactions include purchase order receipts and returns for inventory. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your receiving value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Unprocessed material transactions exist for this period
This message indicates you have unprocessed material transactions in the MTL_MATERIAL_TRANSACTIONS_TEMP table. You are unable to close the period with this condition. Please see your system administrator. Inventory considers entries in this table as part of the quantity movement.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
Pending material transactions for this period
This message indicates you have unprocessed material transactions in the MTL_TRANSACTIONS_INTERFACE table. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your inventory value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Uncosted material transactions exist for this period
This message indicates you have material transactions in the MTL_MATERIAL_TRANSACTIONS table with no accounting entries (Standard Costing) and no accounting entries and no costs (Average Costing). You are unable to close the period with this condition. These transactions are part of your inventory value.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
Pending move transactions for this period
This message indicates you have unprocessed shop floor move transactions in the WIP_MOVE_TXN_INTERFACE table. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your work in process value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Pending WIP costing transactions exist in this period
This message indicates you have unprocessed resource and overhead accounting transactions in the WIP_COST_TXN_INTERFACE table. You are unable to close the period with this condition. These transactions are in your work in process value, and awaiting further processing.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
After you have checked all the pending transactions and after clearing all the mandatory pending transactions and again once again check for any pending transactions, Once you are sure that you are ready to close the inventory period you can come back to the main inventory accounting periods page in the right end corner press the change status button in the pop up window select Close and be sure that INVENTORY PERIOD CLOSED CANNOT BE REOPENED (This is a irreversable process), Take extra care while closing inventory period.
Thanks & Regards,
S.Grace Paul Regan.
Subscribe to:
Posts (Atom)