...
2022
...
2021
...
2020
...
2019
...
...
...
...
...
Send To context menu
Removed Word and Excel from the send-to context menus.
Invoice Entry/Petty Cash Entry → Right Click → Move to Batch context menu
Fixed an issue that could move the transaction into the incorrect numbered batch zero.
...
Petty Cash → Paste EU Petty Cash Form
Added some logic to prevent a tax line being created when ‘create dist line’ is unticked under Indirect Tax Codes.
A tax line will only be created if a tax code rate is >0% or if the ‘create dist line’ option is ticked under Indirect Tax Codes.
System Default → Tax Balance → Auto Create and Balance Tax Line
Added additional criteria for when a tax line is automatically created under Petty Cash.
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.
...
System Default → Tax Balance → Auto Create and Balance Tax Lines
Added additional criteria for when a tax line is automatically created under Invoices.
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.
...
Invoice Inquiry Reports
Fixed an issue with the paid date field returning Unpaid reports as blank.
Invoice Inquiry → Unposted Invoices
Fixed an issue that allowed users to edit fields that should not have been editable (Currency, Tran Number, etc).
...
Invoice Inquiry Reports
Updated 1099 reports with a paid date field
New Tax Balance System Default → Tax Balance → Auto Create and Balance Tax Lines
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
...
Financial Reports - Period Range
Further fixes for Sky Production’s Period Range reporting and templates.
All Attachment Screens
Fixed an issue where a blank attachment would load a file explorer in the attachment viewport.
Vendor Master Maintenance
Changed the excel class used for Exports in this module only.
...
Financial Reports - Period Range
Further fixes for Sky Production’s Period Range reporting and templates.
...
Financial Reports - Period Range
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.
...
Purchase Order Reports
Fixed an issue with PO Excel Reports corrupting due to an invalid character in the description fields.
MTD VAT Submission Module
Fixed an issue where the submission number was not being added to the records in GLMASTER.
Added the SQL statement to update the submission number to the VAT logs.
...
Reporting
Fixed an issue with reports freezing if trying to export data with a negative transaction number.
...
MTD VAT Submission Module
Fixed some more VAT submission headers as per HMRC feedback.
Petty Cash and Invoices Attachment Uploading
Fixed an issue when uploading attachments and and the previous attachment subfolder still being in the buffer which applied to any new attachment uploaded
...
MTD VAT Submission Module
Fixed some missing and invalid web headers.
Petty Cash → Petty Cash Entry
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.
Invoices → Invoice Entry
Changed the background colour of fully approved invoices from light green to dark green
Fixed the comments via the DPF tab not being sent to DPF when the Invoice is sent.
...
Excel Exports
Fixed an invalid character breaking the Excel Exports that resulted in a blank excel file in the Vendor Master Maintenance and Invoice Inquiry modules.
...
Eclipse User Security Levels
Went over every module to fix any missing areas where the user security level did not take effect.
Fixed wildcard level 99 sec levels not working correctly
Added Control Account Filtering to Invoice Entry, Cheque Printing, and PC Entry.
For more information on sec levels see: User Security Access and Security Levels
...
Control Table → System Defaults → SMTP → Admin Email
Increased the character limit of this field so more emails could be assigned as an Admin email.
Accounts Payable → Cheque Printing
Removed some old unused libraries from the cheque printing screen.
...
Unposted Journal Transactions
Fixed issues with flags not updating (F,IN,TX) when an updated spreadsheet was pasted in.
Invoice Entry → Send to DPF
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.
Financial Reports - Unposted PO checkbox
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.
This option will no longer include any modified orders sitting in an unposted batch.
Added the Cent Trip Debit Card API
This option can be found in the System Defaults → Petty Cash section
See attached instructions.
| View file | ||
|---|---|---|
|
...
Integrated Barcode Scanning (AU ONLY)
Rolled out iEclipse barcode scanning to the AU Side.
A button is available under Invoice Inquiry that allows users to upload their barcode scans with the same functionality as the iEclipse website.
Invoice Entry → Invoice Entry Paste in
Removed the paste in from using the BSB, Acc Number and Acc Name in the template and overwriting the vendor details in Eclipse.
...
Financial Reports → Send to Excel
Fixed an issue with an invalid character breaking the excel report output.
Invoice Entry → New Attachment Popup
Removed this button as it had invalid code and was not working.
...
Budget Worksheet → Transactions tab
Fixed an issue with an invalid character breaking the excel report output.
...
All Modules → Attachments tab
Fixed an issue with attachments not displaying if GLMS Subfolder is populated and the attachment is in the root DATA folder.
Bank Reconciliation → Reports
Fixed an issue where the reports would export blank data if the report name differed from the default layout name.
Excel Node API Update (AU ONLY)
Replaced the Node API to fix numerous issues with the old Node API.
Fixes an issue where the ETC, Fringe, Variance and Period Variance were blank in the Excel export if a Note is present.
Invoice Inquiry → Invoice Input Reports
Fixed an issue where running these reports over no data would not display anything.
A blank report will now be displayed to the user if the filters they are using will not actually give them any data.
Ledger Inquiry/Budget Worksheet → Excel Paste In
Fixed an issue where the F, IN and Tax did not update Unposted transactions on paste in.
Petty Cash → Paste NEW PC Form
Added validation to the VAT Total Line on paste in.
User Level Security Filtering → “Use User Sec Level for New Chart and Vendors”
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.
...
Invoice Entry → Invoice Line Distribution
Fixed a missing tab on the Invoice Line Distribution Excel Export for Live Nation
Exports these details to a second tab in the export: Oracle Code / Invoice # / Eclipse Code/ Description / Amount/ Transaction # / Vendor Name
...
Journal Entry → Security Levels
Fixed security levels not applying to unposted journals.
If a chart of account does not exist for the journal line, the user can still see the transaction line.
...
Financial Reports → Send to Excel
Fixed a bug where the ‘Send to Excel’ option would not save to the Report Default.
...
Invoice Entry → Invoice Lines Export
Fixed an issue where the excel export for Invoice lines was using the COM method instead of the Node API.
...
Invoice Entry → Add two Tax Lines
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.
Instead the system will create one tax flag and one non-tax flag as specified in the Control Table → Currencies tax flag selections.
...
Financial Reports → Send to Excel
This checkbox will now be saved to the report default correctly.
Petty Cash Inquiry → Reports
Removed the defunct checkbox Use Selected Records that was greyed out.
...
Budget Worksheet Excel Paste In
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.
...
Excel Node Reports
Fixed an issue with Excel Node reports not exporting in Financial Reports and Ledger Inquiry if the show name contained invalid filename characters.
...
Vendor Master Maintenance
Fixed an issue with the Vendor Name column not sorting correctly.
Cheque Posting
Fixed issues with this window not resizing correctly and UI elements overlapping
Added a minimum resize value to this window.
...
Financial Reports - Closed Period Reports
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.
...
Invoice Entry → PO Transfer
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.
Purchase Orders
Fixed an issue with the 5 day hire calculation being incorrect.
Excel Node Reports
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.xlsxFixed an issue where the Excel PO Distribution and Input Control Reports did not respect Save to Disk being enabled.
Production List
Added a search bar to the production list. This will help with sorting through the master show file.
Financial Reports
Fixed a bug where a blank period date field would still appear on the report window when “Use Period Close Date” was ticked.
...
Ledger Inquiry → Excel/CSV
Fixed an issue with the save to disk folders not being created on the users local drive.
Cheque Printing → User Defaults
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.
DPF Invoices and Petty Cash Batches
Added in delete protection for DPF Invoice batches 2,3,4.
Added in delete protection for DPF Petty Cash batches 5,6,7.
...
Financial Reports -> Send to Excel
Fixed an issue with the header row not generating correctly in the excel export.
...
System Defaults → General Ledger → Period End Date
Added a system default under Use Period Close Date. By default this is enabled.
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.
Invoice Entry → Tax Balance
Corrected a bug where the tax would balance when checking with the button but would throw a tax balance error on post.
Excel Node Export for large datasets
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.
Master Show file
Added some user debug logging under C:\Users\%username%\AppData\Local\Temp to troubleshoot production access issues with the master showfile rollout.
...
Vendor Master Maintenance - Invoices and Cheques tabs
Fixed the excel node export not working on the Invoices and Cheques tabs.
...
Invoice Inquiry - Hold Invoices
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.
System Defaults → Scan Check Excel Report
Fixed an issue with the export not exporting barcodes with missing file attachments in the DATA folder.
System Defaults → Petty Cash → Email PC Start Line
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.
The default value is set to export lines into a PC form starting from line 5.
Petty Cash → Debit Card Paste in
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.
Financial Reports - Historical Periods
Removed the Period End Date field from the Report options.
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.
...
...
Cheque Printing → Test Cheques
Fixed error messages popping up and spamming a user when they printed a Test Cheque.
Debit Card Paste In
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).
The default is set as 15.
System Defaults Security Permissions
Added CTRL+F8 Security Operator permissions to most System Defaults tabs (except General and Company Details).
This allows Operators to be given access to specific sections in the System Defaults without being an Supervisor user account.
Scan Check Excel Report
This report has been added back into Eclipse under the System Defaults → Scanning tab.
...
Budget Worksheet → Transactions
Fixed an issue when exporting transactions to Excel. The sort order would reset and the transaction window would go blank until refreshed.
...
Payroll Module
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.
Debit Card Import
Updated max tran to 15.
Eclipse and DPF Functionality
Indirect Tax, Vendor and Control Table Chart Sort and Chart Code will now correctly update in DPF if changed in Eclipse.
Debit Card Paste
Fixed issue when pasting equals data into Eclipse and it not correctly separating transactions.
Period Close
Updated period close when ‘Clear Costs’ was unselected by a user to now always take a snapshot to the pericost table.
Chart of Accounts
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.
Financial Reports - Historical Period Range option
Added a checkbox under System Defaults → General Ledger to enable this functionality.
This functionality will allow a user to select a period range in the Financial Reports module to run their reports over.
...
Netflix Upload
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.
Fixed issue where if an ITD file was sent it would remove the control account mapping in TenantGUID from GLCHART.
Control account mapping for old control accounts is now set in SystemAccount.
Invoice Inquiry → Reports
Added a Studio Code field to the report fields.
Invoice Inquiry → Hold Invoices
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.
Petty Cash → Voucher Field
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.
Chart of Accounts → Excel Paste In
The excel paste in will now strip all characters except the following: A-Z, 0-9, (space), period and dash)
MTD Submission Module
Updated headers sent to HMRC to be compliant with the specifications.
...
Accounts Payable → Cheque History 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.
...
Payroll Module
Removed this option entirely from the Eclipse menus.
The license must be changed toEnterpriseto get this option back.
Invoice Entry
Fixed bug where sorting on Approval Group or Username would crash the batch window.
General Ledger → Financial Reports
Fixed an issue with sequences and set ranges being ignored.
Budget Upload → Movie Magic
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.
Fixed the issue with the imported budget window not refreshing when uploading the budget multiple times.
Fixed the issue with the first non-postable chart of account in the budget file not getting uploaded.
...
Budget Worksheet
Added Cost Report updating checkboxes to the BWS Setup Screen so Operator accounts can still access.
User Entry Defaults → Auto Print Attachments
Changed checkbox description to “Auto Print Attachments During Invoice Entry” and added tooltip to provide further information on what this option does.
Cheque Printing
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.
Node Export → 1099 Vendor Report
Added the TaxID field to the export.
Node Export → Cheque Posting
Fixed the export not using the fm3.ini setting so it will now correctly export via the NodeAPI.
Control Table → Control Accounts
Granted access to Operator accounts to create and edit Control Accounts. Previously only Supervisor accounts could do this.
...
Budget Worksheet
Added an ‘exclude zero lines’ to the BWS Summary sheet to exclude any zero value accounts.
Added an ‘exclude zero lines’ to the Transactions tab.
User Entry Defaults → Save to Disk
Fixed a bug where the save to disk default would not save for the user when re-opening Eclipse.
...
Cheque Printing - Create EFT File
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.
Ledger Inquiry → VAT Reports
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.
...
Chart of Accounts
Fixed CoA scrolling to the bottom after deleting an account code.
Ledger Inquiry → Dist Change
Fixed issue when populating the Dist Change list with multiple transactions using the same tran number.
...
MTD VAT Submission
Added additional required information sent in headers to HMRC when grabbing a period obligation.
Budget Worksheet - Transactions Tab
Fixed an issue where an Excel export from the transactions tab would sometimes double up lines in the export.
User Entry Defaults - MAC User checkbox
If a user ticks this checkbox and then presses ok, it sets the default save to disk path to M:\Desktop\Eclipse
...
Invoice Entry - Unposted Invoice Lists
Populated all DPF data into the columns that were previously missing.
Distribution Change Excel Paste in
Fixed the excel distribution paste in missing checks when it added transactions. This resulted in paste ins failing incorrectly.
System Defaults → Excel Beta Reports
Removed this system default as it is defunct.
Excel Beta reports is a setting that is set per server in the eclipse/start/fm3.ini file
...
Vendor Master Maintenance
Made the vendor code a required field
Replaced the SQL Error message with a more user friendly message when the user enters a vendor code that already exists.
Node Export - Unposted Invoice List
Added DPF Fields to the Invoice List Export
Netflix Upload
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
User Security Levels
Added missing security name filters for Journal Entry and Journal Inquiry as security names were not functioning properly in these modules.
...
EFT File Creation
Fixed a bug where if the user selected ‘PDF’ as their Report Type in Cheque Printing it would print a corrupted EFT File.
Node Export - FBT Report
Fixed all missing fields in the Fuel Register and Car Hire Register sheet for the Excel Node Export.
Node Export - Debit Card Transactions
Fixed issue where no transaction lines would populate the export sheet.
Node Export - Unposted Invoice List
Exporting transactions to Excel from the Unposted Invoice list will now list DPF Columns (approved by, import log, current approver, etc).
...
EFT File Creation
Fixed bug with Fremantle SFTP Upload at Cheque Printing.
Fixed issue where creating a PDF Report (Not Preview) in Cheque Printing could change the EFT Download path.
Chart of Accounts
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.
Ledger Inquiry Reports
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.
Chart Lookup
Fixed issue with the Exit button selecting the chart of account instead of exiting the lookup.
Fixed issue where selecting the Exit button in the VMM PC Advance Code selection would insert a period into the Set field.
BWS Rebate Sheet
Fixed issue with dumping the BWS Rebate sheet to Excel
Purchase Orders
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.
...
User Entry Defaults → Mac User
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).
...
Vendor Master Maintenance
Fixed issue with selecting a PC Float code with the ellipsis menu if the field was already populated.
PC Fuel Entry
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.
Ledger Inquiry
Fixed issue where uploading an attachment would set the upload with a subfolder so it appeared blank in the attachments view.
System Defaults → Petty Cash → Disable Auto-Recalc of Tax in Petty Cash
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.
BBC VAT Report
Added a Description Column to the Excel Report (after Tax ID and before Net Amount)
Eclipse Production Selection List
Fixed bug where if you pressed the ‘enter’ key to select a production from the list it would throw an SQL error.
Petty Cash Form Generation (Email PC Form and Create PC Form)
Lines will now be exported in ascending date order (most recent transaction at the bottom)
...
Vendor Master Maintenance
Fixed issue with the Excel Node export not correctly exporting the vendor contact information and email
Fixed issue with the Excel Paste in and it wiping the W9 Expiry Date
Invoice Inquiry Reports → Input Control Report
Fixed issue where if you ran the report Input Control Report and no data was returned it would crash Eclipse.
MTD VAT Submission
Corrected error with incorrect file path to CARoot.pem
Financial Reports → Sequence Ranges
Added the ability to copy the entire sequence range including Sub, Cu, Loc, Eps, and Subtotal Header
Netflix Upload
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.
The GL auto-export will be skipped if the user is not part of the Netflix-Upload group in Active Directory.
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.
Fremantle Upload
Added extra SFTP settings for Fremantle Uploads. Fremantle Uploads now use SFTP2 settings.
...
Invoice Inquiry Reports
Fixed issue with node export not working for Invoice Inquiry Reports.
Debit Card PC Email
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.“
MTD VAT Submission
Fixed an issue where the MTD CSV Report being opened would break Excel node file generation.
Fixed an issue where files in the MTD History Log being opened would break Excel node file generation.
Vendor Master Maintenance
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.
Master Production Show File
Laid down the groundwork to move to one centralised showfile with all productions inside it, instead of individual show files per each user.
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).
To turn on this functionality, put FilterShows=Y under [FM3ODB] in the Eclipse/start/fm3.ini folder. By default Eclipse uses FilterShows=N
...
Petty Cash Debit Card Reconciliation Paste in
Added the functionality to chose your tax code when pasting in debit card transactions into the Petty Cash Entry screen.
If this checkbox is not ticked it will use the default vendor tax code.
...
...
VAT Submission Module
Fixed issue with PeriodKey text record being named incorrectly in the history logs.
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.
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.
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.
Excel Node Reports
Fixed issue with node reports not appearing for users on the UK side because of missing quotes around the filename.
Fixed various node reports not working on the UK side and not generating any file.
Fixed issue where the Ledger Inquiry excel exports would ignore the ‘save to disk’ option in user defaults.
Invoice Entry - Fixed issue with the payroll TPH Invoices not showing the attachments.
...
Invoice Entry PO Transfer - Fixed issue where the CTRL key was getting initialised after a PO Transfer to an Invoice.
Negative Cheques - Fixed an issue where the negative cheque tick box would not stay ticked in the Cheque Printing Module.
Excel BAS Report (AUS Side) - Fixed missing headers in the Ledger Sheet of the BAS Workbook.
EFT File Creation - Added additional fields to Eclipse for EFT File Creation to complete the EFT Layout for Spiderhead’s US Team.
...
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.
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.
Negative Cheque Reprint - Fixed a bug where reprinting a negative cheque would make it disappear.
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.
Journal Entry Column Sorting - Fixed issue with sorting columns in the entry screen and lines disappearing.
New Attachment Control - Fixed issue with non-pdf documents not being able to be downloaded.
Spiderhead EFT US File Creation - Added some fields required to code up the EFT file for Spiderhead’s US EFT.
Tax Balance Message - Changed the GST does not Balance tax message to Tax does not balance across all modules.
Chart of Accounts - Fixed an issue where changing an account code would revert back to the previously entered code after closing the CoA window.
...
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.
Attachment Upload in PO Entry -
The previously visited file path is now saved for the user when they attempt to upload a file via explorer.
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.
Netflix Upload - Added a system generated description to any transactions with blank description fields in the Netflix Upload.
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.
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.
...
Bank Reconciliation - Attachments tab
Fixed issue where you could not run a bank rec report after uploading an attachment (you had to reopen the bank rec window).
MTD VAT Submission
Will now force users to enter in their VAT Rego number before the Check Obligation Process.
VAT Folder now created in the DATA Folder to record logs during the Obligation Process.
Netflix Upload
Fix to the Netflix Sequence Numbers for their EFC Uploads so they should correctly stay in sequence.
Node Excel Updates
GL Reports - Fixed exporting a report to excel and it not clearing previous data
PO Reports - Fixed PO Reports not exporting to excel
Cheque Printing
Changed the upto due date field to be one year from the current date.
Petty Cash
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).
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.
This should only be used for non-GB Currencies because it will break the VAT Report.
Split Line to Bal GST must be turned off in the System Defaults → Petty Cash.
...
...
Bank Reconciliation - Attachments tab
Fixed attachments not uploading
Budget Worksheet - Rebate Budget Worksheet Paste in
Fixed issue where rebate BWS notes were overwriting default BWS notes.
...
Excel Node Report Generation
...
New Functionality: PDF Cheque Remittance Generation
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.
iEclipse Barcode scanning is still only supported by 5 digit cheque numbers.
...
Excel Node Report Generation
...
Fixed VMM → Excel AP Aging Report not generating
...
Fixed Data Integrity → Check Scans Report not generating. (Will generate but will throw errors still)
...
BWS Excel Reports
...
Fixed issue with Fringe % column outputting to 2 decimals instead of 4.
...
Vendor Master Maintenance
...
Cheque Printing
...
Excel Node Report Generation
...
Reports
...
Debit Card Paste Ins
...
Debit Card Reconciliation
...
Email PC Form → Users MUST enable Excel Beta Reports in System Defaults for the Email PC Form and Create PC Form to work properly.
...
Fixed error messages occuring about not being able to remove the file.
...
Create PC Invoice button
...
Eclipse DPF Updates
Added Default Approver group to System Defaults → Digital Approve.
Copied chart sort\code\flags in Eclipse for PC and AP on ok.
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.
...
Excel Node Report Generation
...
Debit Card Expense
...
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.
...
(AU) BAS Workbook
...
(UK) VAT Submission
...
(AU) New Feature - Send Invoices and Petty Cash to DPF: Allows users to use Eclipse for data entry but then use DPF for approval.
Adds a right click menu to send AP, PC, Fuel to DPF.
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.
...
Excel Node Report Generation
...
Ledger Inquiry → Edit Journal Invoice Number
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.
...
Bug Fixes:
...
Fixed bug with VAT Flag Report that occured with the change to ignore invoice if empref is not blank for BBC.
...
Fixed the Delete button not working in Debit Card Reconciliation
...
Debit Card Reconciliation - New Provider Added (VASCO)
Added a field in System Defaults → Petty Cash where a user can type the provider name. By default it is set as EQUALS.
A User can type in VASCO instead and it will use a different set of debit card defaults.
The user can use PPAN or ClientID in vendor setup.
...
Petty Cash Fuel → Create Invoice
...
Petty Cash Per Diem → Create Invoice
...
Period Close → Don't Clear Notes
...
MTD Digital Vat Submission
...
Debit Card Expense Forms
...
User Reports
...
Invoice Inquiry → AP Aging Report
...
Budget Worksheet → Auto Balance Check
...
Budget Worksheet → Transaction tab → Reports
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).
If the user clicks the "use selected records" checkbox it will remove the source code tab to prevent any confusion.
...
Budget Worksheet → GL Description Lines
Fixed an issue where the description line of a transaction was missing from the export.
...
Excel Node Server
Enabled Excel report for Vendor AP Spend
Budget Worksheet → Transactions → Reports: Updated this module to use excel node
...
Ledger Inquiry → Dist Change History (Edit History button)
Enabled resizing on this window to increase readability.
...
VAT MTD Submissions
Fixed a bug where if a vat submission failed it would mark the transactions in Eclipse as being sent.
NBCU Password Complexity
...
Pushed out the ability in Eclipse to use forced password resets and complex passwords - this is specifically designed for NBCU on the UK side.
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
...
Chart of Accounts → Inserting or Pasting
...
Trimmed blank space in the chart of account code when a user entered a new chart of account or pasted one into Eclipse.
...
Excel Node Server
...
Petty Cash → Email PC Forms
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.
...
Budget Worksheet → Reports button
Replaced this button with the same module used in General Ledger → Financial Reports
Cheque Printing → EFT Layout Editor button
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.
...
Excel Node Server
...
Converted the FBT and BAS workbooks to use the new Excel Node file generation.
...
System Defaults → Add 2 Tax Lines.
...
MTD Submission Module -
...
Corrected the generation of the file link in the History Log tab to the CSV Report and the submission text file.
...
Excel Node Server
Pushed out the new Node method of Excel file generation across all servers.
This replaces the old Office dependant COM Method of generating Excel files in Eclipse.
This method is disabled by default, but can be enabled by ticking the "New Beta Excel Reports" checkbox under System Defaults.
...
SAP Paste - Misc bug fixes.
...
Netflix Debit Card Reconciliation - Misc bug fixes.
...
Control Table → Control Accounts - Fixes to allow the scrollbar to be used along with enabling header sorting.
...
Vendor Master Maintenance - The First Name will now be shown in the Vendor Names list separated by a comma.
...
Bank Reconcillation - Removed the undo button as its no longer used and was not working properly.
...
Show File Path Dialog box - Increased the size of the show path dialog box so you can see the prod paths more easily.
...
Production Selection - Removed buttons that were no longer used so only Select and Backup buttons remain.
...
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.
...
Tax Balance - All entry modules are now using an updated tax balance calculation.
...
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.
...
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
...
Ledger Inquiry → Reports
Fixed a bug that prevented users from running a ledger report on accounts that had a blank episode code.
Removed the XML option and merged the Excel and CSV option into one checkbox.
The FBT option is now saveable to the Report Defaults.
...
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.
...
Digital VAT Submission -
Added extra detail to the history logs by including the vat period field from the MTD screen.
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.
...
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.
...
Vendor Maintenance → ABN/Superfund Lookup - Changed lookup web service to use HTTPS as HTTP port 80 now depreciated.
...
Vat Submission - Fixed an error message throwing an invalid json string which prevented the submission from being accepted by HMRC.
...
Cheque Posting - Added a reminder message when a user attempts to post Cheques asking them if they have sent remittances.
...
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.
...
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.
...
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.
Purchase Order Entry -
...
Removed the "Chart code not found" message from popping up when a user opens a PO with invalid charts coded to transaction lines.
...
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.
...
PO Maintenance - Excel PO Input Control Reports will now list the requester, department and who approved the PO.
...
...
Digital Approve - Invoice Approval - Updated String Theory and removed line wrapping to resolve base64 error messages when approving an Invoice.
...
Screen Resizing - Added window resizing to PC Inquiry and Cheque History 1.
...
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.
...
AP Excel Reports - Made some changes as requested by BBC.
...
PO Excel Reports - Made some changes as requested by BBC
...
VAT MTD Module - Fixed filepath in the history logs so it correctly points to the submitted VAT csv data.
...
Bug Fixes:
...
Budget Worksheet - When ticking to show unposted journal entries in the BWS it will no longer throw an error message.
...
Cheque Printing - Added in code to reduce the occurrence of Error Code "FILE NOT OPEN 37".
...
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.
...
Invoice Inquiry - Fixed issue when sorting via Cheque Number and records duplicating in the viewport.
...
Journal Inquiry - Fixed issue where the Unposted tab was in focus when opening the window.
...
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.
...
VAT Submissions - Fixed an issue where the Check Obligation was not grabbing the VAT Period because of a corrupted header being sent.
...
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.
...
Cheque Printing - Adding Window Resizing
...
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.
...
Chart Rebuilds - The chart rebuild is faster and now only displays a completion message when done. The intermediate messages are now suppressed.
...
Misc Changes:
...
Removed the Help menu option
...
Misc Fixes:
...
MTD VAT Submission -
...
VAT CSV Report of submitted data based on Submission ID will be generated and stored in the History Log file list.
...
Changed MTD Vat Submission Date format so it correctly displays DD/MM/YYYY
...
Fixed issue where the submission was flagging items already submitted in previous vat submissions with the new reconcile number.
...
Cheque History Remittances -
...
When selecting ALL bank control accounts to print cheques from, it will correctly print the company details on each cheque.
...
Duplicate Inquiry Screens - Merged some duplicate inquiry screens into their respective modules.
...
Journal Inquiry 1 and Journal Inquiry merged.
...
Petty Cash Inquiry 1 and Petty Cash Inquiry merged.
...
EFT File Creation - Added support for XML tags. Note that most tags will still need to be hardcoded.
Put the XML tag in the Description (without the <>)
X in the Comma field
and populate the FIELD type.
This will then wrap the Description XML tags around the field.
...
Misc Fixes:
...
Fixed an error where the Input Control with Audit Report was not calculating totals correctly.
...
PO Reports - PO Maintenance Reports can now be run to Excel. This includes PO Distribution and Input Control.
...
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.
...
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.
...
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.
...
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.
...
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:
...
Journal Entry and Journal Entry Reports
...
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).
...
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.
...
New PO Auto-Calculate Distribution Feature added to the PO Master Maintenance Module.
...
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 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.
...
Operator accounts no longer have access to System Defaults and are automatically blocked from entering this screen.
...
Fixes to prevent users from posting or deleting an EzyPO Batch
...
The missing batch function will not create the EzyPO Batch automatically.
...
Users cannot post anything in the EzyPO Batch.
...
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.
...
Fixed an error message popping up when pasting in Control Account transactions from a GL excel export into the General Ledger → Ledger Inquiry window.
...
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'.
...
"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:
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.
...
| Child pages (Children Display) |
|---|