Friday, May 24, 2024
2 changes · master
Resolved issues and error corrections
Spreadsheet autocomplete now includes the needed date granularity when suggesting pivot fields, preventing formula errors for date-grouped data. The spreadsheet edition was also aligned with the latest underlying spreadsheet library changes, improving compatibility and reliability.
Original PR description
### [FIX] spreadsheet_edition: auto-complete with date granularity
Steps to reproduce:
- Go to CRM lead pivot view
- group by any date field by day
- insert in spreadsheet
- start typing '=odoo.pivot(1, <measure>, '
=> Currently, when the auto-complete proposes a date field (e.g. "create_date"),
the field is proposed without the granularity ("create_date", not
"create_date:month").
The formula result is an error if the granularity is missing.
Task: 3823433
X-original-commit: https://github.com/odoo/enterprise/commit/a52b11884adaefa45e2f854bf775a43afb462d2b
### [FIX] spreadsheet_edition: Update o_spreasheet to latest version
Update spreadsheet_edition code following library update.
Counterpart of https://github.com/odoo/odoo/pull/166687The GSTR-1 report now includes POS order reversal entries when a customer later requests an invoice for a POS sale. This prevents sales and HSN values from being counted twice, improving the accuracy of Indian GST reporting.
Original PR description
Fixes an issue where the GSTR-1 Report was double counting sales and HSN due to missing POS order reversal entries. Scenario: - A sale is made via POS without an invoice. - Later, an invoice is requested and generated, creating two entries: 1. Invoice sales entry. 2. Reversal of the POS order. This update ensures that these reversal entries are included in the GSTR-1 report, preventing double counting. Task Id: 3927208