2020 - Eclipse Updates

Dec 10, 2020

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.

Open

Open

Nov 26, 2020

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.

Nov 19, 2020

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.

Nov 16, 2020

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.
      
      

Oct 26, 2020

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.

Oct 13, 2020

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.

Oct 8, 2020

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.

Oct 7, 2020

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.

Sep 29, 2020

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.
      
      

Sep 22, 2020

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.

Sep 14, 2020

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.
      
      

Sep 1, 2020

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.

Aug 19, 2020

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.

Aug 14, 2020

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
      
      

Aug 4, 2020

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.

Jul 24, 2020

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.
   
   

Jul 3, 2020

1. Netflix Debit Card Reconciliation - Misc bug fixes.
   
   

Jun 29, 2020

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. 
   
   

Jun 15, 2020

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

Jun 5, 2020

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.
   
   

May 22, 2020

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.
   
   

May 15, 2020

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.
   
   

May 7, 2020

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.
   
   

Apr 27, 2020

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.
   
   

Apr 24, 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.

Apr 22, 2020

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. 
      
      

Apr 21, 2020

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.

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

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

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

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. 

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.

• 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.
  
  

Apr 9, 2020

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.

Apr 7, 2020

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
   
   

Mar 31, 2020

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

Mar 23, 2020

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

Mar 20, 2020

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.
      
      

Mar 16, 2020

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.
    
    

Feb 27, 2020

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 http://www.myip.com  to get their IP address.
   
   

Feb 26, 2020

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.

Feb 21, 2020

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. 

    

Feb 20, 2020

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).
   
   

Feb 18, 2020

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

Feb 13, 2020

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

Feb 11, 2020

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.

Jan 22, 2020

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.