web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Smart List/Inventory/I...
Microsoft Dynamics GP (Archived)

Smart List/Inventory/Items Price Levels

(0) ShareShare
ReportReport
Posted on by Community Member

I have been trying to get a report from ReportWriter  to show my open items with their Price Level 1 "value".

I am now looking at Smart List to do this.  I have gathered all the fields I need but I cannot get the dollar value for Price Level 1.  Where is this located?  It sems all the fields are availeable but this one.

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    What do you mean by 'Open Items'?

  • Community Member Profile Picture
    Community Member on at

    Discontinued items not included in the list.

    Leslie - I previously sent you the report I was trying to create and never heard from you.  I am now trying to get this info via Smart List

  • Community Member Profile Picture
    Community Member on at

    Try the  'Item Sales Prices' smartlist under Inventory.

    You will need to restrict the smartlist to some value that is unique in your List Prices - Price Level or Currency, or maybe Units of Measure. Or export to XL and cut and dice it there.

    However, you won't have access to the 'Discontinued' field on the Item Master table.

    Eithre export two spreadsheets and use VLOOKUP in XL....or build your own smartlist using Smartlist Builder that links the Item Master table with the Item Price table (use Item Price as the main table).

    Ian.

  • Community Member Profile Picture
    Community Member on at

    I have no Smart List Report called Item Sales Prices under Inventory.

    Every time I try to use the Price List option in Smart List I get the Level Number, NOT the dollar value.

    Export two spread sheets kind of defeats the purpose of Reports, no?

    Smartlist Builder is a verrrry nice add-on but it is too expensive for us at theis time.

    I quess I will have to continue with the inputting of the Level 1 selling price into the "Item Short Name" field.  At least I can pull this field into the report correctly., plus it shows up on the Inventory Inquiry screen which is helpful.  Just AT LOT OF WORK !!!!

    Tx yall

    Mary

  • Community Member Profile Picture
    Community Member on at

    Yes Mary - you're right!! There is no standard smartlist called 'Item Sales Prices' - its one I created myself using Smartlist Builder ..D'oh - Apologies for that - I should have checked before I posted.

    Do you use SQL Server Reporting Services?

    You could also modify a standard GP report? Click on Reports >> Inventroy >> Item >> Item Price List. If you don't find a filter to suit - you could insert a restriction in Report Writer. You could also edit the report format to make it XL friendly. On this report there is a tick box to exclude Discontinued Items.

    Hope this helps.

    Ian.

  • Community Member Profile Picture
    Community Member on at

    I get big red X with message: Canot access this report because the dictionary containing it is not loaded.   !!??

  • Community Member Profile Picture
    Community Member on at

    Understood.

    This is a standard report based on the standard Inventory module - so the cause of the error is most likely that the report was modified at some stage, rolled out to your user ID, and then the modified report was deleted. So when you try and print - its looking for he modified version, but cannot find it.

    What you need to do as a first step is go to GP User Security and take rights away from this report for your user ID. (Tools >> Setup >> System ...and then its eithre 'Security' or 'Alternative Modified Forms and Reports' depending on what version of GP you are using). This will give you back access to the original version of the report.

    Is this process something you are experienced with? If not, can you talk to someone internally about doing it? It really needs 'eyes on' to ensure the correct steps are taken.

    Best regards,

    Ian.

  • Community Member Profile Picture
    Community Member on at

    Again, there is NO listing for Item Price List

  • Community Member Profile Picture
    Community Member on at

    Hi Mary - Maybe we are at odds. When I print the report I get the sales price for items based on what is entered in he Cards >> Inventory >> Item >> Price List window.

    Are we talking about the same piece of data?

    Could you post a screen shot of the window where the data you want on the report / smartlist is displayed?

    Best regards,

    Ian.

  • Community Member Profile Picture
    Community Member on at

    s927.photobucket.com/.../Dynamics%20Examples

    Here is a link to the pics

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans