Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Shari Bruno]

?Good Afternoon!

I’m trying to put “Inactive” into an Inventory>Items SmartList and have not been able to locate it:

I’ve tried looking for “Inactive” and “Active” as well as “Status,” along with pulling in all of the User Defined options to see if it’s living there and have had no luck.

Does the field have another name? Or do I need to search in a different folder/subfolder?

Thanks!

——————————
Shari Bruno
Accounting Operations Manager
Bible League International
Crete, IL
——————————

[Jo deRuiter]

?Hi

You are right, that is not anywhere in the Inventory Smartlists at all.   The field name is “Inactive”.  

The only way I got it to show was a custom Smartlist (Designer or Builder) looking at the Item Master and joining with the default Smartlist (SL Builder) on the Inventory Number.

Interesting that it’s not there out of the box. 

?

——————————
Kindest Regards,

Jo deRuiter
“That GP Red Head”
Senior Financial Systems Consultant
Advanced Credentialed Professional-Dynamics GP
Chairman, GPUG Partner Advisory Board
Heartland Business Systems, LLC
Milwaukee, WI
770-906-4504 (Cell)
——————————
——————————————-

[Shari Bruno]

?Thanks ! We have SmartList Builder, I’ll give that a try.?

——————————
Shari Bruno
Accounting Operations Manager
Bible League International
Crete, IL
——————————
——————————————-

[Kristen Hosman]

Things that make you scratch your head!  

When using SmartList to identify inactive customers, vendors or items just simply add these columns to your SmartList:

• Customers you add the ‘Inactive’ column
• Vendors you add the ‘Vendor Status’ column
• Items…follow Jo deRuiter’s suggestion to create a SmartList or if using SmartList Designer see below

Highlight the Items folder then click New.  Navigate to Microsoft Dynamics GP > Tables > Inventory > Item Master > Inactive (check this to bring it into the selected fields area).  Then create the relationship between the two tables as shown below in the screen shot.  Execute Query to verify it works then click OK to save this as a new SmartList.

——————————
Kristen Hosman
Dynamics ERP Consultant
Briware Solutions Inc.
Pine CO
——————————
——————————————-

[Jo deRuiter]

?

Things that make you go….

?

——————————
Kindest Regards,

Jo deRuiter
“That GP Red Head”
Senior Financial Systems Consultant
Advanced Credentialed Professional-Dynamics GP
Chairman, GPUG Partner Advisory Board
Heartland Business Systems, LLC
Milwaukee, WI
770-906-4504 (Cell)
——————————
——————————————-

[Victoria Yudin]

I am pretty sure the reason that’s not on the out-of-the-box Inventory SmartList is that the field was added only a few versions ago. I believe it was introduced in GP 2013. From what I have seen, in those situations no existing SmartLists were updated.

——————————
Victoria Yudin
Microsoft Dynamics GP MVP 2005-2018
Flexible Solutions, Inc.
http://www.GPReportsViewer.com
http://victoriayudin.com
——————————
——————————————-

[Windi Epperson]

Hey
Don’t forget about Navigation Lists.  I just clicked on Items, then added the filter shown below.  Once that was sorted, I clicked the name of the list which before customization said “Items” where it now says Inactive Items.  When you click it, you have a the option to Save As – which I did and gave it the name Inactive Items.   Once it’s saved, you can customize it to add the Inactive column and it will show in the navigation list like a smartlist favorite.   From there, if you need this for export, you can select all then choose Go To and Send to Excel.   
Nice and easy with no table linking 🙂

?

——————————
Windi Epperson [Designation]
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 Ext 102
——————————
——————————————-

[Shari Bruno]

?Hi

Thanks for the Navigation List suggestion. The only issue is that one of the fields we need on this report is User Defined. When I look at the Customize option there isn’t a user defined field? available. Is there a way to see that type of field on a Navigation List?

Thanks again!

——————————
Shari Bruno
Accounting Operations Manager
Bible League International
Crete, IL
——————————
——————————————-

[Windi Epperson]

If you’re using the (User) Categories from the Item MaintOptions screen, then yes.  If they are user defined in some other item setup window, then no.  If you have SmartList Builder you also have Navigation List Builder so you can adjust, but you’re kind of back to the original suggestion of using SLB.

?

——————————
Windi Epperson [Designation]
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 Ext 102
——————————
——————————————-

[Nicole Albertson]

Appears you have gotten some great answers on how to get the Inactive field there.  Let me know if you need help with SmartList Builder at all.

I have created a product suggestion to get this added to the default SmartList if anyone wants to vote on it.

https://experience.dynamics.com/ideas/idea/?ideaid=de1f835c-db43-e811-a822-0003ff68bbc0

——————————
Nicole Albertson
Product Manager
eOne Solutions
——————————
——————————————-