navariltd / navari_csf_ke

EXPNext Country Specific Customizations for Kenya
GNU General Public License v3.0
16 stars 25 forks source link

Purchase Tax Report Showing Cancelled Documents #80

Closed eleben closed 4 weeks ago

eleben commented 1 month ago

The Kenya Purchase Tax Report is now showing Cancelled Documents in the grid/calculations. Example below:

image
eleben commented 1 month ago

Looks like the Sales Tax Report was fixed with this change...

https://github.com/navariltd/navari_csf_ke/commit/8e8ef411c1e96421f5383dec855684d21ef1ca7b

I'm not seeing the same for Purchase Tax Report...

https://github.com/navariltd/navari_csf_ke/blob/8e8ef411c1e96421f5383dec855684d21ef1ca7b/csf_ke/csf_ke/report/kenya_purchase_tax_report/kenya_purchase_tax_report.py possibly around Line 104 needs

.where(purchase_invoice_.status != 'Cancelled')