Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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...

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

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 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... 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... 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,782 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... 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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans