[Release Notes] ERPNext and Frappe Version 13.23.0

ERPNext version 13.23.0 Release Notes

Features & Enhancements

  • feat: Bank Reconciliation for loan documents (backport #29865) (#29865)
  • feat: Include child item group products in Item Group Page & cleanup (backport #30091) (#30091)
  • refactor: Employee Leave Balance (backport #29439) (#29439)

Fixes

  • perf(asset): fetch only distinct depreciable assets (backport #30114) (#30114)
  • fix(pos): do not reset mode of payments in case of consolidation (backport #30198) (#30198)
  • fix(pos): loyalty points in case of returned pos invoice (backport #30242) (#30242)
  • fix(psoa): add company filter to account (backport #30145) (#30145)
  • fix(psoa): no such element: dict object[‘account’] (backport #30153) (#30153)
  • fix(translation) - correction for assets translation (backport #30000) (#30000)
  • fix(ux): Improve label for better understanding (backport #30096) (#30096)
  • fix: ‘save_quotations_as_draft’ checkbox not honoured (backport #30160) (#30160)
  • fix: Add missing currency option in Supplier Quotation’s rounded_total field (backport #30229) (#30229)
  • fix: Ambigous column in picklist query (backport #30102) (#30102)
  • fix: Cleanup and fixes in Dimension-wise Accounts Balance Report (backport #30284) (#30284)
  • fix: Do not consider cancelled entries (backport #30207) (#30207)
  • fix: Do not update ignore pricing rule check implicitly (backport #30269) (#30269)
  • fix: Error in bank reconciliation statement (backport #30261) (#30261)
  • fix: Get MRs that are yet to be received but fully ordered in Report Requested Items to Order and Receive (backport #29987) (#29987)
  • fix: Item discounts for quotation and other docs (backport #29940) (#29940)
  • fix: Item-wise sales history report (backport #30080) (#30080)
  • fix: Job Card sub operations status and list view (#30243)
  • fix: KSA E-Invoice QR Code showing wrong VAT amount (backport #30230) (#30230)
  • fix: Leave Policy Assignment creation patch (#30215)
  • fix: Multi-currency bank reconciliation fixes (backport #29979) (#29979)
  • fix: Multiple fixes in Gross Profit report (backport #29740) (#29740)
  • fix: Nil and Exempted values in GSTR-3B Report (backport #30039) (#30039)
  • fix: Non Profit fixes (#30280)
  • fix: Pos return payment mode issue (#26872)
  • fix: Remove tax invoice no field (backport #30136) (#30136)
  • fix: Sales and Purchase return optimization (backport #30152) (#30152)
  • fix: Search query of payroll entry reference in Journal Entry (#30225)
  • fix: Shipping rule application fixes (backport #30181) (#30181)
  • fix: Sub-Category Routing in Item Group Page Listing pills (backport #30258) (#30258)
  • fix: Validate income/expense account in sales and purchase invoice (backport #30266) (#30266)
  • fix: cannot create multicurrency sales order with product bundles (backport #30166) (#30166)
  • fix: cannot create purchase order from sales order (backport #30217) (#30217)
  • fix: customer credit limit validation on update (backport #30110) (#30110)
  • fix: disable “get items” buttons from submitted production plan (backport #30223) (#30223)
  • fix: do not reset asset_category (backport #29696) (#29696)
  • fix: dont fetch entire barcode table in get_item_details (#30131)
  • fix: dont reset UOM in MR on every get_item_detail call (backport #30164) (#30164)
  • fix: fetch new fields from routing to bom (#30169)
  • fix: filter default_discount_account field in item_group_defaults table is_group = 0 (#30095)
  • fix: ignore non-unique swift numbers while migrating (backport #30132) (#30132)
  • fix: incorrect debit credit amount in presentation currency (backport #30244) (#30244)
  • fix: leave allocation records query (#30118)
  • fix: max_qty validation condition in WO (backport #30216) (#30216)
  • fix: pos return payment mode issue (#26872) (#30220)
  • fix: program enrollment button labels (backport #30148) (#30148)
  • fix: respect db multi_tenancy while fetching precision (backport #30301) (#30301)
  • fix: salary slip amount rounding errors (#30248)
  • fix: packed items return when items are removed (#30263)
  • fix: wrong payment days in salary slip for employees joining/leaving during mid payroll dates (backport #29082) (#29082)
  • refactor: removed unrequired code and test for standalone delivery note serial return (#30276)
  • revert: BU Schl√Âșssel (a21f76f) (backport #29654) (#29654)
  • chore: add German translations (backport #30265) (#30265)

Frappe version 13.23.0 Release Notes

Features & Enhancements

  • feat: MySQL TIMESTAMP functionality for QB (#16295)

Fixes

  • fix: Consider title field only if it’s value exists (#16236)
  • fix: set_column_disp contradicts arguments (backport #16255) (#16255)
  • fix(BackupGenerator): set missing attribute for class object (#16273)
  • fix(rename_doc): Allow updating only document title or name (backport #16225) (#16225)
  • fix(ux): remove attachment limits (#16222)
  • fix: Dashboard report link (backport #14052) (#14052)
  • fix: Double signature in composed Email (backport #16178) (#16178)
  • fix: Number Card to support child table doctype for filters (backport #16243) (#16243)
  • fix: Print for tree view is broken (backport #16137) (#16137)
  • fix: Routing with hash in URL [v13] (#16298)
  • fix: Typo in is_downgrade’s user warning (backport #16313) (#16313)
  • fix: typo in database file for v12 - latest (#16250)
  • chore: add German translations (backport #16292) (#16292)
7 Likes

have anyone experienced here that the rate field of any item on all transactions is being rounded off based on the discount percentage?

Example:
I have a pricelist of 3,500
my rate on the invoice is 2,500
so the discount amount will be 1,000

However, the system prioritizes the discount percentage so it changes the discount amount to 999.99 with a 28.57 discount percentage.

Then after saving the document, the system will change the rate to 2500.015 instead of the encoded 2,500.

We are using a Frappe cloud and before the latest version update, we never experience this error. So right now all rate are having the wrong amount.

The solution or work around that we did is to make the precision of the discount percentage to 9.

This is to get a discount percentage of 28.571428571
and a discount rate of exact to 1,000.

The solution for now is working however, we need to change the percentage to all item child tables for the transactions.

refer to issue Item rate changes on save · Issue #30394 · frappe/erpnext · GitHub

1 Like

Thank you for the github reference :slight_smile: I hope this can be fix on the next update. :grin:

Not sure when was this bug occurred but we are experiencing it right now for the newly created suppliers but for the past years and for the old suppliers we can still create invoices for AP that has different document Currency. For example, the document currency is billed as INR based on the supplier invoice, but we use the multi-currency to convert the invoice into USD since we need to record the AP in USD since in our credit card it was paid as USD.

We also do this conversion since our profit and loss statement should be in USD. Or are we doing it wrong? Is our process incorrect?

Current system version is using frappe cloud:
ERPNext: v13.34.1 (HEAD)
Frappe Framework: v13.33.1 (HEAD)
https://github.com/frappe/erpnext/issues/31452