Author Topic: Weekly Order Summary  (Read 3861 times)

Awana@CBVB

  • Full Member
  • ***
  • Posts: 25
Weekly Order Summary
« on: October 02, 2013, 07:57:12 PM »
Note: This post is applicable in the Cloud database's Windows App as well as in the Legacy database.

Similar to this discussion thread (https://www.approvedworkman.com/forum/index.php?topic=1586.0), our secretaries were discussing how to quickly print off a summary each week of items that were ordered so they would know to whom they belong when the order arrives.  We were working on manipulating the ledger to see but the SQL option may be faster.  It would preclude the need for them to keep a written record of who ordered what.

Any help would be appreciated.

Jason Grahame
« Last Edit: September 12, 2023, 04:05:22 PM by Annette »

Rick Leffler

  • Guest
Re: Weekly Order Summary
« Reply #1 on: October 03, 2013, 03:21:22 PM »
If you create a Fee record for each book, uniform, or book bag, or anything else that is ordered from the Awana supply catalog and intended for a specific member, you could use the Item_Received field to track whether or not the person is still waiting on the item.  Set the default value to "No" (not received).  Then when the supply order comes in you could use the main Ledger > Fees grid and apply a filter to Item Rcvd = "No" and then drag the Household Name column header into the area above the grid to group all the records by Household. 

Once the items are handed out to the intended recipient, select the Fee and use the toolbar button to mark it as "Yes" (Received).   Tip: Remember that you can select multiple rows.

Items used for Awards also have the similar "Received" field and thus you could do the same thing.