LoMag for Android working online with SQL database using WiFi (or 3G / 4G)

All the above ways of selecting an item are equivalent and result in the filling in of the rest of the fields of the form: the barcode, the unit, the suggested price, and the current stock level. The next step should always be typing in the quantity. It is worth using the TAB button to pass from one field to another. The form for adding order lines varies between individual document types:

• in a GRN you can change the "purchase price" and add "remarks" to each line of the order;

Our application for Android "LoMag MSSQL Warehouse Program" allows you to convert almost any phone or tablet (with android) into a professional barcode scanner. The data is saved and read in real time envirnment to the LoMag database. With the Android system for online work based on the application, we can also use professional data collectors.

1. Requirements and Installation of the Application

• in a GIN you can change the "selling price" or the "margin (%)" or the "margin (sum)"; once you have entered the quantity, the program also calculates the purchase price and there is a possibility of previewing the purchase price, as well as the possibility of adding discounts - by enabling additional functions in "Settings/Documents".
• in an Internal GRN you can change the "price" and add "remarks" for each line of the order;
• in an Internal GIN you can only add "remarks". The price is calculated automatically basing on the value of the item;

The minimum requirements include phone, tablet or collector with android system version 4.1 or advanced. To efficiently read bar codes, it is recommended to use the device that must have a camera in Full HD (1920 x 1080) with the Autofocus function or a built-in barcode reader. In the case of dark rooms, it is recommended to light the bar codes by the flash.

The application is downloaded using the Google Play platform. To download the product, click or run the "Play Store" on your phone. In order to download the application you must have a free Google Play account and run the "Play Store" on your phone:



After approval, we select "LoMag Warehouse online + MSSQL" from the list and press the INSTALL, ACCEPT and OPEN button:



2. Configure the Connection of the Android Application to the LoMag Database

• in an Interbranch Transfer the program shows current stock levels of the chosen item in the source and target warehouses. You can perform a transfer to several different warehouses on one Interbranch Transfer document, by choosing a different target warehouse for each line. If the item is not on the item list at the target warehouse, the program suggests copying it from the source warehouse. The value of the item is not altered as a result of being moved to another warehouse; You may also transfer an item within the same warehouse - by using the "Warehouse locations" option.
• in a stock level correction you can type in a new stock level and any remarks you might have;

The LoMag database uses Microsoft SQL Server 2005 or newer libraries. In order to establish the connection between Android device and the database, these libraries must be installed and configured accordingly. The easiest way to do this; is to use Windows for LoMag. The program installer automatically installs and configures Microsoft SQL Server libraries on your computer. If we already have LoMag for Windows, then run 'Settings', move towards the network tab and select the third option. The computer acts as an "Authentication SQL Server". Please note the server name from this window:


• in Discounts, you may enter a new quantity or value, and you can also change the name of the item. Discounts introduce modifications not only of prices, but also of quantities of individual items. Therefore, the application can take into account the following example situation: 10 multi-packs of water were received. 2 multi-packs were unpacked and individual bottles were sold with a new price. After entering this discount, the stock level of "multipack of mineral water" will decrease by 2, while the stock level of the item "bottle of mineral water" shall be increased by 12;

If it was a standard LoMag installation along with SQL libraries, you do not need to change the login and password and other parameters. The LoMag program will automatically make the database available on the network, open the firewall port 1433 and confirm the completion of the configuration as below:

In the windows for adding items to a document (apart from GRN and GIN correction) in the "Preview and selection of receipts" part, you may determine precisely a concrete receipt from which the item is to be issued.

Editing and removing documents

If at this point the program displays a message that the settings can not be changed, you must reinstall the SQL libraries or manually configure the SQL server to make the LoMag database available to the network. In case of problems, please contact us at service@longint.pl

After configuring the access to the database, we can run the application on Android and enter the name of the server that we noted earlier:

The program enables you to modify the existing documents. You may find a document which needs to be repaired or corrected. You should be particularly cautious when changing the quantity of items on archival documents - you cannot remove an item which has been issued on subsequent documents. Similarly, the program will not allow the removal of documents, from which at least one item has been issued.

