In Item Maintenance, you can do a custom lookup that includes those fields (Cycle Count Value and Inactive Yes/No Value).  From the lookup screen you can export to excel.  If you are planning to change the values in the excel file you then need to write a visual integrator import to refresh the values from the excel document into the item master.  I would suggest you work with your Sage 100 Consultant or your Reseller of Record for assistance in importing data to the item maintenance data table. 

Hello SAGE fren, thank for replying. I have been using SAGE for three years and still can BARELY use it. I believe I did what you suggested and did not have the result I was hoping for. The images you will see are, CUSTOM LOOK UP, initial box/window for customizing filters, FIELDS, showing the different filed to choose, and RESULT, the result of my choices. 

I don't need to import anything back in, only export to work with the date but MUST include, "Active/Inactive, Inventory Cycle"

You named your custom Lookup as:  In-Active, Inventory Cycle; but looks like you are showing a preview of a different lookup not the one you just created. 

Here is a link to the Sage Knowledgebase Article on how to create a Lookup:  https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=224924450060200&page=1&position=5&q=custom%20lookup 

Here also is a link to Sage Software University, Custom Lookups:  https://sageu.csod.com/LMS/LoDetails/DetailsLo.aspx?loid=fce9f077-6bb6-4f4f-8d35-f22d50fac4ca&query=%3Fs%3D1%26q%3Dsage%2520100%2520lookups&back_key=1#t=1 

That worked! Thank you again for your help. 

I found it easy to create a straight SQL link through Excel  and pull the columns we need to filter.

Is there a choice for "BIN LOCATION" in that filter/export? I need to generate a report that show a range of part numbers and the BIN LOCATION as well. 

I haven't found a way to include the Bin Location in the lookup table, the IM_ItemWarehouse is not an option to select for your filters.  That's why we had to pull the data from SQL.

You can't create a "lookup" on item maintenance that includes the Item/Warehouse Primary Bin.  Inventory is not a one to one relationship to that data table. You can write a crystal report.