LoMag inventory management for Android

The list of documents in the module is empty; to display a full list of warehouse documents, click , and display the full list of warehouse documents in the LoMag database.

You can find documents in several various ways: with a text fragment, by specifying a concrete item and/or account, document type, or by typing in a fragment of a barcode, or remarks placed on the document. If you type in information in several fields, you will limit the spectrum of your search.

Guided by market expectations we've created an inventory management application, which can change almost any android-run mobile phone (tablet) into a professional inventory management tool. The app - useful for inventory-making and other logistic procedures at the warehouse - has been created in two versions: the limited free of charge version and the paid version, which has no limitation on amounts of items, documents and operations. The app has an inbuilt barcode reader, whose range of recognized code formats is comparable to a professional facility. The app may be used by all companies, and even individuals, who do not conduct any business activity.

For examplelet's find a GRNs of "John Kowalski" account, which includes "Carrots". Type in the information to the field (i.e., GRN), the field (i.e., "John Kowalski") and the field (i.e.,"Carrots").

1.The most important characteristics of the program:

• inbuilt barcode scanner employing the camera of a mobile device

If you employ several search criteria, you can considerably limit the spectrum of your search.

• stock level as at a given date and hour exportable to Excel
• warehouse documents: Goods Received Note, Goods Issued Note, Inventory
• adding items to documents by scanning codes or browsing the item list

The tool bar allows you to edit () and delete () warehouse documents. It also enables you to print () a document listing and to export it to () an Excel file.

• history of warehouse transfers for a chosen item
• browsing through warehouse history of documents and their content
• editing or removing the last warehouse document
• quick search of items by names or codes
• editing the item list, ascribing codes with a scanner
• adding own units of measurement and removing unused units
• changing the date of the documents (introduction of historical data)
• export of documents to Excel (including inventory)
• expanded inventory-creating options

2. Download and installation of software

You can freely configure the dialogue box of the module, e.g. you can manage the display of columns, change column names, etc. There is also the data filtering function; it helps you to quickly display appropriate documents matching the variants defined by you. This function is not used so often with documents, as it is with, e.g. items. To find out more about the configuration of the dialogue window go here, and then proceed to item 6.3 Tool bar, configuration and filtering of data.

10. OB document

The OB document includes items, which have been added and information about their initial stock level in the item list. When adding items to the module, you set their

The updated version of the application may be downloaded from the Internet from the Play Store at https://play.google.com/store or directly through the "Play Store" app available on your Android device. First, find the app by typing in "LoMag Warehouse Management", and then click "Install". The download and the installation of the app will start once you have accepted the terms and conditions of access to required data for the app.

3. Basic configuration of the program

To have a look at the OB document, you must go to the module, and then specify the document type as "Opening balance". The opening balance will be displayed as one of the options.

When starting work with "LoMag Warehouse Management" mobile app you should adjust the app to your preferences - to do that click "Settings" in the main menu.

To open and view the document, double click opening balance or use the icon.

Read below for the basic settings description

• Settings/Prices support- if you unmark this option, the app will not support the prices of items and you will be able only to conduct a quantitative register of items. When receiving and issuing items, the field for the determination of price for one unit will disappear.

The opening balance document includes information about the amount of items which was specified when the warehouse was being opened. You can correct the number of items and prices, once you open the document. When editing historical documents, you should remember, however, not to delete or decrease the number of items, which were issued afterwards.

11. Inventory

• Settings/Enter codes manually - if you mark that option, the barcode scanner incorporated into the app will not be used during receipts and issues. Barcodes will be entered manually from the keyboard or an external reader.

The actual number of items on stock may differ from the stock levels determined in the inventory management program - many factors come into play. For that reason, it is advisable to make an inventory from time to time.

11.1 Launching the inventory module.

The app has an incorporated barcode reader, which uses an inbuilt camera to automatically recognize the following barcode formats:

• codes on products : EAN-13, EAN-8, ISBN, UPC-A, UPC-E
• industrial codes: Codabar, Code 128, Code 93, Code 39, ITF, RSS
• two-dimensional codes: QR Code, Data Matrix

LoMag enables you to carry out an inventory of stock levels. The inventory wizard can be turned on in two ways. Method number one: go to in the part.

4. Start working with "LoMag Warehouse Management"

The second method for launching the inventory module is via the inventory icon on the tool bar of the program, which can be found in the main menu.

The above actions will result in the opening of the window, thanks to which you will be able to start the warehouse inventory.

11.2 Inventory wizard

is a module used for making a warehouse inventory. This process will result in the creation of an inventory document and a stock level correction document.

The wizard enables you to carry out the inventory in three ways:

• Making an inventory basing on the current stock level.
• Making an inventory basing on inventory sheets.

