FrameReady Version History
What's New In FrameReady's Latest Version?
Version 6.1.v2
Added features:
- Payment report displays taxable and non-taxable totals and the corresponding tax totals for use in cash basis accounting.
- In Work Order, description of a mat colour has been added to mounting field (purpose- for entering a mat number in the mounting field for float mounts).
- Received, First Sold, Previously Sold and Last Sold fields have been added to the Price Codes file.
Items Fixed:
- Printing bulk letters from Contacts file.
Version 6.1.v2 Multi Site
Added features:
- In Products file, move inventory field and product activity tabs.
Version 6.1.v1
Converted to FileMaker Pro 9 format
Added features:
- Pricing by the size in Work Order (Code Tables). By entering fixed sizes in a code table, price will default to the "best fit".
- Pricing glazing by the lite size.
- In Work Order, added enter Outside Frame dimensions and have image size calculated after entering one or several mouldings.
- In Work Order, added button to calculate mirrors to "Fit to Outside Dimensions" of frame.
- Email field to Form View in Work Order.
- Second contact name in Contact file. Especially useful with couples with different last names.
- Correspondence screen in Contacts file now has two override fields, one for name, one for salutation.
- Ranking feature now excludes "Deposit" and "Gift Certificate" invoices to give a truer picture of actual dollars spent.
- In the Price Codes file, a price comparison screen now gives the ability to review the pricing for several items at once.
- In the Price Codes file, Apply Type to Group button to quickly change all records of a group or moulding records to be ordered by the selected radio button (Length, Chop, Join).
- New Pricing Options and Defaults buttons to improve functionality in the Price Codes file.
- Selection check boxes to Frame Order (Main Menu) to include items such as mat design, mounting, hardware, extra, glazing and fitting.
- Preview only option to End of Day reports from Main Menu. (Hold down Control key and click Proceed.)
Items modified:
- Renamed "My Custom Defaults" to "Pricing Options and Defaults" in Price Codes file.
- Customer entry now controlled by search dialogs (Company, Name and Phone) and can no longer be changed from Form View in Work Orders, Invoices and Gift Certificates.
Version 6.1.v1 Multi Site:
Added features:
- Up to four site locations can connect to a central database via Terminal
Services. Financial reports are kept separate. Inventory can be "moved" from
one location to another.
Version 6.0v1
Converted to FileMaker Pro 8.5 format
New Component:
- Consignments file: tracking artwork coming and going, recording sales, invoicing artwork out on consignment.
- Instant Vendor Pricing Updates with broadband access.
- Integration with Wizard's Mat Designer (TM) and Integrated Framer (TM) visualization software.
Added features:
- Store Credits/ Gift Certificates – issuing, recording date redeemed, auto-tracking and printing.
- Ability to sell Price Code items, such as of sheets of matboard, moulding footage and frame supplies, directly onto an invoice.
- Increased security features: certain file access blocked from lower level accounts.
- Width and Height fields may be increased and decreased with auto-button by 1/8 increments.
- Four white space fields.
- Default set for bottom mat weighting.
- Default pricing structures.
- When Posting to Invoice you may select which work orders may be omitted.
- New side bar button to create Special Order from Contacts file without creating a work order.
- When creating a Frame Order choose which vendors to include/omit for a Purchase Order.
- Contacts File has new Terms/Shipping info and Credits tabs.
- Google Map (TM) lookup feature.
- Importing retail product catalog/databases feature.
- Create Schedule document for production flow.
- Import a moulding image into the Price Codes file.
- Invoice # is displayed when mouse hovers over Post to Invoice side bar.
- Rapid entry screen for use with bar code readers on Invoice.
- Ability to add a dated note to a found set in Contacts file, i.e. “sent mail for Art show.”
- View Gift Certificate and Store Credits on Customer record.
- Move a line item to another Purchase Order.
Items fixed:
- Back Order item check box doesn’t cause crash.
- When duplicating work orders, any changes on the Contacts file are re-looked up.
Items modified:
- The Contacts File has tabs for additional information.
- Adding a work order to an existing invoice requires Search Item button.
- The look of the markups and pricing structure has been changed.
- Applying mark-ups is faster.
- Accounts Receivable Report available with 30, 60, and 90 day aging totals.
- Ability to change log-in passwords.
- Enter a Payment button.
- More Done choices after entering a payment.
- Easier to navigate customer referrals.
Enhanced features:
- Price Codes file screens have been updated with new tabs: Auto Inventory, Manual Inventory, Pricing, Surcharge, Matrix, Retail Pricing and Image.
- Ability to update an invoice from the work order using the Post to Invoice side bar button.
- Separated Invoices and Invoice Details into two tabs in Contacts file.
Version 5.6v5
Converted to FileMaker Pro 8.0v3 format
Added features:
- An option to calculate moulding based on a Wholesale Cost * Markup + Set Price per foot.
- A Format menu to the Setup Data screen to allow text formatting of the Business name.
- A Create Special Order side bar on the Contacts file.
- A report for items that have been added to a vendor after an update.
- Enabled the "x" button to allow print preview windows to be closed.
- A Delete button in the UI Codes tables to allow deletion of united inch lines.
Modified:
- Print layout headers to more easily allow logos to be used with the address info from Setup Data.
- United inch fields in the UI Code tables.
Items fixed:
- Live vendor updates to prevent importing of extra records.
- A problem when posting a Work Order to an Invoice, in some instances it would default to the first invoice of the Invoice file instead of the newly created one.
- "Order Taken By" does not display when clicking on "Lookup by Phone".
Version 5.6v4
Added features:
- Image size on printed Work Order was added back (removed in previous version).
- Added Increment by 6 UI to UI Code Tables template.
- Printing of mat descriptions (removed in previous version).
- Description of item will display as "Discontinued" if the box is marked in the Price Codes field.
- In Print display of Invoice, new File menu called "Print or Save as PDF" to allow preview of printed invoice to be saved as a PDF.
- Also added "Print or Save as PDF" menu option on Work Orders, Purchase Orders and Products files.
- Green button to delete phone numbers in Contact file.
- Insert Picture button and screens on Work Order file.
- Green button to clear the margins default field on the Work Order Options screen.
- Edit menu to Main Menu screen to allow copy and paste functions (removed in previous version).
- New Keywords to the New Customer dialog box.
- New Vendor button to the Order From screen.
- Add A Line button to the Moulding Markup Table to allow for additional entries with correct Group and Cost Type automatically entered.
Items fixed:
- Stuck in Tender field fixed by changing to a pop-up menu.
- Fixed validation of STS fields (matboard reveals).
- Printing of Art ID when printing a single Work Order.
- Fixed Readymade blue button to allow entry into field.
- Fixed Clear All Mat Measurements button in include display fields.
- Fixed 48 hour approval.
- Fixed matboard and moulding usage to print properly.
- Lengthened current date field to print in full on reports.
- Changed printed work order to have all mat cutter setting align left.
Items removed:
- The auto-complete feature on the work order file which was causing a slow down in entering items.
- The new value lists for moulding and matboard because of conflicts with scanned UPC numbers.
Enhanced features:
- Adjusted Print List in Contacts to print multiple phone numbers.
- Added Retail price and % columns to Cost of Goods report.
- Modified Mats and Glass inventory fields to account for correct yardage.
- Modified Qty field on Work Order Form View (when auto-inventory is on) to prevent entry unless you click on Modify Work Order button (inventory would be inaccurate otherwise).
Version 5.6v3
Converted to FileMaker Pro 8.0v2 format
Added features:
- All features from 5.6v2 for Windows.
- Created the ability to restore FileMaker standard menus which are required when customizing the program. Call for details.
- A variety of print options; to pause on the preview of a printed page or to instantly print.
Items fixed:
- Several Work Order printouts which failed to display footage and UI.
Version 5.6v2 - available for Macintosh only
Added features:
- A Completed By field and Date Completed field on the Work Order screen.
- An option to create the Work Order Sales report by completed date or created date.
- A monthly sales clip (a report of projected sales: a clip is a projection of the sales for that month based on the sales of the previous days.)
Items fixed:
- Duplication of the print dialog box appearing.
Version 5.6v1
Converted to FileMaker Pro 8.0v1 format
Added features:
- Ranking feature in Contact file to rank best customers
- Pop-up list and auto-complete features for framing components on Work Order
- Pop-up calendars added to many date fields
- Automatic email messaging to customers when order is completed
- "Company" name to drop-down list of referrals (on Work Order screen)
Enhanced features:
- Expanded Category field to make it easily visible and more accessible
- Locked Price button which now can change price at any time or return to previous price
- New Customer button on Work Order to automatically look up customers with same first and last names. If the named customer does not exist in the database, a new record will be created with the first and last name entered.
Version 5.5v1
Converted to FileMaker Pro 7.0v3 format
Added features:
- Glazing size option to allow glass to be size for any frame in a stacked set.
- Lip measurement field to Price Codes file and Work Order file to allow for more accurate measurement of stacked frames.
- A Modify button to stacked frame view to allow changes to dimensions for more accurate sizing.
- Accounts Receivable Report to End of Day Reports.
- "Additional Requests" button to Find screen to search for multiple items in one requested search.
Enhanced features:
- Modified the Customer Preferences box to now operate as Keywords.
- Modified deposit invoice to not have date appear in payment line when it is applied to the actual invoice for the work order. This prevents the previous deposit from being shown on the payment report of income received that day.
- Modified the field in the Work Order file so that either UPC barcode or Item number can be entered without marking the UPC box. Removed the UPC boxes on the Price Codes screen.
- Modified List view format to fill depth of screen but resize when returning to form view.
- Modified the Find Screen in the Price Codes file to search for a moulding, by either UPC or number, when entered into the one field: UPC/Number.
Version 5.0v4
Added features:
- A customer “interest” field was added to contacts file to track such things as birthdates, anniversaries, name of spouse/children, pets, hobbies, etc. This can be searched by either interest or the interest group.
- A Designer field has been added to the work order screen. The Designer field is used for generating sales totals for designers when creating a work order sales report.
- Two columns have been added to the work order sales report: average dollars discounted, total dollars discounted.
- Ability to imported work records to the Product Labels file (look under the Extras menu in the Labels file).
- Added business return address labels to the Product Label file.
- More options for password security.
- Spelling button to artist’s bio page
Items fixed:
- Changed the way moulding and mat numbers are validated in the work order file. It is no longer possible to inadvertently enter a mat number in a frame field or vice versa.
- The current date is no longer entered on an invoice for a deposit payment made on an earlier invoice. This only applies to using the Enter Deposit feature on the work order.
- Changed the way the Print dialog box displays when printing sales reports. Behavior was made consistent with the “Show Print Dialog Box” option for work orders and invoices.
- In the Price Codes the inventory field for mats, mounting, glass was added to the Find View.
- In the Price Codes file the default UI setting was corrected for the various layouts.
- Changed the order of the listed documents on the End of Day report to match the Print/Preview order.
Version 5.0v3
Added features:
- New FrameReady 5 opening splash screen.
- Added an option to the work order file to prevent a discount from being applied to labor (i.e., the Fitting field). Note: this item posts as a separate line on an invoice.
- Added a status field to the Purchase Order file.
- Added a pop-up value list for the City field when creating a new contact record. The list displays all municipalities which share the same postal code.
- Added a default area code field to the Phone Number file which will be entered in the search dialog box when looking up a customer by phone number.
- Added an artist biography page to the Contacts file with a photo field
- Added minimum footage fields to all fillet fields.
- Added fillet description field to the work order fillet selection screen.
- Added summary fields to the Invoice “Print List” print out.
- Added retail total fields to the Inventory List of the Products file
Enhanced features:
- Modified the description field on the work order screen to display if a moulding or matboard is marked as discontinued in the Price Codes file.
Items Fixed:
- Fixed a problem with missing markup tables when performing a vendor update.
- Fixed a problem when duplicating a work order that contains items that have been discontinued or the items have been barcoded. Such items failed to recognized in the duplicated record.
- Fixed a problem where the matboard markup table was not sorting properly.
Version 5.0v2
Added features:
- Default reveals for matboard (click on Default Mat Reveals button in Price codes).
- Option to choose All Records or Found Set to Product Category Report.
- A Perform Last Find command to the Invoice Extras menu.
- A dialog box for adjusting the top mat margins on the main work order screen (click on the value displaying the reveal for the top mat).
Enhanced features:
- Changed the "Set Top Mat To" feature in the Matboard detail view and Fillet view to a button and dialog box.
- Modified the Fletcher interface to always create an export file when Done.
Items Fixed:
- A problem in the Labels file where the screen failed to return to Browse mode after printing.
- A calculation in the Chop Order file for the moulding usage report.
- A problem with the Lump Sum Payment feature where amounts were applied to records that had a negative balance regardless of customer.
- A problem where oversized surcharges failed to work for Frames 2 thru 5.
- Several Print scripts that failed to show the Print dialog box before
printing.
Version 5.0
Enhanced features:
- Main Menu and Opening Splash screen redesigned.
- Formatted the Due Date field on invoices to include day of week.
- Modified the way the Price Codes file creates new records for matboards.
- Moved certificate of authenticity check box on Work Order to artwork section.
- Renamed "Change Print Options" on Invoice screen to "Invoice Options".
- The phone # lookup on a Work Order or Invoice. If more than one customer is found to have the same phone number a selection list is presented.
- Modified the "Post To Invoice" button on Gift Certificate to read "Posted" after being posted to an Invoice, cannot be posted a second time.
- Modified the way a markup and set price is applied to a new mouldings that have been imported when doing a vendor update so that vendor specific tables will be applied.
- Finds discontinued items following a Vendor update.
- Modified the way a new Markup Table is created for moulding (more user friendly).
- Created a script where on program startup markups would be applied to mouldings or matboards missing a markup value.
- Modified the opening script to reduce the number of files which open on single-user and networked guest machines for faster opening (Host computer must still open all files).
- Modified the Startup file on guest machines to prevent from inadvertently clicking on the wrong file when there is a problem with the network.
- Modified the "Update Price Codes file" feature to include a Cancel button in cases where the Update is the wrong vendor.
- Realigned columns on Summary of Sales by Category and re-titled columns to ‘Retail’ and ‘Wholesale’ from ‘Subtotal’ and ‘Subtotal Cost’.
- Extended Description, Edition # and Artist fields on printed invoice to accommodate two lines of type if required.
Added Version 5.0:
- Eclipse CMC interface.
- Lump sum payment feature to Invoice.
- Option to combine code and formula pricing for mats/fabric, mounting and glass.
- Pop-up dialog box for looking up customers by phone.
- Payment report sorted by Sales Rep.
- Date field to the Art Type file so it can used as notes and can be searched by date.
- A summary field for Qty of pieces on the Work Order list view print out.
- A Substitute field and lookup for matboard and moulding.
- A supplier field to the Artist consignment report.
- A certificate of authenticity to the Product file.
- An edit spelling feature to the Artist file.
- Several new fields to the Product file: long description; date of art;
condition of art (does lookup on work
order); publisher. - A find Work Order button on the Invoice file (same as the Contacts file)
- Location field to Work Order summary layout.
- An error-check for an invalid fraction entry.
- 2 oversize surcharge fields for moulding entries.
- A moulding specific minimum footage option.
- Several new pricing options for mats, mounting, and glass.
- Fabric group to the Price Codes file.
- An Extender group to the Price Codes file (an Extender is used to create shadow box frames and therefore does not increase the size of the frame on top of it).
- A "Finishes" option for Frame1 in the Work Order file. Includes four fields with cascading value lists specific to vendor and related finishes.
- Work Order description prefix option to Invoice Options.
- "Security" tab to Setup for enhanced security.
- Password security to Sales Report, Payment Report, Statements over 30 days, Invoice Void button, Price Codes Update, Price Codes Inventory Reports, Price Codes Clear Inventory Fields and for modifying an invoice and access to Products and Price Codes.
- Special Entry feature now inserts image W & H (including White Space) that were entered on the main
Work Order screen Version 5.0.
- Field for tracking discontinued items.
- Counter and progress bar when updating mouldings.
- Cost field (Price Codes) to Mat Design, Hardware, Extra, and Fitting Group for Inventory Tracking.
- Fitting, Hardware, Mat Design, & Extra to be included on PO's if a Vendor is selected.
- A Restore Last Frame Order feature in the Create Frame Order dialog box.
- Second Readymade field in the Work Order file to accommodate the use and sale of prepackaged frame kits.
- UPC field to the Product file for use with a barcode scanner while retaining a separate product number (either number can be entered on an invoice for lookup).
- Artwork Category (from Work Order) to Purchase History screen in Contacts file.
- Artwork Category pop-up list to Find screen in Contacts file.
Items Fixed Version 5.0:
- Purchase History in Contacts so that Work Order totals calculate Work Order instead of just the unit price.
- A problem with the due date refreshing when the program is left on 24/7.
- A problem where the mouse wheel could move to other invoices when in the line item entry screen.
- A problem where the Work Order due date calendar failed to appear as in previous versions.
- An omission where only one tax exemption # field printed on invoices.
- A problem where new mouldings failed to be given the vendor number for purchase ordering purposes if such had been applied earlier to the particular vendor.
- Removed "Modify By Supplier" button from Markup Table screen (too confusing for the user as to the purpose of this feature)
Version 4.3v2
- Added interface with the Fletcher 6100 computerized mat cutter.
Version 4.3v1
- Incorporated some new features available in FileMaker Pro 6.0. The most noticeable is a pop-up dialog box on the work order when searching for a moulding or matboard number.
- The Price Codes and Product files were resized for 800x600 screen display.
- Added an option where documents given to customers can be printed in Spanish or French.
- Added to the work order options default settings for the following fields, mount/stretch, Hardware, Glass, and fitting.
- Added a new feature to the work order file called Go To Materials List. This feature is designed to track whether all the materials are in stock before starting a given job.
- Fixed a problem where the due date on the work order was not calculated properly and added the option of disabling Maximum Number of Pieces per Day requirement.
- Fixed a problem where the properties of the Fillet 4 field took the user to a search screen instead of allowing data entry.
- Added an error check for missing image width or height values.
- Fixed a problem in the End of Day reports where the Summary report failed to print if no payments had been made on the day in question.
- Fixed a problem where if a work order was duplicated which had an artwork product number entered for an open edition print and that same product number was entered on the duplicated work order and a new customer was entered on the work order then after posting to an invoice the new customer would be inserted on the original work order that had been duplicated.
- Fixed a problem where if a record was duplicated in the Product file then the Qty Sold and Sales dates field were also duplicated.
- Fixed a problem where if you entered a value in the Reference field on a payment on the main screen of the Invoice then the program caused an irreconcilable loop which could only be resolved by a force quit.
- Fixed a problem where the business name and address failed to print on a receipt when using a logo.
- Fixed a problem where the current date printed on a payment report that was printed for a different day.
- Modified the Art Price field to allow a value to be entered which is added to the work order Unit Price (not as a separate art price). Selecting a print from the art inventory or clicking Special Order remains unchanged.
- Added a field to the Contacts file to store and launch a website address.
- Added a related field to the Contacts file to store Art type categories (similar to Artists).
- Enhanced the product inventory reports to have the option of omitting consignment items from the report.
- Enhanced the Purchase Order file to move back order items to new PO's whenever a Framing or Product order is generated.
- Changed the wording on a work order button from "Select for Chop Order" to "Select for Frame Order".
- Added to the Work Order sales report two columns which displays sales based on united inch.
- Enhanced the Codes pop-up list in the Price Codes file to display a comment field related to code in question.
Version 4.2v2
- In the Work Order file, the calculator button was removed from the modify work order screen (second screen when update inventory is turned on). This corrected the problem of being returned to the wrong screen when clicking "Done".
- Fixed a problem in the Work Order file where the wrong screen was displayed after leaving the Enter Glass Size dialog box.
- Added a Matboard report to the Work Order file which displayed and printed a report of mats for the current found set. The Matboard report command is also found under the Extras menu.
- The print layouts for the framing order were redesigned to be more readable and require less paper for printing.
- Corrected a problem occurring when a user manually entered a work order number on an invoice and the work order was an estimate. The work order could not be activated and became unusable. Now in such a situation, the work order is automatically activated.
- The screens in the Contacts file have been resized to better fit an 800x600 screen display.
Version 4.2v1
- Work Order and Invoice screens were resized to better fit an 800x600 screen display.
- Added a relationship in the Labels file to connect the Work Order file so that labels could be created and printed for work order fields. The relationship uses the work order number as the key field.
- Fixed a problem where the calendar numbers did not display properly when running on Windows NT, 2000, or XP.
- Fixed a networking problem where all the files did not open on a guest computer and the Update file could not be found.
- Fixed a problem in the Work Order file where the moulding width was a fraction (without a whole number, such as 3/4, 5/8, 9/16). When there was a space after the last character, it would calculate incorrectly (e.g. 3/4 would calculate as 34 instead of .75).
Version 4.2
- Fixed a problem where import scripts failed to import when running on a network.
- Added two "Next" options in the Codes file (under the Extras menu) for greater ease in modifying a code table.
- The command enables the use of the Enter key on the Number pad to move to the next record instead of having to use the Tab key (From the Extras menu, the commands are Next By 1UI and Next By 2UI, which enters the amount in two UI fields).
- Main Menu, replaced the button entitled, "Print Blank Letterhead" with "Connect to Vendor Price Updates". This button launches the user's Web Browser and enters the URL for FrameReady Vendor Updates.
- Fixed a problem where only one tax field was selected as nontaxable when selecting "Enter A Deposit" from the work Order. Now both tax fields are selected as nontaxable.
Version 4.1v1
- Added the Group field to frames 1-5 in the layered frames screen of the Work Order file.
- Added the frame size for frames 1-5 to the work order layered frames screen.
- Modified the footage and frame calculations to ignore the width of a fillet if a fillet was used in a frame combination.
- Fixed a problem with windows resizing when doing a find for a Frame, Fillet or Matboard.
- Modified the layered frame calculations to subtract 3/16 of an inch from the moulding width to fit under the rabbet of a succeeding frame. (There is still an inherent inaccuracy in this method as most moulding widths are not true sizes provided by the vendor and the lip of many mouldings are larger than 1/4 inch).
- Added the Group field to the framing order layout and modified the layout to print two lines per items. Customer and work order number print on a second line. (Later modified to one line.)
Version 4.1
- The mouse changes to a Hand icon when it moves over a button.
- The change password option under the File has been disabled.
- Certain views have been disabled under the View menu.
- The Liner field was removed from the Work Order file as it was redundant and sometimes confusing with the newer layered frames option (older work orders will still display liners that were entered in the Liner field).
- A second tax exemption field was added to the Invoice and Product file. Now either or both tax fields can be exempted.
- Added a receipt printer option for use with an Epson T-88 Thermal printer (Select invoice print options and select Receipt Printer).
- Fixed a problem in the Work Order file when selecting a second Glass item which used a code table for pricing (lookup failed to enter price).
- Added an "Accept All" button to the Purchase file for updating inventory.
- Added a Back Order checkbox to the Purchase file for tracking back orders and preventing inventory updating when the "Accept All" button is clicked.
- Modified the "Delete" button in the Contacts file so that it only works with privileged passwords.
- Fixed the Invoice date field in the customer Purchase History so that it cannot be modified.
- Modified the Matboard Markup tables in the Price Codes file so that generic tables can be used (i.e. a table that does not specify the size of a mat). When no size is specified in the table then a size of 32x40 is assumed. The cost of the matboard is broken down to a cost per sq. inch and the appropriate code or markup is assigned based on that cost per square.
Version 4.0v8
Converted to FileMaker Pro 5.5 format
- Fixed a problem where Sales reports failed to evaluate the Valid - Void field in the Invoice file thus creating an inaccurate report.
- Fixed a problem where a blank Category field failed to display as Miscellaneous on Sales reports.
- Fixed a problem where Frames, Liners, and Fillets would deduct too much inventory when a quantity greater than 1 was entered on the work order.
- Disabled the Standard Toolbars feature in FileMaker Pro 5.5
- Fixed a problem in the Work Order file where the wrong screen displayed if "Another Work Order for Current Customer" was clicked and the Inventory Update was turned on.
- Added Date of Referrals field to the Find view in the Contacts file.
- Added Opening Sales field to Purchase History in the Contacts file.
- Fixed a problem where shipping information on a printed invoice originated from the Contacts file and not the Invoice file.
- Fixed a problem in the Artist file where all records were deleted if you clicked the "Delete Artist" button and it was a blank record. Now just blank records are deleted.
- Modified the Invoice file so that when the "Done" button is clicked the user does not lose the current found set.




