Location Based Cycle Count

[Steve Langley]

Greetings,



I have a situation where the warehouse manager wants to perform a cycle
count using a range of locations as the data selection. It is possible to
data select on a range of locations; however, the cycle count will only
generate counts for locations showing inventory. Makes sense; but the
business process outside of the software is to at least observe all
locations in the designated range. The reason stems from wanting to be sure
no one misplaced inventory.



Solution One: Open data selection to include where the on hand quantity is
equal to 0. When tested it brought back all the locations but hundreds parts
to NOT count (zero qty on hand.) Any inventory ever going through the
location was brought forth to be counted. Need a way to show the location
without showing all the transaction history in that location.



Solution Two: Use tag count. The problem is no data is provided and the
user has to write everything down. It's OK in an RF solution but it's not
acceptable in a paper based warehouse. Lots of un-necessary steps.



Solution three. Generate a report that is not a cycle count showing all
locations and any inventory registered with in the location. Compare and
verify the report against the physical. Perform a cycle count if there is a
discrepancy.



Thank in advance for your ideas and help.



Steve Langley



ERP 8.0

Update1

AS400

Web client

 

[Mike Dupaix]

Why not print all locaions for a specific BP without running it through the count process? You could evaluate all locations for the warehouse and make any adjustments necessary.

Slangley <[email protected]> wrote:Greetings,



I have a situation where the warehouse manager wants to perform a cycle
count using a range of locations as the data selection. It is possible to
data select on a range of locations; however, the cycle count will only
generate counts for locations showing inventory. Makes sense; but the
business process outside of the software is to at least observe all
locations in the designated range. The reason stems from wanting to be sure
no one misplaced inventory.



Solution One: Open data selection to include where the on hand quantity is
equal to 0. When tested it brought back all the locations but hundreds parts
to NOT count (zero qty on hand.) Any inventory ever going through the
location was brought forth to be counted. Need a way to show the location
without showing all the transaction history in that location.



Solution Two: Use tag count. The problem is no data is provided and t! he
user has to write everything down. It's OK in an RF solution but it's not
acceptable in a paper based warehouse. Lots of un-necessary steps.



Solution three. Generate a report that is not a cycle count showing all
locations and any inventory registered with in the location. Compare and
verify the report against the physical. Perform a cycle count if there is a
discrepancy.



Thank in advance for your ideas and help.



Steve Langley



ERP 8.0

Update1

AS400

Web client

 

[Krofire.com]

I don't have a solution to your problem but I did recently implement Cycle and Tag Counting. I just wanted to make a quick observation and it is this: Cycle Counting is intended to make you go to locations and count what is there - even if the system thinks there is nothing there.

So even if the On Hand is zero there may be stock left in that location. The point is that you are meant to count all the Locations associated with an item. It appears that you first and second paragraphs contradict each other. You agree that you need to count all locations (in-case something was misplaced) and then you mention that there is a problem when the system comes back with lots of locations with nothing in.

So I am a little confused by the requirement. How do you want the system to work? I guess you are saying that you can put Items into Locations 'on-the-fly' so therefore you have a lot of Items with Lots of Locations? Most of which no longer hold stock. But how do you know they don't have stock unless you go there and count it?!

Is it worth purging the F41021 of Item/Locations with no On Hand, Availability of Commitments? This might be what you are after but I am a little unsure about integrity problems with the Cardex. Let us know a little more.

 

[CraigM]

Hi,

I have had a similar requirement from a client. They used RF to do the count but the solution would also work for you I think.

We created a new UBE to run over the F41021 to select the records to count. For each location within the range, if the quantity on hand was not zero then the record was marked (user reserved field). If there were no on hand quantities in a location then a single F41021 was marked.

It then submitted the R41411 to create the count, selecting only the marked records. The result was that there was just 1 count record for each empty location.

Regards,

Craig