Foodco6 Update notes (6.5.6)
(Last update 6.5.5 was 3/31/2003)
Inventory Item Maintenance
Added manual price changes
when changing case cost. This feature will enable you to print the
Increase/Decrease warning report for items that are manually changed from the
inventory screen, quick item change and when the item case cost is updated
through the import manager. This feature will only work when you have activated
the Track Manual Price Changes option in user preferences.
Added the Last Activity date
to the activity tab. The last activity is updated anytime you post a
transaction to the item i.e. physical inventory, sales, waste, purchase, etc.
Added alternate name field
to activity tab. You can just type an alternate name for the item in this
field.
Added alternate name lookup
button 
to activity tab. This will bring up a new
form where you can add different alternate name types i.e. contract name,
regional naming, foreign language, etc. Once the name type has been defined,
you can then enter the alternate name for any item.
Alternate Pack Size capabilities have been added to
Foodco. This will enable you to have alternate names for your items. This can
be used for regional names, foreign languages, client specifications, or for
customer presentation. There is only one report that is available that uses
this feature at this time. The report that uses this feature is the NEW
Calendar Menu Report. The alternate
name functionality has been setup in a multi level facet. There are 4 levels
that can be used in your naming convention
.
1
Master
Description
2
Alternate
name
3
Meal
Step Alternate name
4
Alternate
name type
Custom Worksheet entry
Posting physical inventory or sales worksheets now forces item active status flag to checked. This feature stems off of a feature made in the last Foodco update that marks items inactive automatically when closing a period if there has been no activity on the item in a specified number of days.
Fixed
posting zeros when option to post wasn't selected and item was edited
Added saving previous inventory and date by record. This feature will enable you to print your previous inventory value by location. Below are some rules to this new feature.
1.
The
previous inventory by line record/location only applies to the worksheet where
the inventory counts are being entered and posted.
2.
If
the item is moved up or down on the worksheet, the previous count will be
retained for that record.
3.
A
new criteria option has been added to the inventory entry worksheet to allow
printing of the separated inventory value.
4.
If
an item is deleted from the worksheet and then added again the previous counts
will not be retained.
5.
If
the master pack size of the item is changed during the course of the week, the
previous inventory value will be adjusted to correspond to the equivalent value
of the new pack size.
Meal Calendar
You can now assign the meal
type to the meals from the calendar screen for the meal planner. This is a
lookup in the grid next to each meal.
Meals
Added special directive to
not print item on menu calendar report
Added a new field for an
alternate name to ingredient grid on the Projected tab within the meal. This
field will override all other alternate names, except alternate name types,
when printing the Calendar Menu Report unless you select to always use master
description.
Receiving Vouchers
Post Voucher now sets item active status to
be checked for all items that have been purchased.
Changed update costs to
filter for distribution dates when using FIFO for transfers.
Changed update costs button
to get correct FIFO costs for recipes when using FIFO for transfers from within
user preferences.
Added a column for the
vendor’s product number next to the reconciled check box. This will enable an
easier way of identifying and referencing item from an invoice during the
reconciling process.
Receiving Quick Item Add
The quantity on hand field now changes to red
if the amount being transferred is greater than the quantity on hand.
Quick Item Change
Added manual price changes when changing case
cost. This feature will only work when you have activated the Track Manual
Price Changes option in user preferences.
Foodco6 License Information
Fixed reading machine code
from registry when user doesn't have full access
Changed reading/writing
machine code to use hkey_current_user if hkey_local_machine fails
Enabled expiration date on
license code. Note: All programs will default to expire in the year 9999 so I
don’t think this will expire in our lifetime.
User Login
Fixed to allow access into
program if user name is valid but there is a registry read/write error
Reports
We have changed the look of the report criteria screens throughout the program to allow an easier understanding of the options available for any selected report. This new format also allows you to change the description of the report criteria name that is printed in the heading of the report. Another advantage to this change is that you can see all reports that have been defined.
Added button to print last report ran. This is a real
time saver when you are running the same report multiple times. After running a
report, using the dropdown menu, the report will be remembered when you click
on the last report button 
.
Pressing this button will take you to the criteria screen for the last report
that you ran.
Added right click menu to last report button, which will list up to the last 5 reports that have been run during the current session of Foodco. When you right click on the last report button you will be presented with the reports and when you left click on one of them, you will be taken to the criteria for the selected report.
Verify Recipe and Meals Report
Added a new routine to identify any ingredients within a recipe and meal to see if there are any Profit Center Mismatches between profit centers. These will be identified on a per profit center basis. This report is relatively new and if you haven’t run it yet; it is strongly recommended that you do! This report will identify any potential problems that exist in your data. “Invalid Unit Codes”, and “Profit Center Mismatch” items are the most serious and should be corrected.
Cooks Recipe report
Added
option to print item cost when printing by calculated usage or recipe unit
Custom Worksheet Entry report
We have added the criteria option to “Print Separated Previous Inventory”. When this option is selected, the inventory value from the last date that you posted from that worksheet will be printed.
Changed
combined previous inventory to print 'N/A' for more than one time
Changed
previous inventory header to reflect whether the value is being printed by
Cases or Parts
Increase/Decrease Warning Report
Fixed printing item when
first change is 0
Cost of Goods report
Corrected
percentages when revenue is 0
Meal Detail report
Changed the unit description
to use description from within the meal ingredient instead of the master unit
description
Changed usage amount to
portion amount and added column for unit description
Meal Summary report
Changed meal attendance
totals and daily totals when printing by meal type
Managers Pre-Cost
Changed “Projected Servings”
to “Projected Attendance”
Ordering Requirement report
Fixed framework titles so
they don't run below bottom margin
Quick Item Print
Fixed adding recipes into
total cost when not printing sub recipes
Calendar Menu Report (NEW)
This is a new report under the meal planner reports. This report will enable you to print weekly menus or monthly menus. There are several criteria options associated with this report to allow maximum flexibility to design it the way you want. This report is designed to scale in size according to the size of paper you select.
Definition of Criteria
Print Landscape = Will print the width on the long edge of the paper.
Print Weekly Menu = Prints calendar for up to 7 days and allows selection of different meal types i.e. Breakfast, Lunch, Dinner, etc.
Allow Multiple Meals Per Type on Weekly Menu = Allows you to select what meal types you want on the calendar. You can select the order of the meals by selecting them in the sequence you want them printed in. You can select multiple meals by holding down the Ctrl key and clicking on each type desired.
Always use item’s master description = Forces the use of the master description when printing.
Select Alternate Name Type = Will prompt you to select one of the Alternate name types defined within inventory. If no alternate name has been entered for an item the program will use the alternate name from the meal ingredient, then the item, and last the master description.
Print Portion Size = Prints the portion amount that has been defined within the meal
Hide Calendar Dates = Will remove date range from header of report and remove numbers from day boxes.
After selecting the criteria for the format, you will be presented with second criteria screen that allow you to define other characteristics for the calendar.
Start date = The starting date you want to start the calendar on.
End Date = The ending date that the calendar will end on.
Days Per Week = Allows you to select how many days per week you want to print on the calendar.
Start Day of Week = Enables you to select what the first day of the week will be. Note: The date range and start day of week can conflict and may cause calendars to print incorrectly.
Calendar Footer = The calendar footer is a lookup list to select a pre-defined footer for the calendar. When selected, the program will allow you to specify the height of the margin at the bottom of the report. You can click on the new button which will bring up a screen to define the new footer, when you answer Ok Foodco will open the RTF editor where you can specify your own information for the footer. If you have a footer and need to edit it, select the one you want and click edit to modify the footer.
Bottom Margin = This is where you
will define the height of the margin .5” is the default and can be up to 5”.
Note the margin height will reduce the number of items that will be able to
print on a page.
Meal Cost Summary Report (NEW)
We have designed a new Meal Cost Summary report that will allow you to evaluate an entire menu cycle on one page. This report has quite a bit of flexibility and an explanation of the criteria has been provided.
Order Entry Returns report
Fixed selling total and
average
Added average order
Changed quantities to print
decimals only if needed
Changed portion column
header to Quantity Returned
Added average return and
removed quote total
Added option for page break
between accounts
Added last sent order
Commissary Order Form
Changed portion amount to
not print unneeded decimals
Added max average days to
foodco6.ini file for limiting how far in the past we go
Added suggested order
Commissary Order Recap
Added date range to page
header
Recipe Support Maintenance
Added alternate name type
Added calendar footer type
User Preferences
Added a new field to the inventory tab in
user preferences to Track Manual price changes for inventory. This feature
should be turned on only if you are manually changing the case price from the
inventory maintenance screen, Quick item change screen, and/or updating the
case cost when importing prices from a vendor.
Calculate Theoretical procedures
Changed
Get FIFO For Usage to not include cost of transfers and orders and use last
unit cost for remainder
Added AltMenuName to
QmakeTmpSourc SQL to fixed invalid parameter error
Import Manager
Fixed access violation when
closing Run Import
Removed question to use
import wizard when add a new import definition.
When you select the + to add
a new import definition, the first question that you will be asked is if you
want to copy from the import routine you have highlighted. This feature will
save you time if you need to setup multiple profit centers with the same type
of interface.
Import Wizard
Changed selection edit box
to component that allows scroll bars and showing selection
Added Tab delimited file
type
Added PO number to invoice
import
Changed "Actual
Servings" and "Projected Servings" to Attendance on the Meal
Import
Removed portion factor from
meal import
Processing Import
Changed invoice import to
edit existing voucher if found by PO number
Fixed Meal import to
create/update meals
Added missing item errors to
notes for invoice and meal import
Changed float, integer, and
currency conversion to remove "$" and "," before conversion
When importing invoices Foodco will first verify if that invoice number matches an existing voucher. If the invoice number is found, we check to see if it has been posted, if it is posted we skip that invoice on the import and write it to the warning of last run. If it is not posted Foodco will update the voucher with the amounts specified in the file. If no matching invoice number is found, Foodco will check for an existing PO number, if the PO number is found Foodco will update that voucher, and if not found a new voucher will be added.
Note: Foodco does not support duplicate PO numbers during
the import process. If a duplicate PO number occurs, the program will verify
that the invoice number is blank before updating the voucher, if there is an
invoice number and it does not match, we just add a new voucher for the current
invoice.
Foodco6 Main
Removed
security popup menus when security is closed after making Custom changes.
Remove Orphans
Added
procedure to cleanup altname
Added
procedure to cleanup miscuse profit centers
Added
procedure to cleanup all datasync files
Added
a new procedure to delete any files from your data folder that were once
distributed and are no longer needed. This will help speed up the process when
running the data repair utility
Data Sync Wizard
There have been a number of changes
to the Datasync process. We are always looking for ways to simplify processes
and ensure the integrity of the data. Before using the new datasync, all
computers must be running the same version of Foodco.
The
process for sending a datasync is much the same as previous programs; however,
you are now forced to zip the datasync files during the send process. You can
still name the file to whatever you want, except the file extension should
remain .F6
The
real changes are from the computer receiving the datasync. The user will run
Foodco and select the profit center they want to receive the update to. Then
select Setup>Merge/Datasync>Datasync Receive Only. At that point, a
browser will be displayed to locate the appropriate .F6 datasync file. Once the
file is selected they will receive a verification screen to ensure that the
correct profit center has been selected. The Foodco program will do the rest.
Anything specified by the sender will be updated in their profit center.
Changed datasync send to force creating zip
file
Changed default zip file extension to .F6
Changed zipping up to not include .zip or .F6
files
Changed datasync receive only to use .F6 zip
file and automatically extract
Added version checking to datasync receive
only (stamped into .F6 file)
Changed receive to create new secondary unit
code from master code before changing to new master code
Added list of items with changed unit codes
to end of log
Changed datasync log to display errors as red
Changed selecting target folder to check for
Foodco6 database files
Fixed infinite loop when selecting target
folder
Changed replace framework code with Change
Framework code and renamed option to Update/Add
Added option to delete framework items from
target that are not in source
Datasync now aborts if inventory item is
found with blank number
Datasync now aborts if recipe or sub-recipe
is found with blank number
Added confirmation to delete profile button
Datasync send now aborts if tables couldn't
be emptied
Datasync send now skips zipping up .lck files
Fixed recipe and meal unit code datasync to
get correct child unit code links
Added profile number to
select profile grid and run history