General

Miscellaneous

The Miscellaneous option allows you to review transfers, check for system alerts, reconcile negative inventory, recalculate recipe nutrition, review receiving, issuing, and ordering history, run Edison in test mode, and access prior-year databases.

From the Utilities tab, click on Miscellaneous. Then, select the appropriate action.

Review Transfers

When reviewing transfers, you have the added ability to edit issuing records, edit receiving records, and print transfer tickets, transfer discrepancies reports, issuing details, and receiving details.

1. From the Miscellaneous option, Review Transfers.
2. Enter information in the Search area and select a transfer record. Then, choose the appropriate action.
   

1. 1.  Edit Issuing Record

      You may choose to add and delete items, enter comments, or delete the entire issuing records. After you have made changes, click Save Changes.
      

   2.  Edit Receiving Record

      You may choose to verify received items, edit quantities received, attach images, add and remove items (from a list, by inventory tag, or ad-hoc), edit items, enter comments, or delete the entire receiving record. After you have made changes, click Save Changes.
      The Receive Inventory screen displays:

      Quantity Unit Description Partial Unit Catalog Number Item Description Brand

      Inventory Tag Price Contract Donation Source Lot Number Expiration Date Purchased Price/Case

      Donated Value/Case Delivery Fee/Case Storage Fee/Case Other Cost/Case Purchased Total "Running Total" Purchased Total

      Donated Total "Running Total" Donated Total Sales Tax "Running Total" Sales Tax Total Delivery Fee "Running Total" Total Delivery Fee

      Total 'Other' Cost "Running Total" Total 'Other' Cost Total Storage Fee "Running Total" Total Storage Fee

      

   3.  Attach Receiving

      Receiving records can only be attached to orders that have not yet been received.

      

   4.  Detach Receiving

      Receiving records can only be detached from transfers that have not yet been received.

      

   5.  Print Reports

      
      Transfer Ticket
      Select a report layout by using the drop-down menu. Then, click Ok.
      
      

      Transfer Order/Issue Discrepancies
      

      Transfer Issue/Receive Discrepancies
      
      

      Issuing Detail
      
      

      Issuing Tracking Log
      
      

      Receiving Detail
      Select how to Include Images in the report. Then, click Ok.
      

      Images included are Attached Receiving records and Invoice Attachments, not item images.

      
      
      

      Receiving Tracking Log
      

Return to Top

Check Alerts

1. From the Miscellaneous option, select Check Alerts.
2. Any system alerts will be displayed. Click on each alert and read the description in the area below.
   

Return to Top

Negative Inventory Reconciliation

1. From the Miscellaneous option, select Negative Inventory Reconciliation.

