Can't find what you're looking for? Still have questions? Contact customer support

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 214 Next »


2022

2021

2020

2019

  1. System Default → Auto Create and Balance Tax Lines

    1. Added additional criteria for when a tax line is automatically created.

    2. Under the Indirect Tax Codes setup If ‘create distribution line' is ticked or if the tax rate > 0 then a tax line will be automatically created for that tax flag.

  1. Invoice Inquiry Reports

    1. Fixed an issue with the paid date field returning Unpaid reports as blank.

  2. Invoice Inquiry → Unposted Invoices

    1. Fixed an issue that allowed users to edit fields that should not have been editable (Currency, Tran Number, etc).

  1. Invoice Inquiry Reports

    1. Updated 1099 reports with a paid date field

  2. New Tax Balance System Default → Auto Create and Balance Tax Lines

    1. Added a new tax balance system default. It is turned off by default for all Australian databases and must be manually enabled. See: Auto Create and Balance Tax Lines System Default

  1. Financial Reports - Period Range

    1. Further fixes for Sky Production’s Period Range reporting and templates.

  2. All Attachment Screens

    1. Fixed an issue where a blank attachment would load a file explorer in the attachment viewport.

  3. Vendor Master Maintenance

    1. Changed the excel class used for Exports in this module only.

  1. Financial Reports - Period Range

    1. Further fixes for Sky Production’s Period Range reporting and templates.

  1. Financial Reports - Period Range

    1. Added functionality to output the period range and dates when running over historical periods. Currently this report is only applicable to a specific Sky Database with a custom report layout.

  1. Purchase Order Reports

    1. Fixed an issue with PO Excel Reports corrupting due to an invalid character in the description fields.

  2. MTD VAT Submission Module

    1. Fixed an issue where the submission number was not being added to the records in GLMASTER.

    2. Added the SQL statement to update the submission number to the VAT logs.

  1. Reporting

    1. Fixed an issue with reports freezing if trying to export data with a negative transaction number.

  1. MTD VAT Submission Module

    1. Fixed some more VAT submission headers as per HMRC feedback.

  2. Petty Cash and Invoices Attachment Uploading

    1. Fixed an issue when uploading attachments and and the previous attachment subfolder still being in the buffer which applied to any new attachment uploaded

  1. MTD VAT Submission Module

    1. Fixed some missing and invalid web headers.

  2. Petty Cash → Petty Cash Entry

    1. Users can now update date in the PC Adv and PC Acc lines by exporting to excel and pasting it back in, or changing the date in the PC Entry field and then deleting the PC Adv and PC Acc lines and re-entering in amounts.

  3. Invoices → Invoice Entry

    1. Changed the background colour of fully approved invoices from light green to dark green

    2. Fixed the comments via the DPF tab not being sent to DPF when the Invoice is sent.

  1. Excel Exports

    1. Fixed an invalid character breaking the Excel Exports that resulted in a blank excel file in the Vendor Master Maintenance and Invoice Inquiry modules.

  1. Eclipse User Security Levels

    1. Went over every module to fix any missing areas where the user security level did not take effect.

    2. Fixed wildcard level 99 sec levels not working correctly

    3. Added Control Account Filtering to Invoice Entry, Cheque Printing, and PC Entry.

    4. For more information on sec levels see: User Security Access and Security Levels

  1. Control Table → System Defaults → SMTP → Admin Email

    1. Increased the character limit of this field so more emails could be assigned as an Admin email.

  2. Accounts Payable → Cheque Printing

    1. Removed some old unused libraries from the cheque printing screen.

  1. Unposted Journal Transactions

    1. Fixed issues with flags not updating (F,IN,TX) when an updated spreadsheet was pasted in.

  2. Invoice Entry → Send to DPF

    1. Fixed an issue where a user emailed invoices to the OCR module, as these were already in DPF the send to DPF option threw an error message.

  3. Financial Reports - Unposted PO checkbox

    1. Fixed an issue where if you had this option ticked and ran a Financial Report it was doubling up the orders that had been modified and were sitting in an unposted batch.

    2. This option will no longer include any modified orders sitting in an unposted batch.

  4. Added the Cent Trip Debit Card API

    1. This option can be found in the System Defaults → Petty Cash section

    2. See attached instructions.

  1. Integrated Barcode Scanning (AU ONLY)

    1. Rolled out iEclipse barcode scanning to the AU Side.

    2. A button is available under Invoice Inquiry that allows users to upload their barcode scans with the same functionality as the iEclipse website.

  2. Invoice Entry → Invoice Entry Paste in

    1. Removed the paste in from using the BSB, Acc Number and Acc Name in the template and overwriting the vendor details in Eclipse.

  1. Financial Reports → Send to Excel

    1. Fixed an issue with an invalid character breaking the excel report output.

  2. Invoice Entry → New Attachment Popup

    1. Removed this button as it had invalid code and was not working.

  1. Budget Worksheet → Transactions tab

    1. Fixed an issue with an invalid character breaking the excel report output.

  1. All Modules → Attachments tab

    1. Fixed an issue with attachments not displaying if GLMS Subfolder is populated and the attachment is in the root DATA folder.

  2. Bank Reconciliation → Reports

    1. Fixed an issue where the reports would export blank data if the report name differed from the default layout name.

  3. Excel Node API Update (AU ONLY)

    1. Replaced the Node API to fix numerous issues with the old Node API.

    2. Fixes an issue where the ETC, Fringe, Variance and Period Variance were blank in the Excel export if a Note is present.

  4. Invoice Inquiry → Invoice Input Reports

    1. Fixed an issue where running these reports over no data would not display anything.

    2. A blank report will now be displayed to the user if the filters they are using will not actually give them any data.

  5. Ledger Inquiry/Budget Worksheet → Excel Paste In

    1. Fixed an issue where the F, IN and Tax did not update Unposted transactions on paste in.

  6. Petty Cash → Paste NEW PC Form

    1. Added validation to the VAT Total Line on paste in.

  7. User Level Security Filtering → “Use User Sec Level for New Chart and Vendors”

    1. Added all missing data entry screens for filtering based on the user security level. Some screens were not correctly filtering based on the user security levels, vendor security levels and chart security levels.

  1. Invoice Entry → Invoice Line Distribution

    1. Fixed a missing tab on the Invoice Line Distribution Excel Export for Live Nation

    2. Exports these details to a second tab in the export: Oracle Code / Invoice # / Eclipse Code/ Description /  Amount/  Transaction # / Vendor Name

  1. Journal Entry → Security Levels

    1. Fixed security levels not applying to unposted journals.

    2. If a chart of account does not exist for the journal line, the user can still see the transaction line.

  1. Financial Reports → Send to Excel

    1. Fixed a bug where the ‘Send to Excel’ option would not save to the Report Default.

  1. Invoice Entry → Invoice Lines Export

    1. Fixed an issue where the excel export for Invoice lines was using the COM method instead of the Node API.

  1. Invoice Entry → Add two Tax Lines

    1. If a vendor is setup with a N tax flag and the Add Two Tax Lines system default is ticked, Eclipse will no longer automatically create two N flags in the invoice entry screen.

    2. Instead the system will create one tax flag and one non-tax flag as specified in the Control Table → Currencies tax flag selections.

  1. Financial Reports → Send to Excel

    1. This checkbox will now be saved to the report default correctly.

  2. Petty Cash Inquiry → Reports

    1. Removed the defunct checkbox Use Selected Records that was greyed out.

  1. Budget Worksheet Excel Paste In

    1. Fixed an issue where pasting a budget worksheet into Eclipse with the wrong amount of columns selected would spam the user with error messages for every incorrect row. It will now only throw one error message.

  1. Excel Node Reports

    1. Fixed an issue with Excel Node reports not exporting in Financial Reports and Ledger Inquiry if the show name contained invalid filename characters.

  1. Vendor Master Maintenance

    1. Fixed an issue with the Vendor Name column not sorting correctly.

  2. Cheque Posting

    1. Fixed issues with this window not resizing correctly and UI elements overlapping

    2. Added a minimum resize value to this window.

  1. Financial Reports - Closed Period Reports

    1. Fixed an issue with the closed period reports not generating the correct current period figures when the ‘allow period range on financial reports’ in system defaults was enabled.

  1. Invoice Entry → PO Transfer

    1. Fixed an issue were transferring a PO to an Invoice would set the PO as the first page in DPF when the Invoice was sent there.

  2. Purchase Orders

    1. Fixed an issue with the 5 day hire calculation being incorrect.

  3. Excel Node Reports

    1. General Ledger Inquiry and Financial reports that are saved to disk will have more friendly filenames.
      e.g. DEMO_COST REPORT_2021-09-03_11-26-16.xlsx

    2. Fixed an issue where the Excel PO Distribution and Input Control Reports did not respect Save to Disk being enabled.

  4. Production List

    1. Added a search bar to the production list. This will help with sorting through the master show file.

  5. Financial Reports

    1. Fixed a bug where a blank period date field would still appear on the report window when “Use Period Close Date” was ticked.

  1. Ledger Inquiry → Excel/CSV

    1. Fixed an issue with the save to disk folders not being created on the users local drive.

  2. Cheque Printing → User Defaults

    1. Will now copy and set the default control code, report layout, invoices per cheque, cheque copies and EFT setup when the user creates a new cheque printing default.

  3. DPF Invoices and Petty Cash Batches

    1. Added in delete protection for DPF Invoice batches 2,3,4.

    2. Added in delete protection for DPF Petty Cash batches 5,6,7.

  1. Financial Reports -> Send to Excel

    1. Fixed an issue with the header row not generating correctly in the excel export.

  1. System Defaults → General Ledger → Period End Date

    1. Added a system default under Use Period Close Date. By default this is enabled.

    2. If a user disables this functionality it will enable a Period End Date field under Financial Reports for users to type in their period end date manually, which is then printed on the Report header.

  2. Invoice Entry → Tax Balance

    1. Corrected a bug where the tax would balance when checking with the button but would throw a tax balance error on post.

  3. Excel Node Export for large datasets

    1. If an excel report is >500 lines the formatting will be removed in order to prevent the Excel Repair/Corruption dialog box when opening the file.

  4. Master Show file

    1. Added some user debug logging under C:\Users\%username%\AppData\Local\Temp to troubleshoot production access issues with the master showfile rollout.

  1. Vendor Master Maintenance - Invoices and Cheques tabs

    1. Fixed the excel node export not working on the Invoices and Cheques tabs.

  1. Invoice Inquiry - Hold Invoices

    1. Fixed an issue where if an Invoice was marked as Hold = Y and the user cancelled that Invoice, the cancelled Invoice would also be marked as Hold = Y. The hold status is now cleared correctly.

  2. System Defaults → Scan Check Excel Report

    1. Fixed an issue with the export not exporting barcodes with missing file attachments in the DATA folder.

  3. System Defaults → Petty Cash → Email PC Start Line

    1. Added an option to change the start line of the Email PC Form and Create PC Form exports. This is for when the user is not using any tax lines on lines 3 and 4 and they want their PC Form to have items under line number 5 exported.

    2. The default value is set to export lines into a PC form starting from line 5.

  4. Petty Cash → Debit Card Paste in

    1. Fixed an issue where the data lines were not pasting in starting at line 5 when Add 2 Tax Lines was disabled in System Defaults.

  5. Financial Reports - Historical Periods

    1. Removed the Period End Date field from the Report options.

    2. When running a historical report over a closed period, the Period Number and Period Date will now be grabbed from the Period Close or the currently open period.

  1. Cheque Printing → Test Cheques

    1. Fixed error messages popping up and spamming a user when they printed a Test Cheque.

  2. Debit Card Paste In

    1. Added a system default under the Petty Cash tab that allows a user to enter in a number between 5 and 20. This setting will split the envelope based on the number entered here (min 5, max 20).

    2. The default is set as 15.

  3. System Defaults Security Permissions

    1. Added CTRL+F8 Security Operator permissions to most System Defaults tabs (except General and Company Details).

    2. This allows Operators to be given access to specific sections in the System Defaults without being an Supervisor user account.

  4. Scan Check Excel Report

    1. This report has been added back into Eclipse under the System Defaults → Scanning tab.

  1. Budget Worksheet → Transactions

    1. Fixed an issue when exporting transactions to Excel. The sort order would reset and the transaction window would go blank until refreshed.

  1. Payroll Module

    1. Users can now set access to the Payroll Module again on a Professional License. In order to do this you must add L:AllowPayroll=Y to the eclipsed.ini file in the DATA folder of the production, under the [“PRODUCTION NAME”] heading.

  2. Debit Card Import

    1. Updated max tran to 15.

  3. Eclipse and DPF Functionality

    1. Indirect Tax, Vendor and Control Table Chart Sort and Chart Code will now correctly update in DPF if changed in Eclipse.

  4. Debit Card Paste

    1. Fixed issue when pasting equals data into Eclipse and it not correctly separating transactions.

  5. Period Close

    1. Updated period close when ‘Clear Costs’ was unselected by a user to now always take a snapshot to the pericost table.

  6. Chart of Accounts

    1. The chart of accounts fields for CU, LO, EPS, PROD, DETL, SET will now only accept alphanumeric characters (A-Z, 0-9, period and dash). If a user tries to enter in a symbol into any of these fields it will be stripped out automatically.

  7. Financial Reports - Historical Period Range option

    1. Added a checkbox under System Defaults → General Ledger to enable this functionality.

    2. This functionality will allow a user to select a period range in the Financial Reports module to run their reports over.

  1. Netflix Upload

    1. This fix is only applicable where productions were setup with non-compatible Netflix balance sheet codes and then had to change to Netflix compatible account codes for the Interstellar upload.

    2. Fixed issue where if an ITD file was sent it would remove the control account mapping in TenantGUID from GLCHART.

    3. Control account mapping for old control accounts is now set in SystemAccount.

  2. Invoice Inquiry → Reports

    1. Added a Studio Code field to the report fields.

  3. Invoice Inquiry → Hold Invoices

    1. Fixed an issue where if an Invoice was flagged as Y under Hold Invoices, the user could still assign a manual cheque number. It will now throw an error if a user tries to do this and the Hold flag is set.

  4. Petty Cash → Voucher Field

    1. When a production is using barcode scanning, the barcode number entered into the Attach field will now also be set in the Voucher field on manual entry or via the paste in.

  5. Chart of Accounts → Excel Paste In

    1. The excel paste in will now strip all characters except the following: A-Z, 0-9, (space), period and dash)

  6. MTD Submission Module

    1. Updated headers sent to HMRC to be compliant with the specifications.

  1. Accounts Payable → Cheque History 1

    1. Renamed this module to Cheque History with Attachments to better reflect the functionality of this window compared to the Cheque History/Cancel,Reissue module.

  1. Payroll Module

    1. Removed this option entirely from the Eclipse menus. The license must be changed to Enterprise to get this option back.

  2. Invoice Entry

    1. Fixed bug where sorting on Approval Group or Username would crash the batch window.

  3. General Ledger → Financial Reports

    1. Fixed an issue with sequences and set ranges being ignored.

  4. Budget Upload → Movie Magic

    1. Added a Movie Magic 10 upload option so it’s compatible with the latest movie magic version. You must export in the Tab Delimited format.

    2. Fixed the issue with the imported budget window not refreshing when uploading the budget multiple times.

    3. Fixed the issue with the first non-postable chart of account in the budget file not getting uploaded.

  1. Budget Worksheet

    1. Added Cost Report updating checkboxes to the BWS Setup Screen so Operator accounts can still access.

  2. User Entry Defaults → Auto Print Attachments

    1. Changed checkbox description to “Auto Print Attachments During Invoice Entry” and added tooltip to provide further information on what this option does.

  3. Cheque Printing

    1. If the Set Invoices Per Cheque field is set to <10, this value is ignored and the system automatically sets this field to 99. This is to prevent issues with users incorrectly using this option to split invoices to cheques.

  4. Node Export → 1099 Vendor Report

    1. Added the TaxID field to the export.

  5. Node Export → Cheque Posting

    1. Fixed the export not using the fm3.ini setting so it will now correctly export via the NodeAPI.

  6. Control Table → Control Accounts

    1. Granted access to Operator accounts to create and edit Control Accounts. Previously only Supervisor accounts could do this.

  1. Budget Worksheet

    1. Added an ‘exclude zero lines’ to the BWS Summary sheet to exclude any zero value accounts.

    2. Added an ‘exclude zero lines’ to the Transactions tab.

  2. User Entry Defaults → Save to Disk

    1. Fixed a bug where the save to disk default would not save for the user when re-opening Eclipse.

  1. Cheque Printing - Create EFT File

    1. Made the ‘Reprint Cheques’ and ‘Create EFT File’ checkboxes more intuitive to select. Previously ticking ‘reprint cheques’ would disable ‘create eft file’ unless ‘print negative cheques’ was unticked.

  2. Ledger Inquiry → VAT Reports

    1. Made ‘calculate net tax’ compatible with Unposted Journals. This works on all VAT Reports so users can run VAT Reports over unposted journals to check that they have entered in their journals correctly and the VAT balances.

  1. Chart of Accounts

    1. Fixed CoA scrolling to the bottom after deleting an account code.

  2. Ledger Inquiry → Dist Change

    1. Fixed issue when populating the Dist Change list with multiple transactions using the same tran number.

  1. MTD VAT Submission

    1. Added additional required information sent in headers to HMRC when grabbing a period obligation.

  2. Budget Worksheet - Transactions Tab

    1. Fixed an issue where an Excel export from the transactions tab would sometimes double up lines in the export.

  3. User Entry Defaults - MAC User checkbox

    1. If a user ticks this checkbox and then presses ok, it sets the default save to disk path to M:\Desktop\Eclipse

  1. Invoice Entry - Unposted Invoice Lists

    1. Populated all DPF data into the columns that were previously missing.

  2. Distribution Change Excel Paste in

    1. Fixed the excel distribution paste in missing checks when it added transactions. This resulted in paste ins failing incorrectly.

  3. System Defaults → Excel Beta Reports

    1. Removed this system default as it is defunct.

    2. Excel Beta reports is a setting that is set per server in the eclipse/start/fm3.ini file

  1. Vendor Master Maintenance

    1. Made the vendor code a required field

    2. Replaced the SQL Error message with a more user friendly message when the user enters a vendor code that already exists.

  2. Node Export - Unposted Invoice List

    1. Added DPF Fields to the Invoice List Export

  3. Netflix Upload

    1. Netflix export will now abort if EFC or Budget figures found against non-postable accounts as their system will not process these. Users will need to set these accounts to postable, zero the amounts or move the budget and EFC amounts to postable accounts for the upload to work

  4. User Security Levels

    1. Added missing security name filters for Journal Entry and Journal Inquiry as security names were not functioning properly in these modules.

  1. EFT File Creation

    1. Fixed a bug where if the user selected ‘PDF’ as their Report Type in Cheque Printing it would print a corrupted EFT File.

  2. Node Export - FBT Report

    1. Fixed all missing fields in the Fuel Register and Car Hire Register sheet for the Excel Node Export.

  3. Node Export - Debit Card Transactions

    1. Fixed issue where no transaction lines would populate the export sheet.

  4. Node Export - Unposted Invoice List

    1. Exporting transactions to Excel from the Unposted Invoice list will now list DPF Columns (approved by, import log, current approver, etc).

  1. EFT File Creation

    1. Fixed bug with Fremantle SFTP Upload at Cheque Printing.

    2. Fixed issue where creating a PDF Report (Not Preview) in Cheque Printing could change the EFT Download path.

  2. Chart of Accounts

    1. Created a more user friendly error message when trying to copy a chart of account with the ‘Copy’ button and the destination chart already existing. Previously it would show an SQL Insert error.

  3. Ledger Inquiry Reports

    1. Fixed Issue with Excel Reports exporting more than 10 invoice numbers (max is 15 in Eclipse) to an excel file. Previously it would truncate invoice numbers to 10 character.

  4. Chart Lookup

    1. Fixed issue with the Exit button selecting the chart of account instead of exiting the lookup.

    2. Fixed issue where selecting the Exit button in the VMM PC Advance Code selection would insert a period into the Set field.

  5. BWS Rebate Sheet

    1. Fixed issue with dumping the BWS Rebate sheet to Excel

  6. Purchase Orders

    1. Fixed issue with being able to paste an PO transaction line sheet with Car Hire lines and it not updating in the specific Car Hire lines in Eclipse.

  1. User Entry Defaults → Mac User

    1. This checkbox will ‘force on’ the Excel Save to Disk for the user by overwriting the default Save to Disk functionality set by the server (Either Yes or No).

  1. Vendor Master Maintenance

    1. Fixed issue with selecting a PC Float code with the ellipsis menu if the field was already populated.

  2. PC Fuel Entry

    1. Fixed issue where you cannot re-assign the PC Float code if changed in VMM by retyping in the adv/acc amounts in the entry screen.

  3. Ledger Inquiry

    1. Fixed issue where uploading an attachment would set the upload with a subfolder so it appeared blank in the attachments view.

  4. System Defaults → Petty Cash → Disable Auto-Recalc of Tax in Petty Cash

    1. Added a system default under the Petty Cash tab to prevent the system from recalculating the VAT line when the user wants to manually edit it.

  5. BBC VAT Report

    1. Added a Description Column to the Excel Report (after Tax ID and before Net Amount)

  6. Eclipse Production Selection List

    1. Fixed bug where if you pressed the ‘enter’ key to select a production from the list it would throw an SQL error.

  7. Petty Cash Form Generation (Email PC Form and Create PC Form)

    1. Lines will now be exported in ascending date order (most recent transaction at the bottom)

  1. Vendor Master Maintenance

    1. Fixed issue with the Excel Node export not correctly exporting the vendor contact information and email

    2. Fixed issue with the Excel Paste in and it wiping the W9 Expiry Date

  2. Invoice Inquiry Reports → Input Control Report

    1. Fixed issue where if you ran the report Input Control Report and no data was returned it would crash Eclipse.

  3. MTD VAT Submission

    1. Corrected error with incorrect file path to CARoot.pem

  4. Financial Reports → Sequence Ranges

    1. Added the ability to copy the entire sequence range including Sub, Cu, Loc, Eps, and Subtotal Header

  5. Netflix Upload

    1. Added checks to see if the user has permissions to upload to Netflix (access to C:\winscp) when starting Eclipse or pressing the Upload button under the Ledger Inquiry → Export → Netflix screen.

    2. The GL auto-export will be skipped if the user is not part of the Netflix-Upload group in Active Directory.

    3. The Ledger Inquiry → Export → Netflix screen will throw an error telling the user to contact support if they are not part of the Netflix-Upload group in Active Directory.

  6. Fremantle Upload

    1. Added extra SFTP settings for Fremantle Uploads. Fremantle Uploads now use SFTP2 settings.

  1. Invoice Inquiry Reports

    1. Fixed issue with node export not working for Invoice Inquiry Reports.

  2. Debit Card PC Email

    1. Changed the body of the PC Email message to:
      “Please find attached a copy of your latest debit card expenses. Please fill in the details and return this form as an Excel document, along with a scanned copy of all receipts in PDF format.“

  3. MTD VAT Submission

    1. Fixed an issue where the MTD CSV Report being opened would break Excel node file generation.

    2. Fixed an issue where files in the MTD History Log being opened would break Excel node file generation.

  4. Vendor Master Maintenance

    1. Fixed issue where the Excel Paste in to update vendor details would wipe the bank details if ‘lock vendor bank’ was ticked in System Defaults. The functionality will now work as desired and will still update all other vendor details except bank details if this system default is ticked.

  5. Master Production Show File

    1. Laid down the groundwork to move to one centralised showfile with all productions inside it, instead of individual show files per each user.

    2. If a user does not have AD group permissions to view the production folder, Eclipse will filter it out from the user’s production list and hide it (instead of needing to remove it manually from the user’s show.tps file).

    3. To turn on this functionality, put FilterShows=Y under [FM3ODB] in the Eclipse/start/fm3.ini folder. By default Eclipse uses FilterShows=N

  1. Petty Cash Debit Card Reconciliation Paste in

    1. Added the functionality to chose your tax code when pasting in debit card transactions into the Petty Cash Entry screen.

    2. If this checkbox is not ticked it will use the default vendor tax code.

  1. VAT Submission Module

    1. Fixed issue with PeriodKey text record being named incorrectly in the history logs.

    2. Fixed non-GB currencies being picked up in the MTD Module for the VAT portion when the user has flagged non-GB Accounts as V or S using the multiple VAT accounts method.

  2. Ledger Inquiry Reports - Fixed issue where generating a FBT or BAS Report with Excel/CSV ticked at the same time would cause a GPF and crash the program.

  3. Bank Rec Attachments - Fixed an issue where bank rec attachments were not getting primed with the correct tran number so they were showing under all control accounts. When a user uploads a new attachment they will now be primed to that control account, and will only show under the attachments tab for that account.

  4. Excel Node Reports

    1. Fixed issue with node reports not appearing for users on the UK side because of missing quotes around the filename.

    2. Fixed various node reports not working on the UK side and not generating any file.

    3. Fixed issue where the Ledger Inquiry excel exports would ignore the ‘save to disk’ option in user defaults.

  5. Invoice Entry - Fixed issue with the payroll TPH Invoices not showing the attachments.

  1. Invoice Entry PO Transfer - Fixed issue where the CTRL key was getting initialised after a PO Transfer to an Invoice.

  2. Negative Cheques - Fixed an issue where the negative cheque tick box would not stay ticked in the Cheque Printing Module.

  3. Excel BAS Report (AUS Side) - Fixed missing headers in the Ledger Sheet of the BAS Workbook.

  4. EFT File Creation - Added additional fields to Eclipse for EFT File Creation to complete the EFT Layout for Spiderhead’s US Team.

  1. Attachment Upload in all modules - Fixed issue with uploading documents with long file paths or periods in file paths causing the attachment upload to fail.

  2. Viewing Attachments in attachment tabs- Fixed a bug where if there was no attachment attached to a transaction it would display the previously viewed attachment.

  3. Negative Cheque Reprint - Fixed a bug where reprinting a negative cheque would make it disappear.

  4. Create/Email PC Forms - Forced excel node to be on for these menu items regardless of the system default being ticked or not. Should fix issues with productions complaining about blank forms.

  5. Journal Entry Column Sorting - Fixed issue with sorting columns in the entry screen and lines disappearing.

  6. New Attachment Control - Fixed issue with non-pdf documents not being able to be downloaded.

  7. Spiderhead EFT US File Creation - Added some fields required to code up the EFT file for Spiderhead’s US EFT.

  8. Tax Balance Message - Changed the GST does not Balance tax message to Tax does not balance across all modules.

  9. Chart of Accounts - Fixed an issue where changing an account code would revert back to the previously entered code after closing the CoA window.

  1. Attachment Upload in Entry Screens - Fixed issue with uploading documents with long file paths or periods in file paths and the upload failing. The other modules (inquiry screens) will be added in the next update.

  2. Attachment Upload in PO Entry -

    1. The previously visited file path is now saved for the user when they attempt to upload a file via explorer.

    2. The PO Entry attachment screen was missing the attachment control to view files. A new chrome based attachment control has been added to this screen for viewing PDF files. It does not work for non-pdf files currently.

  3. Netflix Upload - Added a system generated description to any transactions with blank description fields in the Netflix Upload.

  4. PC Fuel and PC Fuel Invoices - Fixed issue where the PC Date for PC Generated Invoices was getting cut off from YYYY to YY which displayed the incorrect year.

  5. Emailing PC Forms → System Defaults → Petty Cash - A new System Default has been added to prevent the “Email PC Form” option from moving PC Forms to the next open batch. If this is turned on, Emailed PC Forms will remain in the same batch they were entered into. The default functionality is to move the emailed pc form to the next open batch.

  1. Bank Reconciliation - Attachments tab

    1. Fixed issue where you could not run a bank rec report after uploading an attachment (you had to reopen the bank rec window).

  2. MTD VAT Submission

    1. Will now force users to enter in their VAT Rego number before the Check Obligation Process.

    2. VAT Folder now created in the DATA Folder to record logs during the Obligation Process.

  3. Netflix Upload

    1. Fix to the Netflix Sequence Numbers for their EFC Uploads so they should correctly stay in sequence.

  4. Node Excel Updates

    1. GL Reports - Fixed exporting a report to excel and it not clearing previous data

    2. PO Reports - Fixed PO Reports not exporting to excel

  5. Cheque Printing

    1. Changed the upto due date field to be one year from the current date.

  6. Petty Cash

    1. Fixed issue with Email PC Form creating a new batch but not incrementing the batch number (this caused issues with other batches with the same number disappearing until reinstated).

    2. Pushed out new PC Paste Option for EU Productions. Users can select “Paste EU PC Form” when pasting in a petty cash template to create a separate VAT line for each VAT Amount.

      1. This should only be used for non-GB Currencies because it will break the VAT Report.

      2. Split Line to Bal GST must be turned off in the System Defaults → Petty Cash.

  1. Bank Reconciliation - Attachments tab

    1. Fixed attachments not uploading

  2. Budget Worksheet - Rebate Budget Worksheet Paste in

    1. Fixed issue where rebate BWS notes were overwriting default BWS notes.

  1. Invoice Inquiry - Fixed Unpaid and Paid Status Checkboxes.

  2. Excel Node Report Generation

    1. Fixed right-click > Excel in PO Maintenance.

  3. Journal Form Paste - Fixed issue with the IN and F columns being mixed up in the Journal Form Paste option.

  4. New Functionality: PDF Cheque Remittance Generation

    1. When Printing and Posting a Cheque with Autoscan/Create Cheque Remittance turned on in the System Defaults it will now automatically create the CK<>.pdf and C<>.pdf files with <> being the cheque number. It should support all cheque ranges and not just 5 digits.

    2. iEclipse Barcode scanning is still only supported by 5 digit cheque numbers.


  1. Excel Node Report Generation

    1. Fixed VMM → Excel AP Aging Report not generating

    2. Fixed Data Integrity → Check Scans Report not generating. (Will generate but will throw errors still)

    3. Fixed Chart of Accounts PDF Report not generating when Excel node enabled.

  2. BWS Excel Reports

    1. Fixed issue with Fringe % column outputting to 2 decimals instead of 4.

    2. Fixed sort order of the BWS Output. Should now correctly export based on your BWS Sort Order in Eclipse.

  3. Vendor Master Maintenance

    1. Filtered out all blank vendor codes which are created for DPF.

  4. Cheque Printing

    1. Fixed an issue where a user could print a cheque to a different Control Account then what it was issued to. The user would select invoices to print, then select a different control account and print the cheques without going back to the invoice selection tab.

  1. Excel Node Report Generation

    1. Compressed JSON data for big data sets.

  2. Reports 

    1. Fixed issue where Chq Sort Order would break the report.

  3. Debit Card Paste Ins

    1. Fixed issue where aborting the pc paste in would wipe the entry that already existed.

  4. Debit Card Reconciliation

    1. Fixes for importing duplicate debit card reconciles and eclipse throwing an error message for every duplicate.

  5. Email PC Form → Users MUST enable Excel Beta Reports in System Defaults for the Email PC Form and Create PC Form to work properly. 

    1. Fixed error messages occuring about not being able to remove the file.

    2. Fixed issue in the PC Form template where the GST/VAT/Receipt formulas were being stripped out by Eclipse.

  6. Create PC Invoice button

    1. Fixed issue where the invoice created by the Create PC Invoice button would not be properly inserted into an Invoice batch and would disappear.

  7. Eclipse DPF Updates

    1. Added Default Approver group to System Defaults → Digital Approve.

    2. Copied chart sort\code\flags in Eclipse for PC and AP on ok.

    3. When sending PC or AP to DPF if there is no vendor approver group for PC, or no PO Approver group for invoices, it will use this group Default Approver Group.

  1. Excel Node Report Generation 

    1. Fixed the vendor master maintenance excel dump not working.

  2. Debit Card Expense

    1. Fixed bug with the Email PC Forms option and it not inserting the emailed form into the next batch, causing it to disappear for the user.

    2. Fixed paste in issue if the amounts, date and description were the same for the VASCO import. It would drop one of the lines from the reconciliation entry and throw an error. Now it will tweak the desc of one of the lines so both are added.

  3. (AU) BAS Workbook 

    1. Fixed a missing reference number and incorrect percentage and pushed it out to AUS Productions. File can be found in F:\Custom Report Layouts\BAS Workbook\ if it needs to be pasted into non 2019/2020 productions.

  4. (UK) VAT Submission 

    1. Fixed issue with a two character Tax Flag in the EC Acquisitions field and it picking up the other two characters as tax flags by themselves.

  5. (AU) New Feature - Send Invoices and Petty Cash to DPF: Allows users to use Eclipse for data entry but then use DPF for approval.

    1. Adds a right click menu to send AP, PC, Fuel to DPF.

    2. Added a tab under the PC Vendor called Vendor PO Approval. Go to this tab and add in the Defaults PC Approver Group for that Person. This will avoid them having to do it manually in DPF.

  1. Excel Node Report Generation

    1. Pushed out update to strip and clean invalid characters before its sent to the excel node server for report generation.

  2. Ledger Inquiry → Edit Journal Invoice Number

    1. You can now edit the Invoice Number inside Ledger Inquiry for Journals. BBC needed this ability to edit already posted journals for their custom VAT Report.


  1. Bug Fixes:

    1. Fixed bug with VAT Flag Report that occured with the change to ignore invoice if empref is not blank for BBC.

    2. Fixed the Delete button not working in Debit Card Reconciliation

    3. Fixed bug where GL INQUIRY Attachments not displaying files if in a sub folder (eg TPH invoices or digi approve invoices).

  2. Debit Card Reconciliation - New Provider Added (VASCO)

    1. Added a field in System Defaults → Petty Cash where a user can type the provider name. By default it is set as EQUALS.

    2. A User can type in VASCO instead and it will use a different set of debit card defaults.

    3. The user can use PPAN or ClientID in vendor setup.


  1. Petty Cash Fuel → Create Invoice

    1. Create Invoice button added to PC Fuel entries

  2. Petty Cash Per Diem → Create Invoice

    1. Create Invoice button added to Per Diem PC entries.

  3. Period Close → Don't Clear Notes 

    1. Checkbox added to the Period Close window to exclude clearing notes in the BWS when the user closes the period.

  4. MTD Digital Vat Submission

    1. Fixed bug that allowed a user to enter in a blank vat code and blank tax code and submit it to HMRC. 

  5. Debit Card Expense Forms

    1. Fixed bug that resulted in the "Email PC Forms" in the Petty Cash module not generating the PC Form correctly and emailing out a 0 byte file.

  1. User Reports

    1. You can now export a list of Eclipse users for audit purposes from the User Screen → Send To button.

  2. Invoice Inquiry → AP Aging Report

    1. This report will now output the invoice description to Excel.

  3. Budget Worksheet → Auto Balance Check

    1. Added a checkbox under BWS → Setup to turn off the auto-balance check. Improves speed of the BWS opening but the system will no longer check for problems when opening the BWS. Useful for very large databases like Endemol Shine.

  4. Budget Worksheet → Transaction tab → Reports

    1. Added the ability to select PO Source Code to the report (User will have to double click the save icon to get this to save).

    2. If the user clicks the "use selected records" checkbox it will remove the source code tab to prevent any confusion.

  5. Budget Worksheet → GL Description Lines

    1. Fixed an issue where the description line of a transaction was missing from the export.


  1. Excel Node Server

    1. Enabled Excel report for Vendor AP Spend

    2. Budget Worksheet → Transactions → Reports: Updated this module to use excel node

  2. Ledger Inquiry → Dist Change History (Edit History button)

    1. Enabled resizing on this window to increase readability.

  3. VAT MTD Submissions 

    1. Fixed a bug where if a vat submission failed it would mark the transactions in Eclipse as being sent.

  4. NBCU Password Complexity

    1. Pushed out the ability in Eclipse to use forced password resets and complex passwords - this is specifically designed for NBCU on the UK side.

    2. To enable, edit the eclipsed.ini file in the DATA folder of the production and paste these three lines under the show name. E.g. Production name is DEMO

      ["DEMO"]
      L:ResetAllPassword=Y
      L:ResetAfterXDays=90
      L:ComplexPassword=Y

      1) will force all users at next login to change their password
      2) will also force all users at next login to change their password and then again after x days
      3) will force users to use 8 char + upper + lower + spec character in password

      The system will also lock accounts after 10 consecutive failed attempts and the only way to reset is via SQL GLOBALFLD table looks for FailedLogins and User name and set back to 0.

  1. Chart of Accounts → Inserting or Pasting

    1. Trimmed blank space in the chart of account code when a user entered a new chart of account or pasted one into Eclipse.

    2. Example: If a user entered in an Account code 850-(space)01 will now default to 850-01 and remove the blank space when saved.

  2. Excel Node Server

    1. Fixed PO column not populating when exporting the BWS to Excel.

  3. Petty Cash → Email PC Forms

    1. The user will receive an error message if no email exists for the vendor. The PC form will not be generated or moved to a new batch.

  1. Budget Worksheet → Reports button

    1. Replaced this button with the same module used in General Ledger → Financial Reports

  2. Cheque Printing → EFT Layout Editor button

    1. Moved the layout editor button away from the EFT entry field so clients do not think this is a selection menu. Renamed the button to Layout Editor.

  1. Excel Node Server

    1. Converted the FBT and BAS workbooks to use the new Excel Node file generation.

    2. Added an option under C:\Eclipse\start\fm3.ini to force all productions on the GG server to use the Excel Node Server for file generation. This will be turned on in the future when we make the changeover. For now all servers have this set to N (L:BetaExcelReports=N) to disable it.

  2. System Defaults → Add 2 Tax Lines.

    1. This option will now add a tax second line to invoice creation. To customise the tax flag added, see this freshdesk article: https://tphsupport.freshdesk.com/support/solutions/articles/2100045601-add-2-tax-lines-system-default

  1. MTD Submission Module -

    1. Corrected the generation of the file link in the History Log tab to the CSV Report and the submission text file. 

    2. Old MTD Submissions still generated the CSV VAT Report and can be found in the production's DATA Folder.

  2. Excel Node Server

    1. Pushed out the new Node method of Excel file generation across all servers.

    2. This replaces the old Office dependant COM Method of generating Excel files in Eclipse.

    3. This method is disabled by default, but can be enabled by ticking the "New Beta Excel Reports" checkbox under System Defaults.


  1. Budget Worksheet - Pushed out a fix for the auto-recalc when opening the budget worksheet. It would fail if some chart codes were in lowercase.

  1. Netflix Debit Card Reconciliation - Misc bug fixes.

  1. SAP Paste - Misc bug fixes. 

  2. Netflix Debit Card Reconciliation - Misc bug fixes.

  3. Control Table → Control Accounts - Fixes to allow the scrollbar to be used along with enabling header sorting.

  4. Vendor Master Maintenance - The First Name will now be shown in the Vendor Names list separated by a comma.

  5. Closing and Editing Periods - The Next and Future period numbers are now editable. The current, next, and future period dates are all editable. A user can now edit these fields and press the tab key afterwards to save them. 

  1. BBC VAT Report - Fixed an issue where the total amount in the excel report was doubling. 

  1. Bank Reconcillation - Removed the undo button as its no longer used and was not working properly.

  2. SAP Paste - Added some more features to the SAP Paste in Eclipse.  To do SAP Paste you right click on Invoice Entry distribution lines and select SAP Paste.

  1. Show File Path Dialog box - Increased the size of the show path dialog box so you can see the prod paths more easily.

  2. Production Selection - Removed buttons that were no longer used so only Select and Backup buttons remain.

  3. Netflix Debit Card Expense Import - Pushed out new modules for Netflix Debit Card Transactions and Reconciliations.

  1. Financial Reports - Exclude Zero Budget EFC Option will now correctly exclude any zero budget efc accounts. If used in conjunction with Exclude non-postable accounts it should remove all 0 value accounts from a user's financial reports.

  1. Future Posting Stored Procedure Fix - Pushed out a stored procedure fix across all blank databases across the AU and UK. This fixed an issue with users posting to future periods and it not correctly updating the BWS, resulting in incorrect reports when running them on historical periods. This fix should be applied to any live production databases that are heavily utilising the future posting feature in Eclipse - Contact Kevin or Kai to get them to rollout the fix to a specific database.

  1. Movie Magic Budget Upload - Changed the created expense accounts and their Chart Types from E to EX when uploading a budget. This is so expense accounts are not linked to the Exempt tax flag (E) on UK Databases with the change in the Tax Balance calculation made on the 22 Apr 2020 and 21 Apr 2020.

  1. Financial Reports - Fixed a bug that prevented users from running reports over blank episode codes. Highlighting a blank episode code and saving it to the report defaults will now work correctly.

  2. Petty Cash Vendors - An email field has been added to Petty Cash vendors so they can be emailed reimbursement remittances from the new Create PC Invoice procedures.

  1. Entry Postings - Fixed a bug in the PC/AP/Bank Rec and Cheque Postings when a change was made yesterday to change how Eclipse handles journal posts when the dates are older than the system defaults allow.

  2. Tax Balance - All entry modules are now using an updated tax balance calculation.

    1. This will help productions that use multiple tax accounts or are posting re-issue invoices or older entries to tax accounts that are not setup in Control Table → Indirect Tax Codes.

    2. By adding the tax flag to the chart of account type in the Chart of Accounts module, the Tax Balance procedure will look at the range of accounts with this tax flag to determine if the tax is correctly calculated. 

  1. Period Dates - Period date format changed to DD/MM/YYYY

  2. Distribution Changes - Prevented users from being able to do a cross-currency distribution change.

  3. MTD VAT CSV Report - Fixed an issue with the layout of the VAT CSV Report that sometimes shifted the columns by 1-2 places.

  4. Journal Postings - Changed how Eclipse handles journal posts when the date is older than what is set in the system defaults. Previously the user would get a message for each journal line which was problematic for large journal postings. They will now get a message box with Yes/No/Ignore options. Selecting Yes will prompt the message to the next journal line, selecting No will terminate the posting procedure, and selecting Ignore will ignore any further messages thrown by the batch.

5. Reports -> Scissors Icon - Added a message prompt when the scissor icon is pressed if the user wants to delete the report default.

6. Eclipse License Expiry - Added the ability to access the User module of Eclipse when a production's license had expired.

7. Ledger Inquiry → Calculate Net Tax Amount - Fixed the checkbox not working from merging the Excel and CSV options.

8. New Feature -> Invoice Cancelation - Added new procedures to cancel invoices when a cheque has not been printed. A user can cancel an invoice from Invoice Inquiry or Vendor Master Maintenance → Invoices tab. The user can tick to reissue the invoice to a batch where they can then alter it and post it again, or they can cancel the invoice out-right. 

9. Changes to Tax Balance Calculation for Accounts Payable - A user can add the tax flag to their VAT and GST accounts in their chart of account type. This will only work for one character tax flags. Instead of looking for the exact code in their Indirect Tax Codes, it will instead look at a range of tax accounts to balance against as set in their CoA. Blank Databases have been updated to have their VAT and GST accounts set as V and G account types.

10. Backend Changes: 

  • Created a master production show.tps file to replace GG Cluster Manger on the AUS GG Side. This mimics the functionality of what is currently on the UK GG side.

  • Stored procedure update for Live Nation databases

  • Eclipse File changes to move writeable Eclipse files to a subfolder in the root directory so write priviliges can be removed from the root directory in the future.

  1. Ledger Inquiry → Reports 

    1. Fixed a bug that prevented users from running a ledger report on accounts that had a blank episode code.

    2. Removed the XML option and merged the Excel and CSV option into one checkbox.

    3. The FBT option is now saveable to the Report Defaults.

  2. Periods Numbers - The periods are now editable by the user if nothing has been posted into the general ledger. This means a tech will not have to go into SQL to set the period numbers. The user can edit the periods in the List mode or List and Close and save the new period sequence by pressing OK. 

  3. Negative Cheque Printing - Negative Cheques can now be printed from the Cheque Printing screen. The Print Negative Cheques tickbox must be ticked for it to allow printing. The EFT file creation is also disabled during this time.

  4. Invoice Inquiry → Reports - Exporting an excel Input Control report will now output the Invoice Entry Date.

  5. Digital VAT Submission -

    1. Added extra detail to the history logs by including the vat period field from the MTD screen.

    2. Users can now use multiple VAT and Sales accounts in the MTD Submission module. To do this the user needs to change the account TYPE in their Chart of Accounts for all the VAT accounts they want to include to V, and all the Sales accounts they want to include to S. They then leave the account code field blank in the MTD module and include the V or S flag in their output and input flag fields.

  6. PC Envelopes and Invoice Reimbursement Creation - Users can now quickly create an invoice from a PC Envelope to reimburse via the bank. By highlighting the PC Envelope in an open batch and clicking the "Create Invoice" button this will create an invoice to a new or existing batch, ready to be posted down and have its cheque printed and posted. The advanced amount for the PC Envelope should be zero as the reimbursement is coming from the AP invoice.


  1. Petty Cash Inquiry → Reports - Increased the envelope field to 10 characters so users can run reports over long PC envelope numbers, eg. PC:14532671

  1. Vendor Maintenance → ABN/Superfund Lookup - Changed lookup web service to use HTTPS as HTTP port 80 now depreciated. 


  1. Vat Submission - Fixed an error message throwing an invalid json string which prevented the submission from being accepted by HMRC.


  1. Cheque Posting - Added a reminder message when a user attempts to post Cheques asking them if they have sent remittances.

  2. Control Table - Under System Defaults → Accounts Payable → Vendor Tax Type - Fixed an issue where this tax type was not pulling through when inserting a new vendor.

  3. Various Screens - Fixed the "enter" key on the keyboard closing the window on the Cash Flow, Ledger, PC and Journal Inquiry, Cheque History and Bank Rec screens.

  4. Petty Cash → Split PC Form - Added a message telling a user to setup their tax codes under control table→currency when they are blank. This message pops up when they are attempt to paste a petty cash split pc form.

  5. Purchase Order Entry -

    1. Removed the "Chart code not found" message from popping up when a user opens a PO with invalid charts coded to transaction lines.

    2. Removed the requirement to clear the "transaction number" column when pasting in an excel sheet. If the transaction number does not match it will paste in the sheet and just change the transaction number to that of the PO that is open.

  1. VAT Submissions - The client users IP will now be auto-populated when they enter the VAT Submission module. They will no longer have to enter it in manually when doing a submission.

  2. Digital Approve - Added a Digital Approve tab to the System Defaults for Australian productions.

  3. Control Table →  Episode and Location Codes - Limited the insertion of episode field to 3 and location to 2.

  4. Period Close - Fixed an issue where a user could enter in a period number that was less than the current/next period. This would crash the period close module.

  5. Ledger Inquiry Reports - The BAS and BIBLE checkbox are now saved to the defaults when the floppy disk save icon is pressed.

  6. Ledger Inquiry Excel Reports - Added the Chart of Account descriptions to the last column of Excel and CSV Exports. 

  7. Petty Cash Fuel Entry - Fixed an issue where the PC Fuel list would disappear if a user sorted by accounted and then advanced columns.

  8. Batch Posting - Added extra validation checks for items posted to accounts set to inactive for the PC and PO modules.

  9. Journal Entry - Added the Chart of Account descriptions to the Right Click → Excel export for journal entries.

  10. Bank Reconciliation → Bank Transactions tab - Added a user friendly error message notifying the user that the date and reference must be unique per line.

  11. PO Maintenance 1 - Fixed a bug where the Exclude Zero POs and Open PDF buttons would disappear when resizing the window.

  1. VAT Submissions - Added a field at the bottom of the Digital Vat Submission module where a user needs to type in their IP Address as a required field. HMRC Require a client to input their IP when doing a submission.
    We are looking at ways of automating this in the future, but for now a client has to do this manually. They can go to www.myip.com to get their IP address.

  1. Financial Reports → Exclude Zero Budget EFC - Reinstated this option to original functionality.

  2. PO Maintenance → Right clicking and selecting Excel will now also export the Requester, Department and Approved By fields just like the PO Input Excel Report.

  3. PO Numbers → Pushed out a stored procedure fix to the trans procedure to blank databases to solve a rare bug that could sometimes duplicate PO numbers in EzyPO.

  4. System Defaults → Vendor Bank Lock - Both Operators and Supervisors can now add the bank details when first creating and inserting a new vendor. An audit email will be sent out to the admin email address in System Defaults.

  5. User Security → Register Product - Removed this menu item from the User Security menu.

  6. User Security → User Setup - Merged the Users screen and removed the old one. Contains some specific fixes like refreshing when adding a user, allowing you to change the user group, etc.

  1. Vendor Master Maintenance - If a user enters a duplicate vendor name it will append a period on the end of it.

  2. System Defaults - Fixed a bug that was showing an invoice email field on all the tabs.

  3. Financial Reports → Exclude Zero Budget EFC - Hardcoded this option to off even if it is ticked.

  4. PO Maintenance - Excel PO Input Control Reports will now list the requester, department and who approved the PO. 

     


  1. Negative Cheques - Fixed issue where a user would reprint a negative Cheque after assigning it a manual cheque number, this caused it to disappear from the Cheque Posting Register. 

  2. Changes to User Security - All menus in Control Table can now have Ctrl + F8 fine grain permissions set for Operators. The Read-Only groups have been updated in blank databases to reflect this new security change. 
    Existing databases will need to have their Read-Only group settings changed manually to allow access to items in the Control Table, as the entire menu is blocked by default for the ReadOnly group. The ReadOnly group can have access regained by going to User Security → Set User Access → Select Read Only Group → Tick Control Table. All items in Control Table will then need to have Ctrl + F8 permissions set (apart from User Security and System Defaults which are blocked).

  1. Financial Reports - Fixed issue where rejected POs were being included in the Cost Report when the Unposted PO data option was ticked.  

  1. PO Maintenance - Fixed the Excel PO Distribution Report so it correctly outputs all distribution lines.

  1. Chart Rebuild - Fixed issue when doing a chart rebuild where it would not correctly re-calculate and rebuild the Financial Reports Period History.

  2. Digital Approve - Invoice Approval - Updated String Theory and removed line wrapping to resolve base64 error messages when approving an Invoice.


  1. Purchase Order Maintenance - Copy Log to PO - Added a Y/N confirmation dialog box when a user clicks Copy Log to PO to stop users from accidentally fully restoring their POs.

  2. Purchase Order Entry - Fixed issue where a user could zero a line in PO Entry in the EzyPO Unposted Batch and it would drop the chart sort and chart code in EzyPO.

  3. Screen Resizing - Added window resizing to PC Inquiry and Cheque History 1.


  1. Vendor Master Maintenance - You can now export Invoices and Cheques to Excel from their respective tabs after highlighting a vendor.

  2. Journal Reports - The Reports are now exportable to excel by ticking the "Excel" checkbox before running the report.

  3. VAT MTD Module - Fixed the filepath in the history logs for the submitted VAT csv data for any productions thave have already submitted their VAT before the change on the 19th December 2019.


  1. AP Excel Reports - Made some changes as requested by BBC.

    1. AP Aging Report now provides a total for each vendor.

  2. PO Excel Reports - Made some changes as requested by BBC

    1. PO Dist Report now includes the vendor code, account code, and line number.

  3. VAT MTD Module - Fixed filepath in the history logs so it correctly points to the submitted VAT csv data. 


  1. Bug Fixes:

    1. Budget Worksheet - When ticking to show unposted journal entries in the BWS it will no longer throw an error message.

    2. Cheque Printing - Added in code to reduce the occurrence of Error Code "FILE NOT OPEN 37".

    3. SHOW.TPS Filepath - Fixed issue on the Australian GG Servers where the production path in the show file was not correctly resolving to the archive folder path.

    4. Invoice Inquiry - Fixed issue when sorting via Cheque Number and records duplicating in the viewport.

    5. Journal Inquiry - Fixed issue where the Unposted tab was in focus when opening the window.

    6. Dist Changes - Fixed issue where the chart separator for the Chart Sort would drop when doing a dist change on a PO line in the BWS.

  2. Petty Cash Inquiry Reports - All Petty Cash Inquiry reports can now be run to Excel from the Reports screen.

  3. Cheque Printing - Fixed an issue when adding two invoices for the same vendor to the same cheque number and the total of the cheque not updating. This should resolve the TCHQREG error message.

  1. Budget Worksheet - Fixed a bug where exporting a highlighted transaction to excel would export all transactions with the same tran number, instead of just the highlighted transaction.


  1. Journal Template Paste - Fixed issue when using "Paste Journal Form" and getting an invalid chart error message.

  2. Update EzyPO Button - Fixed issue where the update ezypo button in the CoA would not work.

  3. VAT Submissions - Fixed an issue where the Check Obligation was not grabbing the VAT Period because of a corrupted header being sent. 

  1. VAT CSV Report - Added a total at the end of the CSV for Net Vat.

  2. Journal Entry/Journal Paste - Fixed an issue with Journal Invoice Numbers >15 characters propagating to the system, resulting in a 2File System Error when going into the Budget Worksheet.

  3. Distribution Changes - Fixed an issue where the new transactions from a dist change would not carry over the Emp Ref field.This should fix an issue in the VAT Report where a user does a dist change on the VAT amount from one VAT account to another, and it not picking up the corresponding NET correctly.

  4. Rebate Budget Worksheet - Fixed an issue where the BWS doesn't calculate the Actual columns (Period, PO, Unposted, Tax, ToDate) when both the Rebates F flag and the Unposted Batches are ticked.

  1. Vendor Bank Approval - Fixed an issue where the email when an operator changes the vendor bank details was not getting sent out.

  2. Journal Entry - Replaced the SPROC error when trying to post a journal with a transaction number that already exists with a more user friendly message.


  1. Purchase Orders - Added in code to automatically recalculate the PO header and tax totals so they correctly show in the PO transfer screen.

  1. Cheque Printing - Adding Window Resizing


