a wrong exchange rate (14,500 SYP/USD) was used when submitting a Purchase Receipt, which caused an incorrect stock valuation. Later, the correct exchange rate (10,500 SYP/USD) was entered in the Purchase Invoice, but it did not affect the item valuation. Since the Purchase Receipt cannot be cancelled (items from the same batch were already used in subsequent transactions), how can I correctly adjust the stock valuation or account for this currency error retrospectively?
any one can help please
@ErpnextRaja IT IS CHECKED .
Hello @hayyan_daood
Pls Check This
@Smit-Bhaliya it will work if there is no exchange rate ,
but in my case :
i am using usd pricelist , and set the exchange rate .
when i do this nothing happened even if i did repost item valuation ,
here is a picture :
in the receipt the exchange rate was 11000 SYP
and this is the stock ledger:
in the invoice :
the exchange rate changed to 10500 so the valuation should changed . but still the same
@Smit-Bhaliya but if the invoice and the receipt uses the standard pricelist , no problem , valuation rate will be updated in the receipt after the invoice submitted
the best approach to solve this problem is to make landed cost voucher for the purchase receipt to adjust the valuation difference .
go to invoice and see the accounting ledger :
This is an Exchange Loss. A credit entry here means your valuation rate (e.g., exchange rate) increased the liability or the inventory cost compared to the original value when you received the stock.
value = 32000
in the landed cost voucher :
make the difference -32000
and the stock ledger will be updated by new valuation rate
