Re: Looking for inventory management and invoicing programs

Ian Mavric wrote:
>
> Good point Rick, but I think most of the problematic issue with Y2K related
> to how data files are treated during the change over from 1999 -> 2000.
>
> A database created in 1989 might use MM/DD/YY and so may have a record dated
> 01/01/89. One can see the confusion about adding a record today 06/30/05
> might be seen as 1905 to the TRS-80 or operator...
>
> However in the case of our friend Conceited Jerk (his name, not his persona)
> he would know his database (or inventory) started in 2005, and so 05 would
> be no more confusing to the operator than 89 was back in 1989.
>
> If that Inventory is still running in 2100... well... I guess he's got 95
> years to work out a solution...
>
> Ian.

Hee. 8-)

It would need to be looked at. When I went through my own version of
"y2k hell" I found that some accounting and financial programs not able
to deal with dates after 12/31/1999 did many different things, none of
with allowed the programs to function. (Well, no purposeful function
anyway...):

Scenario one: The programs didn't "revert" to the year 1900 (vs. 2000)
in date fields. Instead, they inserted the next ascii character in
sequence into the date field after the character "9". On those programs
"00" was reported as "0:" or another such non number.

Scenario two: Accounting program used 4 digits for data in the year
field - you could still enter data just fine. *But* the program used two
digit years in the report generation coding. So you could enter tons of
data, but you couldn't do anything with it - generate reports, reconcile
account balances etc. - for any dates after 12/31/1999.

Scenario three: The year reported was off by -30 years. 01/05/2000 was
reported as 01/05/1970. Go figure on that one.

Scenario four: Database program generated "automatic dates" using Julian
numbers. It simply went nuts trying to report dates after 12/31/1999.
The Julian part was probably still right, but translating it into a year
in a date field wasn't working.

How quickly we all forget how much of a headache y2k rollover was for
(some) accounting and data entry programs. Good luck to the OP with the
programs.

Rick


>
> "Rick" <rickajho@xxxxxxx> wrote in message news:42C374C6.A55D125E@xxxxxxxxxx
> > Conceited Jerk wrote:
> > >
> > > Hi all!
> > >
> > > I'm looking for both inventory management and invoicing programs for
> > > either my Coco 3 or my newly-acquired TRS-80 Model 4P.
> > >
> > > I'm starting a sort-of side business and want to get my "old" hardware
> > > into the act. Much cooler and eye-catching than a generic PC...
> > >
> > > Any help would be greatly appreciated!
> > >
> > > CJ
> > >
> >
> > Ummm, I guess the one question I see here that no one is asking is "Is
> > this stuff even close to being y2k compliant?" Especially the invoicing
> > program. What's the last date entry these programs can deal with?
> >
> > Anybody know?
.

Relevant Pages

  • Re: Copying Report from another database
    ... "Rick B" wrote: ... >> I have copied a report from a database into another database. ... I changed the Record Source to reflect the new database. ...
    (microsoft.public.access.reports)
  • Re: Exclusive access to the database
    ... Do you mean that two managers can't modify the same report at the same time ... "Rick B" wrote: ... You should split your database into Front-End and BAck-End. ...
    (microsoft.public.access.security)
  • Re: Eliminating unnecessary data in a report
    ... To do what you want in a DATABASE, you would create a new record in a table ... a normalized database would include one record for each account in your ... Rick B ... in my report ...
    (microsoft.public.access.reports)
  • Sql 2k NT Group Question
    ... I have Month End database, which is a frozen copy of the production ... and used by accounting for reporting purposes. ... A report user is present, and this report user owns the tables ...
    (microsoft.public.sqlserver.security)
  • Re: Change Data for Check Box
    ... Rick B ... > I have a database that i use check boxes to track completion of certain ... > However the default data for check check boxes when check enters a -1 into ... > report so it shows up as a check or an x, ...
    (microsoft.public.access.reports)