Re: inventory reporting

Hi

Does'nt BPCS create a work file (it uses the Inventory transaction Sequence
number to record the point at which the cycle count is generated ) and then when
you log a cycle count it compares the count to the figure at which the cycle
count was generated and updates the stocck.

Wendy DeCair wrote:

> 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
> +---



+---
| 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
+---