Simon Clement

About Simon Clement

This author has not yet filled in any details.
So far Simon Clement has created 86 blog entries.

December 2016

Manage Stock


Stock added

The Manage Stock button gives you access to the Stock/Sales Screen where you add and adjust stock levels for the current artwork.

When an artwork is created at least one item of stock is likely to have been automatically added. You can amend this number using this button and can add or remove stock by adding new stock records. The current level of stock is calculated as a product of all the stock you’ve entered, less stock sold and less stock out on consignment.

(For detailed stock reports use the Inventory Report accessible from the Reports screen accessed via the Tessera screen).


Managing Stock Levels

To add more stock access the Stock/Sales management screen from the Artwork Edit screen.


Adding stock and managing the purchase price of an artwork

  1. Information on the Stock/Sales screen shows that for this artwork shown two entries have been made. One for one artwork and one for two artworks. This suggests that this artwork would be an item you regularly sell that can be restocked such as jewellery or ceramics.
  2. The calculation used to show the remaining artworks in stock. Placing artworks out on consignment reduces the total amount of stock available.
  3. To add additional stock for the current artwork use the Add Stock button.NewImage

Adding Additional Stock

  1. Enter the date of stock entry as this will be used in any Purchase Report you run from the Tessera Screen which report amounts spent for specified date ranges.
  2. For general comments.
  3. Enter the amount for the individual price for this artwork
  4. Mark when artworks include tax in the Purchase Price.
  5. Tax rates will have automatically been entered from settings entered in Tessera Preferences.
  6. Where need be the tax amount can be entered manually.
  7. Enter the number of stock items. Entries can be amended to zero for if need be. e.g. An artist has taken an artwork back into their studio but you want to keep a record of the artwork details while maintaining accurate stock reports.NewImage

Sales of this artwork

The Sales button also takes you to the Stock/Sales screen where you can review the sales for the current artwork. For accurate and detailed sales reports use the Advanced Sales Report.



Artworks can be placed out on consignment using the Tessera Consignment feature which is accessed from the Tessera screen. On the artwork edit screen screen the consignment field will display the number of consignments on which the current artwork is featured. Click through to the Stock/Sales screen where the related consignment reports are listed and from where they can be accessed and edited.


November 2016

Installing Tessera on a Mac


Download Tessera from

  1. Once downloaded you’ll find the Tessera.dmg download in your designated download location which is likely to be your Downloads folder.
  2. If it hasn’t already been opened then double-click on the Tessera.dmg icon and the Tessera Volume icon will appear on your Desktop.

DMG The Tessera Volume Icon NewImage

Copying Tessera to your Applications folder

  1. Double-clicking on the Tessera Volume Icon opens the window below and from here you drag and drop the Tessera folder onto the provided Application Alias. After a moment a copy of Tessera will have appeared in your own Applications Folder.

Tessera install Locate the Tessera Folder

  1. The Tessera Folder in your Applications Folder now contains the Tessera App and your Tessera data file.


Contents of the Tessera Folder

  1. The data file contains any information you enter into Tessera and should be part of your daily backup routine.
  2. The Tessera App can be dragged into your Dock if you want to place it in an easy to reach location.

(The Tessera App and the Tessera data file need to remain in the same folder and should not be renamed).


Once Tessera has been installed you can close the installer window and safety delete the Volume Icon and the .dmg icon (1).


Installing Tessera on Windows


Download Tessera from

On opening the downloaded Tessera.exe file you’ll be presented with a dialog prompting you to install Tessera on your PC. Options will include installing shortcuts. The default Location is set to be the base level of your C drive rather than your Programs or Documents folder.

The Tessera folder contains both the Tessera Application and the Tessera Data file. This data file is constantly being modified as you use Tessera. Windows does not expect programs to be altering in this manner which is why Tessera is placed where it is. Try the Tessera in other locations on your PC. The Documents folder should be suitable but you may experience difficulties if Tessera is placed in the Programs folder.

To uninstall Tessera access the uninstall feature via your Control Panel settings.

If you have problems once Tessera is installed with entering data it may be that there’s a problem on the properties set for the Tessera folder. It may be set to “Read Only” which will prevent the entry of data .

  1. Open File Explorer, and then Tessera folder.
  2. Right-click the folder, click Properties, and then click the Security tab. (This step will vary depending on what version of Windows is in use).
  3. Click the Advanced button. …  (This step will vary depending on what version of Windows is in use).
  4. Make sure the folder and it’s contents are not set to “Read only”


Sharing Tessera


To share Tessera you need: A copy of FileMaker Pro running Tessera Pro with sharing enabled.

Upgrade to Tessera Pro on a Mac or PC and a number of people can use Tessera at the same time from different devices from different locations.

More than one person could be adding artworks, creating invoices or making changes to client records and all the changes will be visible to all the users simultaneously.

Each Mac or PC will need to have a licensed copy of FileMaker Pro installed. (iPad or iPhone users need a free copy of FileMaker Go to access a copy of Tessera hosted using FileMaker Pro).

FileMaker Pro is an application from that lets users create and run FileMaker Pro files such as Tessera. One of the computers hosts the Tessera data file using FileMaker Pro while the other users are guests of this hosted file which they also open using FileMaker Pro. This is the ideal situation for a few users wanting to work on one copy of Tessera. The users need not be on the same local network as long as you have internet access and the hosted copy of Tessera is open on the host computer. See FileMaker’s help files for more details.

Enabling Sharing

  1. From the Tessera Home Screen under Preferences use the Sharing button.



FileMaker Pro Server and sharing Tessera

FileMaker Pro Server is a server solution for managing larger networks ensuring data integrity and backups that makes it the best option in any circumstances but is certainly the only option to consider if you plan to have more than five users at any one time and want to ensure Tessera functions as expected. With FileMaker Server you also have the option to allow users access to your FileMaker Pro database using a web browser. FileMaker Pro Server and offer additional security and features that suit larger organisations where security and stability are particularly important. Ideally FileMaker Pro Server will live on it’s own workstation along with a copy of Tessera. This way FileMaker Pro Server can provide a stable and secure platform for users to log-in as guests. Each guest of the Tessera data file will need a copy of FileMaker Pro or a copy of FileMaker Go if they are on an iPad or iPhone.

Let someone else handle the sharing of Tessera

There are many companies that will host your FileMaker Pro solution for you allowing you to access the Tessera data file from wherever you are as long as you are online. This way you don’t need to manage and support the hardware and software required to run Tessera and there are addition benefits for when it comes to security and backup.

For more details on sharing FileMaker Pro files see these resources from

FileMaker Cloud and Tessera

FileMaker offers a solution to host Tessera using FileMaker Cloud. Using Amazon Web Services you can be walked through the setting up of FileMaker Pro Server on the web and then hosting your Tessera file.

Watch this video from FileMaker for more details.

Tessera 402



Amended “Import folder of images” step when using the Artwork Image Manager so it works as expected.

Artwork List- View


This List – of artworks is an ideal way to review and sort a number of artworks at once. Use the button provided on the List – screen to select which field appears in the left-most column.  The first three choices in the menu result in bold titled columns. Selecting to sort these, and other bold columns, results in summarised details. Couple this with using the Hide Sold Artworks button to quickly review groups of available artworks.List viewSelect field

Tessera 401


New Features

Creating New Artworks

New artwork’s screen now includes a comprehensive list of fields for data entry including custom fields. Up to three images can now be added when creating a new artwork. Extended range of custom fields available on this screen as well.

Importing folder of images

Individual artworks now allow the import of a folder of images

Navigations Aid

The navigation board now includes access to one-click access to each View available in each component.


  • Creating new client from Client List screen now works as expected
  • Invoice design now correctly reflects changes to field headings on printed invoice
  • Attaching documents to artworks now allows the attachment of any document

other minor alterations to ensure Tessera works as expected.

October 2016

Try the Omit button


There’s nothing mysterious about the Omit button. It simply shows the artworks that are not being shown, or omitted, from the artworks being browsed. Let’s say you have 7 artworks and have conducted a search so that you are now viewing only 5 of these artworks. The Navigation bar will show (A) that you are viewing 5 records and that (B) there are a total of 7 artworks available.

Use the (C) Omit button and you are now viewing the 2 artworks that were omitted and the 5 initial Artworks you found are omitted instead. Click the Omit button again to toggle between these sets. This is useful to find artworks that do not belong to your search criteria. For example: Search for artworks that belong to the artworks medium of “Oil”, click the Omit button, and you are now viewing all artworks that are not marked as having an artwork medium of “Oil”.

Use the Show All button (E) at any time to revert to viewing all Artworks.



Hiding sold artworks


When browsing artworks in Tessera you’ll usually be interested in viewing artworks that are available. But when you’ve conducted a search you’ll often be left looking at a screen like the one below where there are a mixture of sold and in-stock artworks. (Where there is no stock available the Info Button will always be displayed in red instead of green).

To temporarily hide out of stock artworks use the “Hide Sold Artworks”. Now you can use the Omit button to toggle the view between sold and unsold artworks.

List view

Browse Stock and Sales


Review Stock and Sales

  1. Use Browse Stock and Sales to gain an overview of current sales and stock


Basic details

  1. Select to review either sales or stock
  2. Filter the complete lists of artists
  3. Print a basic report but use the dedicated Stock or Sales Report screens for more detailed results.
  4. Use the Reveal Totals… button to show total
  5. Select an individual artist to reveal individual artist details (Once reviewing an individual artist’s works select an individual artwork to review details).