10
I am getting following error message when I am trying to hard close July period.
Cannot close period Period 7 when there are source documents remaining to be journalized with an accounting date within the period.
*This post is locked for comments
Hi Ron,
What is the status of this issue... how did you solve this issue
Could you please help me, as i am facing the same problem
Regards
Yousaf
Hi Ron,
In the general ledger module there is an inquiry form called "Subledger entries not yet transferred". Do you have some pending transactions here?
Hi Ron,
Please try to run the below job in your server to get RecIds of the corrupted lines. It will be in the AccountingDistribution table ,and once you delete these lines, you will be able to close the period successfully.
static void ClosingPeriod(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));
//}
}
}
}
~ Nidhi :)
Hi Ron,
Why you want /need to hard close your period?
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (