Project transaction rules FAQs

Transaction rules define what steps to take when posting a transaction (such as an employee timesheet) for a project.

Transaction rules apply to timesheet entries only. As timesheet entries are approved and posted, the rules defined in the transaction rule can:

1. Look for specific transactions posted to a project, such as timesheet entries for employee labor.
2. Add rules to calculate secondary transactions.
3. Post one or more secondary transactions, in the form of a journal entry.

Assign defined rules to projects as needed. For example, create one general rule for Indirect labor costs, then assign that rule to each project. Approving and posting a timesheet for a project triggers the transaction rule automatically.

Transaction rules mostly calculate indirect costs or work-in-progress (WIP) related to employee labor. Rules can also trigger the creation of billable General Ledger transactions, or post to statistical accounts.

No, journal entries created by transaction rules post automatically, even if you have an approval process set up for the General Ledger.

You can delete the original transaction, such as a timesheet. Deleting a transaction deletes all secondary transactions automatically.

Specifying a Location ID on the Posting Details page posts the transaction to the specified entity or sub-location. Leaving the Location ID blank posts the transaction to the location of the processed transaction.

No, if you specify a Location ID on the Posting Details page, the location for the debit and credit must match and cannot be from a different entity than the source transaction.

The base currency comes from the location specified on the Posting Details page. If a location is blank, the base currency comes from the source transaction.

• For cost amounts, the transaction currency comes from the employee's location.
• For billing amounts, the transaction currency comes the location's base currency.
• If the posting occurs on a subtotal line, then the transaction currency is based on the last source transaction in the subtotal range.

You can correct a mistaken timesheet by entering a new timesheet with the adjusted hours. For example, an employee's hours for October 1 were overstated by 4 hours, a new timesheet can be added with -4 as the hours for October 1.

Submitting the new timesheet triggers transaction rule again and posts a journal entry. The negative amount debits the credit account and the credits the debit account.