Create/Update Foreign Currency Item Sales Prices for Item

nayanpatel2393

How to Create/Update Foreign Currency Item Sales Prices for Item and For each Currency defined in Currencies table?
-> USD Item Sales Price = Unit Price (LCY) * USD Sales Price Factor.

archer89

ok, thats a different requirement.
in that case you need a customization in the onvalidate trigger of field unit price.
there write the needed code to change the according records in table sales price or maybe create new records depending on the conditions.

archer89

do you mean updating currency exchange rates ?

nayanpatel2393

Yes, @archer89

archer89

please follow
https://msdn.microsoft.com/en-us/library/hh168784(v=nav.70).aspx
https://m.youtube.com/watch?v=qneV7jLdD90
https://nav-magno.be/2012/04/weekly-exchange-rate-update/

nayanpatel2393

See this Image @archer89 !!

archer89

ok, thats a different requirement.
in that case you need a customization in the onvalidate trigger of field unit price.
there write the needed code to change the according records in table sales price or maybe create new records depending on the conditions.