Miscellaneous

From the Utilities tab, locate and click on the Miscellaneous button.

Audit/Review Processed Applications

Create the Review Processed Applications report.

1. From the Utilities tab, locate Miscellaneous Setup. Then, select Audit/Review Processed Applications.
2. Establish the Audit Review parameters in the Application Audit Review window. Then, click Ok.

   1. Select By Category, then use the magnifying glass icon to select the CRE category.

      If you choose to filter by Specific School, separate export folders will need to be created for each school.

   2. After you have selected the category, click the next magnifying glass icon to select the Category Description.

   3. You may choose to add a filter to the audit report.

      1. Scanned Batch - Enter a specific batch number.

      2. Online applications Received On - Enter a date to select only online applications on a particular date.

      3. All applications - Creates a report for all applications in the category and category description.

   4. Include Only Current Applications - This box is checked off by default. You may choose to uncheck the box.

3. A list of applications, household details and eligibility statuses will appear. Click on the plus + icon next to each Batch Code to expand the batch and view applications.

   Franklin gives you the ability to group the applications by headers. To group by Batch Code, left-mouse click on the Batch Code column. While holding down the left-mouse button, drag and drop the header into the area stating "Drag a column header here to group by that column." Release the left mouse button once you have dragged the header to the position. You may drag other headers behind the first group to create subgroups.
   

    

   1. If you see Online Application (Click to View), the application was received online. You can view the submitted information by clicking on the link and logging in to the Apply for Lunch website.
      
      

   2. If you see an image, a hardcopy of the application was received and scanned into the system.

4. You may select a batch Once a batch has been highlighted, the following options are available:

   Review Application and Application Detail Report will only pull up one application ID at a time.

    

   
5. To create an entire report that simulates the Scanning Report, you need to export the file. Click Export All to HTML.
   
6. In the Export Audit-Review Data window, select which way data should be sorted. Then click Ok.
    

7. Establish an export path.
   

   You must create a new, empty folder in order to successfully export the Audit/Review file.

   1. A window will appear for you to save the file. Choose the location you wish to save the file by clicking on the list to the left.

   2. Then, right-click the mouse and locate New. A subwindow will appear.

   3. Click on New Folder.

      
   4. Create a folder name and hit the return button when you are done. Then, click Open.
      

   5. Click Save.
      

      Do not change the file name. It must remain as index.html in order to work properly.

      
      You should see export data processes running. It may take a few minutes for all of the data to fully export.
       Once the export process has completed, an internet browser window will appear.

Test Mode

If you wish to attempt  to perform an operation and are unsure how the results will affect your data, you can choose Test Mode. This will allow you to perform functions without affecting your current database.

1. From the Utilities tab, locate Miscellaneous Setup. Then, select Test Mode.
2. Select the Test Database you wish to use when performing functions. Then, click Connect.
   
3. Enter your username and password and click Ok.
   
4. Perform the functions in Test Mode to review the results. Once you are done, select Test Mode (Utilities → Miscellaneous → Test Mode) again to be returned to the login screen and the live database.
    

   The Test Database and Prior-Year Database appear with a different background color and text to indicate you are not in the original database.

    

   
   

Prior-Year Database

The Prior-Year Database option allows you to login and review information from a prior-year.

1. From the Utilities tab, locate Miscellaneous Setup. Then, select Prior-Year Database.
2. Select the Prior-Year Database you wish to review. Then, click Connect.
   
3. Enter your username and password and click Ok.
   
4. Perform the functions to review information in the Prior-Year Database. Once you are done, select Prior-Year Database (Utilities → Miscellaneous → Prior-Year Database) again to be returned to the login screen and the live database.
   

   The Test Database and Prior-Year Database appear with a different background color and text to indicate you are not in the original database.