• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Physical On Inventory

jberry123

Active Member
We are getting ready to do our first physical in JDE. Does anybody have any
Do's, Don't, or Tricks they would like to share.

Any help would be greatful.
Thanks,
JB
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.
 

Jack_Crouch

Well Known Member
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04500.E19615C0
Content-Type: text/plain;
charset="iso-8859-1"

Turn your head and cough.
 

AlekK

Member
JB,
We have run a few Physical Inventories since our 7.332 implementation. The
process is much lacking in features and efficiency. It was designed to be a
manual data entry process. The first time we did this it took 5 employees
working all day to complete 6,000 parts. Since then I have designed an
Access application to upload the inventory count files into the F4140 and
F4141 tables.

Another option is to upload the counts into the F4141Z1 tables and use the
Z1 processing UBE.

Definitely:
DO NOT: try to use the Excel import feature to process your counted
inventory. It will fail miserably.
DO: run your variance reports and double check your qty totals to verify all
entered items have actually been applied in JDE.

Good Luck,

Alek Kirstein
Software Developer/DBA
(949) 460-7514
AlekK@GoldenRAM.com
www.GoldenRAM.com
 
JB - I work for an Electrical Distributor in the Southeast. We're right in
the middle of our second weekend of Physical Inventories. Last weekend we
had 27 branches and 25 this weekend. This is our second year on OneWorld.
Our average branch has 5000+ items and about 7000 locations.

We made a couple of modifications to the standard Cycle Count application
and added a couple of new UBE's and applications.
Here's what we did:
*** Modified the "Select Items for Count" UBE to only select items that
are stock or non-stock with Qty on-hand.
*** Created a UBE to add New items to our count. We run our Count sheets
the Monday prior to the weekend of our inventory. So we needed a way to add
the items to our count that we added to our file that have Qty on-hand.
*** Modified the "Cycle Count" application to include Hard Commits.
*** Added the ability to insert a row. This keeps you from having to go to
the end of your count to add a new item.
*** Created a new variance report to update the count code to a "3" on an
item that has a variance. This allows you to easily identify those items
when you're re-entering your counts.
*** Created a UBE to populate a table with the information from your count
and an application to view this information. This allows our associates to
see what was Item, Qty on-hand, Qty counted, etc.....
*** Created another UBE to randomly select items from the count to
calculate the accuracy of the count.
*** Changed an error message to a warning message.

Last weekend and this weekend we've only had a few issues where our
associates were not following our procedures.

A couple of things that you need to be aware of is:
*** When you click the "Replace" button in the row exit, be sure that the
qty in the qty field goes away. Sometimes you have to click this button
twice.
*** Be sure to click the "Reset Frozen" button prior to entering your
counts.
*** When entering your counts click the "OK" button after you've entered a
couple sheets. We've experienced some memory errors that cause you to lose
all the data you've entered.

Hope this helps.

Cheers,

JC Blackwell
Business Analyst/OneWorld Developer
Mayer Electric Supply Company, Inc.




>From: jberry123 <jberry123@hotmail.com>
>Reply-To: jdeowdev@jdelist.com
>To: jdeowdevml@jdelist.com
>Subject: Physical On Inventory ~~0:334
>Date: Thu, 2 Nov 2000 10:31:13 -0800 (PST)
>
>We are getting ready to do our first physical in JDE. Does anybody have
>any
>Do's, Don't, or Tricks they would like to share.
>
>Any help would be greatful.
>Thanks,
>JB
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=334
>*************************************************************
>This is the JDEList One World Developers Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>




_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.
 
Top