I notice OEORDH has a column EXPDATE but our customer service says it does not reflect the same date in the report they need. What is the column and what table is the expected ship date located?
Hi Walter Anderson without digging into the Crystal Report and looking at the database I'm not sure, and don't have time presently (someone might). Meanwhile, try looking through the OE tables and see if you can locate the field you need and add it to the Crystal Report. Hopefully the table or datapiped field will already be on the report, if not you might need to stitch it in.
OE fields: https://sageaom.kcsvar.com/AOM2022/OE.xml (thanks Kerr Consulting)
(Make sure you scroll down the Tables section)
Once you have a Table that looks like what you need, drill into it to identify the field that may help. It could also be that the field you're using is correct, but its the time/moment the data is committed that is causing the issue. I.e. some fields in Crystal Reports will show details at the time it was posted, other fields showing similar data show the current details. They won't be the exact same fields, they will come from different tables.
Good luck!
