Problem in end of year closing with additional reporting cur

Comments

• Options

  Hayan Member Posts: 110

  2015-12-07

  Dear All,
  
  I am trying to close the year but i am getting an error of inconsistency in GL see attached.
  the problem is that i had two scenarios:
  1- without additional reporting currency setup in General Ledger setup and it is working fine
  2- when i setup addition reporting currency in General Ledger setup i get the attached error,taking into consideration that the Closing is by Dimension.
  
  we are reaching end of year and we need to close the year in NAV. Anybody can help on this error. I would appreciate this problem.
  
  Best
  HAYAN

  0
• Options

  jglathe Member Posts: 639

  2015-12-08

  Hi Hayan,
  
  well there are several known issues with ACY, and close income statement and other postings. The problem is they don't occur often, and are hard to debug. To get a better handle on what's happening I wrote a version of Close Income Statement that's always filling a general journal, even when ACY is used. This helps to check if the ACY balance in the journal is 0 (and if the closing is by desired dimension combinations). If this is ok, the root cause is normally in CU12, somewhere around HandleAddCurrResidualGLEntry().
  
  with best regards
  
  Jens

  0
• Options

  Hayan Member Posts: 110

  2015-12-09

  Hi @jglathe, thank you very much for your reply, please can you share with me this code.
  thank you very much in advance.
  
  Best
  HAYAN

  0
• Options

  jglathe Member Posts: 639

  2015-12-09

  Hi @Hayan,
  
  here is the relevant change in Report 94:
  

  HandleGenJnlLine()
  //OS001s os.jgl
  GenJnlLine."Force Post" := TRUE;
  GenJnlLine."System-Created Entry" := TRUE;
  //Handle all postings via system journal batch
  DimMgt.CopyJnlLineDimToJnlLineDim(TempJnlLineDim,JnlLineDim);
  GenJnlLine.INSERT;
  //OS001e os.jgl
  

  
  This will always generate the gen. journal batch. I suggest to try it out in a copy of the report Our version does a few other nice things too, it's part of the Plexada BuildingBlocks AddOn.
  
  with best regards
  
  Jens

  0
• Options

  Hayan Member Posts: 110

  2015-12-09

  Thank you @jglathe, but can you tell me where I need to add this code in the original code.
  
  
  LOCAL HandleGenJnlLine()
  GenJnlLine."Additional-Currency Posting" :=
  GenJnlLine."Additional-Currency Posting"::None;
  IF GLSetup."Additional Reporting Currency" <> '' THEN BEGIN
  GenJnlLine."Source Currency Code" := GLSetup."Additional Reporting Currency";
  IF ZeroGenJnlAmount THEN BEGIN
  GenJnlLine."Additional-Currency Posting" :=
  GenJnlLine."Additional-Currency Posting"::"Additional-Currency Amount Only";
  GenJnlLine.VALIDATE(Amount,GenJnlLine."Source Currency Amount");
  GenJnlLine."Source Currency Amount" := 0;
  END;
  IF GenJnlLine.Amount <> 0 THEN BEGIN
  //CAP++
  GenJnlPostLine.RUN(GenJnlLine);
  //CAP--
  IF DocNo = NoSeriesMgt.GetNextNo(GenJnlBatch."No. Series",EndDateReq,FALSE) THEN
  NoSeriesMgt.SaveNoSeries;
  //CAP--
  GenJnlLine.INSERT;
  //CAP--
  END;
  END ELSE
  IF NOT ZeroGenJnlAmount THEN
  GenJnlLine.INSERT;
  
  Best
  HAYAN
  

  0
• Options

  jglathe Member Posts: 639

  2015-12-09

  Hi @Hayan ,
  
  replace the whole bunch... I mean the complete function HandleGenJnlLine(). This doesn't look like classic client code, though. For NAV2013+, this looks more like:
  

  LOCAL HandleGenJnlLine()
  //OS001s os.jgl
  //you don't have this field
  //GenJnlLine."Force Post" := TRUE;
  //OS004s os.jgl
  GenJnlLine."System-Created Entry" := TRUE;
  //OS004e os.jgl
  //Handle all postings via system journal batch
  GenJnlLine.INSERT;
  //OS001e os.jgl
  

  
  with best regards
  
  Jens

  0
• Options

  Jones Member Posts: 6

  2015-12-09

  Thank you Hayan, You helped me a lot including with those codes.

  0
• Options

  jglathe Member Posts: 639

  2015-12-10

  My name is Jens...?

  1
• Options

  Hayan Member Posts: 110

  2015-12-11

  Thank you Jens I have extracted the code from the Objects as is, we are working on W1 Version. anyways I will check and work on it.
  Thanks you for your corporation.
  
  Best
  HAYAN

  0