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)?
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)?
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
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?
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.
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.
*Community Hub is the new name for Sage City