LCY setup

idiot

LCY in G/L set to USD.
Taking Customer transactions as example, when the currency code is left blank during transactions, it is automatically taken to be USD with a currency factor of zero.


Would it be possible to set Customer Card Currency Code to USD, defining an exchange rate for USD to USD 1:1, & currency factor in this case should be 1?

Is this setup possible? Any implications?

ara3n

Based on past experience, I was told to leave it blank, I can't remember the reasons or implications. Why do you want to set it USD?

idiot

1. Some customized reports have to specially cater to conditions of currency factor of zero (division by zero error).
2. Currency Factor or exchange rate of zero doesn't sound right & logical.
3. Selection based on currency blank interfered with some data mining processes.
4. Retrieval of currency is direct, no need for IF "Currency Code" = "" THEN Currency Code := 'USD' type, very messy & redundant coding.
5. Possibility of setting condition blank to enforce selection of currency.

selece28

I agree,
I also want to know how did Cronus Database can set the currency factor = 1 for Default Currency?

Anyone have idea?

Thanks in advance

idiot

:shock: =D>
Finally someone noticed \:D/
Apparently cronus cheated, proof of the cheat:

UpdateCurrencyFactor()

IF "Currency Code" <> '' THEN BEGIN
  IF ("Document Type" IN ["Document Type"::Quote,"Document Type"::"Blanket Order"]) AND
     ("Posting Date" = 0D)
  THEN
    CurrencyDate := WORKDATE
  ELSE
    CurrencyDate := "Posting Date";

  "Currency Factor" := CurrExchRate.ExchangeRate(CurrencyDate,"Currency Code");
END ELSE
  "Currency Factor" := 0;

selece28

Yes, but it doesn't solve our problem.
How to make the default exchange rate to 1 instead of 0
Anyone know?

Thanks

idiot

Edit the segment of code above, specifically the last line.
But I prefer to find out what implications there are by defining actual LCY instead of leaving it blank on Customer/Vendor Cards...

selece28

yes but instead of adding codes, is there any way to set this?
I mean if we add codes, theres a possibility that we miss some of it right?

Thanks

selece28

Ow and where can you put this "UpdateCurrencyFactor()" function?

Sorry Never mind about my question,
Just discuss with my Senior Tech. It was only records from Standard Cronus.
Even if we create a new Sales Order from that DB, the currency factor is still 0. And i think no other way to set it to 1 unless we do modification.

Everything is clear now.

Thanks in advance