Re: inventory reporting

Hi
We are running version 6.002 BPCS CS.
My company produces milk and other just in time dairy products.  At any
given point in the day we may be taking orders and producing milk with 'no
inventory'.  The order program is from a third party vendor with an
interface written to affect inventories as items are ordered, then  picked
and then sold.
Here is the problem:  we have tried to do cycle counting but once an order
is ready to be picked it is immediately relieved from the BPCS inventory
total.  We may have the product in the cooler when the count was taken, but
by the time we get ready to key  in  the count, 400 transactions have
occured.  If you use one step cycle counting it doesn't total up all the
transactions for you and we only have a one hour window to get these keyed
into the system.  Our clerks don't have time to recalculate the count for
each and every item.  Has anyone used a different transaction or
modified/created a new cycle counting program?  What I think the cycle
counting should do is create an onhand balance at the time the cycle count
sheet was printed and let me work toward that balance not the balance at the
time I key the count in.
Any recommendations.  This is seriously hampering our efforts to expand our
use of BPCS.

Wendy DeCair
Country Fresh Inc
Suiza Foods
-----Original Message-----
From: Lacelle, Marc <LACELLE@rcmint.ca>
To: 'BPCS-L@midrange.com' <BPCS-L@midrange.com>
Date: Monday, June 21, 1999 3:20 PM
Subject: RE: performance


>Hi Roger.
>
> I am aware of the INV970D and all of the other Reorg options
>provided by BPCS. Beleive me,  run the SQL statements I mentioned below
>after running the INV970D. You will be surprised.
>
>> ----------
>> From: Wolf, Roger[SMTP:Roger.Wolf@garmin.com]
>> Reply To: BPCS-L@midrange.com
>> Sent: Monday, June 21, 1999 12:15 PM
>> To: 'BPCS-L@midrange.com'
>> Subject: RE: performance
>>
>> Forgive me.
>>
>> But, In BPCS405CD INV970 does the same thing.  We did one modification to
>> it to test the individual fields for zero instead of in total.  The users
>> wanted to see Opening Balance, receipts, adjustments and Issue.
>>
>> INV970 is on the system file clean up menu.
>>
>> Would hope there would be a similar thing in your release.
>>
>> Best Regards,
>> Roger Wolf
>>
>> -----Original Message-----
>> From:   Lacelle, Marc [SMTP:LACELLE@rcmint.ca]
>> Sent:   Monday, June 21, 1999 7:51 AM
>> To:     'BPCS-L@midrange.com'
>> Subject:        RE: performance
>>
>> Hi Ho.
>>
>>         This one can be tried by anyone who finds that their
>> response times
>> are slow. This will also improve your reporting times (INV230,INV260
>> .....)
>>
>> 1.      No users can be on when running these statements (very
>> important)
>> 2.      Do this right after month end
>> 2.      Backup the following files (ILI, IWI)
>> 3.      RUN THESE SQL STATEMENTS
>> 4.      delete from ???/ili where (lopb + lrct + ladju - lissu) = 0
>> 5.      The ??? is the name of your data library
>> 6.      delete from ???/iwi where (wopb + wrct + wadj - wiss) = 0
>> 7.      The ??? is the name of your data library
>>
>>         These statements can actually take a few minutes. It all
>> depends on
>> the number of records you have in these data files.
>>
>>         When I first wrote and tested these statements I was quite
>> surprised
>> to find that our ILI file went from 365,000 to 100,000 records (this took
>> about 10 minutes to execute).
>>
>>         Enjoy
>>
>>         Marc Lacelle
>>         Programmer Analyst
>>         Royal Canadian Mint
>>
>>
>>
>> > ----------
>> > From:
>> jos.kramer@kaochemicals.de[SMTP:jos.kramer@kaochemicals.de]
>> > Reply To:     BPCS-L@midrange.com
>> > Sent:         Monday, June 21, 1999 5:16 AM
>> > To:   BPCS-L@midrange.com
>> > Subject:      performance
>> >
>> > Dear Members,
>> >
>> > I would like to know if someone has tips on how to improve performance
>> on
>> > the
>> > following programms in BPCS 6.1:
>> >
>> > INV300, ORD550 (Action 12 allocations), ORD720 (order allocations).
>> > Generally all the programm that use allocations are extremely slow.
>> >
>> > Thanks in advance,
>> >
>> > jos.kramer@kaochemicals.de
>> >
>>
>>
>+---
>| This is the BPCS Users Mailing List!
>| To submit a new message, send your mail to BPCS-L@midrange.com.
>| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
>| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: dasmussen@aol.com
>+---
>

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---