tree 842b3c1711596202e1d2dd9fc310d94d584c51b3
parent 10e4b9d4e8b7bcc594de32dff10effeed6b970c0
author UrvashiKishnani <41088003+UrvashiKishnani@users.noreply.github.com> 1614658803 +0400
committer GitHub <noreply@github.com> 1614658803 +0400
gpgsig -----BEGIN PGP SIGNATURE-----
 
 wsBcBAABCAAQBQJgPbzzCRBK7hj4Ov3rIwAAdHIIADJqHoMIWdbM4B+rhdq/T1jb
 ioSzDuhc89JJa4WP+cAs7nEr4ARjhCy1uQBj5jcL1X12Ic4woBwrpG9Y2SPXGmaY
 D4iUV1mJ/4j52UeUDBsVNR1xDVJxeLTXlhgtpDn5igj7FLUO+HBb1Qt6ROpg1ENw
 Jyn6fGImLxE3DjsdOobodsZ4FvNfaBDNKHyUzPC36E00pDldP9jQw7H4GVhkgYDj
 czGJhixHn0SXb5/OjJQ69qKKhYkGCRNu0GN4hWbbEy7f/bxtqVsnSlySyT1yRyiL
 3pHWH3V0JG1WHNs2G82dOp5zIRKWVfh08jRuiVxwFeAV5WJ8zNWrBRXqbVwDgNM=
 =kRHj
 -----END PGP SIGNATURE-----
 

fix: GL Entries for AP/AR Summary without SQL join

SQL query modified to fetch only those GL Entries for Accounts Payable Summary and Accounts Receivable Summary reports where the corresponding payment entry is not in cancelled state.