Skip to content

x Want to ask a question or reply? Click here to join the group.
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 14 subscribers
  • Views 275 views
  • Users 0 members are here
Browse Forums
Announcements
304
topics
39
replies
General Discussion
532
topics
1k
replies
More Content

Journal Entry for Sage 300 (Accpac)

Aurelio DeAssis
Solved
Posted By

Hi,

Does anyone have an accurate sql script that can extract all the journal entries with the entry user and the postedd user from a company?

We are using: 300 Premium (Version 2023) and having been able to get a proper journal listing report. 

regards

Parents
  • +1
    verified answer

    try this. what i normally do is open excel, Data, new query, sql, fill in servername and database, then on sql statement copy and paste the below

    SELECT GLPOST.ACCTID, GLPOST.FISCALYR, GLPOST.FISCALPERD, GLPOST.SRCECURN, GLPOST.SRCELEDGER, GLPOST.SRCETYPE, GLPOST.POSTINGSEQ, GLPOST.CNTDETAIL, GLPOST.AUDTDATE, GLPOST.AUDTUSER,
    GLPOST.AUDTORG, GLPOST.JRNLDATE, GLPOST.BATCHNBR, GLPOST.ENTRYNBR, GLPOST.TRANSNBR, GLPOST.COMPANYID, GLPOST.JNLDTLDESC, GLPOST.JNLDTLREF, GLPOST.TRANSAMT,
    GLPOST.SCURNDEC, GLPOST.SCURNAMT, GLPOST.HCURNCODE, GLPOST.SCURNCODE, GLPOST.DOCDATE,GLJEH.ENTEREDBY, GLJEH.DOCDATE AS POSTDATE, GLJEH.DATEENTRY
    FROM GLPOST LEFT OUTER JOIN
    GLJEH ON GLPOST.BATCHNBR = GLJEH.BATCHID AND GLPOST.ENTRYNBR = GLJEH.BTCHENTRY
    WHERE (GLPOST.FISCALYR = 2026)

  • 0 in reply to Mr_Mayor

    Worked perfectly. Thank you so much. Appretiate the help

Reply Children
No Data

*Community Hub is the new name for Sage City