Menu
Language: Program Magazynowy - Wersja angielska Program Magazynowy - Wersja polska
  • List of warehouse transfers for a given item, barcode, account or group of items in a given period

    • Frequently asked questions concerning the purchase of the program

    How long may I use the program after I buy the licence?

  • Detailed list of all discounts for the chosen criteria and total balance of value of discounts
  • Total amount and value of the sold items from all the warehouses for the chosen criteria

    • "Reports/Time spent on assembly”:

    The licence for the warehouse management program is without a time limit. The buyer who purchased the licence may use the software in their business activity as long as they like.

    Can I download updates for free?

    • Active (manufacturing) time for individual items comprising of many components. You may also check the time devoted by a given employee to a given assembly process.

    „Reports/Detailed serial numbers report”:

    • Serial number database for all items on stock.

      • After the purchase, the buyer may update the software free of charge for the period of 12 months. After 12 months have passed they can keep the last version they downloaded or buy the possibility to download updates for another 12 months for prices quoted in updates price list.

    • A list of serial numbers for a given item or barcode, account, or item group in a given period.

    „Reports/Report on serial numbers on stock":

    Am I going to lose the data entered into the DEMO version after I enter the activation key?

    NO. The activation key does not remove any data.

    • Database for serial numbers for all items on stock in all warehouses.

      • What is the difference between the DEMO version and the full version?

    The list of reports is being constantly broadened, and the existing reports are being frequently streamlined. The program may already include reports not described in the instructions.

    There are no differences in the functionalities of both of the versions. The DEMO version is time-limited and stops working after you have run it 30 times.

    11. Users and authorisations

    Does the program have any limitations, e.g. the number of warehouses, items?

    LoMag offers the following possibilities of restricting authorisations:

    • Access only to chosen warehouses, e.g. you have three warehouses, but a given user may access only 2 of them
    • Access to only some of the functions, e.g. a given user does not have access to reports
    • Access only to chosen operations e.g. a given user may add documents, but they cannot change or edit them

      • NO. The program may support any number of warehouses, items, accounts, documents. The program has been tested on thousands of elements. Only the size of the Microsoft SQL Express database, i.e. 10GB, limits the amount of data. In practise this stands for many MILLIONS OF ENTRIES. There is also a possibility of buying a more advanced version of Microsoft SQL Server: Standard and Enterprise, which does not have limits as regards the size of the database.

      When will I get the activation key and in what form?

      The activation key is usually sent to an e-mail address of the buyer after the payment comes through. When paying for the program via bank transfer, it is best to give your e-mail address in the transfer name field. We can also send you the activation key via SMS.

      Is it possible to receive a VAT invoice with deferred payment?

    The only default user in the program is the Administrator, who is authorised to enter all warehouses and all options in the program. The login and password of this user are empty. The Administrator is a special user and you cannot restrict his authorisations or remove him. You may, however, change the login and the password of the Administrator. ATTENTION: Please note down the changed Administrator's password. If you forget this password, the only way to retrieve access to the program is by sending the database to the manufacturer.

    YES. Please make a note of it in the remarks to the order. After receiving an order we send the original and a copy of the invoice to the Buyer via traditional mail. After we receive a signed copy of the invoice, we send the activation key to the full version of the program.

    Can I transfer the program and the activation key onto another computer?

    YES. The activation key is ascribed to the database. You must install the demo version on the new computer and then restore the database.

    If several people use the computer and you want to secure access to LoMag Inventory Management, simply add a new user in the "Users/Add new user" menu. When adding a new user, you specify their name, e.g. "Jan Kowalski”, then their login and password. The login and password will be entered each time the program is opened. The program allows you to define a login and passwords of any length (including blank). Log in is only possible once you have saved the new user and restarted the program.

    What if the key is lost, e.g., as a result of a computer breakdown?

    You can retrieve your activation key from the program manufacturer. A request must be sent from the e-mail address to which the key was sent, together with the name of the company for which it was generated.

    Can I resell LoMag or give my key to someone else?

    When adding a user, you define their role and authorisations to access warehouses. You mark the authorisations to warehouses by the names of the warehouses. Marking the field next to the name of the warehouse will mean that the user is entitled to access a given warehouse in accordance with the ascribed role, unmarking the filed will disable their access.

    NO. The activation key is SECRET ascribed to the Buyer and dedicated only to the Buyer. The distribution of the key or making the key accessible to third parties is severely prohibited.

    You may define a different interface language for each user. The language for a given user may be changed by using the "Users/List of users/Edit" function.

    Frequently asked questions regarding the DEMO version:

    User roles

    How long may I use the DEMO version?

    The DEMO version may be launched 30 times. It is a fully functional version of he program created for you to familiarise with the functionalities of LoMag free of charge and without any risk

    Does the DEMO version operate in a network?

    YES. On any number of computers.

    Can I continue to work on the data I entered in the DEMO version?

    YES

    What is the difference between the DEMO version and the full version?

    The idea behind the roles is that once a role is defined, it may be used for many employees, e.g. LoMag may be used by 5 warehouse keepers, 2 accountants and an Administrator. You define the authorisations of a warehouse keeper only once, and then ascribe the "warehouse keeper" role to 5 users; similarly you define authorisations for the "accountant" role only once and you ascribe it to 2 users. You can define any number of roles and add as many users as you like. The number of people working simultaneously is, however, limited by a number of purchased licences.

    There are no differences in the functionalities of both of the versions. The DEMO version is time-limited and stops working after you have run it 30 times.

    Does the program have any limitations, e.g. the number of warehouses, items?

    NO. The program supports any number of warehouses, items, accounts, documents. The program has been tested on thousands of elements. Only the size of the Microsoft SQL Express database, i.e. 10GB, limits the amount of data. In practise this stands for many MILLIONS OF ENTRIES. There is also a possibility of buying a more advanced version of Microsoft SQL Server: Standard and Enterprise, which does not have limits as regards the size of the database.

    A role is defined in the "Users/Roles" menu. By default there are two roles added to the program: the Administrator and the Warehouse Keeper. The Warehouse Keeper role may be removed or changed by marking and unmaking authorisations on the tree. Similarly, by pressing "Add" you can define a new role: in the "name of role" field you add a name, and mark/unmark authorisations on the tree below. If you click [+] on the tree, you unfold details, e.g. by unfolding the branch "Documents/Goods Received Note GRN" you can mark or unmark authorisations to add/edit/remove GRN documents.

    12. Templates editor

    Frequently asked questions concerning Network configuration

    How to configure the program on several computers?

    Users of LoMag Inventory Management LoMag get ready templates for documents and warehouse labels by default. However, the program also enables you to easily design and edit label templates and warehouse documents.

    Label designer

    For the program to work in a network the computers need to be connected with a local network or VPN. Select "This computer is a server" in the Program/Settings/Networking on the computer which plays the role of the server and remember the name of the server which is displayed below. Select "This computer is a client and it connects with the server" on the remaining computers and type in the name of the server.

    What to do if the program cannot connect with the server?

    To go to the label designer, select "Items/Label designer" from the top menu. You can also open the designer from the level of the "Find in warehouse" window and from the level of any warehouse document. The application enables you to design warehouse labels by applying any fields from the database, permanent texts, graphical elements, barcodes, photos and it also gives you the possibility of printing on various types of printers and paper sizes - including divided labels, e.g. 10 labels 2x5 on an A4 sheet.

    • Check whether an antivirus program or a firewall does not block the traffic between the computers. In some networks you will be asked to give the IP address of the server instead of the name of the server.

      • Documents editor

    • The computer which plays the role of the server must have the following tcp ports open: 1433 , 1434, 445 as well as udp: 1434
    • Check whether you can connect to the server by browsing through the network neighbourhood or find the computer by going to "Start/Find/Computer in a network".

      • The documents editor may be opened from any warehouse document window. The editor enables you to design document templates by applying any data from the database, permanent inscriptions, photos, barcodes for all data in the database and permanent inscriptions.

      13. Database management

      Backup copies

    • Launch "PING serverName" from (Start menu/Launch/cmd). If the result is "Request time out" it means that the network is not active (e.g. the cable is not connecting).

    Issues and Technical problems

    Where is the data entered to LoMag stored?

    The program saves the data in the SQL database in 2 files on the drive in the sub-folder "Baza danych". Usually the data files are located here:

    • c:\Program Files\LoMag\Baza danych\firma.mdf

      • All data, including program settings are saved in the database. It is very important to make regular copies to an external carrier, e.g. a USB stick. In case your computer is damaged, you can quickly recover the whole of the database on another computer. Make the copy by selecting the "Program/Backup" option and selecting a folder to which you wish to back up the database.

    • c:\Program Files\LoMag\Baza danych\firma.ldf

      • Carrying the database over to another computer.

    All the data and program settings are located in those two files. The files may be copied only if the warehouse management program is closed.

    How to move the database to another computer?

    • 1. menu Program / Backup database (on the old computer - server) and point the USB key to create a copy of the database.

      • To carry the database over to another computer, you must install a full version of the program on the new computer (e.g. the demo version from LoMag.pl), back up the database on the old computer (save the database to a USB stick), and restore the database on the new computer (upload the database from a USB stick).

      Working with the program from a USB stick

    • 2. menu Program / Restore database (on a new computer) and point to a USB key with a copy of the database.

      • You can launch the program from a USB stick. It may be useful, if only one person works with the program, but they use several computers. For the data to be saved directly on a USB stick, you should copy the whole folder of the program onto the USB stick, or choose the USB stick as the place for installation. For the program to operate properly on other computers you will need SQL libraries, so the easiest thing to do is to install a full version of the program on each computer, but to launch program from the USB stick. All data will be saved on the USB stick in the "Database" folder. You should make safety copies of the database to another carrier, so as not to lose the data in case the USB key is lost or damaged.

      14. Advanced configuration options:

    NOTES: Backup can only be performed on a server computer: either from the LoMag program in the menu Program / Backup or by copying database files. In case of multi-user operation, archiving is performed as a BAK file because other users can use the program at the same time and the files are blocked. If you want to restore a copy from the BAK database on another computer, then this computer must also be set "as a server". If you want to copy manually database files: firma.mdf and firma_log.ldf and files are locked then you must first stop the Lomag and restart computer or stop the "SQL Server" service before copying. When copying the database to another computer, remember to set the file permissions on the new computer. In the file properties / Security / Users give "full control".

    Does LoMag work with other versions of SQL libraries?

    "Settings/Calculations/Calculation of stock value: LIFO/FIFO” This parameter determines the order of issue, in case you have the same product on stock from different receipts. For FIFO (First In First Out) the first item to be issued will be from the oldest receipt. For LIFO (Last In First Out) the item from the last receipt will be issued first.

    At the moment the program automatically installs and configures SQL Express 2005 or SQL Express 2012 by default. LoMag also supports SQL 2008, SQL 2008 R2, SQL 2014, SQL 2016. The program will also work correctly with SQL Server Standard and Enterprise versions. LoMag does not work with Microsoft SQL 2000 (Version 8.0 and earlier).

    The program displays "database is read only"

    The situation in which the database is "read-only" is possible in several cases:

    "Settings/Documents/Support for packaging” - if you mark that option, you will be able to define packaging in the item list and ascribe it to products. Items with ascribed packaging are automatically supported on documents. Upon adding an item to a document, the program will also automatically add packaging.

    • Two copies of the program are working at the same time e.g. 2 people logged in to the computer have launched LoMag and configured it to single computer operation.

      • "Settings/Documents/Selection of transport type on documents” - possibility of entering information about transport for a given warehouse transfer. You can define any number of types of transport in "Item/Type of transport".

    • The network drive with the LoMag database has been made available (this in not how you configure LoMag).
    • No authorisation to save in the folder where the database is located: C:\PROGRAM FILES\LoMag\Baza danych
    • Another program or process is blocking the database e.g. SQL Server Management Studio or an installation program.

      • "Settings/Documents/Support of cost groups for documents” - a function developed for grouping items by cost (e.g. "Investment", "Office Supplies") of a given warehouse document. You can define any number of groups in "Item/Cost group".

    Several solutions of that problem:

    • Restart the computer and log in as the administrator.
    • Configure the authorisation: Full authorisation to save to folder c:\Program Files\LoMag\ for the "Users" group.

      • "Settings/Documents/Support for grouping of items on documents” - summing up of quantities for the same products on document print-outs. You may disable the summing up option manually for one document from the level of the document window.

    • Go to Program/Settings/networking and change to Many computers - this computer is a server"
    • Removal of all temporary files from C:\Documents and Settings\XXXXX\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\

      • "Settings/Documents/Support of lot numbers and expiry dates" - you can mark items with an expiry date (e.g. medication, foodstuffs) to prevent them from being kept at the warehouse for too long. When adding an item to a GIN, you may define which item should be issued the earliest, to prevent it from expiring while on stock.

    • Change the account on which SQL Express is working into a system account and restart the SQL server.
    • Install the SQL Server Management Studio Express diagnostic tool: http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en