I've noticed that some of the EE Financial tables (e.g. GL (GL Accounts) & Journal (Daybooks)) will contain "internal" codes that are not very human readable. These codes are translated into a more human-readable form for QAD Views.
Here is an example...in the GL table, there is an internal GL Type called DEBTORCONTROL, which is translated to the much more readable "Customer Control Account" when displayed in Views. The issue that we’re facing is that when developing custom reports/browses/etc., all we can see is DEBTORCONTROL which is the value of the database field.
Does anyone know the mechanics of how the translation is done? We can see the human-readable version in Financial Translation View (36.24.11), but we cannot make the connection. Has anyone done that for custom reporting? We asked QAD Support and they haven’t been able to help.
Appreciate any insights…