lstewart
Forum Replies Created
-
Nevermind, I found a way to expand it by manipulating the code. Thanks again. This was just what I needed to get me started.
-
Thanks Mike. I tried the code and it works on this test case. Can you modify it to get all RO that are linked to an MO (SI_Number starting with M)
-
Thank you so much. I spent so much time joining tables together with no success.
-
The person I am designing the report for wants these fields from Stock Audit. I will try the table you mentioned to see if it gives me the same information that’s in the Stock Audit view.
-
Thanks Thiago. I stumbled upon a solution yesterday using the Alternates_View. I joined Master_PNM_Auto_Key to PNM_Auto_Key on Parts Master table, and it worked.
-
What’s the linkage between Parts Master and CQ History with Alternates. First attached image
Here’s the scenario. I want to determine what Parts have had no customer quotes for the last 3 yrs. In the attached figure, X-D4N-300M is in our inventory and has no quotes, but it’s alternate X-D4N does. I want to have both X-D4N-300M and X-D4N associated with the same quote so I can do a lookup on X-D4N-300M and see that it has had quotes associated with it even though the quote was on its alternate.
I’ve tried linking the CQ_Detail to Parts_master twice. One join is on ALT_PNM_AUTO_KEY to PNM_Auto_Key and PNM_Auto_key to PNM_Auto_key. (Image 3 & 4) I get the same part number in the Crystal Report (image 2).
-
Thanks guys, I abandoned the view after using your tips. I have an almost complete solution. This Crystal Report I’m designing is challenging, but I’ve learned a lot from it.
-
Thanks David.
-
No. This is an entirely new problem. His post did help with the issue I had posted about, but I found an alternate solution using the VIEW_SPR_WO_BOM table. I’d like to be able to get the Qty Issued from the Stock Line but Stock table doesn’t have QTY Issued field which is weird. I wonder where that Qty Issued comes from. I searched through the Quantum Data Dictionary to find all tables that have that field but the ones I tested did not give me the result I was looking for.
-
How do you join WO_BOM table to STOCK table
-
This was very challenging, but I managed to come up with a solution to getting the year and month in the cross-tab header using fiscal_start from GL_Fiscal and GL_Period. Adding the fields directly blew up the report.
My solution was to use SQL statements to get the fiscal_start from GL_Fiscal and GL_Period and use formulas to format the dates as year and month. I also had to use Select Distinct Records and Perform Grouping on Server option in the Database menu
-
Thanks guys, I will experiment with these ideas when I have some slack time and report back.
-
I am so glad I found this post because I was having the hardest time trying to link PO_Details and SO_Details. Added Purchase_Sales and used left outer joins and it worked perfect.
-
I am so glad I found this thread. I’ve been all morning trying to figure out how to link RO_Detail to WO_Operation. I tried WO_BOM as suggested in the post and it worked perfectly. Thank you, thank you, thank you.
-
Figured out the solution to my problem: This is a repost of what Jake wrote plus some corrections. This will allow you to link Customer Quotes and Contact Manager tables in a Crystal Report.
PROJECT_HEADER links to PROJECT_LINKS on PJH_AUTO_KEY
PROJECT_LINKS links to CQ_HEADER on KEY_VALUE= CQH_AUTO_KEY
COMPANIES links to CQ_HEADER on CMP_AUTO_KEY.
CQ_STATUS links to CQ_HEADER on CQS_AUTO_KEY
PROJECT_HEADER links to PROJECT_DETAIL on PJH_AUTO_KEY
SYS_USERS links to PROJECT_HEADER on SYSUR_AUTO_KEY
FILTERS: PROJECT_LINKS.ORDER_TYPE = ‘CQ’
CQ_STATUS.DESCRIPTION = OPEN
CQ_HEADER.HISTORICAL_FLAG = FALSE
-
I tried what you suggested, but here’s what’s happening now in Crystal Reports.
I have two filters: CQ_Status.Description = OPEN, Project_Links.Order_Type = CQ.
However, I am only getting records where historical flag = true and not where historical flag = false (I have no filter for historical flag). I don’t get a full record set. The CQ_Numbers are in the 160000 range.
I checked 60820 in Customer Quotations in Quantum and clicked Contact Management Links button and 44885 does not appear for the Contact # (i.e. PRJ_Number)
I’ve attached some screenshots from Quantum and Crystal Reports