Record Locking and Unlocking

The locking of specific transactions in Workamajig is necessary for "referential integrity" which means that the related record must match the details of the transaction.

Each transaction that can be entered in Workamajig: Timesheet, Orders, Vouchers, Client Invoices, etc., begins with an Approval process. During this initial approval, step is the time you and your team should take to identify issues with the entry. As a transaction proceeds through the system, it will be locked down by each step to retain the referential integrity and financial details of the transaction. 

NOTE: There may also be security rights that are restricting your ability to edit a transaction. Ex. Edit Transaction After Approval or Unpost Transactions to General Ledger.

How A Transaction Becomes Locked

The best way to describe how or why a transaction becomes locked (uneditable), is to use an example. Here is one that defines the movement of a time entry through the system:

1. You enter time against a project.
2. You submit the timesheet for approval (Lock1)
3. The Timesheet is Approved (Lock 2)
4. One of the time entries contained on the timesheet is part of a Billing Worksheet (Lock 3)
5. Time entry is Billed/Marked as Billed/Marked as Write Off (Lock 4)
6. Client Invoice is approved and posted (Lock 5)
7.  A Receipt is applied to the Client invoice (Lock 6)
8. The Receipt Approved and Posted (Lock 7)
9. The Receipt is part of a Deposit that has been Finalized in an Account Reconciliation (Lock 8)
10. The GL Closing Date has been set (Lock 9)

In order for you to edit your timesheet, directly, the timesheet entry in the above example needs to be moved backward from #10. So Open GL Closing Date>Open the Account Reconciliation>Unpost, Unapprove Receipt>>........

This does not necessarily mean you have to delete records, but you would have to unpost, unapproved and unapply records in order to remove the imposed "Lock" enforced by the preceding step. Once done, you can then reapply/reconnect the changes, approve and post. 

Other examples include:

• A vendor invoice cannot be deleted if there is a payment applied.
• An Expense Report cannot be edited if it has been converted to a vendor invoice.
• A project cannot be deleted if it has time or expenses entered against it.
• A task cannot be deleted if it is part of an approved estimate.
• An employee cannot be deleted if they have entered time or other records into the system.
• An "Order" that is then applied to a Client Invoice. This is called a Prebill in the system, and it processes a slew of accruals that are not easy to undo without backing out all related transactions.

Integrity Of Data And System Audits

To maintain the integrity of the data in the system, these locks are in place for your benefit.

System Logs

To see what has occurred with a transaction or record, Workamajig tracks actions such as Approved Day, User, Deleted Date, Date Posted, etc. From the record itself, there is a Log button in the upper right to see this history. Additionally, there is a Menu > Admin > System Log to run reports regarding the records and transactions.