cancel
Showing results for 
Search instead for 
Did you mean: 

VPRS Cost in Material Ledger

Former Member
0 Kudos

hi all,

i have some problem here.

we use 2 local currency. first local currency is IDR, and second local currency is USD.

our client use material ledger, so in material master accounting 1, we maintain 2 value of inventory (in IDR and USD)

let say we create material XXX (using standard price) in 01 jan 2011 , with IDR value 1,000,000. the system will convert to USD with exchange rate in 01 jan 2011 (which is 10,000). so the USD value will be 1,000,000/10,000 = 100 USD.

then in 10 january 2011, Sales order is created for material XXX with document currency USD .

cond type VPRS get 1,000,000 IDR and covert to doc Curr (USD) with exchange rate in 10 jan 2011 (which is 9,000).

so the VPRS value in USD will be 1,000,000/9,000 = 111,11 USD.

by this case, the VPRS value in sales order is DIFFERENT with value in Material Master. it also become a problem when we want to see PROFIT MARGIN.

can cond type VPRS get the correct USD value according to Material Master?

thanks.

Best Regard,

Hendry

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Hendry,

We are in the process of activating the material ledger and also facing the same issue where the exchange rate is not taken from material ledger, but is just the current day's M rate.  Did you find a solution to your issue?

Thanks

Dwayne

Agrium Inc.

Lakshmipathi
Active Contributor
0 Kudos

Please check the following notes which may help you

a) Note 547570 - FAQ: VPRS in pricing

b) Note 640692 - Currency conversion VPRS

c) Note 1365939 - VPRS logic and Customizing settings in SD

thanks

G. Lakshmipathi

Former Member
0 Kudos

any suggestion?