Important option for balance query.

+2 votes
97 views
asked Oct 18, 2021 in New Feature Requests by ask
Would be very helpful to have an option when making a balance query (in tuition) to be able to exclude headchecks payments, otherwise it takes all charges minus all payments including headchecks which im not considering an actual payment all the time.

1 Answer

answered Oct 18, 2021 by mering

 

By "payments until" you put a later date so it will not look on head checks 

 

commented Oct 25, 2021 by ask

 And  Val(Format((Select Sum(Amount) From MCharges Where Code = Students.FamilyNum And DueDate <= #10/25/21#  And Company In (1)))) - (Val(Format((Select Sum(Amount) From MPayments Where Code = Students.FamilyNum And Date <= #11/04/21#  And Company In (1)))) )<=50

Its not looking on the check date?

Let's Welcome our New Members

  • JSchwartz of Machne Bnos Square - Jan 19, 2022

  • nachmanb of V'yoel Moshe - Jan 18, 2022

  • DDubovick of Yeshiva Ohr Boruch Veitzener Cheder - Jan 17, 2022

  • YNKatz of Viznitz Keimishe - Jan 16, 2022

  • fturner of Yeshiva Darchei Torah - Jan 13, 2022

  • csm of JDBY-YTT - Jan 13, 2022

  • yrlbender of yeshiva Darchei Torah - Jan 13, 2022

  • Menahal of Bnei Yakov Yosef - Jan 11, 2022

  • G. Birnhack of Yeshiva Avir Yaakov - Girls - Jan 11, 2022

  • Moshemayer of Meor Hatorah - Jan 10, 2022

...