Ledger Fiscal Calendar Year Status

(0) Share

Report

Posted on by Israel Gonzalez

733

After that close the ledger fiscal year with all proccess that should be, in the FiscalCalendar form shown the status as "Open" in the year closed, later I do a query to LedgerFiscalCalendarYear table filtering with RecId of FiscalCalendarYear table and the record doesn't exists.

Andre Arnaud de Calavon

Ludwig Reindl

Can you help me please.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Can you please help us here understanding your question?

What does ...'shown the status open in the year closed' ... mean?

Also let us know what kind of query you run, where and how.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Israel Gonzalez 733 on at

Like (0)

Report
Hi Ludwig,

In the route: General Ledger/Setup/Ledger, click on "Fiscal Calendar", the form show the list of all the periods on state Closed as you can see on image, but in the header state shows as Open.

About the SQL query:

SELECT LF.* FROM LEDGERFISCALCALENDARYEAR AS LF INNER JOIN FISCALCALENDARYEAR AS FC ON FC.RECID = LF.FISCALCALENDARYEAR INNER JOIN LEDGER AS LG ON LG.RECID = LF.LEDGER WHERE FC.NAME = '2018' AND LG.NAME = 'COMPANYNAME'

That SQL query result is empty, for that reason I mentioned that doesn't exists the record for the year 2018.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Are you running an older AX2012 version?

Is the status field that you see on top of the grid an adjusted one?

My form looks a bit different from yours...

Best regards,

Ludwig

Was this reply helpful? Yes No
Israel Gonzalez 733 on at

Like (0)

Report

The version is AX2012 R2. The status field on top of the grid is not adjusted.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Is there actually a problem that you have with the status field that prevents you from doing something or is it 'just' the value that is displayed?

If there is a problem consider taking to a developer to get this fixed or upgrading to a newer (R3) version.

Otherwise, I would simply ignore and possibly hide this field until you do the upgrade one day.

Ludwig

Was this reply helpful? Yes No
Israel Gonzalez 733 on at

Like (0)

Report

We don't have problem, the financial manager said everything is ok. The value that is displayed is not a problem, but as I mentioned in my early post, my worry is why doesn't the record of 2018 exists in the table LedgerFiscalCalendarYear?

Was this reply helpful? Yes No
SL-27081458-0 6 on at

Like (0)

Report

Same pb just occured in my company. We are still working with AX2012.

Just to let you know we found out the origin of the pb : on our side, LedgerFiscalCalendarYear record was missing because the user created the accounting year of a company from a another company.

Even if accounting year calendars are shared data, user must change company according to ledger the calendar is attached to.

See Class FiscalCalendars/copyPrevYear line 60

Even a few years later , if this can help....

Was this reply helpful? Yes No