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. 6 followers. Follow

7 Replies
1775 Views

Similar Articles

[PageSpeed] 27

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:

REPOST: Graphing a cumulative item count grouped by month?
This is a repost of my original question: I am trying to not use any add-ins or BI tools. I'm wanting to use a pivot table to create a histogram (graph) that shows: A.) Count of new action items for the week B.) Count of action items resolved for the week C.) The cumulative count of unresolved action items for the week My columns are in a table called tblMain and I figured I could get by using columns [ID] (a unique ID number) and [DateComplete] (a short date). Filtering out the action items that weren't completed is easy enough using a "null" qualifier for the da...

Count of duplictaes
This is my original file Col A Col B Col C Col D Name Jan Feb Mar Deepak 1 0 Deepak 2 1 3 Deepak 1 Tata 0 0 2 Tata 2 Ambani 5 2 Ambani 1 Need to add the count of duplicate - so the result should be as below Name Jan Feb Mar Deepak 4 1 3 Tata 2 0 2 Ambani 6 2 any help is appreciated in advance Deepak Col E Col F Col G Col H Name Jan Feb Mar in cell F2 put this formula =3DSUMIF($A$2:$A$7,$E2,B$2:B$7) copy it down and across. On Jan 21, 12:19=A0am, Deepak <...

Count of Unique numbers in a column
Hi, I have some no's in a column,in which some are duplicating & some are unique no's.Like 825 921 941 921 822 825 941 421 Now i want to count the unique no's in a column. The result should be 5 for the above example. Note : can the result be taken out in a cell instead of using an another column. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ Enter the array formula: =SUM(IF(LEN(A1:A100),1/COUNTIF(A1:A100,A1:A100))) to exclude 0 values, or as: =SU...

Count #12
Hi all, There are two worksheets in my workbook. The first sheet is used to record data entry stats. In the first sheet, the first column contains the data entry date, and the second column contains the data entry name. I am using the second sheet to maintain the stats of each data entry person on a monthly basis. How do i achieve this without using macros. Thanking in advance. Regards, Rohit On May 9, 12:20=A0pm, rohit <desai.rohi...@gmail.com> wrote: > Hi all, > > There are two worksheets in my workbook. The first sheet is used to > record data entry stats. In the first ...

Count Frequentness
Good evening: Is it possible to count how many times a string of numbers appears in a column? I am working on a project that has approximately 1000 telephone numbers. I need a count on how many times a particular number appears in a column. Thank you in advance John Is it really a "number" or is it a telephone number complete with hyphens? =COUNTIF(A1:A1000,2345) if number =COUNTIF(A1:A100, "555-1212") if text In either case the last argument can reference a cell: COUNTIF(A1:A1000,B1) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps ...

Multiple Inventory Counts
I need to know if you are supposed to be able to add in count totals into an open Physical Inventory from multiple stations at the same time. We disperse staff throught our store to count items in several storage areas. I then open a physical inventory count and ask staff to open Store Operations, open the physical inventory and add their counts in. However, it appears the when you hit ok it OVERWRITES anything in the count instead of ADDING to it. Is this by design or something wrong with our system. Try using the import button inside a physical inventory count. It gives options to ov...

What is the formula to count cells with specific text
What is the format of the excel function to count cells with specific text in the cell. I have a column on my spreadsheet that has some data in the cells starting with the letters "wo". There are more letters and numbers after the letters "wo". I need to count the cells that start with the lettes "wo". What is the function and format of the command to count the cells on my spreadsheet with the letters "wo" Thanks Confused confused, here is one way, =COUNTIF(A1:A10,"wo*") -- Paul B Always backup your data before trying something new P...

Count/Sum rows of a column depending on criteria from drop-down li
Hi, I have a question here, appreciate any help. Prod ID Jan Feb Mar.... Prod A 10 5 3 Prod B 3 - - Prod A 4 7 1 Prod C 5 2 7 In Cell A8 = Prod A At cell B7, it is a data validation(drop-down list) for Jan~Dec In B8 cell, I need a formula to calculate When Prod ID = Prod A and when month selected is Mar, the sum, ie. result is 4. In C8 cell, I need a formula to calculate When Prod ID = Prod A and when month selected is Mar, the count if value is > 0, ie. result is 2 I know I may have to use sumproduct, som...

