Cycle Count - Qty to be Counted

Hi,
Client running GP 10.

I am setting up their cycle count schedules and have run into an issue that 
I can't get an answer for.

Want to set up the count to give me the following quantity of items to count 
weekly:
A - 15 Items
B - 10 Items
C - 5 Items

I am unable to find a way to automate this.

Any suggestions (besides buying other count software?). 

-- 
Jim Lines
Sr. Microsoft Dynamics GP Applications Consultant
Certified Microsoft Dynamics GP Specialist
0
1/28/2009 4:50:01 PM
greatplains 29623 articles. 3 followers. Follow

7 Replies
979 Views

Similar Articles

[PageSpeed] 3

I don't think so Jim.  The assumption behind cycle counting is that
you'll count all your inventory at least once annually.  Therefore,
the number of items to count each week will be based on the parameters
set in your ABC Breakpoints setup which determines the number of items
that fall within each classification.  This result is divided by the
number of weeks in your calendar or fiscal periods to deternine which
items get counted each week.

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
blog: www.gp2themax.blogspot.com


-1
fhamelly1 (1404)
1/28/2009 7:07:27 PM
Frank,
What you are saying that if I have 1,000 A items in my Item Master, and I am 
counting every 7 days, I should expect to see approx. 20 items per week 
(1000/52)?  That makes perfect sense.  

That's good to know and I will help me explain to the client.  

Thanks for your quick response and helpful answer.

Best,

-- 
Jim Lines
Sr. Microsoft Dynamics GP Applications Consultant
Certified Microsoft Dynamics GP Specialist


"Frank Hamelly, MCP-GP, MCT, MVP" wrote:

> I don't think so Jim.  The assumption behind cycle counting is that
> you'll count all your inventory at least once annually.  Therefore,
> the number of items to count each week will be based on the parameters
> set in your ABC Breakpoints setup which determines the number of items
> that fall within each classification.  This result is divided by the
> number of weeks in your calendar or fiscal periods to deternine which
> items get counted each week.
> 
> Frank Hamelly
> MCP-GP, MCT, MVP
> East Coast Dynamics
> www.eastcoast-dynamics.com
> blog: www.gp2themax.blogspot.com
> 
> 
> 
1
1/28/2009 7:19:07 PM
Yes sir, you've got it.  Your items will be stratified by ABC code.
Let's say you want that stratification determined by dollar value.
You could set the codes to be equivalent as follows:

A = Top 50% of inventory value
B = Mid 40% of inventory value
C = Bottom 10% of inventory value

So let's say theroretically that this works out to

A = 104 items
B = 416 items
C = 520 items

The cycle count schedule would dictate that you count 2 A items per
week, 8 B items per week and 10 C items per week.

Of course there are different stratification methods available within
GP.  You might want to review the ABC Analysis section of the
Inventory Printable Manual in GP Help.

Good luck!

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
blog: www.gp2themax.blogspot.com


0
fhamelly1 (1404)
1/28/2009 7:42:19 PM
Thanks again Frank.  The only thing I see which seems backwards is the count 
of the C items.  How cost effective is it to count 50 different screw types 
per week...

Again, you've been very helpful. Much appreciated.

-- 
Jim Lines
Sr. Microsoft Dynamics GP Applications Consultant
Certified Microsoft Dynamics GP Specialist


"Frank Hamelly, MCP-GP, MCT, MVP" wrote:

> Yes sir, you've got it.  Your items will be stratified by ABC code.
> Let's say you want that stratification determined by dollar value.
> You could set the codes to be equivalent as follows:
> 
> A = Top 50% of inventory value
> B = Mid 40% of inventory value
> C = Bottom 10% of inventory value
> 
> So let's say theroretically that this works out to
> 
> A = 104 items
> B = 416 items
> C = 520 items
> 
> The cycle count schedule would dictate that you count 2 A items per
> week, 8 B items per week and 10 C items per week.
> 
> Of course there are different stratification methods available within
> GP.  You might want to review the ABC Analysis section of the
> Inventory Printable Manual in GP Help.
> 
> Good luck!
> 
> Frank Hamelly
> MCP-GP, MCT, MVP
> East Coast Dynamics
> www.eastcoast-dynamics.com
> blog: www.gp2themax.blogspot.com
> 
> 
> 
0
1/28/2009 8:43:03 PM
You're welcome Jim.  In the case of screws (which might also be
considered floor stock and not even inventoried) you can choose to not
classify certain low-value, non-critical items, preventing them from
being chosen for a cycle count.

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
blog: www.gp2themax.blogspot.com

0
fhamelly1 (1404)
1/28/2009 9:03:32 PM
Frank,
I want to update this post with the solution to my dilemma (thanks to your 
help).