2. Establish Negative Inventory Reconciliation options if they are not yet established by the default site filter. Then, click Ok.

   Allow Reconciliation Between Different Donation Sources

   Allowing reconciliation between different donation sources allows the system to move donated inventory items to negative count purchased items. (e.g. Green Giant green beans have an inventory of -3 #10 cans, USDA commodity green beans have an inventory or 7 #10 cans. This process will move 3 #10 cans from the USDA commodity inventory to the Green Giant inventory.

   
   Reconcile Inventory at Site - Select a site filter.
           Specific Site - Use the magnifier icon to select a single site.
           By Category - Use the magnifier icon to select a category and subcategory.
           Named Site Filter - Use the drop-down menu to select a named site filter.
           All Sites - By default, all sites are selected.
   Options - Select the checkbox to Allow reconciliation between different donation sources.
   
   

3. Review negative quantities for each item. You can expand item details by clicking the + sign. Once you have verified the amounts are correct, select Commit Changes.
   
   

Return to Top

Recalculate Recipe Nutrition

Only your District's Nutritionist should perform this function as it will recalculate all nutritional information for all recipes that do not have manually-entered information. Nutritional changes may negatively affect USDA nutrient standards.

1. From the Miscellaneous option, Recalculate Recipe Nutrition.

2. Read the message about recalculating recipe nutrition before proceeding. If you wish to continue, click Yes.

   There is no undo for this process. Once performed, if recipe nutrition is incorrect, you will need to manually adjust recipe nutritional values.

   

Return to Top

Receiving History

Every time a change is made while receiving and the "Save" button has been pressed, a record is generated to track the history of a receiving record. There may be one or multiple records associated with a receiving record.

1. From the Miscellaneous option, select Receiving History.
2. Establish Search criteria. Then, click Refresh.

3. Select a record ID and click Print. Then, use the drop-down menu to select a report.

   Report Key

   Bold font - The most recent, up-to-date version of the record.
   Regular font - A past record history. ^{_{Note that ID 5703 and 5706 do not have a regular font associated; therefore, the original Receiving record is the only history for those two IDs at the present time.}}
   Red background - A record has been deleted.

   

   1. Receiving Details
      

      The Receiving Details report cannot be printed for deleted records as they no longer exist.

      

   2. Receiving Tracking Log
      

Return to Top

Issuing History

Every time a change is made while issuing and the "Save" button has been pressed, a record is generated to track the history of an issuing record. There may be one or multiple records associated with an issuing record.

1. From the Miscellaneous option, select Issuing History.
2. Establish Search criteria. Then, click Refresh.

3. Select a record ID and click Print. Then, use the drop-down menu to select a report.

   Report Key

   Bold font - The most recent, up-to-date version of the record.
   Regular font - A past record history. ^{_{Note that ID 5703 and 5706 do not have a regular font associated; therefore, the original Receiving record is the only history for those two IDs at the present time.}}
   Red background - A record has been deleted.

   

   1. Issuing Details
      

      The Issuing Details report cannot be printed for deleted records as they no longer exist.

      

   2. Issuing Tracking Log
      
      

Return to Top

Ordering History

Every time a change is made while ordering and the "Save" button has been pressed, a record is generated to track the history of an ordering record. There may be one or multiple records associated with an ordering record.

1. From the Miscellaneous option, select Ordering History.
2. Establish Search criteria. Then, click Refresh.

3. Select a record ID and click Print. Then, use the drop-down menu to select a report.

   Report Key

   Bold font - The most recent, up-to-date version of the record.
   Regular font - A past record history. ^{_{Note that ID 5703 and 5706 do not have a regular font associated; therefore, the original Receiving record is the only history for those two IDs at the present time.}}
   Red background - A record has been deleted.

   

   1. Ordering Details
      

      The Ordering Details report cannot be printed for deleted records as they no longer exist.

      

   2. Ordering Tracking Log
      
      

Return to Top

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 Miscellaneous option, select Test Mode.
2. Select the Test Database you wish to use when performing functions. Then, click Connect.
   
3. Enter your username and password. Then, 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 appears with a different background color and text to indicate you are not in the original database.

   

Return to Top

Prior-Year Databases

1. From the Miscellaneous option, select Prior-Year Databases.

2. Select the Prior-Year database in which you would like to access. Then, select Connect or Connect in a New Window.

   
3. Enter your username and password. Then, 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 Prior-Year Database appears with a different background color and text to indicate you are not in the original database.

   _{Click Image to Enlarge}
   

Return to Top

Advanced

The Advanced option allows data to be exported, MCS to convert legacy data from the WinFSIM database, CN database updates to be pulled into the system, run the End of Year process, and manually shrink database files.

From the Utilities tab, click on Advanced. Then, select the appropriate action.

Export Data

In order to export data, an export must first be established in Exports in Miscellaneous Setup section menu of the Setup Guide.

1. From the Advanced option, select Export Data.
2. Select the data you wish to export from the list. Then, click Run.
   
3. (If prompted) You may be prompted to establish dataset criteria. Once you have done so, click Ok.
   You will be informed once the export process is complete. Select View Log to review all export times and dates for the selected export.

Return to Top

Review Inventory Tags

The Review Inventory Tags options allow you to view inventory tag details (depending on review permissions), make edits to an inventory tag (depending on permission to edit an inventory tag), navigate to the original receiving record (depending on permission to edit the receiving record), navigate to item maintenance for a selected row (depending on permission to edit an item), and print various inventory reports.

1. From the Advanced option, select Review Inventory Tags.

2. Select an Inventory Tag from the list by clicking on the row. Then, select which task you would like to perform.

   Inventory Tag Details
   Tag Catalog Number Item Description Case/Unit Purchased Price per Case Donated Value per Case Donation Source	Lot # Expiration Date Origin Kind Origin Site Origin Date Original Vendor Origin Invoice #	Brand Product Code Storage Fee per Case Delivery Fee per Case Other Value per Case Tax Rate Cost of Goods per Case

   

   1. Edit - Select the inventory tag you wish to modify. Then, click Edit.
      Make necessary edits to the Inventory Tag. Then, click Ok.

      When modifying an Inventory Tag, changes will be reflected everywhere in the District where the inventory tag exists.

      

   2. Navigate - Click on Navigate and select a navigation option.

      1. Origin Receiving Record - Navigates to the original location when the inventory tag was first received into the system.

         Navigate to Origin of Receiving Record

         In some cases, you may not be able to view the origin of the inventory tag such as a locked inventory period.

         

      2. Item Maintenance - Navigates to the associated item in item maintenance for review/editing purposes.
         
   3. Print - Select which type of report to print for the selected Inventory Tag.
      1. Inventory History - Tracks the history of the Establish report criteria. Then, click Ok.
         
         
         Inventory at site - Select a Specific Site, By Category or Cluster, or Named Site Filter, or All Sites by using the magnifier icon or drop-down menu to locate the correct choice.
         Date Range (Inclusive) - Use the calendar tool(s) to select a From and to date range.
         Options - By default, Include inventory tags with no quantity remaining is selected.
         Run for each site in the site filter - By selecting this option, the report will be run separately for each school while grouping the entire District into one printable report.
         
         
      2. Inventory On-Hand - Establish report criteria. Then, click Ok.
         
         Report Inventory As-Of-Date - Use the calendar tool to select an As-Of date.
         Filter by Site - Select a Specific Site, By Category or Cluster, or Named Site Filter, or All Sites by using the magnifier icon or drop-down menu to locate the correct choice.
         Group Records By - You may choose to group records and apply page breaks between record groupings by using the drop-down menu and selecting options.
         Options - Select one or more options to include in the report.
         Run for each site in the site filter - By selecting this option, the report will be run separately for each school while grouping the entire District into one printable report.
         
         

1. 1. 1. Inventory Tag Labels - Establish report criteria. Then, click Ok.
         
         Number of Labels - Enter the number of inventory tag labels you wish to print.
         Report Layout - Use the drop-down menu to select a report layout.
         
         

Return to Top

Update CN Database

Updates your database with the latest version of the Child Nutrition Database (CND) provided by the USDA.

1. From the Advanced option, select Update CN Database.
2. After reading the message, click Ok to proceed with updating your database with the latest USDA CND version.
   
3. You will see a series of processes running while the database is updated.
   

Return to Top

Shrink Database

Databases can expand during upgrades limiting space on the server. Shrinking the database compresses files thus preventing bloated files. 

1. From the Advanced option, select Shrink Database.
2. Establish how the database should be shrunk. Then, click Ok.
   
   Database(s) to Shrink - Select while database(s) to include during the shrink process.
           Include Production Databases - Shrinks the current production database.
           Include Prior-Year Databases - Shrinks prior year databases.
           Include Test databases - Shrinks test databases.
   Files to Shrink - Select which files to shrink during the process.
           Shrink Log Files - Shrinks activity log files.
                   Shrink to Target Free Space Remaining (100 MB) - Shrinks files to the maximum size established in System Settings.
           Shrink Data Files - Shrinks all data files.
           Shrink Entire Database - Shrinks the entire database by an established percentage.
   Current Database Size - Displays database information for production, prior year, and test databases.
   
   
3. You will see a series of processes running while the database(s) is shrunk. Click Ok.
   
   Note the database size has decreased.
   

Return to Top

Upgrade Test/Prior-Year Databases

The Upgrade Test/Prior Year Databases Option is a utility which allows you to upgrade testing or prior-year databases. Contact Support for more details.

Utilities → Advanced → Upgrade Test/Prior-Year Databases

Return to Top

Agent Monitor

The Agent Monitor is a log of the behind-the-scenes processes of the Edison Agent, such as MealViewer Integration and scheduled jobs. This is a troubleshooting tool for Software Support staff. Contact Support for more details.

Utilities → Advanced → Agent Monitor

Return to Top

Convert Legacy WinFSIM Database

Converting WinFSIM to Edison should only be performed by HSS Staff. For assistance, contact Support.

Return to Top

End of Year

End of Year processes create an archive of the current year. End of Year should not be performed until the school year has ended and all processes have been completed in all systems. End of Year must be completed in a specific order and may vary from year to year; therefore, MCS Software will send out notifications when processes may first be initiated. Complete directions for End of Year/Beginning of Year steps are located in the Knowledge Center.

Utilities → Advanced → End of Year

Return to Top

Synchronize

The Synchronize option allows you to synchronize changes between Edison and additional resources.

DataCenter Sync

Performs a full synchronization between DataCenter and Edison looking at all site records and updates information.

From the Synchronize option, select DataCenter Sync.

You will see a series of processes as synchronization is completed.

Return to Top

MealViewer Status & Sync

Allows you to view the status of your MealViewer sync and to also perform a manual sync between Edison and MealViewer.

From the Synchronize option, select MealViewer Status & Sync.

MealViewer Server Connection - Indicates the successful or unsuccessful connection to the MealViewer Server. Check your MealViewer Settings here.
Automatic Data Synchronization - Indicates if the last attempted sync failed or if automatic data synchronization is disabled.
Last Completed Sync - Shows the date and time of the last completed sync.
Last Attempted Sync - Shows the date and time of the last attempted sync.
Next Expected Sync - Shows the date and time of the next expected sync.
Sync Now - Select this button to run a manual sync. You will see a series of processes as synchronization is completed.

Return to Top