The app may support any number of items and warehouse documents (the free version of the app has a limit of 30 items or 50 documents). Once you launch, the main menu of the app comes up. Before you begin creating you can define the items in the "Stock level module". The defined items can be quickly selected on the document with a scanner or from a selectable list. If you don't define the items list at the beginning, the software allows you to supplement the item list when creating documents. Additionally, you should supplement the name and the unit of measurement for the item. When defining items, the inbuilt barcode scanner might prove helpful, as it changes you device into a professional barcode reader

11.3 Making an inventory on an empty document.

5. Stock level

This method enables you to create both a full and a partial warehouse inventory. In this case the inventory preparation starts with an empty warehouse document, to which the user adds items as their stock levels are corrected.

To create an inventory starting with an empty document select in the window, and then confirm your choice by clicking .

An empty inventory document will be displayed.

Stock level is a module of the item list used to define new and edit the existing items in LoMag Warehouse Management app. To go to this module select "Stock level" in the main menu. Once the stock level module is launched, a list of items will come up with the current stock level. You will also have an option of defining new items - by selecting the "Add" button - you define attributes such as barcode, name item unit. Read below for the meaning and application of each of those fields:

• A barcode may be any string of signs, not necessarily a concrete type of code. The field may also be used for other purposes, e.g. as a unique index, which will make item searching easier. By using the internal barcode reader module of the app, you can scan a barcode with the camera on your mobile to ascribe a given code to an item.
• A unit of measurement may be selected from the list or typed in from the keyboard. If a given unit of measurement is missing, it will be added to the database with the "+" button.

Let's assume that there was a discrepancy noted during warehouse stock-taking between the actual stock level and the stock level on documents. For example there were two items – carrots and potatoes. The warehouse keeper found 40kg of carrots at the warehouse, and the remaining potatoes on stock are not suitable for resale and further use. Let's conduct a partial inventory of those two items. In this case you should reduce the dependencies between the actual stock level and the inventory management program. Use the button, which will display the window of adding items to the inventory document.

• The name of the item should be unique, but the software allows the same names for items with different barcodes.

Next, select the item for which you wish to change the stock level - in this case it will be "carrots", for which a discrepancy between the actual stock level and the actual stock level was discovered.

The module also enables you to remove an item (or many items at once), to export an item to an Excel file, which then can be saved on the hard drive of your device or sent by e-mail. You also may edit any given item at any moment or browse through its history of warehouse movements. The history of warehouse movements depicts the changes in the stock levels since the last inventory.

Once you have chosen the item, the remaining fields on the form, including the current stock level of the item in LoMag, will be fill in. As you can see, this stock level does not correspond with the actual stock level; go to the field to correct the difference and enter the actual stock level for"carrots" ("40kg"). Next, approve the changes with the key, which will add the item to the document.

The item search field is located under the tool menu in the Stock level module. To find any item you need to enter a fragment of a name of an item, e.g. by typing in "ice" the program will find all items including "ice": "ice-cream, liquorice".

6. Warehouse documents

LoMag Warehouse Management mobile app enables you to create the following warehouse documents:

• GRN (Good Received Note), e.g. delivery of a new item to the warehouse,
• GIN (Goods Issued Note), e.g. sale of an item;

All receipts to the warehouse, which include a given item are displayed n the field. When changing the stock level, you can specify which receipt of a given item is to be decreased or increased. Find out more about how to manage the function here in item eight"Preview and selection of deliveries".

To create a Goods Received Note, you click "Receipt", to create a Goods Issued Note, you click "Issue". The icons can be found in the main menu of the application

During the stock-taking you have also noticed a discrepancy concerning "Potatoes". Proceed as you did with "Carrots". (Because the goods are spoilt, decrease the stock level - it will equal zero in this case).

The above items have been added to the inventory documents together with stock level corrections.

When you finish the inventory process, click . The program will request a confirmation of the conducted inventory.

After clicking the icon of the appropriate document, the document creation window comes up - the program automatically enters the current date and time of document creation and proposes a subsequent number. The program allows you to change the number into any random string of signs. It is also possible to change the data, you have to remember, however, to keep the chronology of the documents. When entering old documents, you need to start with the oldest ones and continue to the newest. Changing the date for an existing document influences the stock level and the value of the warehouse. The "comments" field may be used for notes regarding the whole of the document.

Click to approve the inventory. Next, in case of a partial inventory, i.e. not including all items on the document, you will be asked if tithe outstanding items should be added to the document with their stock levels set at zero (see below).

If you select , the remaining items will be added to the document with 0 stock levels (see below).

To skip the remaining items in the inventory, click .

You will be informed about the confirmation of the inventory and the module, which includes information about the stock level and value of items before and after the inventory, will be displayed.