It is worth to mark the "save settings" and do not enter the server name again in the future. In addition, connect the device to the WiFi network. Press the "Connect" button:

After a few seconds, the login window should appear in front of user screen, only if the administrator has given some access, otherwise LoMag window will be opened.

An open document allows you to check the history of warehouse transfers for each of the items on the document (the "History" button on the tool bar over the list of items or "Alt-H"). The "To Excel" button enables the transfer of the list of items from the document to a chosen Excel file. The table may be freely adjusted by right-clicking any column and selecting the "Manage columns” option. The program remembers the chosen settings, and it will recreate the column layout when generating a new document.

If at this point the program displays the message that there is no possibility to connect to the database or logging in takes more than a minute, check the following:

7.Inventory

• It happens that anti-virus programs block access to the server. Please turn off the firewall and antivirus program for a moment and try again.

The information entered into the program may differ from the actual stock level for various reasons. Therefore, from time to time you should make an inventory of the warehouse. It often happens that making an inventory is a long process which blocks the operation of the warehouse. In view of facilitating and accelerating inventory-making, LoMag features "Inventory sheets".

Inventory sheets

• Press the search button next to the server name and check if the application finds the server behind the SQL database
• Try to use the server's IP address instead of the name.

2.1. Checking the server's IP address

To create a new inventory sheet, go to "Documents/Inventory/Inventory Sheets". The program will display a list of the already existing inventory sheets. To add a new sheet, click "Add" or use the "Alt+D" shortcut. You may also edit the existing sheets or remove them completely.

You create inventory sheets just like all other documents, by adding items and their current quantity on stock. The possibility of generating several sheets at the same time, which may be later joined into one big inventory, constitutes a great advantage of the inventory sheets. If the same goods may be found in two locations at the warehouse and they are featured on two inventory sheets, the program shall sum up the quantities from those sheets.

In the console window, enter the ipconfig command and press enter. The IP address assigned to the corresponding network card will be displayed. If we have several cards and have been configured correctly to connect with the network, then the ipconfig command will display all currently available IP addresses.

2.1.2 Checking the IP address in the network and Internet settings

To display the settings window, right-click on the taskbar in the Internet connection icon (Wi-Fi) and select the Open network and Internet settings option.

There is also a possibility of stretching the inventory-making over time. If the warehouse contains inactive items, you may create an inventory or inventories including the inactive items several days earlier, and then merge the sheets into one inventory. If, however, one of the inactive items has been issued form the warehouse, you may make a correction on the sheet before creating the inventory (the "Edit" button on the inventory sheet list).

The above operation will display a new window of settings in which the option to 'view network properties' should be selected.

In the network properties, find a connection named Wi-Fi and then read the value for the IPv4 address parameter in order to know the IP address of our computer in the network.

2.1.3 Connecting to the server using the IP address

The inventory in LoMag does not have to pertain to the whole assortment - if some of the items are omitted, the program will not change the stock levels for items not included in the inventory sheets. Therefore, you may execute a partial inventory, including only a part of the assortment. In case of a partial inventory, the omitted items and their stock levels may also be accounted for on the documents and set to zero balance.

Making an inventory

Knowing the IP address of our server, enter it manually in the field Server name, the second option is to search for all available IP addresses in our network, and then select it from the list - you can do this by clicking on the search icon.
NOTE! We can configure internet networks in various ways. Sometimes it happens that after restarting the computer it will get a different IP address than it had previously. In the event of a connection error, check the current server address as shown in the instructions above.

2.2 Configuring the Firewall

To make an inventory basing on inventory sheets, go to "Documents/Inventory/Create new inventory". Mark the sheets on the basis of which you intend to make the inventory. Then click "Create inventory from the marked sheets". After this operation the program shall correct the stock levels and display a report with the results of the inventory. The report includes information about the stock before and after the inventory, as well as information about the value of the warehouse before and after the inventory. The final result is presented at the bottom of the window - a total of values before and after the inventory. The final report may be printed or exported to Excel.

