Items posted with currency code that is the same as LCY

niallc

We have an issue where some of our users are posting into sub entities and selecting the currency code even though it is the the lcy, hence when you run reports you get currency divided into blank (lcy), GBP (also LCY) and USD making them harder to read.

is there any trick to preventing this, or to remedying the reporting issue?

thanks

David_Cox

Hi,
Options.

1. Remove the LCY Currency from the Currency Table.

2. If the LCY is required or populated for other reasons like exports/imports then in the posting Codeunits for the General Journal Line, Clear the "Currency Code" and check the "Currency Factor"
Make sure the LCY code in the General Ledger Setup is set to the LCY "Currency Code"

Codeunit 11 "Gen. Jnl.-Check Line"

OnRun(VAR Rec : Record "Gen. Journal Line")
GLSetup.GET;

//New Code Start
GLSetup.TESTFIELD("LCY Code");
IF "Currency Code" = GLSetup."LCY Code" THEN BEGIN
  "Currency Code" := '';
  IF "Currency Factor" <> 0 THEN
    TESTFIELD("Currency Factor",1);
END;
//New Code End

3. Set the "Currency Code" and check the "Currency Factor" so all entries have a "Currency Code"!
Make sure the LCY code in the General Ledger Setup is set to the LCY "Currency Code"

Codeunit 11 "Gen. Jnl.-Check Line"

OnRun(VAR Rec : Record "Gen. Journal Line")
GLSetup.GET;

//New Code Start
GLSetup.TESTFIELD("LCY Code");
IF ("Currency Code" = GLSetup."LCY Code")OR("Currency Code" = '') THEN BEGIN
  "Currency Code" := GLSetup."LCY Code";
  IF "Currency Factor" <> 0 THEN
    TESTFIELD("Currency Factor",1)
  ELSE
   "Currency Factor" := 0;
END;
//New Code End

David 8)