Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Item Inquiry & Sma...
Microsoft Dynamics GP (Archived)

Item Inquiry & Smart List dont add up...

(0) ShareShare
ReportReport
Posted on by CLEE 55

Hello,

 I am having a difficult time with GP. I only know the VERY basics of GP, but one thing that just seems odd is that in 'Item Inquiry', I can pull up an item and it will show the correct amount in stock, backordered, allocated etc... Whereas if I pull it up in a Smart List, it will show skewed numbers. Example: The list might show an item to be -100 quantity and have 10 backorders when in reality, there is 0 backordered and 50 in stock.

 Has anyone else experienced this? :(

 Any information would be helpful, thank you!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Item Inquiry & Smart List dont add up...

    Hi,

    Did you build this smartlist in smartlit builder? or did you select a pre-defined list in smartlists and amend / filter it?

    If smartlist builder, what tables are you taking the data from?

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Re: Re: Re: Item Inquiry & Smart List dont add up...

    Something else to try to make sure it's not just an issue with your connection to the SQL server.  Run the SmartList directly on the SQL server or restart your computer, go back into GP - are you still getting the same results?  Sometimes if the client computer has lost connection to the SQL server you can get unpredictable results back. 

  • Tariq Aziz. Profile Picture
    Tariq Aziz. on at
    Re: Re: Re: Item Inquiry & Smart List dont add up...

     Still not clear whether you filtered an already defined smartlist in GP to have your desired view and data or created a new smartlist your self. If list was not already there and you created it by using your own SQL statement(SQL Query) then just send me the SQL query you used. Hope I`ll be able to help you.

    Regards

  • CLEE Profile Picture
    CLEE 55 on at
    Re: Re: Item Inquiry & Smart List dont add up...

    Oh sorry, I should have been clearer! I am using a user-defined smartlist.

    I set the search and colums for what I need, correct parts come up... However, the quantity is skewed on alot of them.

    QTY Available, QTY On Hand, QTY Backordered etc will all have random numbers. And no, its not due to location because we only use one site for all of this stuff. It has be puzzled...

    I could have JUST pulled up the smartlist and have a 'item inquiry' open beside it and the numbers are off! There seems to be absolutely no reason for this.... :(

     

  • Tariq Aziz. Profile Picture
    Tariq Aziz. on at
    Re: Item Inquiry & Smart List dont add up...

     Hi.

    First thing I need to now is whether u a using a buoilt in SmartList of MSGP or a user defined smartlist. If it is user defined then make sure that Data Retreiving Query is correct. If query is correct or Smartlist is a standard onethen you`ll have to run Check links and reconcile in POP, Inventory and Sales. Hope this will resolve your problem.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans