In the Items table, enter all the inventory items which need to be managed.
Create the items list
All items available in the inventory must be posted individually on each row of the Items table. To total the amounts of a series of items, a adding up group must be entered.
The group is defined in the Group column, at the end of the list of items of the same category. The group number must be reported in the Sum in column for each item.
For further information on the grouping system, please refer to the Grouping System page
You can create further groups of items depending on your requirements.
To complete the registration of the items it is necessary to enter:
- The Id to identify the item.
- The description.
- The initial quantity.
- The initial price.
- The unit price.
Items table columns
Columns marked with "*" are protected and calculated by the program.
Link to a digital document.
Column and row to enter the totaling group of a given set of items.
Enter a value (number, letters or both) to identify the item.
Enter a text for the description of the item.
- Sum in (in the arrange columns it is written RowGroupIn)
Enter the totaling group for each item in this column.
You can insert texts for annotations on items or for other needs.
Enter the account present in the main accounting file that refers to the item.
Insert an abbreviation to indicate the unit (eg pcs to indicate the pieces).
Enter the initial quantities referring to the total.
If you want to manage separate quantities by locations, leave this column blank, and enter the initial quantities as entry transactions, with the corresponding location.
Initial unit price
If you want to manage separate quantities for locations, leave this column blank and enter initial quantities as entry transactions, specifying the respective location.
Initial item value calculated by multiplying the Initial Quantity and Initial Unit Price.
Total quantity of items resulting from the sum of the Quantity Plus in the Transactions table. Both the positive and negative values are added. The internal movements between two locations are not added up, when there is TransferId indicated.
Total quantity of items resulting from the sum of the QuantityMinus in the Transactions table.Both the positive and negative values are added.The internal movements between two locations are not added up, when there is TransferId indicated.
Difference between the item's inbound and outbound quantities.
Quantity of items currently in stock. Sum of the starting quantity and the Quantity change.
Unit price of the item, that must be entered manually.
Amount calculated by the program based on quantities and unit price.
For insertion of actual quantity when inverntory has been done.
The actual quantity multiplied by the actual price.
The actual quantity multiplied by the actual price