Monday, May 23, 2011

Viewing Invoices (Sales Order (Actions-->Additional Order Infomation-->Invoices/Credit Memo tab)

The visibility for intercompany invoice in Sales Order Screen (ActionsàAdditional Order Info) is available for only Internal Sales order. For Regular Sales Order when shipping (US) and selling (ES) organization are different legal entities (different OU) the intercompany invoices did created but it displays only Customer invoice in Sales Order Screen (ActionsàAdditional Order Info) not intercompany invoices. Inter-Company AP invoice will be visible in the payables and the Inter-company AR Invoice will be visible in the Receivables responsibility respectively.

According to oracle, we can view intercompany invoices for internal sales orders on the sales orders window (Actions > View Additional Line/Order Info > Invoices / Credit Memos) by setting profile option OM: View Intercompany AR Invoices profile option: Yes.

But it’s not possible to view the intercompany invoices for regular sales order.
 

Price is not getting derived from secondary pricelist with qualifier enabled when we use Pricing agreement in sales Order from

Price is not getting derived from secondary pricelist with qualifier enabled when we use Pricing agreement in sales Order from.
If we are not using Qulifer on price list ,Price is not getting derived as expected

Here is the scenario
1. The Pricelist is created with name “Primary_Pricelist1” and pricing agreement is created with Standard Pricelist “Primary_Pricelist1”with name of “Pricing_Agreement1”
2.The Pricelist “Secondary_Pricelist2”is created with Qualifier “Customer name” and attached as Secondary Pricelist in “Primary_Pricelist1”
I have created Sales Order with pricelist “Primary_Pricelist1” and Price is getting derived from the secondary pricelist and works as expected
When I created Sales Order with pricelist “Primary_Pricelist1” and agreement “Pricing_Agreement1” the Price is not getting derived from the secondary pricelist

Answer :
As per the Pricing functionality, qualifiers will NOT be evaluated when a
Pricing Agreement is attached to a Sales Order.
Setting the profile QP: Qualify Secondary Price Lists to Y and using a
Pricing Agreement is an ambiguous statement.
Whenever an Agreement is attached to a Sales Order, Pricing has to honor the
Price List attached to the Agreement. Hence the qualifier evaluation is never
done.
Hence it is always recommended that the customer should set the profile QP:
Qualify Secondary Price Lists to N when using Pricing Agreements.

As a workaround the customer can use the qualifier on the secondary price
list as a Pricing Attribute instead of a Qualifier.Limitation here is that
qualifier grouping functionality cannot be achieved. But in this case too the
above mentioned profile should be set to N.

When IR-ISO Created or when internal requistion and Internal Sales order is required

Same LE, Same OU, 2 Inv Orgs:
Sub-inventory transfer/Inter-Org transfer should be sufficient (though you can still create IR-ISO provided the pre-requisite setups are done in Shippng Networks (Invnetory super user -->Set up -->Organzation -->Shipping networks and Internal order Flag is enabled )

Same LE, Different OU, 2 Inv Orgs:
Sub-inventory transfer/Inter-Org transfer should be sufficient (though you can still create IR-ISO provided the pre-requisite setups are done in Shippng Networks (Invnetory super user -->Set up -->Organzation -->Shipping networks and Internal order Flag is enabled )

Different LE (OU and Inv Orgs will always be different):
IR-ISO has to be created since goods have to be sent out of the country.

Pre-requisites for IR-ISO:
  1. Internal Orders attribute at item setup
  2. Internal Orders attribute at Shipping networks setup
  3. Purchasing Options setup (what will be the ISO order type)
  4. Inter-company transaction setup

Note: Transfer Type, FOB and other setups in Shipping Network should not affect IR-ISO creation as long as the above pre-requisites are taken care.

the functionality behind the End Customer field in the Sales Order Screen.

This functionality addresses the following: 

The Businesses want to know the end customer for an order line for a number of reasons, for example who is entitled to product support? Who is entitled to sales credits? Who is the user of sold items? 
   
If the end customer is specified when taking the order, it is possible for the system to automatically populate Install Base with the correct end customer, streamlining the integration of Order Management and Install Base. 

     If a business uses Service Contracts, you can create one Service Contract from the sales order. This feature is useful if the Sold To customer / Partner own the Service Contract for multiple end customers. (You cannot create multiple Service Contracts for multiple End Customers on a single sales order.) 

If using Partner Order Processing, it is typical for a partner to sell to a number of End Customers. You can consolidate sales to multiple end customers on a single order. 

This functionality is appropriate for those who: 

a.       Use Install Base for product support
b.      Use Service Contracts for support contracts 
c.       Want a better understanding of the sales channels used in their marketplace, i.e. who are the customers of Partners and for the End Customers 
d.      Split sales commissions between partners and End Customers 

Thursday, May 19, 2011

Difference Between Sales Order and Internal Sales Order in OM


Regular Sales Order
Internal Sales Order
Customer type is External
Customer Type is Internal

Map the customer address to an internal receiving organization(Customer Association)

Define intercompany relations between the selling and shipping operating units
1.Shipping Networks need to be defined (Inventory super user àSet upàOrganization àShipping networks)
2.Intercompany flows need to be defined( Inventory super user àSet upàOrganization à Intercompany flows)

The flowing profile option enabled
• INV: Intercompany Currency Conversion
• INV: Inter-company Invoice for Internal Orders
• INV: Advanced Pricing for Inter-company Invoice
• TAX: Allow Override of Tax Code
• Tax: Invoice Freight as Revenue
• Tax: Inventory Item for Freight
• MO: Operating Unit
Set this profile option to the appropriate operating unit for each responsibility.

The following Inventory item Attribute should be enabled
Customer Ordered
• Customer Order Enabled
• Internal Ordered
• Internal Order Enabled
• Invoiceable Item
• Invoice Enabled
• Cost Enabled
• Stockable
• Transactable
• Inventory Item
Customer Invoice is created
Intercompany invoice is created if Receiving and Shipping Organization different legal entities

• Define Oracle Receivables system options
• Define Oracle Payables system options
• Define tax structures in Oracle Payables and Oracle Receivables
• Set up the Account Generator for the Cost of Goods Sold accounts