Re: dates in Emerald

Dale E. Reed Jr. ( (no email) )
Mon, 15 Dec 1997 15:27:48 -0800

Josh Hillman wrote:
> Are there any plans for future releases of Emerald to have Invoice.Date
> include the time as well as the date (e.g. Dec 15 1997 3:42PM instead of
> 12:00AM)? When presenting invoices/payments/charges, etc. in order by
> eventdate/time, these get out of their correct order. The most common
> place where this occurs is in the History area of an MBR. If there are
> several invoices/charges/payments for an individual MBR in one day, these
> events are displayed in the wrong order because the Invoice.Date doesn't
> track the time that it was created.

In all my databases here, it does? Invoice.Date is a DateTime, which
is accurate to the second. It may be that the 2.1 client is using the
local date, rather than GetDate() to producde the date. All versions
of Emerlad 2.2 and higher use GetDate() for stamps, rather then the
local computer.

> Also, has "the next release" of Emerald been fixed, such that if an invoice
> is VOIDed then saved, the Invoice.LastModifyDate gets updated to GetDate()?


> Presently, anytime I void an invoice that was created in a month prior to
> the present month, I have to go and manually modify the LastModifyDate so
> that that "sale" can be removed/adjusted off of the accounting records for
> a previous month.

Interesting side note, what about the MasterAccounts entry? VOIDING an
invoice changes the MasterAccounts balance field. SHould the LastModify
be updated there as well.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |