Accounts - instructions

LoMag enables you to select an account on each of the documents. An account may be another company, a co-worker, a department of your own company or an institution with which you wish to associate documents. The account support is optional - after it is switched off, the account selection field will disappear from the documents.

1. Suppliers, Customers, Employees

There are three types of accounts in LoMag:

• Suppliers
• Customers
• Employees

The types of accounts were created so that you could separately register given warehouse processes. Different types of accounts go with each warehouse document. The supplier is used on GRNs, the customer is used on GINs and Interbranch Transfers, and the employee on the Internal Goods Received and Issued Notes.

To start working on the first type of accounts - the supplier - you must launch the module responsible for managing this type of account. To launch the module, go to the main menu of the program and select . The window for managing suppliers will open ().

In this module, you will find a list of accounts defined as S for Suppliers, as well as the tools necessary for managing these accounts. The interface allows you to add (), edit () and delete () accounts. The module also allows you to display the history() of the accounts, as well as to print () and export () the list of accounts. With the help of the function you can display various types of accounts, and thanks to the tool you may freely manage the accounts table.

To add a new account to the database, click on the tool bar, which will launch the module.

You will find a series of fields to be filled data about the accounts in the interface of the window. In view of better identification (description) of the account, it is advisable to enter as much information about the account as possible.

