Version 1.120

Rate Calculator
Award Master Page missing the Long Description
New Payrun Split for Fortnightly
Remove the requirement for the Client to be identical on the Placement and the Job

Version 1.120

Rate Calculator

This is currently in BETA phase, future release notes to follow, for more information please contact 2cloudnine support support@2cloundnine.com

Award Master Page missing the Long Description

The Long Description field was only available on Daily Awards.  This field is now available on all Award Masters to allow completion of details related to the award purpose and function.

New Payrun Split for Fortnightly 

Optional Setup

A fortnightly Payrun Split is now available.  It is option “F” (for fortnightly) on Pay Schedule Config

To function correctly, a Placement with a “Pay Schedule”of “F” in the Payrun Split, must have a Timesheet Frequency set to ‘Fortnightly-1’ or ‘Fortnightly-2’

To set an existing Pay Schedule to “F” or create a new Pay Schedule with “F”

Set Up > Custom Settings > Pay Schedule Config       

select F in Payrun Split


Remove the requirement for the Client to be identical on the Placement and the Job

Optional Setup

Previously there has been a requirement that the Client on the Placement be the same as the Client on the associated Job.

A custom setting in TimeCards Config called ‘Disable Client Validation’ has been introduced.

Ticking the box will allow for users to change the client on the placement, without any validation errors when generating timesheets. The original client will remain on the Job.

To Disable Client Validation –

Set Up > Custom Settings > TimeCards Config > Disable Client Validation (True)

Note: Creation of Transactions and Consolidated Invoices will still use the Client on the Placement to determine Invoice Consolidation requirements.

Version 1.119

No cancel option on the Invoice Template record setup/edit page
Ordinary Hours Award can now have Daily Hours Breakpoints defined for Saturday, Sunday and Public Holidays
Fee record stamped with incorrect ‘Invoice Date’
Exporting Transactions generated via “Process Invoice” defaults to a US based date format
List index out of bounds: 0 when attempting to re-invoice

Version 1.119

No cancel option on the Invoice Template record setup/edit page

A “Cancel” button has now been added to the Visualforce page responsible for maintenance of Invoice Template records to enable users to exit.  This button functions in either set up, or edit mode, without saving any changes.

 

Ordinary Hours Award can now have Daily Hours Breakpoints defined for Saturday, Sunday and Public Holidays

Optional Setup

Previously Ordinary Hours Award Masters had the following types of breakpoint options for Monday to Friday:

  • Daily time (hours worked outside of the standard start and end time)
  • Daily hours (hours worked over a defined number of hours in 1 day)
  • Weekly hours (hours worked over a defined  number of hours in 1 week)

Saturday, Sunday and Public Holidays however did not have ‘Daily Hours’ breakpoints meaning users did not have the ability to define if a different pay code should be used on Saturday, Sunday or public holidays based on the number of hours worked on that day.

Users now can now define ‘Daily Hours’ Breakpoints on Ordinary Hours Awards for Saturday, Sunday and Public Holidays. Transactions created for Saturday/Sunday and Public Holidays will use Daily Hours logic as set up in the following breakpoints:

“Do you wish to set Saturday/Sunday/Public Holiday Hours Breakpoints”

“Do you wish to set Saturday/Sunday/Public Holiday Overtime Conditions”

The exception to this rule is when Weekly logic from the ‘Do you wish to set Weekly Breakpoints?’ section takes priority. This occurs when the number of hours worked on a timesheet has exceeded ‘Ordinary Weekly Hours’  defined in the ‘Standard Elements’ Breakpoint.

Setup Notes:

Both of the following sections –

“Do you wish to set Saturday/Sunday/Public Holiday Hours Breakpoints”

“Do you wish to set Saturday/Sunday/Public Holiday Overtime Conditions”

will be required to be populated when a new Ordinary Award Master is created or an existing Ordinary Award Master is edited.

No updates will be required for either breakpoint on existing Ordinary Hours Awards Masters (unless they will be edited/updated after version upgrade).

 

Fee record stamped with incorrect ‘Invoice Date’  

Setup Required

A new field has been created to overcome the issue of fee records being stamped with an Invoice Date that does not match the Date on Consolidated Invoices and the Process Invoice page.

The new field, has a “Date” format: Invoice Date (tc9_ti__Invoice_Date__c).

The new field will replace the existing “Date/Time” field: Invoice Date (tc9_ti__InvoiceDate__c)

To Setup:

Fees > Open a Fee Record > Edit Layout 

Remove  tc9_ti__InvoiceDate__c from page layout and replace with tc9_ti__Invoice_Date__c (both are called ‘Invoice Date’)

Use the following script in Developer Console to transfer Data from  tc9_ti__InvoiceDate__c to new field tc9_ti__Invoice_Date__c :

List<tc9_ti__fee__c> fees = new List<tc9_ti__fee__c>();

