I'm using Macola ES with PCCharge Pro server. When we submit an order with a credit card, it accepts the charge, and I can see the charge on the customer card. The problem is that I can't run the report to show the transactions. I was able to determine the actual crystal report to be Macoecctran.rpt based on the following error message:
"Error in file macoecctran. failed to retrieve datat from the database. Details: [Database Vendor Code: 241] This indicates there are missing table\field\procecures.
I opened that report in crystal reports to find the report is querying the following tables :
oeccfil_sql
oehdrhst_sql
oeordhdr_sql
I'm assuming since each table has ord_no as a field name they are joined on that field. I am able to see the cc authorized in oeccfil_sql, and match that to the same ord_no in eohdrhst_sql, but I can't find the same ord_no in oeordhdr_sql. I think this is why my reports are failing but I don't know why the data isn't there. Any advice?
~N
"Error in file macoecctran. failed to retrieve datat from the database. Details: [Database Vendor Code: 241] This indicates there are missing table\field\procecures.
I opened that report in crystal reports to find the report is querying the following tables :
oeccfil_sql
oehdrhst_sql
oeordhdr_sql
I'm assuming since each table has ord_no as a field name they are joined on that field. I am able to see the cc authorized in oeccfil_sql, and match that to the same ord_no in eohdrhst_sql, but I can't find the same ord_no in oeordhdr_sql. I think this is why my reports are failing but I don't know why the data isn't there. Any advice?
~N