In a query, how can I filter out payments that weren't applied on a certain day? And How can I filter out campaigns which were entered under the wrong company?

0 votes
144 views
asked Nov 11, 2015 in Reports by Sori

2 Answers

answered Nov 11, 2015 by Sori
I figured out the campaigns under the wrong company.  I chose all the companies, except for the correct one, and chose the campaign and ran a charges detail report.
answered Nov 11, 2015 by Admin
What do you mean were not applied to a certain day? Do you mean all payments between Date1 and Date2 that are applied to a charge before date3?

 

If yes you use the Linked to Payment query.
commented Nov 11, 2015 by Sori
I mean that donations were entered and they weren't applied so they don't show up on reports.  It happened on a certain day when we had a new girl working.
commented Nov 11, 2015 by Admin
Look for all payments with Remaining > 0. Or just go to the payment tab in report and sort by the credit field.
commented Nov 11, 2015 by Sori
How do I get the payments to show up in the payment tab?

Let's Welcome our New Members

  • 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

  • samual of Satmar Bloomingburg - Mar 07, 2024

  • lrottenberg of Yeshiva S. Fallsburg - Mar 07, 2024

  • roth of Mareh Yechezkal - Mar 06, 2024

  • lev of UTA BP - Mar 05, 2024

...