for(tc9_ti__Fee__c fee:[select tc9_ti__InvoiceDate__c,tc9_ti__Invoice_Date__c from tc9_ti__fee__c where tc9_ti__InvoiceDate__c!=null and tc9_ti__Invoice_Date__c=null order by createddate desc limit 10000]){
fee.tc9_ti__Invoice_Date__c = fee.tc9_ti__InvoiceDate__c.date();
fees.add(fee);
}

if(fees.size()>0)
update fees;

 

Exporting Transactions generated via “Process Invoice”  defaults to a US based date format

Transactions exported from Consolidated invoices (Client Invoices), previously had a US date format in the .CSV file (ie MM/DD/YYYY)

This has been updated, and the transaction dates exported in the .CSV file will now be based on the logged in users locale. (ie. If the user locale is Australia then the date format will be DD/MM/YYYY)


List index out of bounds: 0 when attempting to re-invoice

When a user selected ‘Create New Transactions and Invoice’ on the Re-Invoice Function, it produced the following error report – “List index out of bounds: 0 error occurs”.

This has now been fixed. There are no modifications required.

Version 1.118

Javascript in Salesforce Critical Update
Placement Start Date / End Date Validation
Remove currency validation
Update to Process Invoice to Group by Currency
‘From’ email address to be custom instead of user’s (consolidated invoice)
Tax Treatment for Expenses

Version 1.118

Javascript in Salesforce Critical Update 

Critical Setup Required

In October 2017 there will be a series of critical updates activated by Salesforce that are in relation to disabling the use of JavaScript within buttons, links and formula fields. As such, a number of the TimeCards buttons have been updated to accommodate this update.

Below is a list of all the buttons and fields that have been updated within the package. These buttons will continue to function with no configuration required.

Label Display Type Object Name
Compose Invoice Email Detail Page Button Consolidated Invoice
Create Credit Note Detail Page Button Consolidated Invoice
Delete Placement Detail Page Button Placement
New Job Fee List Button Fee
Preview Detail Page Button Consolidated Invoice
Re-Invoice Detail Page Button Consolidated Invoice
Send Credit Note Detail Page Button Consolidated Invoice
Send Invoice by Email Detail Page Button Consolidated Invoice
Timesheet Tool Detail Page Button Timesheet
Timesheet Tool List Button Timesheet
Update Failed to Ready Detail Page Button Timesheet
Update Failed to Ready List Button Timesheet
Timesheet Manager Field Button Timesheet
Bulk Remove Detail Page Button Payrun Batch
View Payrun Batch Field Button Payrun Batch


The following buttons are no longer in use and have been made inactive. These should be removed from the search layout for list views. If left on layouts, and the User clicks the button they will be presented with a message advising the button is no longer active.

Label Display Type Object Name
Approve Selected List Button Timesheet Entry
Approve List Button Timesheet Entry
Timesheet Manager List Button Timesheet


To set up –

  • Remove the Approve Selected and Approve List buttons from the Timesheet Entry Search Layout
Setup >  Create > Objects > Timesheet Entry > Search Layouts >  Edit Timesheet Entries List View > Remove the Approve Selected and Approve buttons from the selected buttons list 
  • Remove the Timesheet Manager list buttons from the Timesheet Search Layout
Setup >  Create > Objects > Timesheet  > Search Layouts >  Edit Timesheet List View > Remove the Timesheet Manager buttons from the selected buttons list 

Note: It is suggested that in place of the Timesheet Manager list button, list views should be updated to include the Timesheet Manager field. This field will allow Users to quick launch the Timesheet Manager from each record listed

 

Placement Start Date / End Date Validation

A new validation rule has been added to ensure that the Start Date of the Placement must be equal to or earlier than the Placements End Date.

 

Remove currency validation

Optional Setup

In Timecards there is validation to ensure the currency of the job is maintained for all related child records – from Job Order to Payun Batch and Invoice. It has been identified that some Organisations have a business need to be able to update the currency of certain child records such as the placement.

To support this, we have now introduced a new field, Disable Currency Validation, within the TimeCards Config custom setting. When set to True, validations that ensure the currency is maintained from the Job order through to the Payrun Batch and Invoice will be turned off. Currencies will flow down on creation of the record as normal but Users will be able to amend the currency after creation.

Important Note: Organisations should ensure a thorough assessment of their need to turn off the currency validation prior to disabling the currency validation. When the validations are off, Users with profile access will be able to change the currency of most of the child records. This could impact things such as reporting and data consistency. Further, if at a later time an Organisation chooses to re enable the currency validation, any records that had their currency updated while it was disabled will fail validation and will need to be updated.

 

To set up (optional) –

  • Disable the currency validation via the Custom Setting

    Setup > Custom Setting > TimeCards Config > Disable Currency Validation = True (ticked)

 

