AR_InvoiceHeaderHistory Time Stamp

SOLVED

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)?

Parents
  • 0

    Time created is time the document was originally created in the entry table..  Time updated is when the record was last written to.  In the case are AR_InvoiceHistoryHeader  that is when either the AR or SO sales journal was run and the invoice was updated from the invoice entry file to  AR_InvoiceHistoryHeader

  • 0 in reply to daburke

    from a user interface perspective what is happening? what i am seeing my folks do is type in SO, verify everything, then hit print. how would this translate to created vs updated? does 'print' = posting = updated?

  • +1 in reply to wtcrockett
    verified 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.

Reply
  • +1 in reply to wtcrockett
    verified 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.

Children
No Data