Microsoft Dynamics AX (Archived)

Cannot close period when there are source documents remaining to be journalized with an accounting date within the period. Error ???

(0) Share

Report

Posted on by mostafa mahmoud

5,125

i am trying to close periods in LedgerCalendar in General Ledger-> Ledger -> Ledger Calendar

but it shows me the following message

Cannot close period when there are source documents remaining to be journalized with an accounting date within the period

AX Version AX 2012 R2 upgrade from FB

any suggestion how to solve these ???

*This post is locked for comments

I have the same question (0)

All responses (27)

Answers (0)

Wvduren 1,435 on at

Like (0)

Report

Same issue here. Very annoying

Was this reply helpful? Yes No
mostafa mahmoud 5,125 on at

Like (3)

Report

hi WVDUREN

try to run the below job in your server to get the corrupted lines recid, you will find these line in AccountingDistribution table ,and if you deleted these lines every thing will go ok and the period will be close successfully

static void SFTYClosingLedgerDocumentsIssue(Args _args)

{

AccountingDistribution accountingDistribution;

FiscalCalendar fiscalCalendar;

FiscalCalendarPeriod fiscalCalendarPeriod;

FiscalCalendarPeriod _currentPeriod;

Ledger ledger;

;

select * from _currentPeriod where _currentPeriod.RecId==5637145934;

if (_currentPeriod)

{

while select RecId from accountingDistribution

where accountingDistribution.AccountingDate >= _currentPeriod.StartDate &&

accountingDistribution.AccountingDate <= _currentPeriod.EndDate &&

accountingDistribution.AccountingEvent == 0

exists join ledger

where ledger.PrimaryForLegalEntity == accountingDistribution.AccountingLegalEntity

exists join fiscalCalendar

where fiscalCalendar.RecId == ledger.FiscalCalendar

exists join fiscalCalendarPeriod

where fiscalCalendarPeriod.FiscalCalendar == fiscalCalendar.RecId &&

fiscalCalendarPeriod.RecId == _currentPeriod.RecId

{

//if (accountingDistribution)

//{

info(queryValue(accountingDistribution.RecId));

//_fiscalCalendars.addWarning(strFmt("@SYS344293",_currentPeriod.Name));

//}

}

}

}

Was this reply helpful? Yes No
Wvduren 1,435 on at

Like (0)

Report

Hi Faress,

Thank you for your suggestion. Unfortunately, your job runs perfectly, but gives no results. It seems this table is not the problem. Any ideas where to look?

Maybe good to mention: I use AX 2012 R1 CU2

Was this reply helpful? Yes No
mostafa mahmoud 5,125 on at

Like (0)

Report

i think that you need to made trace and debugging for that issue , as the reason seems to be different

Was this reply helpful? Yes No
Wvduren 1,435 on at

Like (0)

Report

Hi Faress. I guess so. I am sorry, but I never did that before. The only debugging I have done is add a breakpoint to some classes and debug.

How can I add a trace for this problem? Where to start?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Debug class "subLedgerJournalFiscalCalenderEventHandler"

and in table "LedgerFiscalCalendarPeriod" method "ValidateField"

Was this reply helpful? Yes No
Wvduren 1,435 on at

Like (1)

Report

Actually, the code of Faress Mahmoud works fine after all. Although I changed the code a little, it is the right solution for this problem. I also updated it to auto-remove the data from the table and report how many were deleted.

Thank you very much!

Was this reply helpful? Yes No
Khurram Aftab 15 on at

Like (0)

Report

hi Willem,

i have tried and run the same job, but nothing changes. The problem still exist and period can not be closed.

please help if you have any solution

Thank you

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Problem comes from

\Classes\SubledgerJournalFiscalCalendarEventHandl\checkAccDistWithNoAccEvent

And I can't figure out where how accountingDistribution table relaited with transaction or something.

I found that there are field SourceDocumentHeader SourceDocumentLine.

But when i ket there I still cant find relaited transaction.

Was this reply helpful? Yes No
Wvduren 1,435 on at

Like (0)

Report

Hi Khurrum, sorry for my late reply.

Did you use the correct RecID ? You need to change it to the period you experience problems with:

select * from _currentPeriod where _currentPeriod.RecId==5637144589;

Then it should work fine.

You can find the period and corresponding recID in the FiscalCalendarPeriod table (use table browser).

Kind regards, Willem.

Was this reply helpful? Yes No

Community site session details

Cannot close period when there are source documents remaining to be journalized with an accounting date within the period. Error ???

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Cannot close period when there are source documents remaining to be journalized with an accounting date within the period. Error ???

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates