Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Manufacturing Reports
Microsoft Dynamics GP (Archived)

Manufacturing Reports

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all,

I was wondering if anyone can help me in the right direction regarding manufacturing reporting.

We have several hundred actively manufactured items. We go through the full motion of creating MOs, back-flushing the picklists, outsourcing, collecting time spent on that MO by each employee, etc. At the end, I can go into an individual MO and pretty accurately see what it cost us to produce each item.

I would like some reports where we can have some oversight. i.e. to see which items are produced, how often we produce them, and especially at what cost. This way we can have a general concept of what is profitable, or what needs improvement.

We don't have SQL reporting enabled (do you need SQL 2008 for this?) and the most useful manufacturing reports we have; I had to create manually in excel report builder. The canned manufacturing reports are nothing shy of useless.

 Any ideas, comments, SQL views?

*This post is locked for comments

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Re: Re: Manufacturing Reports

    I have been in manufacturing for 30 years and everyone wants different things in their reports.  Even the manufacturing orders vary from shop to shop.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Manufacturing Reports

    Thanks,

     I was afraid of that. I don't really have any issues creating the excel reports other than that it's very time consuming. The variances associated with an MO are spread over a number of tables from what I remember.

    I thought maybe there were some resources, or pre-made reports for this. It would be good even if we have some wiki, or any other type of collaboration so we don't all find ourselves doing the same things over and over.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Manufacturing Reports

    Your question is very broad but I do understand your frustration.

    GP retains a LOT of information on manufacturing orders that will allow you to get the information you need.  You can create these reports in SSRS, Excel Report Writer, SmartList Builder, Crystal Reports, or Access, pick your poison.

    If you look at the Order Variance Inquiry for MOs, you can see that after the MO is closed (until the data is purged) you can drill down to tons of data.  If the data is there, you can report on it any way you want.

    Do you know how to find the tables that contain the data you need?  Look at Resource Descriptions starting with the windows.  Look up a specific window and the list of tables used in that window will be shown.  There will be tons of them, including sources of data in addition to the tables that actually store the data you are looking for.  Also, get a copy of the Support Debugging Tool that David Musgrave wrote.  It is a MS GP free tool you can down load from Customer Source.  It also helps locate data storage tables.

    Now, if you are not good at finding data storage and/or writing custom reports, you might want to get together with your partner or one of us that works with Manufacturing on a daily basis and can help you.  I can be reached at 321-277-1341

     

     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans