Frequently asked questions about the database of the inventory module

Where are the modules integrating the inventory module registered?

In order for the module to recognize which modules are integrated, these must be registered in the INV_TiposOrigem table. This table requires the INV_OrigensTiposDocumentos and INV_OrigensDrillDown tables.

What has been done regarding stock states?

Two stock states tables have been created: INV_Estados and INV_ConfigEstados.

And regarding calculated unit costing, what was done?

Costing was separated by a category called 'cost groups'. Different cost groups can be configured for each warehouse or all the warehouses can have the same group, which represents the overall calculated unit cost.

Where are stock and costing postings recorded?

Previously, if a movement only changed stock, this information would be recorded in the costing and vice versa. With the new structure, inventory and unit cost records are recorded independently, which means data present in the LinhasSTK table will be transposed to the INV_Origens, INV_Movimentos and INV_Custeio tables. Entries in the INV_Origens table are always performed using the unit of the movement and not the item's base unit.

How to search for the current stock and calculated unit cost values with the new module?

Although the recods in the INV_Movimentos and INV_Custeio tables use the date of the unit cost calculation and the quantities of existing stock at the time of registration, tables INV_ValoresActuaisStock and INV_ValoresActuaisCusteio allow you to easily search for this type of information when necessary. These tables represent the old ArtigoArmazem table, which in turn has been replaced by the new V_INV_ArtigoArmazem view. The StockActual and PCMedio fields of the item table must be replaced by the V_INV_ResumoArtigo view.

Where are the serial numbers recorded?

The ArtigosNumerosSerie table must be replaced by the INV_NumerosSerie table. The previous structure only recorded existing serial numbers, but the new structure can record them all. To get this display, filter records using the Stock = 1 clause.

Where are serial number movements recorded?

All movements of serial numbers are recorded in the INV_NumerosSerieMovimento table. If, for example, a certain stock movement reports an entry of 5 serial numbers, this table will identify the 5 serial numbers linked to that stock movement.

What has changed about stock reservations?

Stock reservations are now fully registered into a new structure specifically created for this purpose. In the previous system it was only possible to make reservations for existing stock, and record them using the total quantity. In the new module, both the existing stock and the expected stock of an order can be reserved. All information is recorded in the INV_Reservas table.

Where are the entry and issue documents recorded?

In the previous module's structure, incoming (entry) and outgoing (issue) documents were recorded in the CabecSTK table. In this new version, this table has been replaced by the CabecInternos table.

What was done regarding stock transfers?

In the case of stock transfers, the previous structure was separated into two tables: INV_CabecTransferencias and INV_LinhasTransferencias.

What was done regarding Compositions and Breakdowns?

Compositions and breakdowns were also restructured, and the new data structure is now composed by the INV_CabecComposicoes and INV_LinhasComposicoes tables.

More information on the structure of tables from the Inventory module can be found here.