Create/Update Foreign Currency Item Sales Prices for Item

nayanpatel2393 · 2016-08-05

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 · 2016-08-07

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 · 2016-08-06

do you mean updating currency exchange rates ?

nayanpatel2393 · 2016-08-06

Yes, @archer89

archer89 · 2016-08-07

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 · 2016-08-07

See this Image @archer89 !!

archer89 · 2016-08-07

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.

Create/Update Foreign Currency Item Sales Prices for Item

Best Answer

Answers

Categories