Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Double entries show up...

Double entries show up in Smartlist

(0) Share

Report

Posted on by Community Member Microsoft Employee

I am using smartlist builder to sort out inventory items. When I link Item Master and Item Vendor Master I get good results, but if I add Item Quantity Master (in order to get the quantity on hand), I get double entries in the smartlist. Each inventory item has two exact rows instead of one. Any help would be appreciated. I even get double entries for items that I only have one vendor for.

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Double entries show up in Smartlist

Based on the above, I assume that you only have one site id. What I think you are seeing is that there is a row reflecting inventory qty at one site and then another for overall. If you had 2 sites, you would have 3 rows.

I don't remember if site id is available as a column, but see if you can add it. Then you could filer for either the one site or for the null site.

Warren