By default, Windows has the enabled firewall function. The task of this software is to filter outgoing and incoming data to a computer via a network or the Internet. It may happen that the program will block connections for the device with the android application. The following step shows you to configure system firewalls for Windows 10 and 7.

2.2.1 Configuring the Firewall in Windows 10

An inventory may also be created on an empty document, by adding items to it one by one (while omitting inventory sheets); and basing on the current stock level, where you can change item value by clicking "Edit".

There are several ways to run firewall settings in Windows 10, this manual will present the easiest method, in which you should use the search engine for Windows, located in the menu bar, and then enter the phrase 'firewall' in the search option.

The Inventory removes all the differences between the stock level in the program and the actual stock level on the sheets. It is achieved by adding the stock correction document. The correction may be previewed in "Documents/Stock level corrections". The program inserts "Correction generated automatically through inventory" in the remarks field. You can find a list of items for which the stock levels have been changed below.

Inventory correction

Find the advanced settings item and start it.

With the standard installation of LoMag software, the Windows 10 firewall usually does not create rules so that the SQL database can accept external connections. For this purpose, in the Windows Defender settings for 'inboound rules', set a new one as shown below;

In the new rules wizard, select the program option and then press the next button.

An inventory may be corrected or removed completely. To remove an inventory go to "Documents/Inventory/Backed up inventories". Select the inventory you wish to remove and click "Remove". The removal of the inventory causes the removal of the stock level correction and results in the restoration of the warehouse levels from before the inventory. The removal of the inventory does not affect the inventory sheets - you may create an inventory again basing on the same inventory sheets.

If you've marked the wrong sheets while making the inventory, the easiest thing to do is to remove the inventory and redo it marking the correct inventory sheets.

The default installation of LoMag and its SQL database allows you to enter values ??in the path of the program '%ProgramFiles% (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Binn\sqlservr.exe' - if you installed the SQL database in a different location, you must use the browse button and find the appropriate application on your computer's hard drive. To go to the next step, click Next.

If you wish to correct only one or several items from the inventory, you may do it by editing the appropriate stock level correction. ("Documents/Stock level corrections"). To print the final inventory report again, go to "Documents/Inventory/Backed up inventories". Next, select the inventory from the list and click "Edit".

Opening Balance

In order for applications from the android system to be able to connect to the computer, you must allow the connection by selecting the first option in the next window and confirm the decision with the Next button.

If an item sheet which hasn't been on stock before is added, the program activates the "Price" and the "Value of item" fields. It happens because the program does not know what price to ascribe to the item. You should fill in these fields or leave a zero, if you wish to receive this item on stock with the purchase price amounting to zero. You introduce the "opening balance" in this manner, when commencing work with the program.

In the next window, select all applications for the rule (set by default) and go to the next configuration step by clicking next. The last step is to enter the name and possible description. By clicking the save button, our filter will be added to the incoming rules for the Windows 10 firewall.

In this way, the position configured by us for the program with the specified location path has been added to the list of incoming rules

In the same way, add a second rule for the program with the path % ProgramFiles% (x86) \ Microsoft SQL Server \ 90 \ Shared \ sqlbrowser.exe by setting only another final rule name. Adding these two rules will enable the LoMag application for the android system to connect to the server with the still active firewall for other malicious software.

2.2.2 Configuring the Firewall in Windows 7

Item libraries were added to the program to accelerate the creation of similar documents. They are templates used for quickly preparing documents basing on a previously defied list of items with quantities. To create library, go to "Items/Item libraries". After clicking "Add", define the library name and its code (it may be a barcode). Next, you may add the library components - the list of items with quantity. For instance, a library may be called "daily fruit delivery" and include 30 kg of apples, 10 kg pears, 10 kg of bananas. With a library defined in this manner you are able to very quickly prepare a goods received note by selecting a ready template from the list. There is no need to list the same items and quantities everyday. Of course, you have the possibility of correcting the automatically added entries - you may, e.g. remove the bananas or change the quantity of pears.

