You've got it. Glad to hear it made some sense J.
Ken
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tony Hughes
Sent: Friday, March 20, 2009 6:14 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Cycle count with transactions between Start count
and Enter tag
Bless you Ken, you are crystal clear. I was sensing the importance of
the time they count the tag, so I am going to have them use Handheld to
do all counting out at the bins, the time will be recorded
automagically.
If I may muddy this situation for 1 more example, I wanted to account
for parts that went in to the bin between Start count and physically
counting parts.
Same example/situation with one minor change. on step 2, some parts move
*in* to the bin off of a job.
Do I now report a -1 on Activity?
------------------------
1. Start a count. I pick Part 1 and Part 2
tag 001 for Part 1 Bin A (there are 5)
tag 002 for Part 2 Bin B (there are 6)
These values go to the countexp table.
2. a transaction moves 1 of Part 1 IN TO BIN A
3. the person counts contents of Bin A and Bin B. he finds 4 of Part 1
in Bin A, and finds 6 of Part 2 in Bin B.
4. a transaction moves 1 of Part 2 out to a job
5. the counting person returns to desk and enters tags.
Enters tag 001.
What does he enter for Counted Qty:
What does he enter for Activity Before Count:
Enters tag 002.
What does he enter for Counted Qty:
What does he enter for Activity Before Count:
Back at Count Group Entry, and when Posting the count, do you let it
update Inventory Yes/No ?
-------------------------
________________________________
From: Ken Williams <ken@...
<mailto:ken%40intermountainelectronics.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, March 19, 2009 10:01:00 PM
Subject: RE: [Vantage] Cycle count with transactions between Start count
and Enter tag
Tag 001:
Counted Qty: 4
Activity Before Count: 1
Tage 002:
Counted Qty: 6
Activity Before Count: 0
Yes, allow it to update inventory. Assuming your inventory was accurate
before the count, what you would have had before you started the count
was Qty 5 of Part 1 (4+1) and Qty 6 of Part 2. The idea of "Activity
Before Count" is that you can start a cycle count at any time. The
systems starts keeping track of usage the second you start the count.
Now if you don't get to a row for a day, any activity in that part
listed for the previous day counts as "activity before count". This
allows the person to count what's in the bin and adjust for usage
without having to shutdown all material transactions.
It takes a bit of getting used to, it's important to know when you
actually counted a part so you can seperate the before count activity
from the after cycle count started time.
It's late, I have a cold...and I have a feeling this didn't come across
as clear as I had set out to. Perhaps someone else can elaborate if
needed :).
Ken
____________ _________ _________ __
From: vantage@yahoogroups .com on behalf of Tony Hughes
Sent: Thu 3/19/2009 6:04 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Cycle count with transactions between Start count and
Enter tag
I do not understand this, and was hoping someone could clear it up.
Please help with this example:
1. Start a count. I pick Part 1 and Part 2
tag 001 for Part 1 Bin A (there are 5)
tag 002 for Part 2 Bin B (there are 6)
These values go to the countexp table.
2. a transaction moves 1 of Part 1 out to a sales order
3. the person counts contents of Bin A and Bin B. he finds 4 of Part 1
in Bin A, and finds 6 of Part 2 in Bin B.
4. a transaction moves 1 of Part 2 out to a job
5. the counting person returns to desk and enters tags.
Enters tag 001.
What does he enter for Counted Qty:
What does he enter for Activity Before Count:
Enters tag 002.
What does he enter for Counted Qty:
What does he enter for Activity Before Count:
Back at Count Group Entry, and when Posting the count, do you let it
update Inventory Yes/No ?
Thanks
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Ken
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tony Hughes
Sent: Friday, March 20, 2009 6:14 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Cycle count with transactions between Start count
and Enter tag
Bless you Ken, you are crystal clear. I was sensing the importance of
the time they count the tag, so I am going to have them use Handheld to
do all counting out at the bins, the time will be recorded
automagically.
If I may muddy this situation for 1 more example, I wanted to account
for parts that went in to the bin between Start count and physically
counting parts.
Same example/situation with one minor change. on step 2, some parts move
*in* to the bin off of a job.
Do I now report a -1 on Activity?
------------------------
1. Start a count. I pick Part 1 and Part 2
tag 001 for Part 1 Bin A (there are 5)
tag 002 for Part 2 Bin B (there are 6)
These values go to the countexp table.
2. a transaction moves 1 of Part 1 IN TO BIN A
3. the person counts contents of Bin A and Bin B. he finds 4 of Part 1
in Bin A, and finds 6 of Part 2 in Bin B.
4. a transaction moves 1 of Part 2 out to a job
5. the counting person returns to desk and enters tags.
Enters tag 001.
What does he enter for Counted Qty:
What does he enter for Activity Before Count:
Enters tag 002.
What does he enter for Counted Qty:
What does he enter for Activity Before Count:
Back at Count Group Entry, and when Posting the count, do you let it
update Inventory Yes/No ?
-------------------------
________________________________
From: Ken Williams <ken@...
<mailto:ken%40intermountainelectronics.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, March 19, 2009 10:01:00 PM
Subject: RE: [Vantage] Cycle count with transactions between Start count
and Enter tag
Tag 001:
Counted Qty: 4
Activity Before Count: 1
Tage 002:
Counted Qty: 6
Activity Before Count: 0
Yes, allow it to update inventory. Assuming your inventory was accurate
before the count, what you would have had before you started the count
was Qty 5 of Part 1 (4+1) and Qty 6 of Part 2. The idea of "Activity
Before Count" is that you can start a cycle count at any time. The
systems starts keeping track of usage the second you start the count.
Now if you don't get to a row for a day, any activity in that part
listed for the previous day counts as "activity before count". This
allows the person to count what's in the bin and adjust for usage
without having to shutdown all material transactions.
It takes a bit of getting used to, it's important to know when you
actually counted a part so you can seperate the before count activity
from the after cycle count started time.
It's late, I have a cold...and I have a feeling this didn't come across
as clear as I had set out to. Perhaps someone else can elaborate if
needed :).
Ken
____________ _________ _________ __
From: vantage@yahoogroups .com on behalf of Tony Hughes
Sent: Thu 3/19/2009 6:04 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Cycle count with transactions between Start count and
Enter tag
I do not understand this, and was hoping someone could clear it up.
Please help with this example:
1. Start a count. I pick Part 1 and Part 2
tag 001 for Part 1 Bin A (there are 5)
tag 002 for Part 2 Bin B (there are 6)
These values go to the countexp table.
2. a transaction moves 1 of Part 1 out to a sales order
3. the person counts contents of Bin A and Bin B. he finds 4 of Part 1
in Bin A, and finds 6 of Part 2 in Bin B.
4. a transaction moves 1 of Part 2 out to a job
5. the counting person returns to desk and enters tags.
Enters tag 001.
What does he enter for Counted Qty:
What does he enter for Activity Before Count:
Enters tag 002.
What does he enter for Counted Qty:
What does he enter for Activity Before Count:
Back at Count Group Entry, and when Posting the count, do you let it
update Inventory Yes/No ?
Thanks
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]