This is the table where the movements of the items are recorded:
- Transfers from one warehouse to another, in case you are running several warehouses.
By inserting the movements, the Items table is also automatically updated, in relation to the quantities and corresponding values of the items.
If several warehouses (headquarters and branches) are run simultaneously, the ID codes, set in the Locations, can be recorded, which will refer to the places where the warehouses are located, in order to keep track of the internal movements of the articles.
The ID abbreviations must be entered in the Locations and Transfer columns of the Transactions table. If they are not visible, they can be displayed via the Data → Columns setup menu.
Transactions table columns
Link to a digital document.
The date of the operation.
Document number (e.g. delivery note number).
Numeric or alphanumeric value to identify the item.
Text taken automatically from the Id column of the Items table for the description.
Text to be entered for the description of the items.
In the column you can enter notes about the items or for any other requirement.
Value to indicate the quantities of incoming items, purchased or transferred from other inventories.
Value to indicate the quantities of items that are outbound, sold or transferred to other inventories.
Abbreviation to indicate the type of unit.
The price of the item with which the total value of the items is calculated, based on quantities.
Total value of the items purchased, sold or transferred.
Identification of the place where the Inventory is located and from which the items enter or leave.
Name of the place where the inventory is located, from which the items come in or out.
Code of the place where the inventory is located for which the items are intended.
It works the opposite way to the LocationsId.
- If there is an entry to LocationsId, there will be an exit to LocationTransferld.
- If there is an exit from the LocationsTransferId there will be an entry.
- If LocationsTransferId is indicated, but the LocationsId is left empty, the program will still consider it as an internal movement without a specific LocationsId.
Name of the place where the inventory is located, from which the items arrive or leave, to or from another inventory.