Engineering Masters and their Material Requirements

Does anyone know of a way that I can run a report that will show all of the Engineering Masters and their material requirements? I would thing there would be an easier way than opening each EM one by one.

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

ztrue

I have no idea if there is a canned report, but if you are using an MS SQL backend this will get it for you:

select WORKORDER_BASE_ID, PART_ID from REQUIREMENT where WORKORDER_TYPE = 'M' and WORKORDER_LOT_ID = (select ENGINEERING_MSTR from PART where ID = WORKORDER_BASE_ID)

This gets you the top layer. If you run the results of that through this query again, you can get the grand parents, again for great grand parents, and again for great great grandparents (you see where I am going with this I hope).

kedar-karnik

There is a crude report under the Mfg/Eng - Bill of Material Report
Select Eng Master radio button
Enter the starting and ending part numbers
uncheck the boxes below
print to file or view

unknown

Zack - I am working on some similar report where I'm trying to get the SQL to sort the data in the same level sequence as in the canned Bill of Material Report (VMBOMRPT.qrp). Do you have any suggestions?

unknown

I recommend creating VIEWS in SQL Management Studio, sorted as you wish, and named creatively to denote same. Then create extended queries within the report format overrides area - referencing the view name - for any new variables and only rudimentary joins will usually need to be done so that the QRP knows to properly relate records accordingly. i.e. in our Bookings Report by Order ID and Date is as follows:

SELECT USER_1 , USER_3 , STATE , COUNTRY , FABRICATED , CREDIT_STATUS FROM dbo.**YourViewNameGoesHere** WHERE CUST_ORDER_ID = :ORDER_ID AND LINE_NO = :LINE_NO

(Of course, the "String" types of variables for USER_1, USER_3, STATE, COUNTRY, FABRICATED, CREDIT_STATUS all need to be created so the QRP can see and use them as "drag and drop"pable fields in Report Builder)
Note: If you use Crystal Reports this overall may still apply to you, i.e. use SQL Views first, then feed Crystal? I dunno....but if you use Gupta Report Builder and so on - go here!

This serves a few purposes:
1. Speed of the report will be a lot faster than by using the QRP exclusively to search, parse, sort, define, join, and of course output all of that because the View will usually do most, if not all, heavy lifting, sorting, etc before Gupta ever gets its hands on it or mind into the mix;
2. Immediate testing and results, can be done in SQLMS without interrupting production, reports, etc so you know your results will work or not before ever touching Report Builder, et al;
3. The employee(s) that rely on said report, also are not interrupted nor the QRP being offline, broken, file-locked in use, etc while you work on a View;
4. These Views can then be accessed as "tables" by using "Get external data" features within MS Access, Excel, even Word in many cases as desired.....so then too can other 3rd party applications, reporting & data mining tools, etc. - also with equally fast speeds typically;
5. By working on Views, you leave Visual end users, Visual reports, Gupta anything, SQL Server itself even usually - all untouched while you test, generate, tweek, test more, generate again, and so on - the View, it's output, etc without anyone being any the wiser, on-the-fly;
5. There are more reasons, but usually 1-5 above are typically compelling enough to most folks just stop (reading), drop (prior plans and ideas) and roll (on to building Views on their SQL Server without even needing to go any further except to get some "SQL Views 101" and how to really make those tie into your Gupta QRPs without reinventing the wheel - but maybe that is just me?

You can sure contact me off list here if you would like to know more information. We also use SmartViews from Synergy and believe me when I tell you our goal is to completely circumvent Visual canned reports as we move forward with more SmartViews dashboards, views, etc. - but much of the same can be achieved in MS Office too, especially Office 2013+ Professional and newer Office 365 flavors.

My $.02

[Updated on 3/24/2015 2:41 PM]

unknown

Thank you, I should have clarified that I'm working on a SSRS report to replicate the caned QRP report along with including Christy's needs.

Basically I have replicated the canned QRP in SQL that includes inventory availabilities for each line. Where I'm stuck is getting the levels to come out the same in SQL as in the QRP. The levels are the 1st column in the QRP report.

Copyright © 2025 Infor. All rights reserved.