In the Windows 7 operating system, there are two methods for adding a rule so that the program can connect through the firewall. The first simplified way is to go to the control panel by clicking in the lower left corner of the start menu screen and selecting the Control Panel option. A new window will appear, in which you should click on the word System and security.

In the next window, use the 'Allow programmers to access via Windows Firewall' button.

The libraries may be used in the following types of documents: GRN, GIN, Internal GRN, Internal GIN, GRN correction, GIN correction. The library may be chosen from "Items", a drop-down list which can be found in the window for creating order elements The names of the libraries are on the top of the list over the items. If you select quantity [1], all items and quantities from the library will be added. Selecting quantity [2] will double the contents of the library - so continuing with the above example - it would be 60 kg of apples, 20 kg of pears, 20 kg of bananas.

Find the program you are interested in on the list and select the option of connecting to the selection field by passing the firewall for the selected network. If the program does not exist on the list - you can add it by clicking the appropriate button, which will open another window with a list of available programs. You can also enter its exact path on your computer's hard drive by using the browse button.

You can open the same window to add a new connection more quickly. By clicking on the start menu, then in the search field enter the firewall and click on the option 'Allow the program to access through the Windows firewall'.

The employment of libraries in the issue notes (GINs, Internal GINs) requires a comment. Let's say you want to issue the whole of the library, but one of the items is not on stock. The program will not allow such an issue. In this situation you may check which item is missing from the library and what the current stock level of the library is in the "Items/Item libraries" menu. Below, you will find examples which will facilitate the understanding of library stock levels basing on the example above:

• 30 kg of apples, 10 kg of pears, 10 kg of bananas, LIBRARY STOCK LEVEL = 1

The second way to add a rule to the firewall in Windows 7 is to click on the Windows Firewall option in the system and security window.


• 60 kg of apples, 20 kg of pears, 20 kg of bananas, LIBRARY STOCK LEVEL = 2
• 60 kg of apples, 20 kg of pears, 0 kg of bananas, LIBRARY STOCK LEVEL = 0 , because the bananas are outstanding
• 60 kg of apples, 20 kg of pears, 10 kg of bananas, LIBRARY STOCK LEVEL = 1, quantity of bananas decides about the library stock level

The current firewall status and connection properties with the current network will be displayed. We can enable or disable the firewall by clicking the appropriate button on the left. To go to the advanced firewall settings, select the last option on the left side of the menu.



Performing the above operation will allow a user to start a window from the firewall configuration instructions for Windows 10. Check whether the settings for the rule are correct or in the absence of it, add it in the same way as in Windows 10.

Please note the possibility of employing the "Item library" module in the process of assembly. Creating a library with properly defined components needed for the production of the final product will streamline the whole process. Furthermore, the library will allow you to easily determine how many ready products can be made from the existing raw materials.

9. Find option

3. Description of available functions in the Android Application

The find option may be launched at any given time with the CRTL+F shortcut. You may also select the "Items/Find" option or click the button on the tool bar. The find window comprises of 3 tabs "Items/Documents/Accounts":

Finding Items

In the next step, we choose the warehouse in which we will work. If we have only one warehouse, the following warehouse selection window will not be visible.

In order to find a given item you need a fragment or a few fragments of its name. If you have an item called "LCD PLE2607WSD-B1 2ms" on stock, you can find it by typing in "LCD 26 2ms".

The following is a view of the main application menu of the Android application after logging and selecting the stock level option. Some options may not be available in the menu if a given user does not have defined rights to a given function:

3.1 Menu and Stock level Finding

All search criteria narrow down the results (conjunction). For example, if you type in only a fragment of a name, e.g. "car", the program will find all items which have "car" in their names: "carrot, carp, caramel". If you additionally mark "vegetables", the result of the search will be only "carrot". The remaining fields also narrow down the results - if you additionally select "Stock level>0", "carrot" will only come up, if it is on stock.

In this window you can search for goods by barcode or fragment of the name as shown below. By clicking on the code icon, we can scan the product code to find the product precisely.

In order to add a new product to the warehouse, use the 'Add stock item' button to display the window as shown below.

