Changing condition base value in billing.

[Former Member]

Hello everyone,

In sales order,for certain condition types, when document currency is different from condition currency, system would apply exchange rate. For example if base value is 100USD, then condition value will be 122CAD. ( system would have applied exchange rate of 1.22)

In the billing document system converts the 122CAD to per quantity amount and carries this to base value. for example in sales order if 10 qty costs 100 USD, in biling document the base value is 12.2CAD.

I am wondering why it copies 122 CAD or 12.2 CAD, instead of 100USD.

Now, since both base and document value is in CAD, no exchange rate is applied at the time of billing. If system had copied USD value as such from order, there wuldn't be a probelm.

Our exchange rates are dynamic and hence we want to calculate the exchange rate at billing time. How to proceed?

Thanks in advacne,

[claudia_neudeck]

no action over 2 months

[former_member204513]

Dear Swapna,

Try with this option to calculate the exchange rate at billing time

Go to VTFL transaction then select your billing and delivery document types then go in to the item details here you can find the field called PricingExchRate type maintain this field as C-Exchange rate determination according to billing date now check the result,

I hope this will help you,

Regards,

Murali.

Edited by: Murali Mohan.Tallapaneni on Dec 9, 2008 4:35 AM

Edited by: Murali Mohan.Tallapaneni on Dec 9, 2008 4:35 AM

[Former Member]

Finally we got this resolved using user exits in billing document.