To add a new account to the program database, enter their name and surname in the field. The field may also be defined in another way (e.g., by entering the name a business partner's company). Next, you determine the type of account. You have three options: the customer (), the supplier ) and the employee (). Each account may be ascribed to one, two or all three types of these groups. To assign a given group to an account, mark for a given account field - so if you want a given account to be defined as a customer, a supplier and an employee you should mark () all these items. If, for example, you want it to be only a supplier, mark the field, and leave the remaining fields unmarked ().

Enter data regarding the account - to do that, you will need and parts of the interface. Enter the street, house number, city, postal code, telephone number, etc.

You will find the field in the lower part of the module, where you can enter the account's Tax Identification Number and National Register of Business Entities (REGON). You will also find the field there, into which you can enter additional information about the account.

After you have entered all the data, click to save the account in the program. The window will be closed, and the newly added account will be displayed in the window.

If there is a need to edit any account, left-click it on the accounts list (in the window), and select the function from the tool menu. A window for editing data regarding a given account will be displayed.

The function, which is for deleting an account from the database, works analogously.

• If a given account is used on warehouse documents (transfers), you cannot delete it from the database of LoMag.

The module enables individual verification of warehouse transfers for each of the accounts. To check the history of warehouse processes you should click a given account and then use the button - the dialogue box will be launched.

The interface of the window will show all warehouse transfers (warehouse documents) for a given account. Each transfer may be recovered (edited) with the use of the button located in the upper part of the interface. The history of the transfer may also be printed () and saved as an Excel file (). In the upper part of the window you can find an option of moving directly from one account to another (see below).

Let us close the warehouse transfer window (). The function in the module allows you to go between all types of accounts (see below).

After selecting an appropriate filter in the window, the corresponding type of account will be displayed.

The module enables you to generate and print an address label for the account by pressing the button.

More information about warehouse labels - creation, generation, printing can be found in the "Label Designer" instructions, here.

The modules regarding customers and employees as accounts are located in the same place, as for suppliers. To launch the "customer" accounts module, go to the top menu and select .

An analogous mechanism operates for employees. To launch a module for those accounts select from the menu. Further actions regarding employees in the window are executed in the very same way as for the previous type of account, i.e., supplier.

2. Account history

The module, which we have already discussed in these instructions, could also be launched via the main menu, by selecting .

To select the history of warehouse transfers for a given account, select it from the field.

Once you have selected an account, all warehouse transfers (warehouse documents) for the selected account will be displayed. The tools described previously will enable basic operations regarding warehouse transfers history management.

3. Account balance

Account balance in LoMag inventory management was created for an easy and transparent overview of the quantity and value of items for a chosen account over a given period.

To go to account balance select from the main menu.

After you have selected the interface of the window will be displayed. You will find a series of options in this module which will help you display the desired listing of quantity and value of items for a given account at a given period.

Let's find out how the balance works on a concrete account, let's check the detailed balance for John Kowalski from the 4th quarter 2013, regarding items from the group of "fruit". First, select the account from the "Select account" drop-down list.

After you have selected the account, you will have their whole item listing displayed.

You are interested in the balance from the 4th quarter 2012, so next you have to go to the field of "years, quarters, months", which you will find in the left-hand part of the module, next mark the field. After you have marked the field the balance of the account for the 4th quarter 2012 is displayed.

Let's say you are only interested in the balance for the "fruit" group - select "fruit" from the "All groups" field.

Once you have selected the group, only a listing of items from the "fruit" group for John Kowalski from the last quarter 2013 is displayed (see below).

To have an even more detailed balance for a given account, you can use the search tool in the " Results" part.

You can look into the details of the balance and you an also print it () or export it () to Excel. In you can also display a balance for a given item, e.g., "Apples" as well as check the balance for a more detailed period.

FIRMA HANDLOWA EWA MAKULUS - Ścinawa

FIRMA HANDLOWA GEPARD ŁUCJA KULIKOWSKA - OLSZTYN

Firma Handlowa Jacek Florczak - Kutno

FIRMA HANDLOWA JAREK TATIANA PASIERB - Pikulice

FIRMA HANDLOWA JERZY WAŁACH - Kraków

Firma Handlowa Kampol Kamiński Jacek - Brodnica

FIRMA HANDLOWA keke.net SYLWIA ŻABIEREK - STARE MIASTO

Firma Handlowa Krzysztof Szzczepaniak - Nowe Skalmierzyce

FIRMA HANDLOWA 'LIMONKA' ILONA OCHMAN - DĄBROWA GÓRNICZA

Firma Handlowa Lucyna Kozij - Gdańsk

Firma Handlowa LuxItalia Agnieszka Szulc - Tarnobrzeg

FIRMA HANDLOWA MACIEJ - OTWOCK

Firma Handlowa MAR-DECO Marcin Krzymowski - Gdańsk

To check who was issued which tools, go to the "All groups" field, and select the "Equipment" group. The window will display a register of all the received and issued tools.

Firma Handlowa Maria Soska - Zakliczyn

4. Importing accounts from Excel

Firma Handlowa Melissa Ewa wyrodek - Nowa Ruda

FIRMA HANDLOWA PAMILZBIGNIEW ZARNOWIECKI - SZCZEKOCINY

Firma Handlowa Paweł Grygiel - Końskie

Firma Handlowa Radosław Jaczewski - Olsztyn

Firma Handlowa Renata Brzostowicz - Poznań

FIRMA HANDLOWA SIM Sklep Motoryzacyjny - Witkowo

In many parts of LoMag there is a possibility of importing data from Excel files, e.g. in the parts regarding items. There is also a possibility of importing external data for accounts. To import a list of accounts from Excel you need to use the function, which you will find in the menu.

Firma Handlowa SZYK, Marian Piotrowski - Dębica

Firma Handlowa Teresa Skrzypek - Gdańsk

FIRMA HANDLOWA TOP BABY S.J. - PABIANICE

Firma Handlowa VRM Mariusz Krawczyk - Piekary Śląskie

Firma Handlowa Waldemar Maliszewski - Kraków

Firma Handlowo - Usługowa ALEKSANDRA Magdalena Rocińska - Dębica

FIRMA HANDLOWO - USŁUGOWA DAMIAN STAŃCZYK - ŚWIERZNO

The module will be launched. To import a list of accounts from Excel, first you must select and upload a file, which is located on your hard drive - use the button (located in the upper port of the interface).

Firma Handlowo - Usługowa MASSIMO II MATEUSZ GRYCHNIK - Wodzisław Śląski

FIRMA HANDLOWO - USŁUGOWA PAALPAK AGNIESZKA TOMASZEWSKA - SĘDZISZÓW

Next, choose the file and click . The Excel file will be uploaded to LoMag inventory management.

Firma Handlowo - Usługowa Renax Remigiusz Sowa - Kamyk

• FIRMA HANDLOWO PRODUKCYJNA BOŻENA JANKOWSKA - POZNAŃ
• Firma Handlowo Produkcyjna Dariusz Roszak - Poznań

This is what the file including a list of items looks like in the spreadsheet:

Firma Handlowo Uslugowa Domanscy Roman Domanski - Olszanka

The file has been uploaded to LoMag:

FIRMA HANDLOWO USŁUGOWA A.S. KRZYSZTOF SIERAKOWSKI - BYSTRA

Firma Handlowo Usługowa Adrian Konopski - Szczecin

Firma Handlowo Usługowa ALKOM Michał Kominek - Ruda Śląska

Next, adjust the Excel columns to the fields of the module. Select an appropriate field from the list for every column you wish to import (e.g. account name, account phone number).

Firma Handlowo- Usługowa AnMar Anita Łabaj - Nakło Śląskie

Firma Handlowo Usługowa Belleza & Decoracion Norbert Kłak - Chorzów

FIRMA HANDLOWO USŁUGOWA COM-TEL BOŻENA SZULC - DARŁOWO

There is information regarding the name of the account in the first column. To import this data (column one), select an appropriate field from the drop-down list, i.e. "Account name" (see below).

Firma Handlowo Usługowa Dariusz Fiołek - Brzozów

Firma Handlowo- Usługowa Eltach Robert Koroblowski - Świdnica

Firma Handlowo Usługowa FARMER Witold Niemczyk - Witaszyce

FIRMA HANDLOWO USŁUGOWA GAMBIA AGNIESZKA BORKOWSKA KRZYSZTOF STĘPIEŃ MARCIN BORKOWSKI SPÓŁKA JAWNA - Jelenia Góra

Further columns show additional information about accounts; to import further data, select an appropriate field from the drop-down list, to which the data will be ascribed. Proceed in the same manner with each column you wish to import to the database.

FIRMA HANDLOWO USŁUGOWA GRACJA SEBASTIAN CHMIELEWSKI - Tarnowskie Góry

• Columns marked with "Do not import" will not be imported to LoMag inventory management.
• FIRMA HANDLOWO USŁUGOWA JMB HALINA OKOŃ - LUBIEŃ
• Firma Handlowo Usługowa Krzych-Pol Krzysztof Długoński - Grudziądz

After you have selected appropriate columns, click to import the data.

Firma Handlowo- Usługowa Laszko - Nidzica

Firma Handlowo Usługowa MOTO-DIABLO Daria Wyrzykowska-Ropińska - Śrem

A window informing you that the import has been successful will come up (see below).

FIRMA HANDLOWO USŁUGOWA MUKA ANDRZEJ ŻYRACKI - Rzeszów

Firma Handlowo Usługowa PODIUM Piotr Grzeszczyk - Łaziska Górne

• For the process of data import to conclude, the "Account Name" field (column) is required. If this element (column) is lacking, the import process will not be executed.
• FIRMA HANDLOWO USŁUGOWA ROBERTROBERT MAZUR - KRAKÓW
• Firma handlowo usługowa SZYBKA-SZYBKA Lipowski Sebastian - Łopuszno
• Firma Handlowo Usługowa Techtronic Jacek Konieczny - Opole
• During the import you do not determine the types of accounts (Suppliers, Customers, Employees). Each imported account has been automatically ascribed to all three account types (roles).
• Firma Handlowo Usługowa TERMIKA Zbigniew Jedlecki - GORLICE
• Firma Handlowo Usługowa TĘTENT Marek Maźnio - Wodzisław Ślaski
• Firma Handlowo Usługowa Tomasz Mędrecki - Łopuszno
• Firma Handlowo Usługowa WARZYWKO Krzysztof Gruszka - Strzeleczki
• Firma Handlowo Usługowo Eko Romuald Kuchta - Zendek

To set roles (Supplier, Customer, Employee) for a given account and to check whether the process has been successful (whether the accounts from the Excel file have been added or updated) you can go to one of the account modules, i.e., or or .

Firma Handlowo Usługowo-Doradcza Koncept-Projekt Konrad Kokoszka - Trzebinia

Firma Handlowo-Produkcyjna Delta Sp. z o.o. - Dębica

Firma Handlowo-Transortowa-Adam Wilkosz - Igołomia

As you can see above, the accounts imported from Excel have been properly added. To change their account types, use the function which was discussed before.

Firma Handlowo-Usługowa 2M s.c.Magdalena i Marek Szwed - Brwinów

Firma Handlowo-Usługowa Andrzej Ruszczyk - Koszalin

Firma Handlowo-Usługowa Auto-Gum Kinga Czmut - Toruń

Defining account types can be done also directly while importing the account list. Let's open the *.xls with a list of accounts in any spreadsheet (e.g., Microsoft Excel, OpenOffice Calc).

Firma Handlowo-Usługowa BOLAND Piotr Landowski - Piece

Next, add three additional columns to your file (see below), which will be used for defining the account type.

Define the A1, B1, and C1 cells as: "Supplier", "Customer", "Employee".

To ascribe an account type to a given account, you need to define the cells by entering "yes" or "no", where "yes" - defines given account type, and "no" means the lack of such a role. As an example, let's define "Vincent Devon" as a customer and "Borm McGlan" as an employee (see below).

Let's go back to the module and import the updated Excel file using the key.

Next, use the functions which will help you define an appropriate account type for the "Supplier", "Customer” and "Employee" columns. So, select the "Supplier (yes/no)" field (see below) for the "Supplier" column.

In the same manner, use the "Customer (yes/no)" function for the "Customer" column and "Employee (yes/no)" for the "Employee" column.

After defining appropriate columns, to import data to the program, click

And thus, you have directly determined account types while importing data.

5. Finding accounts

LoMag offers you the option of finding accounts. To that end, you have to use the window, which is launched by default when one of the warehouses is turned on (opened).

The window may also be turned on with the use of the icon located on the tool bar and the use of the "Ctrl+F" keyboard shortcut.

The module may be used for finding data regarding items, documents and accounts, which are our main focus at the moment. To find accounts, go to the window, the "Accounts" tab.

The window has a search tools area (), a tool menu for managing accounts () and the accounts list ().

The list of accounts in the window is empty. To display a full list of accounts, use the . A full list of accounts in LoMag database will be displayed.

Firma Handlowo-Usługowa ''BOSS'' Stanisław Mądroszkiewicz - Milicz

Firma Handlowo-Usługowa CARLINE Iwona Smoter - Rabka-Zdrój

Firma Handlowo-Usługowa DARJAN Dariusz Janas - Kraków

Firma Handlowo-Usługowa E&J Ewa Mańda - Bieruń

Firma Handlowo-Usługowa Euroexpert Grzegorz Ślęczka - Wieliczka

Firma Handlowo-Usługowa Ewelina Sujecka - Pabianice

Firma Handlowo-Usługowa FORKLIFT Drożdzowski Krzysztof - Bolesław

Firma Handlowo-Usługowa KORTADO Bożena Sienkiewicz - Suwałki

Firma Handlowo-Usługowa Krzysztof Jankiewicz - Grajewo

You can search for accounts by a fragment of a text, Tax Identification Number or by account type. The text fragment may also be supplemented by a part or the whole of the Tax Identification Number, or you could specify the account type - this significantly limits the search spectrum. For example, let's find one of the accounts, e.g. Kowalski. Enter the first two letters of the name of the account, i.e. "Ko" to the field and see what happens.

Firma Handlowo-Usługowa MAR-BUD Marcin Kłoskowski - Jednorożec

Firma Handlowo-usługowa Marek Kocki - Drawno

Firma Handlowo-Usługowa Monika Tarnożek - Goleniów

Firma Handlowo-Usługowa NICO Rogala Grzegorz - Jedlnia Letnisko

Firma Handlowo-Usługowa OPTIMA s.c. Krzysztof Maślany, Dariusz Maślany - Wałcz

Firma Handlowo-Usługowa PLON Andrzej Dadrzyński - Sońsk

Firma Handlowo-Usługowa POL-KRUSZ Zbigniew Wojno - Kolno

As you can see in the above screenshot, accounts including letters "ko" in their name have been displayed. In this case only two such accounts are present, however, if you have a lot of accounts, it is advisable to change the search method. Enter a longer text fragment or additionally use the field or set the account type, which you wish to have displayed and/or and/or . The field means that a given account is displayed, while the field means that this type of account is not displayed in the window.

Firma Handlowo-Usługowa PROCPU Aneta Sieradzka - Jelenia Góra

Firma Handlowo-Usługowa SPEKTRUM Maciej Gubernat - Żabno

Tool bar for accounts in the window is identical as in the previous modules , , - tools for accounts operate in the same manner.

Firma Handlowo-Usługowa VNK Wenecjusz Wojtoń - Krosno

Firma Handlowo-Usługowa Zbigniew Kuciak - Chełmża

You can freely configure the dialogue box of the module, e.g. you can display or hide any column, change column name, etc. If you need to manage the columns, use the option, which may be found in the lower part of the interface.

firma Handlowo-Usługowo Produkcyjna GREK Mariola Kmieć-Konstantikakis - Wola Zaradzyńska

Firma INEL Maria Osińska - Dragacz

Firma INEL Zdzisław Osiński - Dragacz

Firma INTERLIGHT Stefan Walędziak - Brańsk

Firma Jubilerska Sułek Marek - Lublin

Firma Knioch S.C. - Środa Wielkopolska

Firma Kołaszewski - Bytów

Firma Lakiernicza Hannex sp. z o.o. - Obrzycko

FIRMA LEDA - Bożena Gurdek - Wieprz

If you click , the interface will be launched. In the first part of the interface you will find fields with hidden columns () and visible columns () in . The second part of the window enables you to change the column name (), adjusting the number of decimal places and the change of column width.

Firma Lemar s.c. M.W.Lewandowscy - Dragacz

Firma LENTAL Grażyna Lenart - Głowno

FIRMA MAKOWSKI Makowski Sławomir - Blok Dobryszyce

Firma Mes - Słupia pod Bralinem

Firma MIKIMAKS Anna Bienias-Popiel - Pajęczno

Firma Milowent s.c. Paweł Miśta Michał Hybirz - Mysłowice

For example, let's use the column display option. You wish to display an important column, which is hidden now - for example a column with account's postal code. To display the chosen column ("postal code"), mark it in the field, and transfer it to the field using the button.

Firma Ochroniarska Omega Now Kolt Sp. z o.o. - Dębica

Firma Ochrony Szkolenia Asekuracji Fosa sp. z o.o. - Chorzów

Firma Odzieżowa Smuda - Rybnik

Firma Ogrodnicza Rabata Marcin Irek - Hrubieszów

Approve the change with the button. From now on, there will be a column with postal codes of accounts in the search module in the warehouse (see below).

FIRMA PHU ENDOR KOMPUTER S.C. A.BARCZYKOWSKI J.PIKORA - Bydgoszcz

Firma Pinus Grzegorz Sztyber - Pionki

Firma Pochłopień Rafał Pochłopień - Maków Podhalański

Firma Poligraficzno-Handlowa AUTOGRAF Klupś Regina - Mielec

Firma Produkcyjni-Handlowo-Usługowa BADERA Tadeusz Badera - Rudniki

Firma Produkcyjno - Usugowa Elektron Sp. z o.o. sp. k - Kobylany

FIRMA PRODUKCYJNO HANDLOWO USŁUGOWA GREM S.C. - Ruda Śląska

You can also use the module to change the names of individual columns. To do that, mark the column in the window, and then give it a new name in the field. You can change the remaining fields, and . You can come back to default settings at any given moment - use the icon to do that.

Firma Produkcyjno Handlowo Usługowa KIKO Antoni Tuszyński - Tarnowskie Góry

Firma Produkcyjno Usługowa Voltec Krzysztof Żurowski - Wola Rzędzińska

Firma Produkcyjno Usługowo Handlowa Mieczysław Kruszelnicki - Wrocław

Firma Produkcyjno -Usługowo-Handlowa EUROSTYL - Rybno

Firma Produkcyjno-Handlowa Ania' - Kraków

Firma Produkcyjno-Usługowa Mebef - Marszewska Kolonia

Firma produkcyjno-usługowo-handllowa Zdzisław Joński - Słupsk

Firma Projektowo Budowlana Zakład Instalacji Sanitarnych PROTEK - Kalisz

Firma Remontowo Budowlana Norbik Norbert Kuta - Mikołów

Firma Remontowo-budowlana KAMBUD Kamil Wieczorek - Dmosin

Apart from the column management button discussed above (), you also have the option of item list pagination. Automatic pagination is turned on by default. If you want the module to display all accounts on one drop-down list, use the function (the pagination function will be turned off). In order to turn on the pagination again use the key. To use pagination to go to the first, previous, next and last page use the following keys . Pages are created automatically adjusting to the number of items and the size of the window.

Firma Remontowo-Budowlana S-Bud Józef Sokół - Zapałów

Firma Ren-Trans Renata Jóźwicka - Bydgoszcz

Firma Robak Irena Robacka - Bydgoszcz

Firma Roma Roman Marciszewski - Ruda Śląska

Firma ROMI Roman Chojka - Kołobrzeg

Firma SEBA Sebastian Zasada - Lisia Góra

FIRMA SYLEX SYLWIA BALICKA - PRUSZCZ GDAŃSKI

FIRMA SZYMAŃSKI - NIECHANOWO

Firma Techniczno-Budowlana Bud-Pol s.c. Janusz Molczyk, Norbert Florek - Zgłobice

FIRMA TOMASZ CHOLEWIAK - GNIEZNO

Firma Transportowa JOAR Artur Michałek - Polanica Zdrój

Firma Transportowa Yelon Tomasz Łoń - Dobrzejewice

Firma Turystyczno-Usługowa Robson Robert Szymański - Sarbinowo

The button is used to manage filters in the window. The filtering function helps us to quickly display appropriate accounts following the variants defined by you. This function is not used with accounts as often as it is used with, e.g., items. To find out more about the function for filtering data, go here, and proceed to item 1.5 Item lists - filtering .