Version 1.111.1 | General Release

AM/PM issue on Timesheet Entry Portal
Picklist fields on ProcessInvoice Field Set added to Process Invoice causing issue

Version 1.111.1

General Release

AM/PM issue on Timesheet Entry Portal

An issue was reported when time is entered for a Timesheet in 12 hour format, where times entered as ‘PM’ were reverting to ‘AM’, thus throwing out Hours Actual. For Example, 9:00am – 5:00pm was appearing as 9:00am – 5:00am, which resulted in 20 hours recorded as opposed to 8 hours.

This has now been resolved and AM/PM will register and display correctly for all start and end times.

 

Picklist fields on ProcessInvoice Field Set added to Process Invoice causing issue

Where a picklist field is added to the ‘Process Invoice’ page via the ‘ProcessInvoice’ field set found on the Transaction object, an issue was reported when this field is used as a filter when attempting to process invoices.

This issue is now fixed and users can add picklist field to the ProcessInvoice field set for use as filters when processing invoices.

Version 1.111

Daily Award – Reinterpretation where multiple timesheet entries for same day
Timesheet Entry Portal – Added timesheet entry lines can now handle all date formats
Custom Settings > Timecards Config Help Text and Descriptions updated
‘New Job Fee’ button

Version 1.111

 

Daily Award – Reinterpretation where multiple timesheet entries for same day

Where multiple timesheet entries are entered for a single day, (such as when multiple project codes are submitted), and the associated Placement is using the ‘Daily Award’ Award Master/Rate Rule type, calculation for pay and billing has been modified to accurately calculate the true division of work done.

OLD calculation of transactions for multiple timesheet entries for single day

Where multiple timesheet entry lines were submitted for a single day then only one transaction was created which only had the day rate defined in the ‘Daily Award’.

NEW calculation of transactions for multiple timesheet entries for single day

Where more than one timesheet entry line is submitted for a single day then the following formula shall apply to all timesheet entries for that day, except the last timesheet entry:

Hours submitted for timesheet entry line / total hours submitted for all timesheet entry lines of that day * 100 (rounded to 2 decimal places).

One timesheet entry line however will use a slightly different calculation to balance out total actual hours, this shall be:

 1 – (sum of percentage of hours worked for other entry lines)

 

For example:

If the following 3 Timesheet Entries (TSEs) all applied to the same day

  • TSE 1 for Project A actual hours = 3.5
  • TSE 2 for Project B actual hours = 1.25
  • TSE 3 for Project C actual hours = 4

The total actual hours for the day is 8.75.

  • TSE 1 is 34.286 % of the total 8.75 hours worked – (3 / 8.75)*100. This means that it should have 34.286% of the total quantity of 1 = 0.34
  • TSE 2 is 14.286 % of the total 8.75 hours worked – (1.25 / 8.75)*100. This means that it should have 14.286% of the total quantity of 1 = 0.14
  • TSE 3 is the last TSE for the day, so the remaining percentage of the total quantity of 1 should be allocated to this transaction: 1 – (0.34 + 0.14) = 0.52

The resulting transactions will be:

  • Transaction 1 for Project A quantity = 0.34
  • Transaction 2 for Project B quantity = 0.14
  • Transaction 3 for Project C quantity = 0.52

 

Considerations:

Where a Placement is using the ‘Daily Award’ Award Master type and has a timesheet with existing transactions prior to the install of version 1.111 and the timesheet is extended: no times can be submitted for days where days have been approved and transactions created.

Times however can be submitted for new days of the week made available following an extension.

 

Timesheet Entry Portal – Added timesheet entry lines can now handle all date formats

An issue was discovered where a timesheet entry line is added to a Timesheet via the Timesheet Entry Portal and an error occurs when the user modifies the date. This issue occurs as the date field was not designed to handle all internal date formats. Ie. DD/MM/YYYY, MM/DD/YYYY or YYYY/MM/DD.

This issue has now been fixed and will work regardless of the user’s locale and associated date format.

 

Custom Settings > Timecards Config Help Text and Descriptions updated

Help Text and Descriptions have been provided for all fields in Set Up > Custom Setting > Timecards Config. This will help users better understand the purpose of fields found in the Timecards custom settings and their impact on Timecards package functionality.

Note: Those that have 1.110 or earlier will not see help text updates, only description updates. This is due to a salesforce limitation, where help text is not updated by package updates.

 

‘New Job Fee’ button

When Job Order > New Job Fee (button)  is used, the chosen record type was found to not always apply and the description field not always saved on creation of the Fee. These issues have now been fixed.