tree 8591e80eff2aa21e29d1ee0c14fbf32ff546f3ab
parent 58a5f816db54300f16ba74689110b87a7a5dd7b0
author ruthra kumar <ruthra@erpnext.com> 1682164475 +0530
committer GitHub <noreply@github.com> 1682164475 +0530
gpgsig -----BEGIN PGP SIGNATURE-----
 
 wsBcBAABCAAQBQJkQ8r7CRBK7hj4Ov3rIwAAnb4IAFjAYSAu0eD65+zv+vrZNv9d
 pb8LpLEVEXNorLBDP8V+uxajmmEiLJotxCPDyoq0OtXBDL88EwEn6Nm1OnCJe652
 a/BS1E/wS5263X/LwNmkuhiI6elMOQo4SM1eMxmeFBK7CzgXQEIrtJ4t+gN8x1QG
 pUJiTgfPOQOeLX/GrSCssEIeXe1lAzlsuNgCfHNrGUWRvxnJnWZbwNPZccyTgSzT
 BBdjGHFpySfFEzz4yM4wc0KqKv7WwiVTZuzjh90bJ+Av0Ht8dyGeUNyWKRzaaoMl
 7omrb1wvq/1avVdabMve0A0ff0fCQ+n0QBGq2ku6rFxRWyYe2ZXGlhPWs8AszQU=
 =puPT
 -----END PGP SIGNATURE-----
 

feat: Reconcile Payments in background (#34596)

* feat: auto reconcile in background

* chore: Option to enable auto reconciliation in settings

* refactor: validate if feature is enabled in settings

* refactor: check for running job while using reconciliation tool

* chore: using doc to get filter values

* chore: use frappe.db.get_value in validations

* chore: cleanup commented out code

* chore: replace get_list with get_all

* chore: use block scope variable

* chore: type information for functions

* refactor: flag to ignore job validation check

* refactor: update parent doc status if all reconciled

* chore: create test_records file

* test: create a bunch of vouchers for testing auto reconcile

* chore: renamed auto_reconcile to process_payment_reconciliation

* chore: another child doctype to hold payments

* chore: remove duplicate field

* chore: add fetched payments to log

* chore: Popup comment message update

* chore: replace get_all with get_value

* chore: replace label in settings page

* chore: remove unit test and records

* refactor: status in reconciliation log

* refactor: set status in log as well

* chore: fix field name

* chore: change triggered job name

* chore: use status field in list view of log

* chore: status while there are no allocations

* refactor: split trigger function into two

* chore: adding cancelled status

* refactor: function trigger queued docs

* chore: cron job scheduled

* chore: fixing accouts settings json file

* chore: typos and variable scope

* chore: use 'pluck' in db call

* chore: remove redundant whitelist decorator

* chore: use single DB call to fetch values

* chore: replace get_all with get_value

* refactor: use raw db calls to fetch reconciliation log records

Using get_doc on `Process Payment Reconciliation Log` is costly when
handling large volumes of invoices.

Use raw frappe.db.get_all to selectively pull status and reconciled count

* chore: update status on successful batch operation

* chore: make payment table readonly

* chore: ability to pause the background job

* chore: remove isolate_each_allocation

* chore: more description in progress bar

* refactor: partially working state

* refactor: update reconcile flag and setting hard limits for fetching

* chore: make allocation editable -- NEED TO REVERT

* chore: pause button

* refactor: skip setter function in Payment Entry for better performan

* refactor: split reconcile function and skip a setter function

1. Split reconcile function into 2
2. While reconciling against payment entry, skip a
set_missing_ref_details setter method

* chore: increase payment limit

* refactor: replace frappe.db.get_all with frappe.db.get_value

* chore: remove unwanted doctypes

* refactor: make allocation table readonly

* perf: update ref_details only for newly linked invoices

* chore: rename skip flag

* refactor(UI): receivable_payable field should auto populate

* refactor: no control statements in finally block

* chore: cleanup section and rename checkbox

* chore: update new fieldname in code

* chore: update error msg

* refactor: start and pause integrated into status

pause checkbox has been removed

* refactor: added cancelled status to the log doctype

1. Moved the status section to the bottom in parent doc
2. Using alerts to indicate Job trigger status