Here's what the client has:
A Items = 147, want to count 15 per week, 147\15 = Count Interval of 10
B Items = 300, want to count 7 per week, 300\7 = Count Interval of 43
C Items = 1832, want to count 3 per week, 1832\3 = Count Interval of 610

I adjusted my Stock Calendar to have all days except Monday as a down day.  
By implementing the above, I get exactly what the client asked for:

Every Monday, Count
A 15
B 7
C 3

Again, thanks so much, I am happy with the results and hope that other users 
find this post helpful.

Have a great day!

-- 
Jim Lines
Sr. Microsoft Dynamics GP Applications Consultant
Certified Microsoft Dynamics GP Specialist


"Frank Hamelly, MCP-GP, MCT, MVP" wrote:

> You're welcome Jim.  In the case of screws (which might also be
> considered floor stock and not even inventoried) you can choose to not
> classify certain low-value, non-critical items, preventing them from
> being chosen for a cycle count.
> 
> Frank Hamelly
> MCP-GP, MCT, MVP
> East Coast Dynamics
> www.eastcoast-dynamics.com
> blog: www.gp2themax.blogspot.com
> 
> 
0
1/28/2009 9:51:02 PM
Interesting Jim. I didn't realize you could specify a count interval
in the cycle count setup.  I learn something new every day.

Thanks for the feedback!

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
blog: www.gp2themax.blogspot.com
0
fhamelly1 (1404)
1/28/2009 10:02:31 PM
Reply:

Similar Artilces:

Cycle
Why cycle (all records) not work on my form I set data entry = Yes The form based on query == Query Criteria is Forms!FormName!ControlName (The ControlName is on the form) We aren't there. We don't know what query you are using. Please post the SQL-statement of your query. Regards Jeff Boyce Microsoft Office/Access MVP "a" <a@a.net> wrote in message news:uRwhikeYIHA.220@TK2MSFTNGP04.phx.gbl... > Why cycle (all records) not work on my form > > I set data entry = Yes > > The form based on query == Query Criteria is > > Forms!FormName!Co...

Count occurrences of filename in column
I want to use VBA to count the occurrences of a filename in column M, such as "myfile.xls". Problem is, each time the name appears (after the first one), it'll include a number, like "myfile(2).xls", "myfile (3).xls", and so on. Also, I can't just count occurrences of the name because it could appear as a non-filename ("myfile"), without the .xls extension, and I don't want to count that. When I have finished counting them, I want to add another instance, with a higher number than the existing ones, also in column M. I've been ...

Count cells matching two criteria (DATE & TEXT)
Hi, I work for a Truancy Reduction Center. We receive referrals from over 50 schools in the district for kids who are truant. We'd like to know the number of referrals a specific school sent us during a specific month. Referral Dates are in F4:F500 and School Names are G4:G500. This is what I've been trying: =SUMPRODUCT(--(TEXT('Client Log 09-10'!f4:f500,"yyyymm")="200910"),--('Client Log 09-10'!G4:G500="pacifica")) These functions work separately, but don't seem to want to play together. I just read a suggested relat...

Unique text count with multiple criteria?
This formula is working but what it's doing right now is giving me a total unique count of names PER QUEUE. Sometimes agents work in two or more queues per day, so what I need it to do is give me a total unique number of names even if the same name shows up under multiple queues. Make sense? If so, does someone know how to make the formula do that? =SUMPRODUCT(((Queue_User_Routing.csv!$C$2:$C$2000="Appeal")+(Queue_User_Routing.csv!$C$2:$C$2000="Duplicate Resolution")+(Queue_User_Routing.csv!$C$2:$C$2000="Manual Determination")+(Queue_User_Routing.csv!$C$2:$...

Counting In Pivot Tables (=count)
I'm trying to count individual numbers in a pivot table, for example... I have this... A1=1 A2=1 A3=5 A4=6 A5=7 With the "=count" function I'm getting the answer "5" because there are 5 different cells with information on them, I need to get the answer "4" because I have four different numbers. I need excel to count A1 and A2 as 1 because it's the same number. Hi, there is no count distinct option in Excel Pivot tables. You can use the following formula in the spreadsheet and reference the pivot table you can use the array formula: =SUM(1/COU...

count #3
I have a table that shows all the employees that have been termed. I want to count how many different codes each manager has used in a given amount of time. ie: bob termed 10 employees using codes 2,3,5,9,12,2,5. what formula can I use to show me: two terms code 2, two term code 5 an so on for a total term of 7 employees Have a great day Your sample layout or try to count bob for reason 2 =sumproduct((a2:a22="bob")*(b2:b22=2)) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "PR Kid" <PRKid@discussions.microsoft.com> wrote in mes...

