Options

Items posted with currency code that is the same as LCY

niallcniallc Member Posts: 2
edited 2015-01-20 in NAV Three Tier
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

Comments

  • Options
    David_CoxDavid_Cox Member Posts: 509
    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)
    Analyst Developer with over 17 years Navision, Contract Status - Busy
    Mobile: +44(0)7854 842801
    Email: david.cox@adeptris.com
    Twitter: https://twitter.com/Adeptris
    Website: http://www.adeptris.com
Sign In or Register to comment.