Update to Process Invoice to Group by Currency

Process Invoice has been updated to incorporate currency grouping. Now, when there are transactions of different currencies to be processed, the Consolidated Invoice will automatically be split into multiple Consolidated Invoices, one per currency. This will ensure that the currency of the overall Consolidated Invoice matches the currency of all the related Transactions.

 

‘From’ email address to be custom instead of user’s (consolidated invoice)

Optional setup required

Previously when Consolidated Invoice emails were sent they were sent ‘From’ the user who initiated the send. New functionality has been created to enable Users/System Admin to define a ‘From’ email address that the invoices will be sent from at an organisation and client level.

The email address that invoice emails can be sent from must be a defined as an Organisation-Wide Address before it can be used. Likewise users will only be able to send emails from an Organisation-Wide Address that they have profile access to use. If the email address is not defined as an Organisation-Wide Address, or the user does not have access to use the Organisation-Wide Address, emails will not be sent and a debug header/log reflecting the failure to send will be raised.

On the Account record, 2 new fields have been added:

‘Send Invoice Emails Setting’

When Consolidated Invoices are emailed, this field defines where the from / reply email address will be taken from. When an email is sent, this value on the Bill To Account related to the Consolidated Invoice will be used. It is a pick list with the following values:

    • Current User (default) – the email(s) will be sent from the current user
    • Account Defined – the email(s) will be sent from the email address defined in the “Send Invoice Emails From Email” field on the related Bill To Account
    • Billing Entity Defined – the email(s) will be sent from the email address defined in the “Send Invoice Emails From Email” field on the related Billing Entity
    • Organization Defined – the email(s) will be sent from the email address defined in the “Send Invoice Emails From Email” field in the TimeCards Config custom setting
    • Note: if the Send Invoice Emails Setting field is left blank the email(s) will be sent from the current user

‘Send Invoice Emails From Email’ –

When the Account’s Send Invoice Emails Setting defines the email source as ‘Account Defined’ or ‘Billing Entity Defined’ the email address defined in this field will be used as the from / reply to email when emailing consolidated invoices. The email addresses available on this picklist should be created by system admin at the time that the Organisation-Wide Address is created.

In the TimeCards Config custom setting a new field has been added:

‘Send Invoice Emails From Email’ –

When the Account’s Send Invoice Emails Setting defines the email source as ‘Global Email’ the email address defined in this field will be used as the from / reply to email when emailing consolidated invoices

To set up –

  • Create Organisation-wide email address
Setup > Email > Organisation-wide addresses > Add

Display Name: Enter the name you would want the email to be displayed as to the recipient ie 2Cloudnine

Email Address: The actual email address the email will be sent from / replied too ie support@2cloudnine.com

Define the profiles that will have access granted to use the organisation-wide email address

Click Save
  • Provide profile access to the below listed Account fields. Users who will populate/update these fields will require read/write access. Users who will send the Consolidated Invoice emails will require read only access.
- Send Invoice Emails Setting
- Send Invoice Emails From Email 
  • Add email addresses as pick list values on the Account Objects Send Invoice Emails From Email field
Setup > Customise > Accounts > Fields > Send Invoice Emails From Email  > Values > New > Email address that matches the value entered in the email address field within the Organization-Wide Email Addresses setup.

Ensure the picklist values are only available for the record types you require. I.e if you want a given email to only be available on the picklist if the email is being sent from the Billing Entity make it only available for the Billing Entity Record Type.
  • Deactivate the Sample 1 pick list value from the Account objects Send Invoice Emails From Email field
Setup > Customise > Accounts > Fields > Send Invoice Emails From Email  > Values > click deactivate next to the Sample 1 value.
  • Add the email address that will be used when the Organization Defined option is selected into the Send Invoice Emails From Email within the TimeCards Config Custom Setting
Setup > Custom Setting > TimeCards Config > Send Invoice Emails From Email > Email address that matches the value entered in the email address field within the Organization-Wide Email Addresses setup
  • Update the Send Invoice Emails Setting and Send Invoice Emails From Email fields on Account/Client and Billing Entities as required.

Note – the Send Invoice Emails Setting is defaulted to be Current User so if these fields are not updated emails will continue to be sent from the logged in user as they were with previous releases.

 

Tax Treatment for Expenses

Setup required

Previously, there has been feedback in relation to the clarity of expense and attributed tax entry and the subsequent transaction handling. As a result we have introduced a series of improvements to ensure ease of use and the correct pay and invoice handling.

The existing “Value” field has been re-labeled to be “Pre Tax Value” and a new “Expense Total (including Tax)” field has been introduced to hold the tax inclusive tax amount. The Timesheet Manager and Candidate entry/approval pages have been updated to automate the population of the expense. Users are now asked to enter the Expense Total (including Tax) and the Tax Value. From there the Pre Tax Value and attributed Tax Rate are automatically calculated.