Unique Count in Sigma Query
Access 2003, Windows XP Pro. SITUATION: Database has lots, which have sublots, which have items. Sublot key is a barcode number. I have a query that joins the three tables, and since a sublot can have multiple items, the sublot key can occur more than once. I want to run a query against this big query that just groups and summarizes some things, one of which is the number of sublots in a given lot. Using a straight Count fails because of the multiple occurrences of the sublot key value. Here's an attempt to show this pictorially: LOT SUBLOT ITEM A A12...

Counting the number of times more than 1 variable occurs
I need to determine how many Separations were processed by a particular salesperson. A | B 1 MIKE | SEPARATION 2 MIKE | LEAVE 3 SARA | SEPARATION 4 JOE | SEPARATION 5 JAMIE | LEAVE 6 MIKE | LEAVE 7 JOE | LEAVE 8 SARA | SEPARATION The only way I can think of is the COUNTIF Funtion *COUNTIF(-range,criteria-)* =COUNTIF(A1:A8,(A1:A8="MIKE")*(B1:B8="SEPARATION")) This does not work though. The results return 0 with no errors when the answer should be 1. does anyone else know of a wa...

How do I make a graph with 2-cycle X 3-cycle log-log graph paper?
I need to create a graph that uses 2-cycle by 3-cycle log-log graph paper. I was told that Excel can be used to do this. However, after fiddling around with it for an hour, I have been unable to figure out how to do it. Any suggestions? Charles A. Wilson - The only Excel chart type that supports log-log is the XY (Scatter) chart type. If more "fiddling around" with an XY (Scatter) chart doesn't yield results for you, post again with your problem and your version of Excel. - Mike http://www.MikeMiddleton.com "Charles A. Wilson" <Cha...

Counting Text Values ?
How do I use worksheet functions to count the number of fields in a database that contain a specific text string, or include specific characters within a text string ? For example : Car Price Landcruiser 40 Landrover 30 Lada 10 Rolls 90 Lada 10 Landrover 30 I would like a cell to count the number of occurrences of 'Lada' in this table, and the answer should be 2. I tried using DCOUNT but it only works on numbers. I would also (ideally) like to be able to count all the cars that start with 'La', so the answer should be 5. Is thi...

Excel : Counting on two columns
THIS IS AN MICROSOFT EXCEL QUESTION: URGENT Suppose I have two columns "A" and "B". "A" "B" Error Open Error Closed Not Error Open Error Open Error Closed ------------------ ------------------ ----- -> Represents blank rows.. How will I find Error which are open in columns 0-7 (including blank rows) Try putting this into C1 =SUMPRODUCT((A1:A65535="Error")*(B1:B65535="Open")) Hope it helps, -Bo -- Message posted from http://www.ExcelForum.com ...

Cycle RR problem
I've just run the cycle RR in Project Account for the first time and have found several problems: GP is mixing up client projects on the same RR window Skips RR documents so I've lost my audit trail Doesn't start a new doc for each contract, as specified in the Cycle instruction And a few other things. Has anyone else had these problems? ...

Count and Rank?
Dear All Say there are 100 records in Column A and the records are all number ranging from 1-5. The numbers are not equally represented... for eg there are 10 "1", 20 "2", 50 "3", 5 "4" and 15 "5". Hence my question is.. is it possible to count how many "1", "2", "3" "4" and "5" and then put a corressponding rank beside the number? Fo eg. as there are 50 "3" which is the biggest out of the other numbers, its ranking is 1. So is it possible to create a macro/functio to get this rank...

Still having a prob counting the blocks of 1's
I am still having problems counting blocks of 1's. A few are returning the correct values, but others are seem to be adding 1 from the previous column. The formula I'm using is.. =SUMPRODUCT(--(C1:C511=1),--(C2:C512<>1)) =SUMPRODUCT(--(D1:D511=1),--(D2:D512<>1)) =SUMPRODUCT(--(E1:E511=1),--(E2:E512<>1)) =SUMPRODUCT(--(F1:F511=1),--(F2:F512<>1)) =SUMPRODUCT(--(G1:G511=1),--(G2:G512<>1)) and so on. The first formula is entered in D1 =SUMPRODUCT(--(C1:C511=1),--(C2:C512<>1)) and so on. Col A B C D E F G H I J K L ...

How do I make total records count faster?
Hi, I have a continous form and I sum the number of records in a text box in the footer. Control Source = Count([StockID]) This is a stock record of marine spares. Some combo boxes on the form provide filtering criteria so that sotck item details, location and number of Stock Lines (records) can be viewed. There are about 32,000 records in total and each time it runs it takes several seconds to present the result on screen. I wondered if there was a faster function or some code that could speed this up? -- John Whyte JohnW wrote: > Hi, > > I have a continous form and I sum...

