Custom Fields and Joins – Basics

​Add custom Fields and Joins to a Product to improve Reporting.  Custom Fields are useful for creating  calculated fields that are done Server side in SQL.  In this way logic specific to a client site can be deployed where reports require complex calculations and also custom sort orders.   Custom Joins allow the join of Table in ways that have not been implemented in the master Datamodel.  In the example a join back from Chart of Account to a GL Transaction table is shown so that all the Account will appear in a report even when Transactions for an Account do not exist

Please note

If you create a Custom Fields and Joins while using Client Setup Local Connections then other users who are Remote Connecting to the Central Sharperlight App Server will not see them.    This is because you would be making changes outside of the App Server and therefore it does not know about these changes.  To avoid this one should Remote Connect to the App Server and make the changes there so that everyone can see them.   If changes are done outside of the Sharperlight App Server Service you will need to restart it so it can pickup the new changes.