Re: Sales Tax -- BPCS-L

Thanks for your ideas Al.

It looks like we have some corrupt program objects as a result of the power
outage (human error hit wrong button on UPS).  We will try and restore the
objects from backup before the power outage.

Thanks again,
Bob
----- Original Message ----- 
From: "Alister Wm Macintyre" <macwheel99@xxxxxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
Sent: Thursday, April 01, 2004 12:14 PM
Subject: Re: Sales Tax


Some obvious ideas to eliminate suspects:
    * Does the AS/400 have a UPS and is it hooked up properly and working
OK?  The batteries can run out so you end up with a UPS box but no
protection home.
    * Have you done a backup since this outage?  If physical files screwed
up, those files would not have successfully backed up.  You can look at
DSPLOG F4 for the time period of the backup to find out if it was
successful or not.
    * Have you had to do a BPCS restore recently and are all logicals in
same library name as their physicals?  There is a 400 integrity issue in
restores with respect to the alphabetical sequencing of library names and
needing to restore physical before its logicals.
    * DSPDBR lists logicals attached to any physical and what library they
in, and you can look at external description to check DATES someone messed
with the files
    * We had recent post in BPCS_L where some human by mistake created a
file incorrect earlier in library list than the real file which was correct
    * Have you had a change in personnel doing the work?  Human beings had
over-ride just about anything.  Do not rely upon 400 history of user-ids
... we had one dept hire some new person, not tell computer department,
have the new hire use sign on id of someone else in department.  I found
out when I was asked to make some BPCS security access adjustments for
REAL_USER_NAME and I said "Huh, that person name does not have a 400 sign
on?"
    * We don't do sales taxes ... If effectivity dates, or other rules
data, got changed then changed back, would you have any way of knowing?

Bob wrote:
>BPCS 6.02 Mixed mode.
>
>Any ideas what would cause Sales Tax to stop being calculated?
>The Effective Date in the ZRC has not changed they are all old dates and
>the current rates are populated.
> >From what we can see, the vendor tax code is in the ECH records, the
> item tax code is in the ECL records.  There is a corresponding record in
> the tax table (ZRT) but the BBL record no longer gets a Tax code put into
> the Tax Rate Code 1 (BLTR01) field.  This all seemed to work a couple of
> days ago.  We can see that the SIL records from then had tax codes in the
> Tax Rate Code 1 (ILTR01) field.
>
>As far as we know nothing has changed on the system but obviously
>something has happened.
>We lost power to the computer room the other day which meant the AS/400
>went down during lunch and not much was happening on the system.
>Could it be something like logical file indexes are screwed up so the
>Billing process is not finding records we can see?
>
>Thanks in advance,
>Bob
>__
_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.