Query Deposit based on percentage

0 votes
126 views
asked May 18, 2018 in Support Questions by BYBZ
Hi

We would like to have a query for parents who did not submit x% of deposit required. i.e. if we require a 50% deposit for day camp, the query should be for 50% f the July charge. Being that each parent is charged based on amount of children or other discounts, using an absolute dollar figure won’t accomplish what we’re looking for.

Thanks,

1 Answer

answered May 22, 2018 by Admin
selected May 22, 2018 by Admin
 
Best answer

Added. Just enter a percent sign by the query.

 

commented May 22, 2018 by BYBZ
Thanks Much.

The example above uses the Amount Field when it should really use the balance due field.

is there anyway to include the Future Credit cards in this tab as well?
commented May 22, 2018 by Admin
No difference what you choose, Amount or Balance Due. Its calculating the balance due against the amount.

No, Future CC Cannot be part of this.

Let's Welcome our New Members

  • astauber of JLS - Mar 27, 2024

  • yaakova of Bnos Menachem - Mar 26, 2024

  • GElefant of YGZM - Mar 21, 2024

  • bmiskin of Yeshiva Gedolah Zichron Moshe - Mar 20, 2024

  • cungar of Kollel Chatzos - Mar 18, 2024

  • sstein of Masores - Mar 18, 2024

  • RochelPultman of Prospect Park Yeshiva - Mar 11, 2024

  • rlefkowits of talmud torah ohel yochanan - Mar 11, 2024

  • Barber739 of Bnos Menachem - Mar 10, 2024

  • Chani Schwarz of Yeshiva K'tana of Waterbury - Mar 07, 2024

...