Further field mapping on transactions has been updated to reflect the new fields

Transaction Field Source
Adjusted_BillRate__c Expense__c.Value__c
Adjusted_PayRate__c Expense__c.Expense_Total_including_Tax__c
BillRate__c Expense__c.Value__c
PayRate__c Expense__c.Expense_Total_including_Tax__c
Taxable__c Expense__c.Taxable__c
Tax_Amount__c Expense__c.Tax_Amount__c
TaxRate__c Expense__c.Tax_Amount__c / Expense__c.Value__c

To set up –

Provide profile access to the Expense__c.Expense_Total_including_Tax__c field for all Users who will be entering and viewing expenses. This should include communities and guest site user profiles.

Version 1.117

Validation for Client on Job Order and Placement must match
Partial Re-Invoice
Send Secondary Approver when Scheduled Send Approver Emails method is in use
Process Invoice VF Page – Transaction Filters radio option
Timesheet visibility for Candidates Communities Portal
Invalid Time Popup on Timesheet Entry pages of Candidate Communities Portal
General bug fixes and improvements

Version 1.117

 

Validation for Client on Job Order and Placement must match

Validation has been added to ensure that once a Job Order has one or more related Placements, the Client on the Job Order can not be changed. Likewise the Client on the Placement must remain the same as the Client on the related Job Order.

 

Partial Re-Invoice  

Critical setup required

When completing credit / re-invoice activities, previously the re-invoice could only be completed once. If the User removed Transactions from the list during the re-invoice activity there was no avenue for them to be able to re-invoice the removed Transactions once the Consolidated Invoice was generated.

New functionality has been added to enable the re-invoice of the previously removed Transactions. Once the initial re-invoice is created, if the User clicks the Re-Invoice button, they will be presented with a list of all the Transactions related to the credit note. The Transactions that have already been re- invoiced will be displayed as ‘Invoiced’ and can not be edited. The previously removed Transactions can be edited as needed and then a new invoice generated. This activity can be completed as many times as needed until all Transactions have been invoiced.

This functionality can be particularly useful when a User needs to split an invoice into multiple invoices after the initial generation.

To set up –

Provide profile access to the below listed fields. Users who create credit notes and re-invoice will require read/write access:

  • Has been reinvoiced (tc9_ti__Has_been_reinvoiced__c) on the Transaction (tc9_ti__Transaction__c) object
  • Has been reinvoiced (tc9_ti__Has_been_reinvoiced__c) on the Fee (tc9_ti__Fee__c) object

Run the below scripts in the Developer Console to ensure  the “Has been reinvoiced” field on historic credit note related Transactions has been populated.

Navigate to Set up > Developer Console > Debug > Open Execute Anonymous Window 

Then insert the following script:

// SCRIPT TO UPDATE TRANSACTIONS' HAS BEEN REINVOICED FIELD
List<tc9_ti__Transaction__c> transList = new List<tc9_ti__Transaction__c>();

List<tc9_ti__Consolidated_Invoice__c> conInvIdList = [select id,recordtypeid from tc9_ti__Consolidated_Invoice__c where recordtype.developerName like 'Credit%' LIMIT 10000];
integer totalInv = [Select Count() From tc9_ti__Consolidated_Invoice__c Where recordtype.developerName like 'Credit%' LIMIT 10000];

if (!conInvIdList.isEmpty()) {
 system.debug('Total invoices found: ' + totalInv);
 for(tc9_ti__Transaction__c trans:[select tc9_ti__Has_been_reinvoiced__c from tc9_ti__Transaction__c where tc9_ti__Has_been_reinvoiced__c = false and tc9_ti__Consolidated_Invoice__c in: conInvIdList]){
 trans.tc9_ti__Has_been_reinvoiced__c = true;
 transList.add(trans);
 }
}

// please uncomment the following line for DML operation
// update transList;

Run the below scripts in the Developer Console to ensure  the “Has been reinvoiced” field on historic credit note related Fees has been populated.

Navigate to Set up > Developer Console > Debug > Open Execute Anonymous Window 

Then insert the following script:

//SCRIPT TO UPDATE FEES' HAS BEEN REINVOICED FIELD
List<tc9_ti__fee__c> feeList = new List<tc9_ti__fee__c>();
List<Id> feeidList = new List<Id>();
List<Id> conInvIdList = new List<Id>();

for(tc9_ti__Consolidated_line__c conInv:[select id,tc9_ti__Invoice__c from tc9_ti__consolidated_line__c where tc9_ti__consolidated_invoice__r.recordtype.developerName like 'Credit_Fee'])
  conInvIdList.add(conInv.tc9_ti__Invoice__c);

