You’re offline. This is a read only version of the page.
708
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.
Can you help me please.
*This post is locked for comments
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?
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
The version is AX2012 R2. The status field on top of the grid is not adjusted.
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
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.
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
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (