Monday, October 17, 2022
4 changes · master
Enhancements to existing features
The spreadsheet app is updated with many additional financial formulas, making it easier to model loans, investments, depreciation, treasury bills, and cash flows directly in Odoo. The update also fixes small usability issues in search, calculation display, and column resizing for a smoother spreadsheet experience.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/ab6f7e4b [FIX] find_and_replace: clear input clears search matches…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/ab6f7e4b [FIX] find_and_replace: clear input clears search matches https://github.com/odoo/o-spreadsheet/commit/fe6afd61 [REF] header_visibility_ui: rewrite findLastVisibleColRowIndex https://github.com/odoo/o-spreadsheet/commit/4c987a64 [REF] grid: remove useless clip https://github.com/odoo/o-spreadsheet/commit/25a3168b [REF] functions: naming convention of assert helpers https://github.com/odoo/o-spreadsheet/commit/ab896cac [IMP] functions: add demo data for financial functions https://github.com/odoo/o-spreadsheet/commit/1e5912ad [IMP] functions: add AMORLINC function https://github.com/odoo/o-spreadsheet/commit/cee8339f [IMP] functions: add XNPV function https://github.com/odoo/o-spreadsheet/commit/dd17ff13 [IMP] functions: add XIRR function https://github.com/odoo/o-spreadsheet/commit/d6813dc4 [IMP] functions: add VDB function https://github.com/odoo/o-spreadsheet/commit/83ea4da8 [IMP] functions: add TBILLYIELD function https://github.com/odoo/o-spreadsheet/commit/b2bd8be3 [IMP] functions: add TBILLEQ function https://github.com/odoo/o-spreadsheet/commit/d1e70d63 [IMP] functions: add TBILLPRICE function https://github.com/odoo/o-spreadsheet/commit/ea1bef1c [IMP] functions: add SYD function https://github.com/odoo/o-spreadsheet/commit/31605fd4 [IMP] functions: add SLN function https://github.com/odoo/o-spreadsheet/commit/816d31af [IMP] functions: add RRI function https://github.com/odoo/o-spreadsheet/commit/a4a83a4b [IMP] functions: add RECEIVED function https://github.com/odoo/o-spreadsheet/commit/28feb878 [IMP] functions: add MIRR function https://github.com/odoo/o-spreadsheet/commit/a289a941 [IMP] functions: add INTRATE function https://github.com/odoo/o-spreadsheet/commit/62da0927 [IMP] functions: add FVSCHEDULE function https://github.com/odoo/o-spreadsheet/commit/b6789bd7 [IMP] functions: add DOLLARFR function https://github.com/odoo/o-spreadsheet/commit/5db4064f [IMP] functions: add DOLLARDE function https://github.com/odoo/o-spreadsheet/commit/cdc73ce5 [IMP] functions: add DISC function https://github.com/odoo/o-spreadsheet/commit/cd0ee521 [IMP] functions: add DDB function https://github.com/odoo/o-spreadsheet/commit/161134e6 [IMP] functions: add CUMPRINC function https://github.com/odoo/o-spreadsheet/commit/c89c64ec [IMP] functions: add CUMIPMT function https://github.com/odoo/o-spreadsheet/commit/4608ce74 [IMP] functions: add ACCRINTM function https://github.com/odoo/o-spreadsheet/commit/c0bbf544 [IMP] functions: add DAYS360 function https://github.com/odoo/o-spreadsheet/commit/2a59663c [IMP] functions: add PRICEMAT function https://github.com/odoo/o-spreadsheet/commit/1c28a0ff [IMP] functions: add PRICEDISC function https://github.com/odoo/o-spreadsheet/commit/dabffa30 [IMP] functions: add ISPMT function https://github.com/odoo/o-spreadsheet/commit/f7351b21 [FIX] evaluation: prevent minus 0 (-0) values https://github.com/odoo/o-spreadsheet/commit/3fca53c9 [IMP] functions: add IPMT function https://github.com/odoo/o-spreadsheet/commit/418c9f4a [IMP] functions: add PPMT function https://github.com/odoo/o-spreadsheet/commit/8ea85442 [IMP] functions: add NPER function https://github.com/odoo/o-spreadsheet/commit/b9eb40b8 [IMP] functions: add PMT function https://github.com/odoo/o-spreadsheet/commit/27228ad7 [IMP] functions: add YIELDDISC function https://github.com/odoo/o-spreadsheet/commit/ca54b439 [IMP] functions: add coupon functions https://github.com/odoo/o-spreadsheet/commit/7f0b3703 [IMP] functions: add RATE formula https://github.com/odoo/o-spreadsheet/commit/9940b6d9 [IMP] functions: add NOMINAL and EFFECT functions https://github.com/odoo/o-spreadsheet/commit/97ddfdd6 [FIX] functions: rename financial test file https://github.com/odoo/o-spreadsheet/commit/16f7d2af [REF] sheetview: don't reset viewports uselessly https://github.com/odoo/o-spreadsheet/commit/4dfa2142 [REF] grid: remove useless anonymous function https://github.com/odoo/o-spreadsheet/commit/e3f64551 [FIX] ui_sheet: do not resize empty columns
Bank statement reports now include fewer blank lines and show more available details about partners and bank accounts. For companies not using online synchronization, the report is generated when the statement is posted, making the final report timing better aligned with accounting workflows.
Original PR description
Improve the bank statement report by reducing the amount of blank lines in it, as well as adding more information about the partner and bank account when we have it. Also, when not using online sync the bank statement report will now be generated at the time of posting and not validating. Task id #2860753
Resolved issues and error corrections
The snailmail process now skips letters for accounts that have no remaining credits, preventing repeated resend attempts and reducing spam-like activity. Users can manually reset selected letters to pending when they want them retried after resolving credit issues.
Original PR description
We are spammed by some accounts that don't have credits anymore. With this commit, the snailmail `cron` does not take their messages into account anymore. There is a new server action (action_reset_to_pending) callable from the list view, for bulk updates on the snailmail_letter records. This action allows the user to reset the state of chosen letters, making those elligible again to the cron. __Pros & Cons__ Some drawbacks of this approach are: - Since the server action is in the views, the snailmail module needs to be upgraded. - The user needs to act (before it was in the background => less ui friendly, but probably rare enough). - Risk of abuse. Some upsides are: - Allows bulk and fine tuning reset (maybe some of the letters dont need to be sent anymore) - Fixes our issue, which is spam. task-2930455 
The stock forecast report now correctly shows and processes reserve and unreserve actions when deliveries use multiple steps. This helps warehouse teams manage availability across the full delivery chain without missing or unavailable controls.
Original PR description
Before this commit, the reserve/unreserve buttons did not work / were hidden with multi-step delivery settings. The report now works with the entire chain of moves linked to the delivery TaskId: 2858139 -- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr