Prev
Next
Forums Financial Management Lawson S3 Financials

How to tell if a job posted successfully i.e. GL165

 9 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Frank
Basic Member
Posts: 6
Basic Member
10/1/2013 3:24 PM
    I am trying to find out if a user for example runs GL165 in update mode, that it posted successfully? I can't seem to find any information like this?
    Thanks
    Frank
    Adam Jacobson
    Veteran Member
    Posts: 69
    Veteran Member
    10/2/2013 6:19 PM
      A little unclear.
      If the job completes successfully, then it ran fine. You should also see that the gltransrel records for the run group have been deleted.
      Frank
      Basic Member
      Posts: 6
      Basic Member
      10/3/2013 3:11 PM
        Sorry about being unclear, since we are a public company, our auditors want to know when the users run a job i.e. GL165 in update mode, was it successfull. I believe your information will help me.
        Thanks for your time.
        Frank
        Joseph Carfagno
        Basic Member
        Posts: 10
        Basic Member
        10/3/2013 4:14 PM
          You may want to run queries against the Gen table QUEUEDJOB where the Token = GL165 (or GL190 or whatever else the auditors are interested in). The Status field value of 63 indicates the job completed successfully. The Lawson/Infor Knowledgebase has a complete list of the meaning of the various Statuses.
          Ruma Malhotra
          Veteran Member
          Posts: 412
          Veteran Member
          10/3/2013 5:20 PM
            If your job ran successfully that is GL165 ran then there will be no entries on GL65 for this run group.

            If it ran successfully the GL jes will be sitting on GL40 and you can inquire on the run group to see this entry on GL40. You can also run a GL240 to get more information on the jes to see if it is in GL40.

            Other wise you can find the released je on GL95 by inquiring either on unreleased, released or posted statuses of the journal entries.

            Hope this helps.
            Greg Moeller
            Veteran Member
            Posts: 1498
            Veteran Member
            10/3/2013 5:22 PM
              QUEUEDJOB would be the table that you're interested in. Some clarification though. Here we are using an Oracle database and the field R_STATUS is stored in the hex equivalent to 63 --- 3F
              Greg Moeller
              Veteran Member
              Posts: 1498
              Veteran Member
              10/3/2013 6:12 PM
                If you are an Oracle shop, this may help: 
                select 
trim(username),
trim(jobname),
trim(token),
to_number(r_status, 'xx'),
actstartdate
from queuedjob
where actstartdate between (to_date('20131001', 'yyyymmdd')) and (to_date('20131003', 'yyyymmdd'))
                Greg Moeller
                Veteran Member
                Posts: 1498
                Veteran Member
                10/3/2013 6:13 PM
                  So those ' are actually supposed to be '
                  Greg Moeller
                  Veteran Member
                  Posts: 1498
                  Veteran Member
                  10/3/2013 6:16 PM
                    Let's try this again.. those
                    '
                    are supposed to be '
                    Greg Moeller
                    Veteran Member
                    Posts: 1498
                    Veteran Member
                    10/3/2013 8:43 PM
                      Ok, I had a little time today... so I wrote a report to gather some of this information.
                      Please feel free to use and modify.
                      Attachments