COunt if Question #2
What is the proper syntax to concatnate Countif function Say you want Colum A = to equal either 100 or 200 and colum B should be a date between Jan 1, 2008 and Dec 1 2008 List the criteria in some cells: D1 = 100 D2 = 200 E1 = 1/1/2008 F1 = 12/1/2008 =SUMPRODUCT(--(ISNUMBER(MATCH(A1:A20,D1:D2,0))),--(B1:B20>=E1),--(B1:B20<=F1)) -- Biff Microsoft Excel MVP <James@aol.com> wrote in message news:s0q325pegdibvc7a9ktgqii597omoki040@4ax.com... > What is the proper syntax to concatnate Countif function > > Say you want Colum A = to equal either 100 or 200 and colum...

Return highest count of one field when duplicate found on another field
I have a table with department IDs, department heads and headcount. Sometimes there are two department heads per department ID. I want to show the head with the largest staff as the leader. I've created a total query to show the count of the staff. Where can I go from there? SELECT [DeptHeadcountTable].DeptID, [DeptHeadcountTable].[Director], Count([DeptHeadcountTable].[EmployeeID]) AS [CountOfEmployeeID] FROM [DeptHeadcountTable] GROUP BY [DeptHeadcountTable].DeptID, [DeptHeadcountTable].[Director]; Try this -- SELECT [DeptHeadcountTable].DeptID, (SELECT TOP 1 [XX].[Department...

Do email groups count as a "user" as far as Microsoft's licensing model?
This is a multi-part message in MIME format. ------=_NextPart_000_0117_01C3C3EE.FE9B01B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Do email groups count as a "user" as far as Microsoft's licensing model? = I would think not, but not sure. Thanks, Brian ------=_NextPart_000_0117_01C3C3EE.FE9B01B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-eq...

Qty on hand & back orders
hi all, A couple questions with inventory and sales. 1. Is it possible to setup CRM so that an order can not be created if there is 0 qty on hand? I don't want to carry a balance or do a back order. 2. Is it possible to only bring over the qty on hand from one warehouse? Currently our sales team sees items that are in our quaranteened warehouse. Thanks. We could help you solve this. www.tsinghuasoft.com "Jeff" wrote: > hi all, > > A couple questions with inventory and sales. > > 1. Is it possible to setup CRM so that an order can not > be created...

Print qty from a form
I am creating a label program where i can select and product from a table and store the selected item to another table so i can print the selected item. I was wondering if I could enter a value and press the print button so the program will automatically print the qty entered in the qty field. Thanks -- George Sydney Frustrated programmer George, Please describe a bit more... Are you printing one label, a certain number of times? It sounds as though you want to print unique labels, but with a common Qty? Please show us some sample data, and what you would like to see on your...

How to enter (-) qty in SOP Order in GP 8.0
I saw a demo by Microsoft technician last year, who demo how to enter (-) qty in the SOP Order form while using GP 8.0. This feature allow user to handle a credit transaction and a debit transaction on the same order. In prior version, the return must be done under Order Return. How can I activate this new feature? When I tried to enter a (-) qty in Order form, the GP 8.0 still do not allow me to enter it. Thanks! On a quote or an order you can only enter a negative unit price, not a negative quantity. On an invoice you can enter a negative quantity OR a negative price, depending ...

Count if or Sum Product
I apologize if this is a duplicate submission. I have a spreadsheet of data with two columns of data for which I need to summarize on another spreadsheet. Column A lists makes/models and Column B counts the number sold. The original spreadsheet will contain multiple duplicate entries of the same makes/models for which I need to summarize. Ex: Column A Column B 7444 loader 2 Which formula would be best for this project? Thank you! SUMIF() is probably what you want. You can either set up several cells with all possible combination ...

Counting based on other cells contents...
Hi, I'm after a (fairly) complicated formula here. I have two three columns I'm interested in. Column 1 contains three different values ("CGF","GGF","SGF"), column 2 contains "Yes"/"No" and column 3 contains "Pass"/"Fail". I'd like to count the number of times in the first column ($C:$C as I don't know how many entries there are) for each value (GGF,CGF,SGF) that have a "No" in column 2 as well. I've tried This: =COUNT(IF(($C:$C="GGF")&($D:$D="No"),1,0)) but with...

SUBTOTAL Second Count / sub-count of Filtered Visible Cells
Hi Excel Forum, original ThreadID (http://www.excelforum.com//showthre...threadid=239331) I have tried a Pivot Table as was previously suggested but the result included the Filtered Hidden Rows as well as the Filtered Visible Rows I require only the data of the Filtered Visible Rows. The Filtered dat will be constantly changing and a solution that can be performe on-the-fly would be more suitable. Is there any way of providing a solution using Formula or VBA to coun the individual departments and then count the subset of department within the Filtered Visible Rows to ultimately provide a s...

Stock Count Imports
Is there any way to import stock count data with integration manager? There is no adapter for that transaction but I noticed a Blue Moon document that said it could be done. There are 3rd party products from Compass and Blue Moon that will import stock count data from a flat file but I would like to avoid adding additional software. Thanks. Lou You should be able to user IM to import them as Inventory Adjustments (Item Transaction Entry). Select 'Variance' as the Document Type to differentiate it from other adjustments, if desired. Frank Hamelly MCP-GP, MCT, MVP E...

Count number of checked boxes on a form
I would like to add a textbox (txtCheckedForms) that shows the number of checkbox fields are checked on a form. Is there a simple way of doing this? The only thing I've come up with so far is something like this... If chkField1 = True then varCheckedForms = varCheckedForms + 1 if chkField2 = True then varCheckedForms = varCheckedForms + 1 .... ifchkField50 = True then varCheckedForms = varCheckedForms + 1 txtCheckedForms = varCheckedForms The problem is, I have about 50 checkbox fields on my form. That would take a long time and a lot of space! Also, the fields aren't actually ...

Counting if numbers fall within a specified range
For a range of cells containing percentages, how can I use COUNTIF to count those cells whose values fall between 90% and 110% ? You could count the number >= .9 and subtract the ones >1.10 =countif(a1:a10,">=.9") - countif(a1:a10,">1.1") Or you could count the ones that are trapped between those numbers: =SUMPRODUCT(--(A1:A10>=0.9),--(A1:A10<1.1)) =sumproduct() likes to work with numbers. The -- converts trues and falses to 1's and 0's. KG wrote: > > For a range of cells containing percentages, how can I use COUNTIF to count > ...

counting duplicates Among Many Sheets, Possible??
:confused: Hi, I have spent countless days trying to find a formula that will allow me to find duplicates across Multiple Sheets within a single workbook. All resources I have checked only allow duplicate finding formulas for A single Sheet. I have multiple sheets 1 to 31 representing a month in which I have a column of phone numbers. i want to be able to know from sheet to sheet (Day to Day) if I may be retyping a number from a previous day. Thats why I need to have a formula to check acrosss the sheets for duplicate numbers... even better if I can have the duplicates displayed on a new...

Counting unique values in a row
I am attempting to count the number of times a specific value range occurs in a row throughout a large spreadsheet. For example, I have three values in multipe rows: A1=10, B1=20, C1=30, A2=20, B2=10, C2=30. A3=50, B3=50, C3=50 I want to create a formula that will allow me to count the number of rows that contain 50,50,50 within a large area. Here's an array formula that will help you count unique instances SUM(1/COUNTIF(data_range,data_range)) CTRL+SHIFT+ENTER to activate the array -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips &quo...

Is it possible to Sort by Item Count after grouping?
When sorting by a column header in Outlook (i.e. Subject, From, etc...) the items are grouped by the header and the count of items is displayed as (x items). Is there then a way to then sort by count of items so the largest groupings with the most items are at the top? This could really help with cleaning up my Inbox as I could identify groups of messages with the same subject or from some person ordered by the largest grouping and work on those first. Any help is greatly appreciated!! -- sramsay As far as I know, no. "sramsay" <sramsay.34d99b8@outlookbanter.com> wro...

How do you count work days excluding weekends and holidays?
I have a large spreadsheet (Excel 2000) that contains more than 1,000 rows. There are two columns with dates and I want to count the workdays, excluding weekends and holidays between the dates in each row. Can I do this without having to put the dates from each column that I want compared in the formula? I want to count the workdays between whatever dates are in these two columns. Use the NETWORKDAYS worksheet function. HTH Jason Atlanta, GA >-----Original Message----- >I have a large spreadsheet (Excel 2000) that contains more than 1,000 rows. >There are two columns with d...

How to Inventory Count at store & try to update it in HQ for RMS2.
Hi! I have RMS HQ and a location -store1 wanted to count inventory on hand & wanted to update HQ qty for store1. I have already updated store1 qty by store manager - Inventory -physical inventory - commited qty Also, try to sync with HQ but won't update qty on HQ for store1 to new count.. New to this HQ - Appreciate all your help. Vinay - at HQ, create and approve worksheet 501 - process it at the store, this uploads the quantities after the PI up to HQ - then in HQ run inventory wizard task 190 to reconcile the qties in hq with what you uploaded on the 501 - hope this helps.......