Mago.net - Inventory

Mago.net - Inventory

The Inventory module makes the ERP software Mago.net perfect for a rational and efficient management of goods in storage.


The program permits to manage inventory quantities and values both at fiscal and at single storage level.
We can print out the fiscal inventory journal and valorise the inventory according to the widest variety of criteria.
It is also possible to automatically generate inventory entries to carry out some very common operations: move goods between two storages and reconcile the actual quantity in the inventory with the data present in the program.

Inventory: main features

Managing Items

In Mago.net it is possible to code both goods items and services.

Item Master DataItem Master Data

The item code can be inserted manually or automatically. Other than a short description, you can add notes or a text file.
Many are the information you can insert: base and alternative units of measure, weight, Tax, sales and purchase offsets.
For the inventory items we can add commercial data, or information for reordering such as Minimum Stock, Maximum Stock, Reordering Lot, which can be differentiated by storage. It is also possible to visualise the data relative to the last sale or purchase (customer/supplier, date, price, discount).

You can associate an image with each item in different formats (bmp, jpg, ico, wmf, cur, emf, png, eps)

Image in Item Master DataImage in Item Master Data

You will be able to differentiate items by Homogeneous Categories, Commodity Categories and Item Type, manage Manufacturers, Product Categories and Product Subcategories, to ease searching for an item in the inventory entries and in the sale and purchase documents.

Items Graphic Navigation

In order to simply and practically visualise the most significant data related to the item such as the quantities available, the price lists, sale and purchase orders still open and more, Mago.net provides Item Graphic Navigation.

Item Graphic NavigationItem Graphic Navigation

This function is available in several parts of the program, also in the inventory data entry and in all the sale and purchase documents.

With a simple click we can go from the Graphic Navigation directly to the master data of the items and to the documents visualised.

Purchase and Sales Barcodes

The management of the barcodes makes it possible to quickly identify an item without any possible errors.

With Mago.net we can use the same Barcodes defined by the suppliers (Purchase barcodes) or define our own Barcode to use for sales (Sales barcodes).

Barcode RepresentationBarcode Representation

In the inventory entries as well as in the sale and purchase documents, instead of inserting an item code, it is possible to insert a Barcode and the program will automatically search for the corresponding item.

The Barcode inside the document can be manually typed in or added using a barcode scanner.

We can also print barcodes to create package labels or other printouts we desire.

Smart Code

With the use of the Smart Code it is possible to automatically construct both the code and the description of an item according to a series of settings freely defined to suit the company needs.

Smart CodeSmart Code

This means all the codes are standardised, making it possible to identify items more effectively.

When setting a Smart code, Mago.net automatically generates the item code and its description. We can also add some information such as unit of measure (basic and alternative), Tax code, commodity and homogeneous category that will be automatically added to the master data of the items created.

The smart code is very useful for particular types of items such as clothing. Indeed, we can define the composition of the code so as to include type of garment, size, colour and other information that may be useful.

Units of Misure

Managing inventory balances, so the book inventory and on hand of items in a given unit of measure and using a different unit of measure in sales or purchase documents is a common need for companies.
All of this is very practical and simple with Mago.net, which allows us to:

  • codify general units of measure, when a there is a fixed relationship between the units of measure (e.g. Kg - Gr - Hg or Mt - Cm - Mm) so they can be used for all items;
  • codify comparable units of measure directly at the item level, when the relationship between the two units of measure varies according to the item (e.g. Nr - Box - Pallet).
    codificare unità di misura.

In Mago.net each single item can be entered with different Units of measure, each time selecting the most appropriate on the line of each document.

If it is necessary to use different units of measure in the purchase documents (e.g. we purchase by the kilogram) and in the sales documents (e.g. we sell by each hundred grams) we can set Mago.net so it can automatically propose the unit of measure in keeping with the type of document.

Multidimensional quantities

In some cases calculations may be necessary to obtain the quantity in a given unit of measure. For example, to find out the quantity of an item managed in square metres it may be necessary to multiply the coefficients (length, width, height and possibly number of pieces).

