General Ledger Code Set Upload

Two changes have been made to the GL code sets, the grouping, name and codes are now editable and there is now an upload facility to import a client’s code set. 

The new template export and upload facility enables a tenancy administrator to edit or add codes to an existing code set, or to upload values to a new code set. 

The process is as follows:

• Open the code set on the codes tab
• Expand the Export to Excel button 
• Select upload template format, this will download a template, if you already have values in the code set it will include these
• The Excel download has a fixed number of columns and headings which are used by the system to upload the code set values. 
• For all existing values in the code set, there is a reference key, do not change this value as it is used by the system to match the line item in the Excel file to the code set entry.
• Code set groupings, names, codes, debit/credit and organisation unit(s) can be edited. Inactive codes can also be set to active. 
• New line items can be added to the template for these they will have a blank reference key, so the system recognises that they are to be added. 
• Click on the upload button an select the completed template, the system will list those items that have changes, and new line items with the option to select all or to select specific line items. 
• If you are editing an existing GL group, name, or code you could be affecting the output of any GL Journal reports which are using that value.