Thank you for the courtesy of your response. I have not used Crystal Reports in over 10 years and am relearning to become an intermediate user as a goal.
First off, according to our Macola version 7.7.300, credit holds are a status of "C" not "H" (see attachment). Status "H" is cancelled order according to this so I am confused with your response on that.
Listed below are the fields we want on the report to get credit holds and I did mean only getting credit holds as of "now" not a retroactive point in time. If I should NOT use tables OEHDRHST_SQL and OELINHST_SQL tables, please help me with what tables I should use if I want the following fields
1> ord_type
2> ord_no
3> status (issue with "H" vs "C" needs clarification)
4> ord_dt
5> entered_dt
6> ship_to_name
7> shipping_dt
8> slspsn_name
9> prod_cat_desc
10> item_desc_1
11> qty_ordered
12> sls_amt (or ordered amount?)
My thoughts / questions:
- Should items 1> - 7> above come from OEORDHDR_SQL table?
- What is relevance of using OEORDLIN_SQL table?; the only fields from list above that are relevant to my objective are "ord_type" and "ord_no".
- I apparently need to incorporate the ARSLMFIL_SQL because item 8> above is needed for this report
- Also need table IMCATFIL_SQL for 9> above as we want the product information on this report
- Regarding the sales / order amount, I am a bit confused about this because I can only get sls_amt off the OELINHST_SQL table which you are indicating not to use. What field/table gets me the order amount on credit hold?
I hope this provides more clarity to my objective and I really appreciate your technical assistance as I am quickly learning how to navigate through Macola tables and fields. As I mentioned, the credit hold report in Macola is a garbled mess and I want to make a better one.
Regards,
Jeff