Capture Expenditure Information in Project Costing for Sales Returns
You can capture expenditure information in Project Costing for sales returns. You will continue to bill your customers from Oracle Project Management. The RMA Receipt transactions are processed and accounted in Costing. The costs are then interfaced to Oracle Project Portfolio Management (PPM).
Sales returns can be referenced RMA or unreferenced RMA. Referenced RMA is costed using the original sales order issue cost. Unreferenced RMA is costed based on the value set for the Unreferenced RMA Receipt Cost option set in the cost profile associated with the item cost profile.
Original Sales Order Shipments from Common Inventory
Let's see how the sales returns into a project striped inventory are accounted where the original shipments are from a common inventory.
In the case of an intracompany shipment (the shipping organization and the selling organization are same), these accounting distributions are created for RMA Receipt.
Event Type |
Account Line Type |
Transaction Type |
Project Expenditure |
---|---|---|---|
RMA Receipt |
Inventory |
Debit |
No |
RMA Receipt |
Project Clearing |
Credit |
No |
In the case of an intercompany shipment (the shipping organization and the selling organization are different), these accounting distributions are created for RMA Receipt.
Event Type |
Organization |
Account Line Type |
Transaction Type |
Project Expenditure |
---|---|---|---|---|
RMA Receipt |
Original Shipping Organization |
Inventory |
Debit |
No (positive) |
RMA Receipt |
Original Shipping Organization |
Trade In Transit |
Credit |
No |
Trade Sales Return |
Original Selling Organization |
Trade In Transit |
Debit |
Yes |
Trade Sales Return |
Original Selling Organization |
Project Clearing |
Credit |
Yes (negative) |
However, in both cases, overheads on the RMA Receipt event and the Trade Sales Return event are sent as additional cost to PPM.
If the costs aren't interfaced to PPM, then these accounting distribution are created for RMA Receipt from intracompany shipment.
Event Type |
Account Line Type |
Transaction Type |
---|---|---|
RMA Receipt |
Inventory |
Debit |
RMA Receipt |
Deferred RMA Gain/Loss |
Credit |
If the costs aren't interfaced to PPM, then these accounting distribution are created for RMA Receipt from intercompany shipment.
Event Type |
Organization |
Account Line Type |
Transaction Type |
---|---|---|---|
RMA Receipt |
Original Shipping Organization |
Inventory |
Debit |
RMA Receipt |
Original Shipping Organization |
Trade In Transit |
Credit |
Trade Sales Return |
Original Selling Organization |
Trade In Transit |
Debit |
Trade Sales Return |
Original Selling Organization |
Deferred RMA Gain/Loss |
Credit |
Also, in both cases, overheads aren't sent to PPM.
Original Sales Order Shipments from Project Inventory
Let's see how the sales returns into a project striped inventory are accounted where the original shipments are from a project inventory.
In the case of an intracompany shipment, these accounting distributions are created for RMA Receipt.
Event Type |
Account Line Type |
Transaction Type |
Project Expenditure |
---|---|---|---|
RMA Receipt |
Inventory |
Debit |
No |
RMA Receipt |
Project Clearing |
Credit |
No |
In the case of an intercompany shipment, these accounting distributions are created for RMA Receipt.
Event Type |
Organization |
Account Line Type |
Transaction Type |
Project Expenditure |
---|---|---|---|---|
RMA Receipt |
Original Shipping Organization |
Inventory |
Debit |
Yes (positive) |
RMA Receipt |
Original Shipping Organization |
Trade In Transit |
Credit |
Yes |
Trade Sales Return |
Original Selling Organization |
Trade In Transit |
Debit |
Yes |
Trade Sales Return |
Original Selling Organization |
Project Clearing |
Credit |
Yes (negative) |
However, in both cases, overheads on the RMA Receipt event and the Trade Sales Return event are sent as additional cost to PPM.
If the costs aren't interfaced to PPM, then these accounting distribution are created for RMA Receipt from intracompany shipment.
Event Type |
Account Line Type |
Transaction Type |
---|---|---|
RMA Receipt |
Inventory |
Debit |
RMA Receipt |
Deferred RMA Gain/Loss |
Credit |
If the costs aren't interfaced to PPM, then these accounting distribution are created for RMA Receipt from intercompany shipment.
Event Type |
Organization |
Account Line Type |
Transaction Type |
---|---|---|---|
RMA Receipt |
Original Shipping Organization |
Inventory |
Debit |
RMA Receipt |
Original Shipping Organization |
Trade In Transit |
Credit |
Trade Sales Return |
Original Selling Organization |
Trade In Transit |
Debit |
Trade Sales Return |
Original Selling Organization |
Deferred RMA Gain/Loss |
Credit |
Also, in both cases, overheads aren't sent to PPM.
Sales Return of Drop Ship Sales Order
In the case of drop ship, we can have two scenarios, one where the customer-facing organization and supplier-facing organization are same and another where they're different.
These accounting distributions are created in the case of a sales return into a project striped inventory where the customer-facing organization and supplier-facing organization are same.
Event Type |
Account Line Type |
Transaction Type |
Project Expenditure |
---|---|---|---|
RMA Receipt |
Inventory |
Debit |
No |
RMA Receipt |
Project Clearing |
Credit |
No |
In the case where the customer-facing organization and supplier-facing organization are different these accounting distributions are created for a sales return into a project striped inventory.
Event Type |
Organization |
Account Line Type |
Transaction Type |
Project Expenditure |
---|---|---|---|---|
RMA Receipt |
Original Shipping Organization |
Inventory |
Debit |
Yes (positive) |
RMA Receipt |
Original Shipping Organization |
Trade In Transit |
Credit |
Yes |
Trade Sales Return |
Original Selling Organization |
Trade In Transit |
Debit |
Yes |
Trade Sales Return |
Original Selling Organization |
Project Clearing |
Credit |
Yes (negative) |
However, in both cases, overheads on the RMA Receipt event and the Trade Sales Return event are sent as additional cost to PPM.
If the costs aren't interfaced to PPM, then these accounting distribution are created when the customer-facing organization and supplier-facing organization are same.
Event Type |
Account Line Type |
Transaction Type |
---|---|---|
RMA Receipt |
Inventory |
Debit |
RMA Receipt |
Deferred RMA Gain/Loss |
Credit |
If the costs aren't interfaced to PPM, then these accounting distribution are created when the organizations are different.
Event Type |
Organization |
Account Line Type |
Transaction Type |
---|---|---|---|
RMA Receipt |
Original Shipping Organization |
Inventory |
Debit |
RMA Receipt |
Original Shipping Organization |
Trade In Transit |
Credit |
Trade Sales Return |
Original Selling Organization |
Trade In Transit |
Debit |
Trade Sales Return |
Original Selling Organization |
Deferred RMA Gain/Loss |
Credit |
Also, in both cases, overheads aren't sent to PPM.
Sales Returns not Interfaced to PPM
Sales returns aren't interfaced to PPM for the cases listed here:
-
Sales returns are received into a common inventory instead of a project striped inventory. These returns aren't considered as part of the project and, therefore, not interfaced to PPM.
-
Sales returns are received into an organization that's different from the original shipping organization and the receiving organization isn't PDSC enabled.
-
Sales returns are received into an organization that's different from the original shipping organization and the project isn't valid in the receiving organization.