FileMaker App for Garment Business

This is a single file database solution developed in FileMaker 11 Pro Advanced. The system is used to keep track of the items in the inventory for several different garment stores or showrooms. The system manages different showrooms, the items or garments available for several different brands at the showrooms, the showroom items that are lend out by the clients, when the items are returned to the showrooms, creating invoices for the clients, etc.

The system allows the user to manage the relationship between Client, Showroom, Brands and Items. It provides the user to add/edit/delete the lendouts to the clients, add the delivery cost for the lendout items and also update the showroom inventory when the items are returned to the showroom. In this system the user can add expenses to the clients for different brand and currency. The system also allows to create new invoice to the client for all the unprocessed delivery costs and expenses added to the client. The system has the ability to keep track of different types of clients such as a client can be media, contact person, freelance, vip and incrowd. The client’s lendout and invoice history are also recorded in the system which can be viewed later. The system has the admin ability to manage all the value lists used in the system, countries, types of currencies and their exchange rate, showrooms, items under brands, printing the labels, manage users of the system, etc.

The system has a built in admin ability to create/edit the e-mail templates to be send as reminder e-mails to the overdue lendouts on the showrooms.

There is a module developed in the system which give the user ability to do Media Analysis. In this section the user can register the press clippings that they get from the different magazines or on the web. The clips can be any type of image format files, pdf or small .mov files. While importing the clips to the database the system also pulls the information regarding the media from the media base.