for(tc9_ti__InvoiceItem__c inv:[Select tc9_ti__fee__c From tc9_ti__InvoiceItem__c where tc9_ti__Invoice__c in:conInvIdList])
  feeidList.add(inv.tc9_ti__fee__c);

for(tc9_ti__fee__c fee:[select id,tc9_ti__has_been_reinvoiced__c from tc9_ti__fee__c where tc9_ti__has_been_reinvoiced__c = false and id in: feeidList]){ //Add 'limit 1000' to this query if timeout errors occur
 fee.tc9_ti__has_been_reinvoiced__c = true;
 feeList.add(fee);
}
update feeList;

 

Send Secondary Approver when Scheduled Send Approver Emails method is in use

Optional setup required

Previously when an Organisation is sending timesheet approver emails via the scheduled method the Send Secondary Approver button on Placement could not be used to send approver emails to the Secondary Approver.

A new workflow, SendApproverEmailRuleForScheduledSend, has been introduced for use when the scheduled method of sending approver emails is in use which will also allow the successful use of the Send Secondary Approver button on Placement.

To set up (optional) –

Only to be used when the scheduled method of sending approver emails is in use within an organisation.

  • Navigate to the SendApproverEmailRuleForScheduledSend workflow
Setup > Create > Workflow Rules > SendApproverEmailRuleForScheduledSend

Note, the Workflow Rule has an immediate workflow action of ‘SendApprovalEmail’. This Email Alert is set to send the packaged ‘NotifyTimeSheetApproverTimeSheetReady’ Email Template. In the instance where an Organisation is using custom Email Templates for their Approver Emails, the Email Alert should be updated to point to the desired Email Template.

  • Activate the SendApproverEmailRuleForScheduledSend workflow

 

Process Invoice VF Page – Transaction Filters radio option

Optional setup required

Previously, on the Process Invoice page the Standard Invoice Filters / Transaction Filters radio option would default to have Standard Invoice Filters selected when the page opens. Now, for Organisations that use Transaction Filters as their preferred method of filtering, we have introduced a custom setting that allows them to set Transaction Filters as the default when the page loads.

The setting can be found in the Timecards Config and is called Default Transaction Filters Invoicing. If unchecked (False), the page will open with Standard Invoice Filters selected. If checked (True), the page will open with Transaction filters selected.

To set up (optional) –

Set the Process Invoice page to open with Transaction Filters defaulted via the Custom Setting

Setup > Custom Setting > TimeCards Config > Default Transaction Filters Invoicing = True (ticked)

 

Timesheet visibility for Candidates Communities Portal

Optional setup required

Previously a timesheet would become visible on the Timesheet Submission pages of the Candidate Communities Portal on the Start Date of the Timesheet. For the duration of the Timesheet (Start Date to End Date) it would be listed under the Current Tab and then move to the Overdue Tab on the day following the End Date.

Now, at an Organisation level, delays can be set for when Timesheets will appear on the portal as well as how long it will remain on the Current tab before moving to Overdue. This is enabled by two fields within the TimeCards Config custom settings. Days til Current Timesheet Visible defines how many days after the Timesheet Start Date before the timesheet will become visible. For example if the timesheet period was 24th July to the 30th July and the Days til Current Timesheet Visible is set as 5 then the Timesheet would not become visible on the Current Tab until 28 July.

Days Until Timesheet Overdue defines how many days after the Timesheet End Date a timesheet will remain on the Current Tab before moving to the Overdue Tab. For example, if the timesheet period was 24th July to the 30th July and Days Until Timesheet Overdue is set as 3 then the Timesheet would remain on the Current Tab up to and including the 2nd August and move to the Overdue Tab on the 3rd August.

These are optional settings, and if nothing is defined, Timesheets will become visible on the Timesheet Start Date and move to the Overdue Tab the day following the Timesheet End Date.

To set up (optional) –

  • To set a delay on when the Timesheet will become visible on the Timesheet Entry pages of the Candidate Communities Portal
Setup > Custom Setting > TimeCards Config > Days til Current Timesheet Visible = enter the number of days required
  • To define how long the Timesheet will remain on the Current Tab after the Timesheet End Date
Setup > Custom Setting > TimeCards Config > Days Until Timesheet Overdue = enter the number of days required

 

Invalid Time Popup on Timesheet Entry pages of Candidate Communities Portal

A number of Organisations have advised of issues with not being able to close the Invalid Time popup on the Timesheet Entry pages of Candidate Communities Portal. To resolve this persistent issue, the invalid time popup has been removed and instead an error message will be displayed directly on the screen.

 

General bug fixes and improvements

General bug fixes and improvements have been applied to the following:

  • Debug log reporting and error messages
  • Improvement to the Create Consolidated Invoice Transactional Invoicing page layout
  • Invoice Template Pagination
  • Ordering of pay codes in Timesheet Manager picklists to be alphabetical
  • User interface improvement on the Preview Payrun page

