Feng Office 3.8.6.13

31 January 2022

Feng Office version 3.8.6.13 is now available (major release).

Upgrading to Feng Office 3.8.6.13

What's New in Feng Office 3.8.6.13

• bugfix: Set subtask's financials to the calculated as default (#839)
  

• enhancement: Improve template task variables formulas (#836); in task templates modify estimated time variable assignation selectors to specify time units for the variable and for the additional amount, and MVP for task templates numeric properties assignation with formulas involving the numeric variables defined in the template
  

• bugfix: ensure that the group by column passed to the advanced reports hook has the right table alias to avoid sql conflicts (#837)
  

• bugfix: fix don't show warning when deleting draft email from secondary account (#832)
  
• bugfix: show or hide add worked time option depending on if task is parent and config settings (#831)
  
• bugfix: if there is an error validating the access token, catch the exception and return that it is invalid, so the user can login again to qbo (#835)
  
• bugfix: Set to 'calculated' all the values in the template task's financials tab (#834)
  

• feature: Task templates new variable type numeric (#830); allow to add 'numeric' variables when configuring a task template, add 'Estimated time' to the elegible properties of a task to be assigned with the value of a template variable when configuring a task template, in tasks form, if a task estimated time has an amount of minutes that is not present in the selector options, then add it to the selector, to prevent losing the value after saving the form, use getColumnType function for the template variable type, refactor code for template variables instantiation, and allow text, numeric, date and user custom properties to be used in template tasks and re-use the same functions that fixed task properties use for calculations
  

• bugfix: fix billing report showing gliched date data (#827)
  
• bugfix: only recalculate due date (using selected payment terms) in the controller if it's not sent by the interface (#825)
  
• bugfix: Fix columns layout in the expenses list for the expense items rows (#826). Add column 'is_billable' to the expense items row in the expenses list. Remove log message.
  
• bugfix: Inherit task's financials info when it gets cloned (#828)
  

• feature: Feature improved outbox email user feedback (#822); add methods for counting total emails in outbox and showing popup to user, show number of emails in outbox folder and give feedback when trying to send emails in outbox, remove legacy method that showed outbox emails count fron cron, and new messages for outbox emails feedback
  
• feature: when creating a project from evx to quickbooks, set the option BillWithParent (#821); when creating a project from evx to quickbooks, set the option BillWithParent to true, and put some comments at project creation in qbo
  

• bugfix: fix typo on email notification messages (#801)
  
• bugfix: errors reported on fresh enterprise edition installation (#766); add typecast to avoid warning: 'count(): Parameter must be an array or an object that implements Countable', call ->database_connection instead of DB, as DB class is not available from this dir, and add date field to insert query for fo_cron_events table to avoid error when installing crpm plugin
  

• feature: Add new config option in the project billing report (#818); add option to exclude subprojects info in the Project Billing report and in the Project Budget Status report, and check if dates are DateTimeValue
  
• enhancement: Improve performance of 'Generate project invoice' function (#817); update invoice status of time entry via SQL query, and added a comment
  

• bugfix: When syncronizing an invoice if a line has a date then include it in the SalesItemDetail data of the qbo line (#820)
  
• qbo-sync: when importing invoices prevent the case where there are in (#815); when importing invoices prevent the case where there are invoice lines with quantity=0 and take into consideration that LinkedTxn sometimes is an array and sometimes is an object, and before checking project number uniqueness, check if it's not empty, and fix qbo sync to prevent differences at subtotal/total calculation when numbers come from qbo rounded up
  

• bugfix: fix time by name report doesn't allow to select all invoice option all (#812)
  
• bugfix: Remove condition that excludes timeslots assigned to the trashed task (#816)
  
• performance: use the 'use index' directive when joining with object_members to avoid mysql to use index_merge and filesort for mail list when filtering by any dimension member (#814)
  
• bugfix: Fix bugs that didn't add timeslot via api (#813); add the date to the time entry, dd claient member associated to the project member
  

• improvement: Improve project billing report performance (#791); check if asocciated members are selected when running Project budget status, get projects that have time and expenses in given date range in Project Billing, and get project members using SQL query instead of Member controller
  
• feature: Microsoft Integrations - Support Multiple Clients (#796); Microsoft Integrations - Support Multiple Clients, Used config options for ms integration configuration
  

• bugfix: Fix bug that effected dates filter in many reports
  
• bugfix: Add missing langs (#804)
  
• bugfix: Check if dates are selected when batch invoicing, notify the user if not (#805)
  
• bugfix: when trying to sync account mailboxes, if imap connection fails, don't retry for each mailbox (#807)
  
• bugfix: Invoice template: don't allow to add description if grouped by labor categories (#808); don't allow to add description if grouped by labor categories, and don't allow to add description if grouped by tasks
  
• bugfix: Remove unwanted characters from client and projects when trying to create them in Quickbooks (#809)
  
• bugfix: Exclude non billables from the project billing report (#810)
  

• feature: add config option to prevent users from adding time to parent tasks (#798); add config option to prevent users from adding time to parent tasks, and update plugin version info
  
• feature: Create invoice memo cp for project (#774); add 'invoice memo' custom property to the project (this custom property is used to autopopulate the additional info of the invoice), add cp in installer, and remove logger message
  
• feature: improve error message when batch invoicing can't be executed (#800); improve error message when batch invoicing can't be executed, and replace double quotes by single quotes in lang.php to avoid js errors
  

• bugfix: format_date function last argument (timezone) had zero instead of null as default value, and that caused that the date on the exported report didn't apply user timezone (#806)
  
• bugfix: add document type for invoices with facturalista (#802); fix income plugin updater at version 32 to 33, add document type selector to invoices in facturalista plugin, to specify the client doc type (ci,rut,passport,dni)
  
• bugfix: at inovoice form: replace country text input with a country selector to ensure that we use country code instead of plain text, and remove duplicated queries in income/update.php and use raw sql instead of DataObject to prevent errors if some columns are not present
  
• bugfix: Fix the excel export bug in the "Worked time by person" report (#794)
  
• bugfix: after making inv number alphanumeric, the autonumeration process returns always number 1000 after reaching num 999 (#803)
  

• feature: make quickbooks column of invoices sortable (#789); make quickbooks column of invoices sortable, and update controllers to allow sorting by quickbooks synch state
  
• feature: Don't allow deleting synchronized invoices and payments receipts when QB is not connected (#793); Flash an error if user tries to delete synchronized invoice when the system is not connected to the Quickbooks, raise an error when the user tries to delete it from the Invoice list or Invoice view, don't allow to delete payment receipt from list if synchronized, and don't allow to delete payment receipt from the view if synchronized.
  
• feature: in customer listing add the client's related contact custom properties as columns (#795)
  

• bugfix: utilization report bugs (#787); fix subtitle of report end date was one day behind selected end day, fix when selecting this month filter showing until last day of month instead of until current day, and add variation column to utilization report
  
• bugfix: Check if user has permissions to generate invoice (#797)
  
• bugfix: fix crpm plugin installer
  

• feature: show start and due date in tasks module (#765); client RN show start and due date in tasks module, changes in the form that seach task tring in filters object, and don't use harcoded index when getting columns to show/hide at the ObjectPicker.js
  

• bugfix: Qbo sync issue with required props when creating member and sync invoice (#788); qbo invoice import: one transaction per invoice and verify again that the invoice has not been imported in the same iteration, and qbo invoice import: prevent duplicated payments when invoice includes payment and payment includes more invoices
  
• bugfix: Check if suppliers and income plugins are activated (#776)
  
• bugfix: Check if email is already assigned to another user (#783) when creating or editing a user
  
• bugfix: fix excel and csv export not showing totals for users (#784); fix excel and csv export not showing totals for users, and add condition to check if total_keys is null before setting default value
  
• bugfix: Qbo sync issue with required props when creating member and sync invoice (#785); ignore required member associations when creating projects from quickbooks job, don't allow to save invoice with more than 21 chars (qbo restriction), allow to select which invoices can be imported from the list preview, fix error importing invoice when client is marked as 'deleted' in quickbooks, and remove unused and commented code
  
• bugfix: Prevent creating duplicated project number entries (#786); Flash an error message when the user tries to create a project with a project number that belongs to another project
  
• bugfix: errors in qbo plugin js and hooks when invoice payment receipts plugin is not installed
  

• feature: Qbo sync import tool for invoices and payments and column to show if invoice/payment is synchronized (#782)
  
• feature: batch import of QBO invoices into the invoicing module
  
• add action to sync invoices and payments that are not synchronized and new column at invoices and payments lists to show if they are synchronized or not
  

• bugfix: at project billing report when use non-standard dimensions, we need to check if they exist before using them
  
• bugfix: Allow invoicing only approved time and expenses via bulk actions; don't allow invoice unsubmitted time and expenses via bulk actions, check if time or entry is approved, when invoicing via bulk actions, update approval status of time entries when invoice is trashed/untrashed
  
• bugfix report showing id instead of value and excel export formatting; show currency name instead of currency id, fix spanish translation of currency name and type of payment, fix customer_rut shown with scientific notation format on excel exports, fix translation net due on receipt, remove lang, check currency is not null, show short name, remove currencies tranlation, and use strval to cast to string
  
• bugfix: set value to empty string instead of null when clicking "remove filter" button on date-picker