In this article
The Items table is a kind of mini-warehouse integrated in accounting.
It is used to:
- Manage the list of products, with their prices.
- You can group products into groups.
- In the Transactions table, you enter the item and the programme takes up the description and price.
- If you enter the quantity in the Transactions table, the programme updates the current quantity in the items table.
Add Items table and Transactions columns
In the Items table you may enter items, products and others. It may also be used as an inventory control, to some extent.
The Items Table is automatically connected to the ItemId and Quantity columns in the Transactions Table when this are available.
- Items table
If it is not available use this command - Transactions Table
Make sure you have the ItemId, Quantity, Price columns in the Transactions Table- Add the Items columns in the Transactions table.
- Display the Item column in the Transactions table via the Data menu →Columns setup.
- The content of the ItemId column must be an item defined in the Items table.
Columns of the Items Table
- Group: Generates the totals rows.
- Item: Item code.
- Description: Item description.
- Sum in: the group in which to total a set of items.
- Account: account used in the transactions.
- Currency: Currency to be used (for multi-currency accounting only).
- VATCode: VAT code to be used (for VAT accounting only).
- Unit: an abbreviation to define the type to which the quantity refers.
- Selling: Unit sale price.
- Cost: Unit cost price,
- Begin Qt.: initial quantity amount of the item
- Price Begin: the initial unit price of the item.
- Value Begin: the initial quantity multiplied by Price Begin.
- Current Qt.: current quantity, calculated by program, taking into account Begin Qt. and transactions of Item in Transactions table. The Quantity column of the Transactions table is being used.
- Price current: current Price of Item.
- Current value: current quantity multiplied by Current price.
help_id
items