Cycle count

Folks,

We're getting ready to do a Cycle Count. After the previous manager at the
"sister company" kept inventory "off-line", we are going to zero out and
start again.

The plan is to zero out the inventory, then do a "Cycle Count" which will
really be a complete physical inventory. Still needing to review the
process, and never having done it myself, we will probably be able to get
through the Cycle Count steps.

The question is how to zero out the inventory for starters.

- Alan

Why "zero" it out...just count it. (After you "freeze" it by creating
the cycle count files) When you post it, it will create an ADJUSTMENT
from what it thinks it is (What you froze), to what you counted. Be
sure to set the flag in the cycle count record that says "zero" was
counted, otherwise you will have to actually key a zero for those items
with nothing on hand.

Alan -

Just one creative way to do it would be to run a cycle count first of all
items in your inventory then "count" zero for them all. That way you would
have it done in one batch and could add a comment that would appear in the
ledger as a reminder. Be sure to query the files after the zero count update
to make sure you got all of them. Then go merrily about doing your real
count.

I am recalling from memory based on A7.3 Cume 11.
(No longer employed)

Edie Elting,
Charlotte, NC

Hi,

There are two ways of doing this.

Alternative-1:
Through Cycle count program, enter on hand quantity as
'zero' and approve/update count. This will generate PI
entries and will affect GL.

You can revive realtime qty.on hand figs. in a
subsequent batch to reverse GL effect to the extent
the stocks are revived.

Alternative-2:
Go to 'As of' option in Inventory and enter stock as
'zero'.

Consider accounting needs while selecting any of these
methods.

I still would prefer that you enter exacr counted
stocks instead of zero-ising stocks.

Regards,

Niranjan
--- alanx <[email protected]> wrote:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=33562


__________________________________________________

just do a cycle count entering all the items with a zero
count. this will zero out your item balance counts and
also do a journal entry for value. post or not, it is up
to you.

Alan,

Are you going to keep your cardex for the prior
transactions? If not, you can clear the cardex
records (f4111) and the branch table (f41021). You
will still hve your purchasing an sales history for
any inventory reporting. You would then write you JE
to zero out your inventory accounts. Then run your
cycle count (for all items), enter you couns and
complete the cycle process. This will rebuild your
balances.

If you intend to keep your cardex information, you can
create an export file, reverse the remaining balances,
input using the interop tables and process as
inventory adjustments. This should create the JE's to
offset your GL balancs. After posting the entries,
make sure all inventory related transactions are
posted befor your count (sales end of day, purchasing
receipts and manufacturing WO completions). Create the
necessary JE to zero your inventory GL balances. Then
run your cycle.

If you need additional help, contact me off line.
--- alanx <[email protected]> wrote:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=33562


__________________________________________________


World, OW B733X and Xe

Thank you Cgraves, Edie, Eileen, Mike, Niranjan, for your helpful comments.

I should have mentioned we're on V 7,3, cum 10.

Also that the person most familiar with JDE here is gone, and the JDE
consultant that set it up for us in the beginning is nowhere to be found.
(Ray B. who was at Premier in Miami, c-q-!) He's the one that said once when
we were ready to do this, to zero out the inventory first.

Also, Niranjan, it has to do with dropping all existing costs and possible
"baggage" from the way the inventory cost and related figures were "left to
fate" by management no longer with us, and is same as trash. We want to
start it all over.

Edie, I'm still going over the Cycle Count instructions in the documentation
(yep), but from your comment there is a way to enter a zero to all the items
without keying it for each?

Eileen, the idea is to post everything, the zeros to start over, the rest to
put inventory value.

Mike, we need the cardex for prior transactions. The higher-ups like to keep
all kinds of history around (me too), too many dream writers want info that
was there before...

While writing this, JDE called back. Am going to look over the Cycle Count
procedures. Still pending...

- Alan

Alan-

Well, no, there isn't a way to enter zero for all the counts that I know of,
but I was using client access and set up a macro on a toolbutton to automate
it, so it was a matter of click button - page down - click button - page
down... Just don't go to sleep doing it! If you use this approach, be sure to
include the correct number of tabs at the beginning!

I split the cycle counts into several chunks, say 200-300 items each
selecting on a range of item numbers - it was a bit more manageable that way.


Good Luck!
Edie Elting

One could use a world writer to update the cycle count file...

Seth E. Tuthill
A7.3 C 11 V5R1

Edie,

This is more or less the way I am beginning to move toward. Now that you
mention the Client Access macro buttons, as I recollect, it's the way we did
it that once upon a time.

-Alan



----- Original Message -----
From: "Edie143" <[email protected]>
To: <[email protected]>
Sent: Monday, April 29, 2002 3:05 PM
Subject: Re: Cycle count


of,
automate
to
way.

Thanks Seth,
But I'm not familiar enough yet with World Writer to set it up. Plus we want
it to go through and post all the things it would post to and all, so as to
keep inventory values and Gl from teetering..

Alan

----- Original Message -----
From: "tuthill" <[email protected]>
To: <[email protected]>
Sent: Monday, April 29, 2002 3:38 PM
Subject: RE: Cycle count

That's