Items table in the accounting file

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.

In order to use the Items table, you need to:

• Add the Items 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.

Adding the Items table 

The Items table can be added from the Tools menu > Add new functionalities > Add Items table

In the Items table, you can enter items, products, or other items, and it can also be used as a small inventory control tool.

The predefined columns are the following:

• 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.
• Value Begin Currency: Only in multi-currency accounting, it represents the begin value in the item currency.
  • When this field is present, the standard Value Begin is instead expressed in the base currency.
  • The exchange rate applied between Value Begin Currency and Value Begin is the opening exchange rate without a date specified in the Exchange rates table for that particular currency.
  • In previous versions, the program allowed manual entry of the exchange rate in the ExchangeBegin column of this table. From version 10.2.0, this column has been removed if not used.
• 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.
• Currency value: Only in multi-currency accounting, it represents the current value in the item currency.
  • When this field is present, the standard Current value is instead expressed in the base currency.
  • The exchange rate applied between Currency value and Current value is the opening exchange rate without a date specified in the Exchange rates table for that particular currency.
  • In previous versions, the program allowed manual entry of the exchange rate in the ExchangeCurrent column of this table. From version 10.2.0, this column has been removed if not used.