AR_InvoiceHeaderHistory Time Stamp

Question

What are the differences between 'Time Created' and 'Time Updated' fields in the invoice history? Assuming they are my local times and that it is based on a 24 hour clock with decimals as fractions of the hour (e.g. 15.5 = 3:30 PM)?

Kevin M · Accepted Answer

Create an SO - does nothing related to invoice data. 
 Print an SO - does nothing related to invoice data. 
 Create an invoice (possibly from an SO) - sets the Date / Time "created" fields for the invoice. 
 Printing the invoice is irrelevant to the dates that appear in invoice history. 
 Posting the Sales Journal - moves the data from open invoice tables to AR invoice history and sets the Date Updated. 
 Note: some things have changed in recent versions, so to see exactly what happens in your system, go through all the steps in your process, using a test company, and see what the values mean in your version.

David Speck · Answer

As far as i know, the TimeCreated would be when the record is first created in the table, TimeUpdated however could be changed if you were to update the record using Visual Integrator at a later time. For the most part, i would expect the values to be the same or very similar unless you do a lot of updates via Visual Integrator. 
 You are correct regarding the way the time is stored. If you divide the value by 24, it becomes a time value that can be formatted to be displayed in any format you prefer. 
 Here's an example in Excel.

Sage 100

AR_InvoiceHeaderHistory Time Stamp

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING