You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Current »

You can use the Expenses tab to create a list of additional expenses on delivering the items to your warehouses or on other services that affect the cost of inventory.


The "Additional Expenses (create)" form. The Expenses tab

To add an expense or service item, click the Add button and then click in the Item column. To open the list of items, click the Show All hyperlink. To create a new item, click (+) Create; for more details, refer to the Items topic. To add multiple expense or service items, click the Pick button on the tab toolbar. For details, refer to Using the pick operation. T

 You can download a list of expense or service items with prices and other details from an Excel document (an .xlsx file). For this, click the button on the table toolbar and follow the step-by-step instructions in the appeared window. The list can be edited in the Administration module.

You can use the Up and Down ( ) arrows to rearrange the items in the list.

In the Quantity column, you can specify the quantity of the service or expense item. The UOM column is automatically populated with the default unit of measurement of the selected item.

The Price column is populated automatically if the supplier price for the service or expense item is available in the system; otherwise, you can enter the price manually.

The amounts in the Amount column are automatically calculated for each item according to the specified price, quantity of the item, and supplier discounts; otherwise, you can enter the amount manually.

You can specify the Discount for the purchased service if the Enable discounts and markups in purchasing documents option is selected on the Administration > Settings > Purchasing and Warehouses form.

The VAT amount is calculated in the currency of the document according to the amount and VAT-related settings (which are specified on the Main tab) as follows:

  • If the Prices Include VAT option is selected: The VAT amount is extracted from the item amount (A), that is,

VAT_Amount = A*VAT_Rate/(100+VAT_Rate).

  • If the Prices do not Include VAT option is selected: The VAT amount is calculated based on the item amount, that is,

VAT_Amount = A*VAT_Rate/100.

The Total column is automatically populated with the amounts calculated according to the VAT-related settings as follows:

  • If the Prices Include VAT option is selected: Total = Amount.
  • If the Prices do not Include VAT option is selected: Total = Amount + VAT_Amount.

In the Project column (which is available for all transaction types), you can specify the project to which the expenses are linked.

In the GL Accounts column (which is available for the Sales and Purchasing transaction types), you can view the default accounts to be updated by this transaction. If needed, you can replace them with other accounts.

The total amounts at the bottom of the form are automatically calculated as the sums of the appropriate columns.



  • No labels