Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

payroll transactions to activities management (AC)

 6 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Margie Gyurisin
Veteran Member
Posts: 538
Veteran Member
2/28/2012 5:01 PM
    We are starting a process to track some employee commitments through Payroll and Activity Management. We would like to put the total commitment amount in Activities (35,000) and then run a payment through each pay tied to the activity code. Our goal is to be able to see a running tally in activities. However, in testing, we find the posted transactions to activities come thorugh as positive (expense accrual) and negative (cash accrual) transactions per pay so their is not a way to run a report showing beginning balance, all transactions and the ending balance.

    Is there something we should do differently in set up to accomplish our tracking so we don't get the tr
    ansactions to post cancelling each other out?
    Karen Ploof
    Veteran Member
    Posts: 118
    Veteran Member
    2/29/2012 1:08 AM
      Margie,

      When tracking balances for grants funds using activities, we loaded the total grant amount in the activity budget. There is a canned report that provides available balance for the activity (can't remember the token id, but I can get it for you if you need it). Where the CFO wanted more detail, we wrote crystal reports.

      Hope that helps, Karen
      Margie Gyurisin
      Veteran Member
      Posts: 538
      Veteran Member
      2/29/2012 12:45 PM
        Karen

        Thanks for your response. 

        I think our problem is that the PR transactions post as debits and credits,  When our activities person runs the reports or looks at the budget, the balance never changes.

        Attached is a screenshot of the drill around on the ac10 (posted transactions).
        Attachments
        mark.cook
        Veteran Member
        Posts: 444
        Veteran Member
        2/29/2012 1:09 PM
          I might be missing something from the screen shot but it looks like both the debit and credits are posting to the same acct categories. Is the Activity set on the HR11 record , is the acct category tied to the proper exense accounts on AC07 or when the transactions are processed in PR23, etc do you add the AC /act cat coding.



          Margie Gyurisin
          Veteran Member
          Posts: 538
          Veteran Member
          3/5/2012 1:01 PM

            You are correct about the postings.  That is what we would like to prevent.  The activity is added to the time record.  The pay code that is used posts to GL as a debit to account 71600 and credit to A/U 999 and account 11915.  The account category 71600 defaults to the time record when the activity is added.

            I dont know much about the AC side but here is a screen shot of the AC07.

            Attachments
            Karen Ploof
            Veteran Member
            Posts: 118
            Veteran Member
            3/6/2012 3:21 AM
              It sounds like the actual payment to the employee is posting to activities correctly, but the offset is not and that the activity category 71600 has been associated with the account 71600 in GL. Is it possible that the account 11915 has also been associated with account category 71600 in the GL? I am not familiar enough with the GL/Activities forms to be able to spout off token id's, but there is a form where you enter a category code for an account number. I am pretty sure it's in the GL area.

              Sorry I can't be more help. Karen
              Margie Gyurisin
              Veteran Member
              Posts: 538
              Veteran Member
              3/6/2012 1:07 PM
                I appreciate your offering ideas to look at. I checked with our Activities person and this is the response. Those fields are blank on the GL side. The only time we use that is when an account number will always require an activity number.