Mago.net can carry out calculations on the units of measure.

It is also possible to insert up to four coefficients and the relative multiplication factors so that Mago.net can automatically calculate the quantities.

Price and Discount Policies

In Mago.net we can insert different types of prices and discounts to use in the inventory entries.

It is possible to define a base price, manage several price lists, providing for brackets of quantities and dates of validity, have prices linked to the customer or to the item or to both. It is also possible to apply price deriving from the mark-up on purchasing or manufacturing costs of the goods.

We can tell the program what priorities to use when proposing the base values to suit our specific company needs, for example choosing from Standard cost, last cost, second last cost, average sale price, average purchase price, list price. It is also possible to set the price proposition list, normally used in the sales/purchase documents so that if for example there is no last of item supplier price, the base price of the item or the last cost is proposed.

Product Composition (Item kit)

Whether a product is a goods or service, it can be formed of an assortment of several subproducts: in this case they are Kits, or Product Composition. One example of a kit is the traditional Easter basket made up of chocolate Easter eggs, traditional cake and sparkling wine.

Mago.net can be used to manage these Kits.

Product CompositionProduct Composition

The kits can be expanded in the purchase, order and sales documents. 
In particular, you can choose whether to enter the kit item in the inventory and expand the lines of the components descriptively or enter the components in the inventory and express the kit line as descriptive.

Inventory Entries

The Inventory entries can be used to perform any operation on coded goods regarding both the fiscal aspect and the physical aspect.

The Inventory entries can be automatically generated with the creation of documents and with the execution of procedures that include this, or inserted manually.
The effect of the inventory itself is piloted simply by indicating the inventory reason. The program provides several predefined Inventory reasons to facilitate the insertion of every common entry (purchase, sale, return, output for vision etc...) and it is in any case possible to add new descriptions or to customise the already existing ones.

To retrieve an item inside an inventory entry we can follow different methods according to the data we have available: for example we can do a search by code and description, or by Barcode, Lot code, Customer code, Supplier code.

In the inventory entries it is also possible to import text files (for example created with Windows notepad or from barcode readers) containing Item Code (or Barcode), Quantity and, possibly, Lot code, Unit Vale and Discount.

Storages and Valuations

In Mago.net it is possible to manage several Storages.
Each item can be entered into the storage desired both in the Inventory entries and in the sale and purchase documents.
With Mago.net we have at our fingertips both the overall value of the inventory and the quantities available in the different storages the relative values.

In order to keep the situation under control we have different data available that provide the inventory situation at the start of the fiscal year, the current situation and the projected situation considering order to supplier and from customer.
And other information is also available relative to entering the item during the fiscal year: purchased, sold, product and scrap, incomings and outgoings.

To valorise the inventory, Mago.net provides a number of criteria:

  • LIFO
  • FIFO
  • Average cost
  • Standard cost
  • Last cost
  • Second last cost
  • Weighted average
  • By lots

If we perform an inventory closing we can valorise each item based on the criteria specified in the relative master data or decide to use the same criteria for all items.

Inventory Adjustment Entries

Often, the quantities physically present in the inventory are not the same as the values present in the management archive.

Mago.net provides a quick and easy procedure making it possible to automatically generate the inventory entries needed to reconcile the real quantities with the programme archives.

Automatic Inventory Adjustment EntriesAutomatic Inventory Adjustment Entries

The quantities actually present in the inventory can be inserted manually into the procedure or be imported using a text file possibly generated using an optical scanner.

Some features are not available on all Editions.

"The ERP software for everyone"

More Info


"The application base on which you can develop new projects"

More Info

"A platform to create flexible and powerful applications"

More Info
Microarea Portal is powered by Mago.net 3.12.13
Copyright © 1984-2016 Microarea SpA - All rigths reserved
The texts and materials published on this site serve a purely informative purpose.
Microarea does not provide any guarantee, neither explicit nor implicit, concerning the content.
All product and company names are trademarks™ or registered® trademarks of their respective holders. ×