Query Deposit based on percentage

0 votes
135 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

  • ras of Mechinas Ner Naftali - Apr 10, 2024

  • ckeller of MYY - Apr 03, 2024

  • Malka.eisenbach of YTT - Apr 02, 2024

  • eneuberger of JDBYYTT - Apr 01, 2024

  • cmayer of Bais Esther - Apr 01, 2024

  • 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

...