web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Period ID Field on GL2...
Microsoft Dynamics GP (Archived)

Period ID Field on GL20000 Table

(0) ShareShare
ReportReport
Posted on by babubaskaran@outloo... 12

Dear All,

I am creating a refreshable excel file connected to GL20000 to bring all open GL transactions.  I wanted to use period ID field on this table, I successfully was able to do the same on GP 2013 R2.  The problem I have now is when did the same on GP 10 the period ID is zero, so I am not able to use the same.  I understand the actual period ID is stored on SY40100 but how to get the same based on the transaction date on GL20000.  Can anybody help on this.

Thanks,

babu

*This post is locked for comments

I have the same question (0)
  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at
    RE: Period ID Field on GL20000 Table

    Hi Ian,

    The period zero is not mapping which is the opening balance, how to get this can you please help me.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at
    RE: Period ID Field on GL20000 Table

    Hi Ian,

    I created a  view along with this condition and got the data from the same with Period ID.

    Thanks for your help.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at
    RE: Period ID Field on GL20000 Table

    Thanks Ian I will try add this on to my query and let you know the result.

    Thanks,

    Babu

  • Verified answer
    Ian Grieve Profile Picture
    Ian Grieve 22,784 on at
    RE: Period ID Field on GL20000 Table

    The following would return the PERIODID:

    SELECT
	(SELECT TOP 1 PERIODID FROM SY40100 WHERE PERDENDT >= CONVERT(DATE, TRXDATE, 103) AND ODESCTN = 'General Entry' ORDER BY PERDENDT)
FROM
	GL20000 GL
  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at
    RE: Period ID Field on GL20000 Table

    Hi Mahmoud,

    How are you doing.  Yes I wanted all GL transactions happened on all periods.  Our financial year is from July to June (12 fiscal period).  Only difference our month end is little different not calender month but we close the month on last Friday of each month.

    Thanks,

    Babu

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Period ID Field on GL20000 Table

    Hello Babu,

    Long time no see,

    You are totally right as I have seen this field PERIODID having a zero value in prior version; specifically GP 10, which usually present such a good justification for developers to use this field when building such custom reports. In recent versions of Dynamics GP, the field was populating properly including the period on a journal entry level.

    So let me know, is it the period ID that you are looking for ? Or you are looking for having specific data stored on the GL20000 to be used for special purposes ?

    What is the fiscal period setup in your case ? (12 fiscal period) January through December ?

    Your feedback is highly appreciated,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans