quite a few years ago, we did a customisation for this by adding a custom link field on the time record showing the invoice. we populated that field after an invoice was created. that solved the problem for the customer.

the value you want is in that Time sublist on the Invoice object

here is how we solved it as an after submit User Event on Invoice save.

function afterSubmitUpdateTimeTracking(type)

{

//get the current invoice record

currentRecordId = nlapiGetRecordId();

// nlapiLogExecution ( 'DEBUG', 'current record id', currentRecordId );

var currentRec= nlapiLoadRecord('invoice',currentRecordId);

// Get the number of line Time Tracking items submitted

lines = currentRec.getLineItemCount('time');

//parse the list of time records

for ( var i=1; i<=lines; i++ )

{

//get the ID of the Time Tracking

var timeRecId = currentRec.getLineItemValue('time', 'doc', i);

nlapiLogExecution ( 'DEBUG', 'time rec id', timeRecId );

var timeSelected = currentRec.getLineItemValue('time', 'apply', i);

nlapiLogExecution ( 'DEBUG', 'time selected id', timeSelected );

//if it's selected on the invoice, update its custom field

if (timeSelected == 'T')

nlapiSubmitField('timebill', timeRecId, 'custcol_related_invoice', currentRecordId );

else

{

//ensure that updates on invoices when Time Tracking records are unapplied

var timeRecord = nlapiLoadRecord('timebill', timeRecId);

var invoiceNoSet = timeRecord.getFieldValue('custcol_related_invoice');

if (invoiceNoSet != null)

nlapiSubmitField('timebill', timeRecId, 'custcol_related_invoice', null );

}

nlapiLogExecution('DEBUG', "title Record Updated", "Invoice=" + currentRecordId );

}

//log.debug({

//"title": "Record Updated",

//"details": "Invoice=" + currentRecordId

//});

}