The search engine also allows you to search for items in all warehouses. If you mark the "find in all warehouses" and item = "carrot" and "Stock level > 0" the program will display a list of warehouses in which you have carrots on stock. The table will show the stock level in each of the warehouse, the price of purchase and the value of the stock.

All mandatory parameters for the new product should be filled, additionally we can manually or automatically (by clicking on the scan code icon) add the product code and clicking on the camera icon, which launch the camera in the phone to take a photo for the product. After filling in all the data, clicking on the save icon, which will add the product.

If you mark the "Items/Find/Low Qty Threshold" field, the program will find all the items the current stock levels of which have reached the minimum values set in the item list. The minimum value for each item is defined separately - e.g. it may be 100 kg for potatoes, and 10 kg for bananas. If there are only 9 kg or less bananas left, the item will be placed on the list of products which reached the low quantity threshold.

In order to edit existing goods in the warehouse, we click on the 'Edit' icon, which will display the editing window in which we will be able to correct the wrong data for the selected product. To delete goods, click on the delete button.

If you mark the fields "Items/Find/High Qty Threshold", the program will find all the items the current stock levels of which have reached maximum values set in the item list. The maximum value for each item is defined separately - e.g. it may be 10 000 kg for potatoes, and 1000 kg for bananas. If there are 1001kg or more bananas left, the item will be placed on the list of products which reached the high quantity threshold.

On the tool bar, over the results list, you have the possibility of viewing the history of warehouse movements, adding or editing items, exporting the result "to Excel", printing the labels, and setting the mark-up simultaneously for several items - by clicking "Change" .

Finding documents

After choosing the option to remove the item, the LoMag application for Android will show the window presented below. In which you should mark the boxes for the goods that we want to remove from the warehouse, and then in the bottom right corner click on the remove icon. In order to withdraw from the selected option - you can always go back to the previous window using the back arrow in the upper part of the window.

The document search engine also works on the basis of narrowing down the results with various criteria. You can enter a fragment of a name into the text fields, e.g. if you enter "123", you will find in your results: "GRN 123/2010", "GIN 123/2010". If you additionally select "GIN" as a criterion, only "GIN 123/2010" will come up as a search result.

ATTENTION! All actions performed in the LoMag application are constantly updated in the database on the computer and vice versa - this is due to the fact that the programs connect to the same database. This means that if, for example, we remove a product from the magazine on the phone - it will no longer be visible in the LoMag warehouse program on the computer.

4. GRN and GIN documents

The default setting of the search engine displays only documents form the current warehouse, but you may also search in all warehouses, simply mark "Find in all warehouses".

In order to issue a GIN or GRN document, you must click on the documnet icon in the application menu of LoMag. The description of issuing documents has been presented by considering the example of GRN, the GIN document is issued in the same way as in the example below.

There is also an option of finding documents in which a given item with a given name has been used. To do that, you must select the name from the list or scan the code of the item in the "with the barcode" field.

To add a product to the document, first select the customer by entering its initial name and selecting it from the drop-down list shown. If you want to add a new client, click on the 'Add' icon LoMag.

Please note that the field "Remarks include" will help you find documents in which the searched text may be found either in the remarks to the whole document, or in the remarks to one of the lines of the document.

Finding Accounts

The above action resulted in displaying a new window in the LoMag application in which you must define data for the new customer. After entering all mandatory data, save the settings by clicking the save button.

You can find accounts in the same way - enter a fragment of the account's name, the name of the contact person, the Tax Identification Number, or the phone number and press Enter or click "Find". When entering the Tax Identification Number you do not have to worry about spaces and dashes - the program will find the account irrespectively of how you enter the number.

10. Reports

The next step is entering the document number (it can be left unchanged - it will be given the next number according to the numbering template set in the LoMag software). The application user also has the option of entering comments for documents. By clicking the add icon, a window will open, in which you can add goods to the document.

All reports are supported in a similar way. You mark the period to which the report is to pertain, or set the exact dates below . You may select filters from the drop-down lists, which narrow down the results (conjunction).The results of each of the reports may be printed or exported to Excel. Below are the most important reports and examples of their employment:

