Exchange rate date in billing documents

[fernando_martin]

Hello,

we have a process in which from one contract we create invoices, credit memos, ... without creating any delivery.

Some contracts were created on 2004, and when we create the invoice/credit memo, ... the exchange rate at item level is taken from contract's date and not billing date (i am not too sure why at header level it takes it from billing date).

In copy control you can set it at item level with VTFA, for example combination WV to G2. Then Click on items >>> select item >>> details >>> PricingExchRate type

There are various options

A - Copy from sales order

B - Xchange rate = accounting rate

C - Exchange rate determination according to billing date

D - Exchange rate determination according to Pricing date

E - Exchange rate determination according to current date

F - Exchange rate determination according to service rendered date

I can select C and then it works.

The question is how to restrict this by company code, as a change here will afect all countries. Maybe we can use the copying control in VOFM?

Thanks and regards,

Fernando

[vishwajit_wattamwar · Accepted solution]

In copying requirement you dedine one custom routine and assign that.In this routine you write the code as if country is ... then only excute else..another part of code.

Please let me know if this works

Regards,

Vishwajit

[fernando_martin]

Hello,

thanks for your replies.

Yes, going to the copying requirement indicated in VTFA (go to VOFM, Copying requirements-> billing documents), edit the exit and you restrict by company code (vbrk-bukrs) and also target and source document type, that is structure TVCPF.

You have to set TVCPF-PFKUR = 'C' (or whatever option) and then when the credit memo is created, the rate is taken from billing date.

[Former Member]

I'm not aware of any other solution than creating a new dcument flow and corresponding item category or maybe determine a specific item category through a user exit. But, considering my experience as consultant facing this kind of problems a lot, i would suggest to make an inquiry amongst the other company codes to check if them as well would rather have this kind of exchange rate determination. Most of the times is worth it.... People don't want to bother or risk any change, and you end up with systems unecessarily mixed and complicated..