--- title: How to Create Specialty Manufacturing Reports in Sage X3 description: Your out-of-the-box software lacks the reports you need? Count on Southeast Computer Solutions's skills in creating specialty manufacturing reports in Sage Enterprise Management (Sage X3). image: https://blog.southeastcomputers.com/hubfs/Logos/Sage_Enterprise_Mngt_stacked_RGB.png --- **[Sage X3](https://www.southeastcomputers.com/sage-enterprise-management-infomation) | **[Sage 100cloud](https://www.southeastcomputers.com/sage-100cloud-information) | [Acumatica](https://www.southeastcomputers.com/acumatica-information) | [LATAM Fiscal Requirements](https://www.southeastcomputers.com/latam-fiscal-requirements-localize-sagex3-sage-500) | [Contact Us |](https://interact.southeastcomputers.com/contact-us) [ 888-773-2161](tel:888-773-2161)**** [![logo-naw-southeast-website](https://blog.southeastcomputers.com/hs-fs/hubfs/logo-naw-southeast-website.png?width=578&height=160&name=logo-naw-southeast-website.png "logo-naw-southeast-website")](https://www.southeastcomputers.com) This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. ![Florida Miami Image](https://blog.southeastcomputers.com/hs-fs/hubfs/Banners/Florida-Miami.jpg?width=2880&name=Florida-Miami.jpg "Florida Miami Image") # Blog Want our new blog posts delivered right to your inbox?  December 27, 2016 # How to Create Specialty Manufacturing Reports in Sage X3 - [Tweet](https://twitter.com/share) ![authorIcon](http://www.sparkreaction.com/hubfs/Oceania%20Theme%202016/Images/authorIcon.png) By [Frank Bernal](https://blog.southeastcomputers.com/author/frank-bernal) ![topicIcon](http://www.sparkreaction.com/hubfs/Oceania%20Theme%202016/Images/topicIcon.png) [Sage X3](https://blog.southeastcomputers.com/topic/sage-x3), [Sage Enterprise Management](https://blog.southeastcomputers.com/topic/sage-enterprise-management), [All](https://blog.southeastcomputers.com/topic/all) [![How to Create Specialty Manufacturing Reports in Sage X3](https://blog.southeastcomputers.com/hubfs/Logos/Sage_Enterprise_Mngt_stacked_RGB.png) ](https://blog.southeastcomputers.com/creating-specialty-manufacturing-reports-in-sage-x3) When you listen to a sales pitch on [business intelligence](https://blog.southeastcomputers.com/how-sage-x3-aids-business-intelligence), you may walk away more confused than when you started because, if you’ve been around long enough, you’ve seen many reporting tools – from Lotus to MS Excel to FRx to Crystal Reports, etc. You then hear about other reporting tools that are better suited for reporting financial data versus operational data; all of this can be confusing and overwhelming.   Ultimately, you come to the realization that many tools can do many things, as long as you have the expertise and the imagination to develop what you need. As we always tell our clients, one thing is for sure: if the data has been captured in the system, we can report on it! Here's how to create speciality manufacturing reports in [Sage X3](https://www.southeastcomputers.com/sage-x3).[![5 Sage X3 Tips, Tricks & Tactics to Make Your Life Easier](https://no-cache.hubspot.com/cta/default/418036/bd6a1c4c-c91f-475a-b00f-528979563fc3.png)](https://cta-redirect.hubspot.com/cta/redirect/418036/bd6a1c4c-c91f-475a-b00f-528979563fc3) ## Out-of-the-Box Options Sage X3 comes with many reports, inquiries, and graphical requesters right out of the box, with no customizations. Another tool, Sage Enterprise Intelligence (SEI), also comes with many predefined cubes, reports, and dashboards.   One area we found lacking was in comparing manufacturing standard data points vs. actual data points. This became sorely evident with a customer that “manufactures” pies. The operations team was coming off an implementation where manufacturing functionality wasn’t being used; one of the main motivations to implement Sage X3 was to gain detailed insights into their manufacturing performance. ## What the Customer Wanted The customer did a fantastic job of learning how they wanted to use Sage X3 and implemented the system in record time. When the time came to compare actual performance versus the standards they had defined, however, they were disappointed. You can do it out of the box, but it’s very cumbersome – one work order at a time – and there are reports that provide comparatives by product or work center, but they lack enough details to see trends and don’t work well in Excel.   **We used the customer's criteria when creating the specialty manufacturing reports in Sage X3: **   - Performance by Work Center Group: Actual run-time vs standard by Shift, Work center group, Work center, and date range - Downtime: Actual downtime by Work center group, by Work center, and by date range - Scrap: Actual scrap by Product, by Work center group, by Work center, and by date range ### [Contact Us to Request a](https://interact.southeastcomputers.com/sage-x3-demo) [Sage X3 Demo](https://interact.southeastcomputers.com/sage-x3-demo) ## How We Gave It to Them In order to provide this information, we built views (cubes) that would be used within Excel using the SEI Excel add-in. Additionally, we used the power of macros in Excel and built a macro that takes the raw data and creates worksheets by Work center so the customer doesn’t have to do this manually each time they refresh the data. And, since the customer wasn’t asking for something extremely detailed, we were able to develop a few reports that can be used by all. Here’s what each of the reports looks like (with data removed to protect the innocent):   ![creating specialty reports in Sage X3](https://blog.southeastcomputers.com/hs-fs/hubfs/Images/performance%20by%20workcenter%20group.jpg?width=665&name=performance%20by%20workcenter%20group.jpg "creating specialty reports in Sage X3") **![creating specialty reports in Sage X3](https://blog.southeastcomputers.com/hs-fs/hubfs/Images/manufacturing%20reports%2c%20downtime.jpg?width=535&name=manufacturing%20reports%2c%20downtime.jpg "creating specialty reports in Sage X3")**   **![creating specialty reports in Sage Enterprise Management](https://blog.southeastcomputers.com/hs-fs/hubfs/Images/manufacturing%20reports%2c%20scrap.jpg?width=533&name=manufacturing%20reports%2c%20scrap.jpg "creating specialty reports in Sage Enterprise Management")**   Ultimately, this is another example of what we always say at Southeast Computers Solutions: “If you can imagine it, we can build it.” Let us build something for you.   If you have questions about creating manufacturing reports, or just questions about software in general, please [contact us](https://www.southeastcomputers.com/contact-us) – we’d love to help! [![The Return of Sage X3 Tips, Tricks & Tactics to Make Your Life Easier](https://no-cache.hubspot.com/cta/default/418036/ff0cb281-384e-46a0-a2b9-27a708d1ed5e.png)](https://cta-redirect.hubspot.com/cta/redirect/418036/ff0cb281-384e-46a0-a2b9-27a708d1ed5e)   ### [Talk to Us About](https://www.southeastcomputers.com/software-support) [Sage Software Support](https://www.southeastcomputers.com/software-support)     # # #   ***About Southeast Computer Solutions*** *Southeast Computer Solutions is based in Miami, Florida and has additional operations in Mexico. For over 30 years, we have positively impacted the success of small and mid-sized businesses with effective business management implementations that improve our clients’ operations. We listen, we are accessible, and we care. Learn more by [visiting our website](“http://www.southeastcomputers.com/”) or calling 305-556-4697.*   | ![Sage Partner Logo](https://blog.southeastcomputers.com/hubfs/sage-Partner-logo-1.png "Sage Partner Logo") |   | ![Sage Enterprise Management](https://blog.southeastcomputers.com/hs-fs/hubfs/Logos/Sage_Enterprise_Mngt_stacked_RGB.png?width=1035&name=Sage_Enterprise_Mngt_stacked_RGB.png "Sage Enterprise Management") | | --- | --- | --- | SHARE THIS STORY [**](https://www.facebook.com/sharer/sharer.php?u=https://blog.southeastcomputers.com/creating-specialty-manufacturing-reports-in-sage-x3&title=How%20to%20Create%20Specialty%20Manufacturing%20Reports%20in%20Sage%20X3&picture=https://cdn2.hubspot.net/hubfs/418036/Logos/Sage_Enterprise_Mngt_stacked_RGB.png&description=Your%20out-of-the-box%20software%20lacks%20the%20reports%20you%20need?%20Count%20on%20Southeast%20Computer%20Solutions's%20skills%20in%20creating%20specialty%20manufacturing%20reports%20in%20Sage%20Enterprise%20Management%20(Sage%20X3).) | [**](https://twitter.com/intent/tweet?source=https://blog.southeastcomputers.com/creating-specialty-manufacturing-reports-in-sage-x3&text=How%20to%20Create%20Specialty%20Manufacturing%20Reports%20in%20Sage%20X3) | [**](http://www.linkedin.com/shareArticle?mini=true&url=https://blog.southeastcomputers.com/creating-specialty-manufacturing-reports-in-sage-x3&title=How%20to%20Create%20Specialty%20Manufacturing%20Reports%20in%20Sage%20X3&summary=Your%20out-of-the-box%20software%20lacks%20the%20reports%20you%20need?%20Count%20on%20Southeast%20Computer%20Solutions's%20skills%20in%20creating%20specialty%20manufacturing%20reports%20in%20Sage%20Enterprise%20Management%20(Sage%20X3).) [NEXT POST **](https://blog.southeastcomputers.com/customizing-reports-in-crystal-reports) ### Related posts [Read More](https://blog.southeastcomputers.com/automating-shipping-in-sage-x3) ### [Automating Shipping in Sage X3](https://blog.southeastcomputers.com/automating-shipping-in-sage-x3) By [**Benjamin Partout**](https://blog.southeastcomputers.com/author/benjamin-partout) July 5, 2017 In this blog, we’re highlighting another one of [Sage X3’s great features](https://www.southeastcomputers.com/sage-x3): automating tasks. This is an important feature because it.. ![topicIcon](http://www.sparkreaction.com/hubfs/Oceania%20Theme%202016/Images/topicIcon.png) [Sage X3](https://blog.southeastcomputers.com/topic/sage-x3) [Read More](https://blog.southeastcomputers.com/pick-ticket-security-in-sage-x3) ### [Pick Ticket Security in Sage X3](https://blog.southeastcomputers.com/pick-ticket-security-in-sage-x3) By [**Benjamin Partout**](https://blog.southeastcomputers.com/author/benjamin-partout) June 27, 2017 [Sage X3 is a highly scalable solution](https://www.southeastcomputers.com/sage-x3) – it can adapt to companies with as few as ten users and enterprise companies with thousands of.. ![topicIcon](http://www.sparkreaction.com/hubfs/Oceania%20Theme%202016/Images/topicIcon.png) [Sage X3](https://blog.southeastcomputers.com/topic/sage-x3) ### Search  --- ### Recent Posts ### Posts by Topic - [All (267)](https://blog.southeastcomputers.com/topic/all) - [Sage Enterprise Management (94)](https://blog.southeastcomputers.com/topic/sage-enterprise-management) - [Sage X3 (85)](https://blog.southeastcomputers.com/topic/sage-x3) - [ERP (60)](https://blog.southeastcomputers.com/topic/erp) - [Productivity (31)](https://blog.southeastcomputers.com/topic/productivity) - [Inventory Control (30)](https://blog.southeastcomputers.com/topic/inventory-control) - [Acumatica (21)](https://blog.southeastcomputers.com/topic/acumatica) - [Food and Beverage (21)](https://blog.southeastcomputers.com/topic/food-and-beverage) - [Cloud Computing (14)](https://blog.southeastcomputers.com/topic/cloud-computing) - [Community (13)](https://blog.southeastcomputers.com/topic/community) - [Sage 100cloud (12)](https://blog.southeastcomputers.com/topic/sage-100cloud) - [Sage 100c (11)](https://blog.southeastcomputers.com/topic/sage-100c) - [Add-Ons (10)](https://blog.southeastcomputers.com/topic/add-ons) - [UDI (9)](https://blog.southeastcomputers.com/topic/udi) - [Manufacturing (8)](https://blog.southeastcomputers.com/topic/manufacturing) [![Sage100cloud_RGB](https://blog.southeastcomputers.com/hs-fs/hubfs/Sage100cloud_RGB.png?width=442&name=Sage100cloud_RGB.png "Sage100cloud_RGB")](https://blog.southeastcomputers.com/sage-100cloud-information) [![Sage500_logo](https://blog.southeastcomputers.com/hs-fs/hubfs/Sage500_logo.png?width=369&name=Sage500_logo.png "Sage500_logo")](https://blog.southeastcomputers.com/sage-500-information) [![sage x3 logo](https://blog.southeastcomputers.com/hs-fs/hubfs/sage%20x3%20logo.png?width=640&name=sage%20x3%20logo.png "sage x3 logo")](https://blog.southeastcomputers.com/sage-enterprise-management-infomation) [![Acumatica_Logo450](https://blog.southeastcomputers.com/hs-fs/hubfs/Acumatica_Logo450.png?width=450&name=Acumatica_Logo450.png "Acumatica_Logo450")](https://blog.southeastcomputers.com/acumatica-information) ### About Us Successful transformation of a company’s systems and business processes requires strong project leadership with a passion to create effective processes-processes that will work for today and assist in further growth. ![scs-logo-short.png](https://blog.southeastcomputers.com/hs-fs/hubfs/scs-logo-short.png?width=500&name=scs-logo-short.png "scs-logo-short.png") ### Useful Links #### Services - [Software Implementation](https://www.southeastcomputers.com/software-implementation) - [Project Management](https://www.southeastcomputers.com/project-management) - [Software Training](https://www.southeastcomputers.com/software-training) - [Software Support](https://www.southeastcomputers.com/software-support) - [Custom Programming](https://www.southeastcomputers.com/custom-programming) - [IT Consulting](https://www.southeastcomputers.com/it-consulting) - [International](https://www.southeastcomputers.com/international) --- #### Products - [Sage X3](https://www.southeastcomputers.com/sage-enterprise-management-infomation) - [Sage 100cloud](https://www.southeastcomputers.com/sage-100cloud-information) - [Acumatica](https://www.southeastcomputers.com/acumatica-information) - [Sage 500](https://www.southeastcomputers.com/sage-500-information) ## Recent Blogs ### Get in Touch #### Miami Location **15165 NW 77th Ave., Suite 2009 Miami, FL 33014 ** [888-773-2161](tel:888-773-2161) ** [Info@southeastcomputers.com](mailto:info@southeastcomputers.com) Within business hours, we'll reply in 24 hours or less --- #### Mexico Location ** Miraflores 221, Col. Insurgentes San Borja. CDMX, México 03100 +52 55 6811 3044   Copyright © Southeast Computer Solutions 2018 | [Privacy Policy](https://www.southeastcomputers.com/privacy-policy) - [Facebook](https://www.facebook.com/SCSolutions) - [Twitter](https://twitter.com/scsolutions) - [LinkedIn](https://www.linkedin.com/company/southeast-computer-solutions)   ![](https://www.facebook.com/tr?id=1761620344049548&ev=PageView&noscript=1)