"Reports/Documents in active warehouse” – examples of reports you may obtain:

• A list of all GRNs from a given year / quarter / month from a given warehouse. A total value of the documents can also be found at the bottom of the report
• A list of GINs for a given customer in a chosen period and the total value of sales
• Documents for the largest and the smallest sum in a given period (you may sort through the results by clicking the "value" column).

"Reports/Documents in all warehouses":

• A list of all GRNs from a given year / quarter / month from all warehouses
• With the common numbering for all warehouses you get a sorted through list of all documents and their values

• Internal receipts and issues in all warehouses

"Reports/Stock levels in the active warehouse":

• Stock level on a given day for all items. Total value of items on stock
• Stock level and value of the warehouse on a given day for a chosen group of items and/or item unit
• Total amount of items for individual units: e.g. 123 kg worth X , 234 pcs worth Y

"Reports/Stock levels in the active warehouse":

• Stock level on a given day for all items with a detailed register of advanced options (e.g. document no., lot no., location).
• Stock levels on a given day for a chosen group of items.

"Reports/Stock levels in all warehouses":

• Stock level on a given day for all items in all warehouses . Total value of items in all warehouses.

"Reports/Expiration date":

There are two ways to add an item to a document. The first is to select the item by entering its initial name in the "Item Name" field, the second to enter the bar code - you can do it manually or scan the item code by clicking the icon. Both fields depend on each other, which means that filling one will fill the other. Enter the quantity of the received goods, price or value (the fields will be automatically calculated after entering at least one value). The current status field informs us how much goods we have in the current warehouse before accepting the document. Additional options are enter the expiration date for the item (to disable this option, uncheck the box), enter the serial number manually or via a scanner, and place comments for the item.

• Expiration dates for all items on stock at all warehouses.

"Reports/Items for an account":

In order to add another item to the document, click on the 'add' icon, which will display the same window that is currently open - in order to configure the addition of another item to the document. Once the document is ready and we want to save it, use the 'save' icon.

In the same way, we can generate GIN documents.

• A list of items issued to an account in a given year / quarter/ month. A total amount and value is shown for each item. If the same goods have been issued several times on different documents to the same account, the program sums up the amount and the value. A total of the value of all of the items may be found at the bottom of the report.

5. Review and Editing of Existing documents in the Database

• Total amount and value of the items ordered from a given supplier during a given period (total at the bottom of the report)

"Reports/Item turnover":

When verifying our newly saved document in the fourth point of this manual, click on the 'document' icon in the main menu of the LoMag application on android. This will display all available documents in the LoMag application.

• Report on initial values and final values for a given period, account and item group.

"Report/Items by type and group":

• Total amount and value of items ordered in a given year / quarter / month
• Detailed list of all ordered items with total amount and value for each item (if you select "all groups")

• Total amount and value of the items sold in a given period (if you select "all groups" at the bottom of the report)

"Reports/Profit from sales - list of items":

In the edit window we have only the option of browsing the goods on the document and removing them. To delete a product from the document, click on the delete button.

• Profit (i.e. the difference between the selling price and the purchase price) for each sold item (if you select "all accounts")
• Profit on individual items sold to a given account and total profit for a chosen account (total sum at the bottom of the report)

In the case when the user of the LoMag application forgot to add a product to the document - it should be used in the document list by clicking the 'add' icon. This will open a window familiar to us from point 4 of this manual - in which it is possible to add missing items.


• Total profit in a given year / quarter / month (total at the bottom of the report if you select "all accounts")

6. Inventory

"Reports/Profit from sales - list of documents”:

• Profit (i.e. the difference between the value of sales and the purchase value) from individual warehouse transfers (documents).

To create a new inventory document, in the main application menu, click on the icon LoMag- a new window will be displayed in which you must enter the document number. In order to place the goods on the document, we use the add button.

• Total profit in a given year / quarter / month (total at the bottom)

"Reports/Warehouse transfer detailed report”:

