Problem in end of year closing with additional reporting cur

Hayan

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.

anybody had such an error can help me.

Thx in advance.

best
HAYAN

Hayan

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

jglathe

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

Hayan

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

jglathe

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

Hayan

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

jglathe

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

Jones

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

jglathe

My name is Jens...?

Hayan

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