Numeric Will Never Equal Alpha
Here is a really frustrating thing about some tables or files, depending on your IT dialect, with in EnterpriseOne. After working with EnterpriseOne for awhile (10 minutes should do) you will notice that the omniscient creators of the application did not like to make things easy. Take, for instance, the issue that Alan VanNice addresses on his blog: joining the F4211 (Sales Orders) and the F4801 (Work Orders).
Our staff has talked about this a number of times. It is a strange way of relating tables. You see the RORN on the F4801 is an alpha field where the DOCO field on the F4211 is numeric. Now, this issue can be overcome fairly easily in SQL with a CAST function. However, inside of E1 the issue is a little more complicated. Alan does a great job explaining his method using the EnterpriseOne Report Design Aid.
Tags: e1, enterpriseone, sql, Uncategorized