• Total sales (quantity and value) for a chosen item in a given year / quarter / month (sum at the bottom of the report)
• List of warehouse transfers for a given item, barcode, account or group of items in a given period
• 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”:

• 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.
• 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":

Using the first option which is "Show goods that are not in inventory" will display a list of goods that are not currently included in the document, using the plus button will open a window with the possibility to add it with the filled name and barcode for the selected product.

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

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.

11. Users and authorisations

Using the second option, which is "Add missing goods with their current status", all items omitted by us will be added to the document along with their current stock. To generate a document, it remains the user of the LoMag application only by clicking on the save icon.

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

Choosing the third option, ie "Add missing goods with zero status", will add to the document all the goods we have on the current warehouse with the state 0. Differences between states are highlighted in green. On the document below you can see in the summary that the old value of current states in the warehouse is 1405.00 and in the document that we want to generate will be 1.00, the same applies to the summary of the value of goods.



By saving the inventory document, you can view it and edit it in the documents section. You can find it by sliding your finger on the Android display, or by using the search engine by entering its name or fragment. To view the document, click on the edit icon. You can delete or add items to the document by using the add and delete icons, respectively.

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.

7. Transfers between Warehouse and Warehouse Change

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.

In order to transfer the item from the currently opened warehouse to another, the owner of the LoMag application must use the 'Interbranch transfer' icon in the main menu. The implementation of the above guidelines will open a window in which, as a standard, we must complete the basic data, including the document number. The most important step is choosing the warehouse to which we want to move the goods that we can specify using the add products button. In the example below, we chose an archive magazine that is supposed to hit 1kg of lemon.
In the window of adding goods a preview of deliveries for a given product is displayed. In order to add another item which is to be moved to another warehouse, use the add button, after entering all the goods that are to be transferred to the archives, click on the save.

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.

If the item is moved to a warehouse where it does not exist, a message will be displayed if we want to copy its file from the current warehouse. Use the yes button.

7.1 Changing the Warehouse in the LoMag Application

To change the currently open warehouse, in the main menu, click the back arrow icon in the upper left window of the application. Performing the above action will cause the LoMag application user to be withdrawn to the possibility of selecting another warehouse. In our example, the productS was moved to the archives and displayed below.

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

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

8. Application Settings

Using the setting icon in the LoMag application, the LoMag user on the Android operating system can go to the application settings.

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.

Documents editor

To enable / disable serial number options and expiration dates for a product, go to the settings window in the LoMag software using the computer platform in the main tab named documents select or deselect the option to use this function.

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

In order to view the changes in option to be noticeable for users of the LoMag application in the Android app, it is necessary to connect to the database again, otherwise the user will always use the old settings. To do this, you can close the application using the power button in the upper right corner, and then restart the application on your phone. Or retreat to the main settings window by clicking the back arrow button several times.

Carrying the database over to another computer.

The effects of enabled or disabled option for handling batch numbers and expiration dates are shown in the screenshot below.

10. Warehouse Locations

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

The commissioning and configuration of storage locations are described in the previous manual. The following section will only show you to use this function in an Android application. If you have made changes to the software on your computer while using the application, you must re-log in to make them visible. When you issue an admission document, you can see a new field called Storage location. You can manually enter an existing location, or define a new one using the plus icon.

By clicking on the Save button, the new location will be automatically added to the SQL database of the LoMaG software with which we are connecting and supplementing the storage location with the new value.

11. Support for Serial Numbers in the LoMag Application for Android

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:

To start servicing serial numbers, display the LoMag settings window by clicking on the settings icon. The next step is to switch tO the items tab, in which you have to select the option "Serial number support" and selecting from the drop-down menu one of two options of uniqueness Global or For commodity. The following instruction is presented for the Android system - in order to read the general instructions for serial numbers, please use the previous instructions.

"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.

The LoMag application for Android supports the function of serial numbers on an 'always or never' basis - this means that the operation on old goods (eg downloaded from a computer database or added without the N / S support function enabled) will not work, and goods that we added on the Android system with serial number support enabled - will work properly.

"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".

