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) / Year to date usage for...
Microsoft Dynamics GP (Archived)

Year to date usage for Items

(0) ShareShare
ReportReport
Posted on by Tami Farrelly 5,080

I cannot seem to find a year to date usage report for items??

I can see item sales current and last year...but nothing that links into the manufacturing use.

This is pretty standard reporting

GP 2010 R2 with Manufacturing

*This post is locked for comments

I have the same question (0)
  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Hello Tami

    Good to hear back from you again,
    I do agree with you that inventory module specifically provides a bit of limited reporting capabilities, leaving a wide space for customization. I have worked on several inventory reports and might provide something related to your requirements.

    Can you provide further specification of the concept of the report you are looking for ? Would it be all the inventory transactions related to manufacturing module specifically ?

    Your feedback is highly appreciated,

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at

    Hi there Mahmoud

    Yes....how many used in manufacturing specifically...ytd, mtd...or custom date range..

    I guess I could write a custom report...just surprised there isn't some canned report that does this??

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Hello Tami,

    you may check the following reports:

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at

    Thank you for the links....do you happen to have some document on creating views in SQL... on which I can store then hit with Crystal reporting for drill down??

    That would be helpful as I am new to the reporting and require a lot of customization. I have a query that our consultant created for us...and had a brief overview of creating a Sql view...un fortunately that was a while back and I have forgotten the procedure.

    I think it is create view..paste in the query and then save??

    Thank you again!

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Tami,

    To create a view from a "SELECT" statement, simply consider adding few lines as follows:

    CREATE VIEW View_Name
    AS
    SELECT
    ...

    ...

    GO
    GRANT SELECT ON View_Name TO DYNGRP

     

    Your feedback is highly appreciated,

    Never hesitate to share any further inquiries,

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Hello Tami

    Any updates on the inquiry above ?  Hope everything is on track as expected.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at

    to be honest...it is a little beyond me...I have been using a subreport

    if {IV30300.TRXQTY} <0 and {IV30300.DOCDATE} >= Date (2014,10 ,01 )then {IV30300.TRXQTY} else 0

    in my crystal reports...but I need a format in smart list ...as it doesn not export well into excel

    Tami

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