Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel
bgColor#ffffff
titleColor#ffffff
titleBGColor#5084ee
titleOverview

The General section allows you to complete bid analysis, run weighted nutrient analysis, run Edison in test mode, set default site filters, export data, convert legacy WinFSIM database, and update the CN database (provide by USDA).

...

Anchor
Negative Inventory
Negative Inventory
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.

    Info
    titleAllow 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.

    Image Removed

  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.
    Image Removed
    Image Removed

Return to Top

...

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.

    Warning

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

    Image Removed
  3. Image Added
    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.

  4. 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.
    Image Added
    Image Added

Return to Top

...

Anchor

...

RecalculateNutrition

...

RecalculateNutrition
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, 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.

    Info
    titleReport 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.

    Image Removed

    1. Receiving Details

      Note

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

      Image Removed

    2. Receiving Tracking Log
      Image Removed

Return to Top

...

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.

    Info
    titleReport 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.

    Image Removed

    1. Issuing Details

      Note

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

      Image Removed

    2. Issuing Tracking Log
      Image Removed

Return to Top

...

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.

    Info
    titleReport 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  Recalculate Recipe Nutrition.
  4. Read the message about recalculating recipe nutrition before proceeding. If you wish to continue, click Yes.

    Warning

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

    Image Added

Return to Top

...

Anchor
ReceivingHistory
ReceivingHistory
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.

    Info
    titleReport 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.

    Image Added

    1. Receiving Details

      Note

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

      Image Added

    2. Receiving Tracking Log
      Image Added

Return to Top

...

Anchor
IssuingHistory
IssuingHistory
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.

    Info
    titleReport 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.

    Image RemovedImage Added

    1. OrderingIssuing Details

      Note

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

      Image RemovedImage AddedOrdering

    2. Issuing Tracking Log
      Image RemovedImage Added

Return to Top

...

Anchor

...

OrderingHistory

...

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.

...

OrderingHistory
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 Test Mode.Select the Test Database you wish to use when performing functions select Ordering History.
  2. Establish Search criteria. Then, click ConnectRefresh.Image Removed
  3. Enter your username and password. Then, click Ok
    Image Removed
  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.

    Info

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

    Image Removed

Return to Top

...

  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.

    Image Removed
  3. Enter your username and password. Then, click Ok
    Image Removed
  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.

    Info

    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
    Image Removed

Return to Top

...

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.

...

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.
    Image Removed
  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

...

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.

...

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

...

  • 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

Image Removed

...

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

Warning

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

Image Removed

...

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

    Note
    titleNavigate 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.

    Image Removed

  2. Item Maintenance - Navigates to the associated item in item maintenance for review/editing purposes.
    Image Removed

...

Return to Top

...

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.
    Image Removed
  3. You will see a series of processes running while the database is updated.
    Image Removed

Return to Top

...

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.
    Image Removed

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

    Info
    titleReport 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.

    Image Added

    1. Ordering Details

      Note

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

      Image Added

    2. Ordering Tracking Log
      Image Added

Return to Top

...

Anchor
Test Mode
Test Mode
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.

Info
 In order for Test Mode to work, a test database must first be created in the Advanced section in the Administration guide.
  1. From the Miscellaneous option, select Test Mode.
  2. Select the Test Database you wish to use when performing functions. Then, click Connect.
    Image Added
  3. Enter your username and password. Then, click Ok
    Image Added
  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.

    Info

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

    Image Added

Return to Top

...

Anchor
PriorYear
PriorYear
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.

    Image Added
  3. Enter your username and password. Then, click Ok
    Image Added
  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.

    Info

    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
    Image Added

Return to Top

...

Anchor
Advanced
Advanced
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.

...

Anchor
Export
Export
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.
    Image Added
  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

...

Anchor
ReviewTags
ReviewTags
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

    Image Added

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

      Warning

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

      Image Added

    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.

        Note
        titleNavigate 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.

        Image Added

      2. Item Maintenance - Navigates to the associated item in item maintenance for review/editing purposes.
        Image Added
    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.

        Image Added
        Inventory at siteSelect 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.

        Image Added
      2. Inventory On-Hand - Establish report criteria. Then, click Ok.
        Image Added
        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.

        Image Added
      1. Inventory Tag Labels - Establish report criteria. Then, click Ok.
        Image Added
        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.

        Image Added

Return to Top

...

Anchor
Update CN
Update CN
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.
    Image Added
  3. You will see a series of processes running while the database is updated.
    Image Added

Return to Top

...

Anchor
Shrink DB
Shrink DB
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.
    Image Added
    Database(s) to Shrink - Select while database(s) to include during the shrink process.
            Include Production DatabasesShrinks 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.

...