"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".
When issuing an acceptance document for a goods warehouse that existed prior to the serial numbers function activation - it will not cause any changes in the view and the way of entering the goods. The situation is different when the N / S function is on and we add the item to the file for the first time. Changes in the functioning of the application will be seen when we want to issue an acceptance document for exactly the same product - for example, we added a 'orange' product to the warehouse. When you try to save the item on the document or attempt to go to the next one, a window will be displayed in which you must enter the number of serial numbers we have declared in the document.

"Settings/Documents/Support for serial numbers” - reception and issue of items with a unique number ascribed to each piece. You may also upload a serial number by importing data from Excel and a collector.

To enter N / S, enter its value manually in the text field or use the code scanner on the scanner icon. Then the add button will be activated - pressing it will enter the number into the list below this button. The save button is not active until the user has entered the required number of serial numbers. The cancel icon is used to go back to the previous window - adding item to the document. We can also skip entering serial numbers using the last option on the list.

"Settings/Documents/Support of warehouse locations” - defining warehouse locations for a given item on warehouse documents. The same product may be stored in various locations, and there may be many products in one location. The locations may be defined from the level of the window for item receipt or in the "Items/Warehouse locations" module.

"Settings/Documents/Digits after decimal point” - prices are usually quoted with two digits after decimal point. There are, however, cases in which prices and values must be quoted more accurately. By changing this parameter, the user may determine with what accuracy are the individual prices to be displayed and printed on documents and reports.

To change the user permissions of the LoMag application to use selected warehouses, in the program on the computer, go to the Users module and select the same option from the drop-down list. A edit window will appear in which clicking the icon opens the possibility to modify user parameters. To change its access to warehouses, select or deselect the selected item, and then save the settings with OK. In the example below, we change the user's access to only have two warehouses.

Now open the android application, a login window will be shown:

"GRN $$$$$$/yy - MAG” (default numbering) - in each year and in each warehouse the numeration runs from the beginning, e.g. in warehouse 1: „GRN 000001/2010 - M1”, the next GRN in warehouse 2 will be numbered: „GRN 000001/2010 - M2”

In order for the changes to be visible in the Android app, you must log in again. To do this, use the back arrow, or restart the application, and enter the login data of the user for whom the changes were previously made. After logging in, you will notice that a given user has access to only two magazines.

"GRN $$$/mm/yy” - Separate numeration in each month and year, common for all warehouses, 3 spaces for a document number, e.g. in August "GRN 001/08/2010”, "GRN 002/08/2010”... In September „GRN/001/09/2010”, „GRN/002/09/2010”... independently of the warehouse.

12.1 Changing the Permissions for the Selected Role

„dok $$$/dd/mm/yy/MAG” - separate numeration each day and for each warehouse with a changed prefix, e.g. January 1: "dok 001/01/01/2010/M1”, January 2 „dok 001/02/01/2010/M1”, but January 2 in warehouse 2 will be "dok 001/02/01/2010/M2”.

14. Technical information

In order to change the permissions for the selected role, use the Users module on the computer and select Roles from the drop-down list. The next step in the newly displayed window is to select the name of the role to be modified on the left. In the previous section of this manual we used the account with the client log, which has the role of a warehouse keeper, therefore we mark this position again. On the right side of the window, you should select or deselect specific permissions that the role should have. In the example below, we completely removed the rights to modules for goods, reports and accounts. Click the OK button to approve the changes.

The program has been created in Microsoft Visual Studio and it operates on .Net Framework 2.0 libraries. It has been compiled as one EXE file, which is installed by default in the "c:\Program Files\LoMag\LoMag.exe” folder. LoMag operates with "Microsoft .Net Framework” libraries and "Microsoft SQL Server 2005” libraries, some reports also use "Crystal Reports” libraries. The program requires authorisation to save in the current folder. If you imposed limitations on user authorisations, you should grant full authorisation to the whole "user" group to the "c:\Program Files\LoMag” folder.

As in the case of changing access to storage, you must log in again to see changes in the application. After selecting the warehouse, you can see that the main menu of the application has been significantly reduced.