The correction document () will be generated simultaneously with the inventory process.

To add an item to a document, click "Add items". Then the barcode scanner turns on to scan the first item. If the "Enter codes manually" setting is on, the window for adding the first item to the document appears, where the barcode may be typed in from the keyboard or chosen from the list. Next, in both cases you enter the remaining information about the product ("The name", "Quantity" and "Price" (available if your warehouse is conducted with the "Price support" option on). "Name" may be automatically downloaded from the item list, if the item was previously defined in the menu ("Stock level"). After adding one item, you can move on to the next one, or finish working with the document.

The inventory document can be found with the use of the module. Find out more about how to find warehouse documents in the module here in item 9. Finding documents.

11.4 Making an inventory basing on the current stock level.

Creating an inventory basing on the current stock level also enables you to create both a full and partial warehouse inventory. However, this method is characterised by commencing with automatic addition of all items to the document with current values.

You can browse through the contents of all created documents. There is a possibility of modifying only the last created document - adding a new item and deleting the document. To edit or delete a document, go to the "Documents" module in the main menu. Next, by clicking the document, go to the document preview. If you click "X", located by the document, you will remove it, while if you click the icon with the pen, located by the document, a new item will be added to the document. If you go to a concrete document (by clicking it in the "Documents" window), you can export the document to an Excel file.

To create an inventory basing on the current stock level in the module, select the option, and then click .

A document with a full list of items available at the warehouse will be displayed.

To execute the correction of the stock level of a given item, click its row in the document, and then use the edit function ().

For example, there was a discrepancy noted between the actual stock level and the stock level on documents for "Oranges" - mark "Oranges" on the document, and click the tool, which is located on the tool bar of the document module.

Next, type in the new stock level (e.g., 100 kg) for this item to the field and approve the changes with the key.

For various reasons, the information introduced to the program may be different from the actual stock level. Therefore, from time to time a warehouse inventory is needed. To that end a special inventory module has been created, available in the main menu of the app. After clicking "Inventory" you will go to the widow for creating an inventory document - the program automatically enters the current date and time of the creating of the document. The whole inventory-making process is analogous with the goods received and issued notes. However, when ending the inventory, before you save the stock level changes resulting from the conducted inventory, you will be asked again for a confirmation of the operation.

Once you have made the changes in stock levels, approve the inventory with the key. Just like with the inventory based on an empty document, you will be asked to approve the conducted operation of stock level correction.

If an inventory is finished with some items missing on the inventory document (but available at the warehouse) the app will propose 4 options for the conclusion of the inventory:

• Show items which are missing in the inventory
• Add the missing items with their current stock level
• Add missing items with their stock level at zero

After you have approved the inventory, a correction document is created, which accounts for the executed changes. The remaining items and their values have not been changed.

• Cancel the inventory

The last stage is "Inventory confirmation" and a report of differences in levels and values before and after the inventory. This operation changes the stock levels and the course of the warehouse movements history (subsequent documents change the level from the last inventory).

As you see above, only the value for "Oranges" has been changed. The remaining items have not changed their stock levels, although they have been accounted for during the preparation of the inventory. The correction document is created along with the inventory document ().

8. Database backup and deleting existing data

11.5 Making an inventory basing on inventory sheets

The LoMag Warehouse Management app has functions allowing to manage the whole database. They are available in the app settings:

The third option for the execution of an inventory at your company involves inventory sheets. This method is useful, if you are conducting the inventory using various methods and many people are checking individual stock levels and introduce changes to them.

• Create backup copy - this function allows you to create a copy of the whole app database. It is used to copy all the data introduced to the program to 1 file. We recommend regular creation of database backups. This function may also be useful if you wish to transfer the database onto another device or recreate the data status from a few days back.

To create an inventory basing on inventory sheets, first you have to create inventory sheets and then proceed to the window. If you do not have inventory sheets, it is not possible to prepare an inventory in this way.



To create an inventory sheet in LoMag you have to go to the main menu, to the part, and then proceed to and . The window will be launched.

• Restore backup copy - this function allows you to upload the database backup copy, created with the function described above. Use it of you wish to restore the previous database, e.g. from several days before or to transfer the database onto another device.


Next, use the button to create a new inventory sheet, in which you add items with stock level corrections.


• Settings/Remove unused units - this option allows you to remove units of measurement, which are no longer used in your warehouse register. You can also use it to remove units entered by mistake, not related to the items anymore.

Adding items to the inventory sheet is just like adding items to the inventory document, or any other document in LoMag.

• Clear data - the database formatting function: deletes all items and documents forever. Do not use this function if you have not backed up you data. Restoring data without a backup copy is impossible.