Changeset - 4bb6177e45bc
Parent rev.
Child rev.
[Not reviewed]
0 1 0
Ben Sturmfels (bsturmfels) - 2 years ago 2022-02-09 23:23:00
ben@sturm.com.au
reconcile: Update cleared query.
1 file changed with 5 insertions and 2 deletions:
conservancy_beancount/reconcile/prototype_amex_reconciler.py
5
2
0 comments (0 inline, 0 general)
conservancy_beancount/reconcile/prototype_amex_reconciler.py
➞
Show inline comments
...
 
@@ -31,2 +31,4 @@ Q. How are reconciliation reports created currently? How do you read them?
 

			




	
	
	
		
 
Problem is potentially similar to diff-ing, but in the books, transaction order isn't super significant.


			




	
	
	
		
 

			




	
	
	
		
 
TODO/ISSUES:


			




	...
	
		
 
@@ -141,3 +143,3 @@ entries, _, options = loader.load_file(args.beancount_file)


			




	
	
	
		
 

			




	
	
	
		
 
total_query = f"""SELECT sum(COST(position)) AS aa WHERE account = "{args.account}"


			




	
	
	
		
 
cleared_query = f"""SELECT sum(COST(position)) AS aa WHERE account = "{args.account}"


			




	
	
	
		
 
    AND date <= {end_date.isoformat()} AND META('bank-statement') != NULL"""


			




	...
	
		
 
@@ -146,5 +148,6 @@ result_types, result_rows = run_query(


			




	
	
	
		
 
    options,


			




	
	
	
		
 
    total_query,


			




	
	
	
		
 
    cleared_query,


			




	
	
	
		
 
    numberify=True,


			




	
	
	
		
 
)


			




	
	
	
		
 

			




	
	
	
		
 
cleared_total = result_rows[0][0]


			




        

    



    


    



    



      

      





    
    0 comments (0 inline, 0 general)
    





    


  

  







    


    

  


    








    
        Server instance: kapok.sfconservancy.org-2166
    
    
        This site is powered by
            Kallithea 0.6.3,
        which is
        © 2010–2020 by various authors & licensed under GPLv3.
            – Support
        – Privacy Policy