Version 1.116.2

Duplication of Transactions from TS Manager

Version 1.116.2

 

Duplication of Transactions from TS Manager

An issue was reported where when the Revert to New button was used within the Timesheet Manager, where transactions were not deleted correctly, duplicate transactions could be created when Transactions were re-processed. Additional validation and checks have been added to the Transaction Processing process to ensure that if a timesheet has been reverted to New all the required Transactions have been deleted before new transactions are created.

Version 1.116

Consolidated Invoice Email CC Validation
Consolidated Invoices List View Send By Email functionality update
Daily Awards Set Up to include leave accruals
Purchase Order Number display on Perm Invoices/Perm Invoice Template
Filtering Allowance Paycode Picklist
Record Limit Error when Scheduled job to Create Invoice Attachments Processes
Invoice Totals not populated on Fee Consolidated Invoice
TimeCards Batch Size custom setting
Adding Credit Reason when creating Credit Notes
Re-invoice for fee invoices
Credit Invoice and Rebill Tracking
Inclusion of a Link to Re-Invoiced Consolidated Invoices when created
Fees with 0 or negative Invoice Tracking
Revert to New – exclude flagged transactions
General bug fixes and improvements

Version 1.116

 

Consolidated Invoice Email CC Validation

The validation on the Invoice Email CC field on the Consolidated Invoice object has been updated to allow the additional characters of underscores (_) and hyphens (-). In addition the validation will now allow non-ordinary domain names such as email addresses that don’t  contain ‘.com’ or ‘.net’.

 

Consolidated Invoices List View Send By Email functionality update

Updates have been applied to the Consolidated Invoice’s Send By Email list view button to accommodate when records selected from the list view includes both invoice and credit note record types. This update ensures that the correct invoice template is used for all records selected.

 

Daily Awards Set Up to include leave accruals

Previously the Daily Awards did not have the ability to define Leave Rates. This functionality has been added via a Daily Award that operates in the same way as the Ordinary Hours, Regular and Shift awards.

To define Leave Types on Award Masters the following setup is required:

Setup the Leave types that will be available for use:

The Leave types that are listed on the Award Master for use are pulled from the picklist values defined in the Leave Type field on the Timesheet Entry. 

To add/modify the leave types listed, the picklist values must be created/modified: 
 
Setup > Create > Object > Timesheet Entry > Leave Types > Values > New > add as leave types as required

Purchase Order Number display on Perm Invoices/Perm Invoice Template  

Setup required

A new column has been added to the package Perm Invoice Templates to display the related purchase order number. The value displayed within this column is taken from the related Invoice’s Purchase Order Number field.

This change has been made to the following invoice templates

  • PermInvoice_v2
  • PermInvoice_US_v2
  • PermInvoice_NZ_v2
  • CreditPermInvoice_NZ_V2
  • Credit_PermInvoice_US_v2
  • Credit_PermInvoice_v2

The following setup is required (only required if using packaged invoice templates):

  • The column label is defaulted as “PO No” however this can optionally be changed by adding a transaction to the Invoice PO custom label
     Setup > Create > Custom labels > Invoice PO > Translations > New 
    Ensure the Purchase Order Number field on the Invoice object is enabled to be visible to the Guest Site User profile.

 

Filtering Allowance Paycode Picklist 

Setup required

Previously when adding an Allowance to a Timesheet in the Allowances section of the Timesheet Manager, Users were presented with a list of Pay Codes that included all the pay codes created within the organisation. This can cause confusion when the same pay code name was used for different pay code record types. Now a filter has been applied to the picklist to ensure that only pay codes with the Record Type of Allowance are listed.

To ensure the picklist continues to list allowance pay codes, ensure that the pay codes have the correct record type assigned.

 

Record Limit Error when Scheduled job to Create Invoice Attachments Processes

An issue was reported that when an Organisation has a high number of Consolidated Invoices that have not had PDF attachments created, a system limit error can occur when the Scheduled job to Create Invoice Attachments (ScheduleCreateInvoiceAttachments) runs.

A limit of 4000 Consolidated Invoices per scheduled job has now been applied to ensure this error no longer occurs. Where the organisation has more than 4000 Consolidated Invoices without PDFs generated, those above 4000 will be left not generated until the next time the scheduled job runs.

 

Invoice Totals not populated on Fee Consolidated Invoice

An issue was reported that Invoice Total Fields are no longer populating on Consolidated Invoices which are derived from Fees. This issue has now been resolved.  

 

TimeCards Batch Size custom setting

Setup required

Previously fields for holding batch size overrides were located within several custom settings. These have now been moved to a central Timecards Variable Settings custom setting.

The following setup is required:

Run the below script in the Developer Console to ensure that the existing batch size overrides within the organisation are maintained 
 
Set up > Developer Console > Debug > Open Execute Anonymous Window 
 
Then insert the following script

tc9_ti__ToCloudNineConfig__c old_config = tc9_ti__ToCloudNineConfig__c.getOrgDefaults();
 tc9_ti__TCS_Variable_Settings__c new_config = tc9_ti__TCS_Variable_Settings__c.getOrgDefaults();
 new_config.tc9_ti__Create_Payrun_Batch_Size__c = old_config.tc9_ti__Create_Payrun_Batch_Size__c;
 new_config.tc9_ti__Generate_Timesheet_Batch_Size__c = old_config.tc9_ti__Generate_Timesheet_Batch_Size__c;
 new_config.tc9_ti__Merge_Invoice_Emails_Batch_Size__c = old_config.tc9_ti__Batch_Limit_MergeInvoiceMails__c;
 new_config.tc9_ti__Process_Timesheets_Batch_Size__c = old_config.tc9_ti__Timesheets_in_ProcessTimesheetsBatch__c;
 upsert new_config;

 

Adding Credit Reason when creating Credit Notes

New functionality has been added to the credit note process to force the User to select a predefined credit reason before they can create a credit note. This functionality is optional and is switched on via the ‘Enforce Credit Note Reason’ field within the TimeCards Config custom setting.

When Enforce Credit Note Reason = TRUE (ticked), if the User clicks the ‘Create Credit Note’ button on the Consolidated Invoice record, they will be presented with a page asking for the credit reason before they can continue to create the credit note. When Enforce Credit Note Reason = False (unticked) the credit note will be created when the ‘Create Credit Note’ button is clicked as normal.

To use this functionality the following setup is required:

  • Define the Credit reasons available for the User to select. 
     These are defined as values on the Credit Reason field on the Consolidated invoice Object.
     
     Setup > Create > Object > Consolidated invoice > Credit Reason > Values > New > add as credit reasons as required
Ensure the Users have profile access to the Credit Reason field on the Consolidated Invoice object.

Turn the Enforce Credit Note Reason functionality on via the custom setting
 
 Setup > Custom Setting > TimeCards Config >  Enforce Credit Note Reason = True (ticked)


Re-invoice for fee invoices

Previously the Credit / Re-Invoice functionality only accommodated the credit / re-invoice of transaction based invoices. This functionality has now been extended to accommodate Fee based invoices. Users will be able to Re-Invoice Fee Credit Notes, adjust the line descriptions, Ex Tax Amount and Tax Amount as well as totally remove a line from the invoice if required.

 

Credit Invoice and Rebill Tracking

New functionality has been introduced to enable easier tracking of Re-Invoiced Consolidated Invoices related to the original Credit Note. Now if a Consolidated Invoice has been created via the Re-Invoice functionality the Re-Billed field on the Consolidated Invoice will be set as True (ticked) and the Original Credit Note field will be populated with the related Credit Note.

This coupled with the existing functionality that links a Credit Note to the Original Invoice will enable Users to easily track their Consolidated Invoices to Credit Notes and then to Credit Notes and vice versa.

 

Inclusion of a Link to Re-Invoiced Consolidated Invoices when created

Previously, when a Consolidated Invoice is successfully created using the Re-Invoice functionality an on screen message is displayed to advise the User that the invoice was successfully created however it did not provide a link to the newly created Consolidated invoice. Users had to go back to their Consolidated Invoice list views to open/view the new invoice. Now the onscreen success message will include a link to the new Consolidated Invoice.

 

Fees with 0 or negative Invoice Tracking  

setup required

In TimeCards version 1.113, Tracking of Transactions not included in Invoices due to 0 value, we introduced the new “Not Required” value for the transactions “Invoiced?” field to identify if a transaction has not been invoiced due to the Enable 0 and Negative Invoices setting = False. This functionality did not extend to Fee based invoices. The functionality has now been updated for Fee based invoices.

To extend this functionality to Fees the following setup is required

Add new picklist value to Fee Invoiced? Field
 Setup > Create > Object > Fee > Invoiced? > Values > New > “Not Required”

 

Revert to New – exclude flagged transactions

optional setup

Previously, when the Revert to New functionality is used within the Timesheet Manager, it deletes the transactions that have been created and resets the Timesheet. Some organisations have reported that they have transactions that they do not wish to have deleted as part of the revert to new functionality.

These transactions include:

  • Manually created Transactions that have been added in the Transaction section of the Timesheet Manager
  • Transactions that have been loaded via external systems (ie data loaded)

Transactions created manually in the Transaction section of the Timesheet Manager will now have the Manual Entry field on the Transaction set to True (ticked) when they are created. Transactions with this field set as true will no longer be deleted as part of the Revert to New process.

Further, a new “Data Loaded Transaction” field has been added to the Transaction Object to identify Transactions that have been loaded externally. When Users are loading Transactions via external means they should set this field to True (Ticked) as part of the data load.  Transactions with this field set as true will no longer be deleted as part of the Revert to New process.

The setup required is to ensure that any external methods used for loading Transactions data are updated to include the population of the Data Loaded Transaction field to be True. 

 

General bug fixes and improvements

General bug fixes and improvements have been applied to the following:

  • Debug log reporting and error messages
  • Process invoice page validations
  • Award Master page validations

Version 1.115

Duplicate Deductions when Deduction Creation Previously Failed
Timeout issue on Payrun Batch VisualForce Page
Timeout issue on Process Invoice VisualForce Page
TCS Apex Job Log Status for Fees

Version 1.115

Duplicate Deductions when Deduction Creation Previously Failed

Previously, if Deduction Creation Failed for a Payrun Batch there were instances when the process was re-ran there would be duplicate Deductions Transactions created. This issue has now been resolved.

Timeout issue on Payrun Batch VisualForce Page

Some clients have been reporting cases where ‘nothing’ appears to happen when they attempt to process a new Payrun, (ie. Create Payrun Batch button is selected and the Payrun Batch filter screen does not show any change).

This issue is caused by a Salesforce CPU time limitation. As Payrun Batch has a high volume of filtering and validation ‘pre-processing’ needing to be completed within a short Salesforce CPU window, Payrun Batch processing may not commence as pre-processing has not been completed within the allowable CPU time.

To resolve this, processing phases for Payrun Batch creation has now been split into two parts.

Part 1 is the ‘validation stage’. This stage will check the filters entered by the user and confirm if there are transactions that meet the filter conditions to be processed.

Part 2 is the create Payrun Batch stage. Once the Validation Stage is complete, users will be required to select ‘Process’ to commence creation of the Payrun Batch(s).

Timeout issue on Process Invoice VisualForce Page

Some clients have been reporting cases of where ‘nothing’ appears to happen when they attempt to process invoices, (ie. Process Invoice button is selected and the Process Invoice filter screen does not show any change).

This issue is caused by a Salesforce CPU time limitation. As Process Invoice has a high volume of filtering and validation ‘pre-processing’ needing to be completed within a short Salesforce CPU window, Invoice processing may not commence as pre-processing has not been completed within the allowable CPU time.

To resolve this, processing phases for Process Invoice creation has now been split into two parts.

Part 1 is the ‘validation stage’. This stage will check the filters entered by the user and confirm if there are transactions that meet the filter conditions to be processed.

Part 2 is the creation of invoice stage. Once the Validation Stage is complete, users will be required to select ‘Process’ to commence creation of Consolidated Invoices.

Note: This change only applies for Processing of Invoices by Batch. Ie Setup > Custom Settings > TimeCards Config > Process invoice by Batch = True

TCS Apex Job Log Status for Fees

Previously, when Fee Invoices were created the Apex Job Logs Status was not updating to “Completed” once process was complete. This is now resolved.

Version 1.114.1

Buttons Available for Users in Timesheet Manager
Candidate Notes not visible in Timesheet Manager when status = Approved

Version 1.114.1

 

Buttons Available for Users in Timesheet Manager

The functionality to hide the Add Transaction button within the Timesheet Manager, introduced in release v1.100 (see release note Custom Setting to remove Add transaction button on Timesheet Manager), has been extended to include other buttons within the page.

Now, in addition to applying an overall function to hide the button, System Administrators can specify on an individual User basis if they should be given access to the button via the “Enable Timesheet Manager Add Transaction” field on the User record.  When this field is set to TRUE, the user will be able to use the Add button to add transactions to a Timesheet regardless of the value of the Hide_Timesheet_Manager_Add_Transaction__c field within the Timecards Config custom setting.

Similar functionality has also been added to define the User visibility of the Submit, Approve, Reject and Revert to New buttons.

Button Field to hide button globally Field to make button visible at User level
Add Transaction Timecards Config Custom Setting  “Hide Timesheet Manager Add Transaction” field User “Enable Timesheet Manager Add Transaction” field
Submit Timecards Config Custom Setting  “Hide Timesheet Manager Submit” field User “Enable Timesheet Manager Submit” field
Approve on Behalf Timecards Config Custom Setting  “Hide Timesheet Manager Approve” field User “Enable Timesheet Manager Approve” field
Reject Timecards Config Custom Setting  “Hide Timesheet Manager Reject” field User “Enable Timesheet Manager Reject” field
Revert to New Timecards Config Custom Setting  “Hide Timesheet Manager Revert” field User “Enable Timesheet Manager Revert” field

 

Candidate Notes not visible in Timesheet Manager when status = Approved

Previously, in the timesheet manager, if the timesheet is approved then the notes icon disappears preventing users from being able to view the note. The notes icon will now be visible when the timesheet is approved. This will allow Users to easily review notes historically.