Prev
Next
Forums Expense Management Lawson Time & Expense

Time Entry Policy and the database

 1 Replies
 0 Subscribed to this topic
 2 Subscribed to this forum
Sort:
Author
Messages
Justin R
Posts: 7
8/11/2010 1:11 PM

    I am trying to write a policy for time entry and I need to look at PTO that has already been taken.  I essentially want to warn/block them if they are trying to use PTO time that they have not accrued yet.   I know where the data is, I just don’t know how to get to it. Is there a way to read from the database from within a policy? 

    pma_jay
    New Member
    Posts: 2
    New Member
    1/24/2011 3:27 PM
      Hi Justin,
      Which database are you referencing? Front office (SA or TM) or the Financials schema? You can definitely read the SA/TM database from policy code. We've written many similar balance policies for other clients.

      Policies can be a bit of a challenge to code but once functioning can be a big value in terms of employees getting time correct at the point of entry.

      Your post is a few months old, are you still interested in this type of policy? If so please let me know - we'd be happy to provide technical assistance or provide you with the policy itself.

      thanks,
      Jay
      PMA
      508-250-9550
      jay@p-m-assoc.com