Billing plan date of SO to be considered as a exchange rate date .

[Former Member]

Hi Everyone,

There is one customer requirement in one of the ongoing project. Scenario is, Sales order is created with a periodic billing plan and then SO line item is account assigned to billing WBSE. Project/WBSE is set up INR which is also the controlling area currency whereas Sales order currency is USD. Exchange rates from USD to INR are maintained as per the billing plan dates. In PS revenue plan should update automatically from SO billing plan, required setting are done in PS. Now the requirement is While updating the plan revenue from SO to WBSE system should consider the billing plan dates for currency conversion. What I have found out is system considers the pricing date maintained in sales order to pick exchange rate whereas we want system to consider billing date maintained in billing plan for currency conversion .

Please advice .

Thanks,

Akhil

[former_member183879]

Hi Akhil,

As per std SAP, pricing and exchange rate will be determined only based on the pricing date and not on any other date.

If you really want a change here, you should change the pricing date value to be the billing date.

Remember that the exchange rate can have only one value for a document. If your expectation is to have multiple exchange rates, because you have different billing dates in different billing plan items, it is not possible in sales order. This is because the exchange rate is stored in VBAK table and there is only one field available for this. This is irrespective of any date except pricing date which is also coded within SAP.

However in billing, if you use different billing documents for each period, you can use the facility of copy control as already mentioned to propose new exchange rate based on the billing date.

[sanjeevc]

Hello,

let me know how you have done invoice type parameter?

pricing exhange rate type is there in VTFA invoice header and item data so mark those then try in development system.

this is SD related so better to post in SD forum to get better answer

Regards,
Sanjeev

[sunil_yadav2]

Hi Akhil,

Please check your copy control TCODE- VTFA

Choose Pricing exchange rate type as C - Exchange rate determination according to billing date.

hope this helps you.

Moderator: i think this thread should be in Sales and Distribution. Please check.

thanks

Sunil

[Former Member]

Hi Sunil,

Thanks for replying. But, the this  copy control setting works at the time of invoicing whereas the need is to have exchange rate available based on the billing date of billing plan at the time of creation of billing plan so that plan revenue can be updated accordingly.

Regards,

Akhil Rathi