1. Manual User Backups - The backup path is now auto generated and cannot be changed. A user just needs to type in the filename to backup the database. Instructions here.

Tech Notes: [SQLBACKUP] L:Country=UK must be present in Eclipsed.ini in the C:\Eclipse5SQL folder where the eclipse.exe resides. By default the AU backup path is populated. If the UK field exists in the ini file, then the UK backup path is used instead.

2. Invoice Inquiry - Fixed the appearance of duplicate records when sorting via Name, Amount or Batch.

3. PO Coding and EzyPO - Fixed an issue where changing a PO code in PO Maintenance, the BWS through a dist change, or in the EzyPO batch would not correctly update the code in EzyPO.

  1. Invoice Entry - Fixed a bug that could cause the PO Total header to clear when transferring PO lines to an invoice via the Subtract and Clear options.


  1. Chart Rebuilds - The chart rebuild is faster and now only displays a completion message when done. The intermediate messages are now suppressed. 



  2. Journals - Fixed an issue with Tax Balance and Journal Posting that could allow the user to still post an unbalanced journal.

  3. Invoice Inquiry - All columns are now sortable again.

  4. Misc Changes:

    1. Removed the Help menu option

    2. Removed the FTP and Email option in SendTo.

  1. Misc Fixes:

    1. Removed the Utilities → Data Backup option.

  2. Budget Worksheet - Added another automatic chart rebuild check so it picks up users that are posting in future periods and checks when they need to rebuild their chart.

  3. MTD VAT Submission - 

    1. VAT CSV Report of submitted data based on Submission ID will be generated and stored in the History Log file list.

    2. Changed MTD Vat Submission Date format so it correctly displays DD/MM/YYYY

    3. Fixed issue where the submission was flagging items already submitted in previous vat submissions with the new reconcile number.

    4. Fixed issue with the period VAT Log text file pointing to the wrong filename with an underscore in it (e.g. pointed to vat19AI_.txt when it should be pointing to vat19AI.txt)

  4. Historical VAT Reports - Added a VAT Submission field in GL Inquiry and GL Inquiry Reports to output all transactions attributed to that VAT Submission. This is a number that increments from 1 onwards for each vat submission. The user has to grab this number either from the VAT Logs from the MTD Submission Module, or from the Ledger Inquiry screen (last column).

  5. Cheque Printing - Fixed a long standing bug where the invoices would not be correctly assigned to a cheque when it went over the "invoices per cheque" setting in the Cheque Printing screen. The invoices could only be manually corrected in SQL by a tech.

  6. Cheque History Remittances - 

    1. When selecting ALL bank control accounts to print cheques from, it will correctly print the company details on each cheque.

    2. Forced the VENDOR code to be in capitals when filtering Cheque History reports. This will fix incorrect remittances being printed out with merged details.

  7. Cheque History - POS Pay List Report - Fixed the POS PAY LIST report layout that is run from Cheque History. It has been pushed to all blank data folders. To import into a production go to G:\Custom Report Layouts\Fixed Pos Lay List and import it into the Cheque History module (delete the old one first or it will not be imported).

  8. Duplicate Inquiry Screens - Merged some duplicate inquiry screens into their respective modules.

    1. Journal Inquiry 1 and Journal Inquiry merged.

    2. Petty Cash Inquiry 1 and Petty Cash Inquiry merged.

    3. Invoice Inquiry 1 and Invoice Inquiry merged.

  9. Invoice Inquiry and Manual Cheques - Added an error message when a user enters in a cheque number but leaves the date blank. This will prevent users from assigning a cheque number but not a date, resulting in the cheque needing to be reset in SQL by a tech.

  10. EFT File Creation - Added support for XML tags. Note that most tags will still need to be hardcoded. 

    1. Put the XML tag in the Description (without the <>)

    2. X in the Comma field

    3. and populate the FIELD type.

    4. This will then wrap the Description XML tags around the field.

  1. Misc Fixes:

    1. Fixed an error where the Input Control with Audit Report was not calculating totals correctly.

    2. Fixed error message when user clicked the check obligation button in MTD Module.

  2. Invoice Reports - AP Inquiry Reports can now be run to Excel. This includes AP Aging, Distribution and Input Control.

  3. PO Reports - PO Maintenance Reports can now be run to Excel. This includes PO Distribution and Input Control.



  4. System Default -> Prevent users from deleting batches  - Renamed the setting in System Defaults to prevent confusion. This default is now called "Allow Batch Delete". This setting applies across all batch posting modules in Eclipse by disabling the Delete button.

  5. User Access - Added Ctrl+F8 User Access option to block the Attachments tab in the BWS and Ledger Inquiry

  6. Resize Window and Window Split - Invoice Inquiry 1 can now be resized between the top and bottom half of the window between the invoice and detail lines. More screens will be added in future updates.


  1. Chart Rebuilds - Changed how the Chart Rebuilds functionality works from the update on the 29 Oct 2019. The system will automatically prompt the user if they want to run a chart rebuild to fix their data instead of asking to contact support. A message will popup stating that the user's totals are not correct, and asks if they want to correct. Selecting Yes will rebuild the charts/BWS.


  1. PO Recalc - The system will now automatically run a PO Recalc if required when opening the Budget Worksheet. It will only run it if the user has set the system to auto update POs in the System Defaults. See here.

  2. Chart Rebuilds - The system will check if the user needs to run a Chart Rebuild when opening the Budget Worksheet. An error message will popup asking the user to contact support. These error messages are GLC_PERI, GLC_PREP or GLC_NXTP do not equal zero. The user will need to run a chart rebuild as outlined here.

  3. EzyPO CoA Update and Eclipse - The Update EzyPO Button/iEclipse Conversion will have no functionality in Eclipse if the production is using an EzyPO only database with a customised chart sort order. This will prevent anyone from accidently running this and destroying the production's chart of account setup.

  4. PO Maintenance - When modifying a PO in Eclipse and adding line items, the chart code will be correctly propagated to EzyPO.

  5. PO Maintenance - When doing a Copy Log to PO it will no longer throw error messages when rebuilding POs with Hire or Accomodation line items.


  1. Updated Eclipse to Clarion 11.

  2. Invoice Entry and PO Drawdowns - The system will now draw-down the PO value to an invoice when clicking OK on the invoice entry screen.

  3. Posting Transactions - Transactions that were getting posted were flagged as a NULL reconcile number instead of zero, this excluded them from reports when the exclude reconcile number item was ticked until the system could update them to 0 in the background.

  4. Vendor Bank Details - Changes that users made to bank details for vendors were incorrectly sending out change-log emails when the "Lock Vendor Bank" system default was turned to off.

  5. CoA Excel Paste - Chart of Accounts module was not refreshing on an Excel paste in.

  6. Invoice Entry - Edit in Place changes, added some code so when you lose focus to a highlighted record it will prompt you to save the record to prevent any accidental deletion.

  7. Invoice Entry - Clipped the Invoice Number to 15 characters from the Invoice Excel Paste in to prevent an invoice getting posted with a number that was too long.

  8. Petty Cash Entry - The system will now warn you if you are entering a PC form with a duplicate PC Envelope number (either sitting in an unposted batch, or posted in the GL).

  9. Invalid Chart Message Error Suppression - Eclipse will no longer throw an error message when it detects an invalid chart of account. This is especially useful with excel paste-ins and 100's of error messages popping up. Will no longer throw the error message for the following modules:

    1. Journal Entry and Journal Entry Reports

    2. Purchase Order Maintenance and Reports

  10. Period Close - Fixed a bug where a warning message telling the user they were closing the period but not clearing costs, even with the "Clear Costs this Period" checkbox ticked.

  11. PO Zeroing - When zeroing a PO the Notes field is now a required entry.

  1. Period Close - Added a dropdown list in this module to show previous periods and dates.

  2. Invoice Barcodes - Removed the warning message that no barcode was entered if Invoice Scanning turned off in System Defaults.

  1. Cheque Remittance History - Fixed an issue where first cheque printed would merge with the first cheque for that vendor. This occurred when using a vendor filter and printing remittances from Cheque History. 

  2. Cheque Printing - Fixed an issue that did not save your default report type where it would always default to printer. 

  3. Chart of Accounts - Deleting a Chart of Account Line no longer jumps the Chart of Account list to the first chart code.

  1. User Entry Defaults - Fixed Ledger Inquiry Browse Filtering. Previously when a filter was set in the user defaults the ledger would show up as blank.

  2. Users - Operators are now restricted by default from editing Control Accounts.

  3. Invoice Inquiry Reports - Reports can now be run over an amount range. 

  4. Cheque Printing - A warning message will pop up when a user tries to create an EFT file and there are no BSB or Account Numbers setup for that vendor. The user can still create the EFT file and print the cheques if they wish.

  5. Financial Reports - The "Use Data From Period" under Report Range/Options will no longer show the current or future periods. This will stop users from running and generating incorrect reports. 

  6. Budget Worksheet - Removed some defunct options from the "Setup Options" tab.

  7. Budget Worksheet - Added the options to include unposted data at all times in the Budget Worksheet. The "Recalc on Open" checkbox will recalculate any unposted entries and show them in the Budget Worksheet when re-opening it. A popup prompt will popup when opening the BWS  asking the user if they would like to recalculate unposed entries (as it can take some time to complete).



  8. Financial Reports > Cost Reports - When ticking the flag filters in the Report Range Options and ticking the "Send to Excel" checkbox, a fourth report sheet will be exported to excel called the Rebate Cost Report. This will be included with Cost Report, Trial Balance, and CR Variance sheets.

  9. VAT MTD Module - The user can tick a "Create CSV Report" before clicking Calculate to generate a ledger output of the calculation to Excel.

  10. Chart of Accounts/EzyPO Sync - Added an Update EzyPO Button to the Chart of Accounts page to sync the CoA with EzyPO.

  11. (AU Only) - Added a new report default called Cost Report QAPE Rebates to the blank data templates. Can be found under F:\Custom Report Layouts\Rebates Cost Report QAPE\ if you need to import it into an existing production.

  1. New Corp Vendor approval feature added under Control Table → System Defaults → Accounts Payable → "Corp Vendor Bank Approval".

    • This has similar functionality to the "Corp All Vendor Approval" but is less rigid and allows vendors to be created without approval if they do not include bank details.

    • An operator can create and edit vendors without approval until they edit the bank details, vendor name or tax ID.

    • The "Corp All Vendor Approval" default should be turned off. Only one should be ticked or the approvers will get multiple approval email messages.

  2. Cheque Printing will now exclude vendors that have not been approved (when corp vendor approval options ticked) or the vendor is marked as inactive.

  3. New PO Auto-Calculate Distribution Feature added to the PO Master Maintenance Module.

    • If you edit the Total PO Amount, the Tax amount, or one of the distribution lines and attempt to save the PO it will prompt with an auto-calculate prompt.

  4. SMTP Settings removed from System Defaults. These are now stored in a database table and do not have to be entered when setting up a database.

  5. A user no longer has to enter a "from" email address for emailing out vendor bank and corp approval emails. It will use the eclipsesupport@tphglobal.com email. 

    • A user will still need to enter in a "from" email address when sending out cheque remittance emails.

  6. A warning message will popup if no admin email set when trying to send an email to it. This is used for the Vendor Bank Loc and Corp Approval system defaults.


  1. Fixed the "Approve" button not being moved correctly when resizing the Vendor Master Maintenance window. 

  2. Operator accounts no longer have access to System Defaults and are automatically blocked from entering this screen.


 

  1.  Fixes to prevent users from posting or deleting an EzyPO Batch

    1. The missing batch function will not create the EzyPO Batch automatically.

    2. Users cannot post anything in the EzyPO Batch.

    3. Users cannot delete the contents of an EzyPO Batch. The batch will be deleted from the PO entry screen if the user deletes it, but none of the contents inside the batch will be removed (can be reinstated via batch-rename).

  2. Fixed filename appearing twice in the attachments tab when uploading a document from the Invoice entry screen and Petty Cash entry screen.

  3. Fixed error message when sorting via Current Approver in the Invoice Entry batch

  4. Vendor attachments now work and will display in Vendor Master Maintenance → Attachments tab. To add an attachment open up the vendor details via change or double clicking, then navigate to the attachments tab.


 

  1. Fixed an error message popping up when pasting in Control Account transactions from a GL excel export into the General Ledger → Ledger Inquiry window.


 

  1. "Lock Budget Column" checkbox created under Control Table → System Defaults → General Ledger. Ticking this prevents users from editing the Budget column in the BWS via insert, paste, or a movie magic budget upload.

  2. Added functionality to automatically restore missing batches when the user enters the JN, INV, PC or PO entry screen. Missing Fuel batches will be moved into the standard PC screen.

  3. Fixed an issue when the user tries to close a period without any dates populated.

  4. Added a visual indicator at the bottom of the Period Close screen that runs through accounts when generating a period close report.

  5. Invoices per cheque set to 500 when the user ticks the "Create EFT File" in Cheque Printing. The number on this screen will not change as this is done in the background. 

  6. Added code to all posting modules to prevent users from posting batches at the same time. 

    • This creates an entry in the DATA\eclipsed.ini file for each posting module. When a user is posting it will flick to 'Y' preventing any posting in that module until the system has completed the post and flicked it back to 'N'.


       

  7. "PO Audit Log" checkbox added to the Invoice Entry batch Reports screen. When this option is ticked and the new report layout "Input with Audit" is selected it will generate a report as per below.

    • NOTE: If the user has this option ticked and is not running the correct layout, it will duplicate the invoice lines multiple times.

    • Only new databases will have this report. If you wish to import into an old database the "Invoice Entry - PO With Audit Report" can be found under Custom Report Layouts on the Productions drive.



"Vendor Approval" functionality added to Eclipse. To turn on, tick the checkbox "Corp All Vendor Approval" under Control Table → System Defaults → Accounts Payable.

  • Vendor Lock and Lock Vendor bank should be off, unless the Supervisor wants to be the only person updating vendor bank details.

How it works:

  1. When an Operator creates a vendor it sends out an email to the Admin to approve a vendor. The vendor is marked as inactive and cannot be used until they are approved.



  2. The Supervisor then needs to login to Eclipse, locate the vendor in VMM, then select them and click the Approve button. This will change the vendor from inactive to active. 




  • No labels