• Search Forums
    Advanced Search Topics Posts
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
Send Private Message
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 Send Private Message
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