Change Import GL journal Sequence Number

 3 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
AD
New Member
Posts: 6
New Member
    Hello,
    How do I go about changing the sequence number of the next GL journal number used through GL165 process?
    mark.cook
    Veteran Member
    Posts: 444
    Veteran Member
      What is the business driver you are trying to accomplish?

      If you want to segregate a particular set of entries with their own numbering sequence, I would point you to the system code/source code. Having a separate system code would start those numbering in a different sequence than the standard GL entries.

      Many places do this to segregate entries coming from sub systems or third party systems.

      If that didn't answer the question please post more detail
      AD
      New Member
      Posts: 6
      New Member
        Mark,
        I am trying to reset the journal entry sequence number for an existing source code. Is this possible?
        Ruma Malhotra
        Veteran Member
        Posts: 412
        Veteran Member
          Generally a journal number is the control group number that is automatically updated to the next number by the system itself. this way Lawson makes sure that a journal entry is a unique journal entry and is given a gontrol group number.

          A journal sequence number is given to a journal number when the entry on GL40 is a wrong journal entry which means that the transaction was coded to a wrong accounting unit or account that has not been defined on the chart or is inactive. The more times you try and release the journal entry after correcting it and the system still does not know where to send the journal entry the sequence number is updated. This is generally not populated on GL165 but only the journal control group is populated. However if your transactions did not go through GL165 there is no way of resetting the sequence number. What you can do is to look at the accounting unit and account the transaction is posting to and make sure either they are rightly defined on the chart and are active. The hournal sequence number is updated when the transaction is coded to the error suspense account.

          If you are referring to the control group number or the journal entry number than you can reset it on GL165 and let the transaction go through.