count 03-19-07
ppey,I am a newbie to Access. I have a report where i am trying to get a count of the number of times "0" appears in a column. The name of the column is NumberOfResult.ThnaksGerry Gerry, You could add a calculated field to the report query such as... IsZero : IIF(NumberOfResult = 0,1,0)Then just =Sum(IsZero) in any footer. Or, in any footer... =Sum(IIF(NumberOfResult = 0,1,0))-- hthAl Campagna . Candia Computer Consulting . Candia, NH USAMicrosoft Access MVPhttp://home.comcast.net/~cccsolutions"Find a job that you love, and you'll never work a day in ...

Counting all "F"s in column A where there is also an "A" in column
I am trying to find the count of all the cells that have an F in one column and also have an A in another column and I'm getting an error. I hope Excel can do this with a simple formula. I don't do macros. Here's an example: 1 A F 2 B F 3 A P 4 A N/A 5 B P 6 A F Basically I am trying to determine how many "A" level requirement have Passed, how many have Failed, how many are N/A and the same for the B level requirements. I've already tallied the total Fails and Passes with ...

How to obtain the row count of a QueryTable from a Web query
I use a Web query to obtain a table on a Web page. How can I know the number of rows in the result QueryTable? The current code I use is as follows: Sub Test() Dim MyStr As String MyStr = "URL;http://mySite/currentuser" With ActiveSheet.QueryTables.Add(Connection:=MyStr, _ Destination:=Range("a10")) .RowNumbers = True .WebSelectionType = xlSpecifiedTables .WebTables = "11" .BackgroundQuery = True .TablesOnlyFromHTML = True .Refresh BackgroundQuery:=False .SaveData = True End...

Count formula #2
Happy new year. I have two columns (A1:A100 and B1:B100). The first column includes the values “ON”, “OFF” and “-”. In the second column i have some dates and empty cells. I would like to apply a formula in the C100 cell, which counts the “ON” cells in A1:A100 but only if the adjacent cells aren’t empty. (That means: count all the “ON” in the Ai cells if the Bi cells have dates values). Any idea? Thank you. In C100: =SUMPRODUCT((A1:A100="ON")*(B1:B100<>"")) -- Max Singapore http://savefile.com/projects/236895 Downloads:22,000 Files:370 Subscribers:66 xdemechan...

display counts AND % of row totals
I would like to have two calculations per field: an actual count and a % of row amount. For Example: Account Type New Existing Transfer Total Checking 20 10 20 50 40% 20% 40% 100% I can't seem to make the pivot table give one row in numbers and the second row in percentages. Any assistance would be greatly appreciated! Thanks, Eric ...

Cycle Counts
I was reading on a website trying to figure out what they changed in 1.3. It mentioned something about a cycle count menu. http://www.positivetechnology.com/rms_ver_1_3.htm I have 1.3 but i dont see anything about these menus... Can anyone help me find these? what is the best way to do cycle counts? ...

report in access (Count)
If i have data in CSV file and it show like belwo Column1 Column2 ABCD Saturday ABCD Saturday EFGH Sunday ABCD Saturday MMM Friday ABCD Monday EFGH Monday I want report show like Saturday Sunday Monday Tuesday Wednesday Thursday Friday ABCD 3 0 1 0 0 0 0 EFGH 0 1 1 0 0 ...

Cycle through a list
Hi, I have a more comprehensive query below but don't really have the time to wait for a comprehensive answer. Could you please help me with going through a list in VBA? I have a named range and the first column has a list of countries. I want to go through this list and do an action for each country. Can you please help with how to do this? I've tried things like application.index(myrange,,1) with no luck, and don't know the appropriate way to cycle through once I have that too. I have a fuller query ('Creating multiple pivot report at run time') with...

asp.net is cycling the AppDomain #2
Hi, My client has been using Business Portal 4.0 for over a month in conjunction with Dynamics GP 10.0. Recently the client has received the following error in the Event Viewer: asp.net is cycling the AppDomain Any idea of what the problem is and how it can be resolved? More detail below: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 2009/05/19 02:27:04 PM Event time (UTC): 2009/05/19 12:27:04 PM Event ID: de12506fed09447a8a8b47bd3c3a26f7 Event sequence: 2757 Event occurrence: 2 Event detail code: 0 Application information: Application domain: /...

Counting Summary in Reports/Queries
I know this is covered but I have spend more time trying the solutions rather than find the one I really need. I have Workstations that belong to Branches and I need to count how many Workstations are in each branch. The Branches field is a Combo Box if that matters. I have 10 Branches. I need to create a summary of all the branches. IE: COB 5 IAAS 25 PGO 3 I tried =Sum(ABS([BranchShort] = "IAAS")) and get error "This expression is typed incorrectly, or it is too complex to be evaluated. A Numberic expression may contain too many complicated elements. Try si...