Table of Contents

Introduction

The invoice management of foreknown offers an overview of all invoices in the form of a list. In the detailed view of an invoice all required actions like update basic data, add introductory and closing text, add positions and discounts and copying and printing invoices are available.

Invoices can be accessed through the menu item "Billing / Invoices" as a user with the role "Accountant".


To the Top ↑


Manage Invoices

Below you will be introduced to all the functions available in the Invoice Management section.

Search Invoice

If you open the "Invoices" dialog, you will see the following:

Invoices - List and Search


In the upper part of the dialog is the search field and the "+ New" button. Below this area, all invoices that have already been created are displayed in the form of a pageable list.

If you now enter a search term in the input field, the list will only show the invoices that contain the entered search term in the title or invoice number. In this way, individual invoices can be found quickly.


To the Top ↑


Filter Invoices

In addition to the search function, invoice management also offers a filter dialog. A filter dialog in foreknown is always located on the right side as a fold-out dialog. The filter dialog can be expanded and collapsed by clicking on the button with the three dashes above the list on the left.

The following filter options are offered for invoices:

  1. Period: Here you can freely select a period from which invoices will be displayed.
  2. Customer: One or more customers can be searched and selected via a field with auto-completion.
  3. Order: One or more orders can be searched and selected via a drop-down field with auto-completion. All invoices are displayed that have invoice positions resulting from services or additional services of the selected orders.
  4. Status: One or more statuses can be selected via a field with auto-completion.
  5. Invoice Amount (net): Two input fields can be used to filter invoices whose net amount is between the two specified values. If only a "from" or "to" value is specified, all invoices are displayed, whose net amounts are greater than the "from" or less than the "to" value.

The action "Apply" displays all invoices in the list that match the filter criteria. The "x" action removes all filter settings and the list shows all invoices again. The "Reset" action (icon: arrow in a circle) discards all changes that may have been made to a saved filter.

For general information about the filter options, see also the chapter Basics: Filters.


To the Top ↑


Create Invoice

To create a new invoice, click on the "+ New" button located at the top right of the search box. This button will open the "Create Invoice" pop-up dialog.

Invoice - Create Invoice


  1. Invoice Date: From a calendar, the creation date of the invoice can be selected.
  2. Customer: From an auto-fill field a customer must be selected. With the "+" in the line, a new customer can also be created directly.
  3. Reference Number: Here a reference number can be entered manually. This is usually a number provided by the customer and serves the allocation on the part of the customer.
  4. Title: Here a title for the invoice can be assigned.
  5. Service Period: Defines the period for which services will be billed in this invoice. When creating an invoice via the invoice assistant, the period selected there will be included in the invoice.
  6. Currency: Here a currency must be selected from an auto-fill field.

The following fields are only activated once a customer has been selected. The fields are pre-assigned with the values of the customer:

  1. Payment Target (in days): The value defines the duration in days in which the customer should have paid the invoice, based on the invoice date.
  2. Payment Discount Period (in days): The value defines the period in days from the invoice date in which the customer may deduct the payment discount.
  3. Payment Discount: The value defines the payment discount in percent.

If you click on the button with the round "arrow" symbol, all data in the dialog will be reset to the initial state. To cancel the process, click on the "Cancel" button.

Click on the blue "Save" button to create the new invoice and return to the list view. The newly created invoice now appears in the list with the status "Draft" and can be selected for further processing. Invoices in the status "Draft" can still be edited completely. Only with the action "Finalize Invoice" an official invoice is created and an invoice number is generated.


To the Top ↑


Edit Invoice

When switching to the detail view of an invoice, all master data and actions, that change the status of an invoice, are displayed in the upper area. The properties of an invoice can be edited via an "Update Invoice" popup dialog. This is opened via the button with the pencil icon, which is always located at the top right of the detail view.

Rules - list and search


For details on the input fields see Create Invoice.

The "Save" action saves the changes made to the invoice. The "Reset" and "Cancel" actions discard the entries, and in the case of the "Cancel" action, the dialog is closed.

The fields "Address", "Responsible" and "Template" can be edited directly by clicking on the pencil icon next to the corresponding field in the detailed view.

Furthermore, for invoices that have invoice items generated on the basis of service entries, a link "Show Services" is displayed below the invoice name. This link leads directly to the list of service entries on which the selected invoice is based.


To the Top ↑


Create Invoice Position

In the bottom half of the detail view, you can see the invoice and text positions in the area "Positions & Texts".

Invoices - Overview


Clicking the "Add position" link will open the "Create Invoice Position" dialog.

Invoices - Invoice Position


  1. Title: The title of the position is entered here.
  2. Title: The title of the position is entered here.
  3. Description: A more detailed explanation of the position can be entered here.
  4. Amount: Here you have to enter the quantity of the selected unit.
  5. Unit: From a drop-down list you have to choose between "piece", "hour", "day", "month", or "flat rate".
  6. Price/Unit: Here the price of a single unit is indicated.
  7. Tax Rate: A VAT rate must be selected from an auto-fill field.

With the action "Save" the invoice position will be saved. With the action "Reset" and "Cancel" the entries are discarded and in case of the action "Cancel" the dialog is closed.


To the Top ↑


Edit Invoice Position

An invoice position can be edited as long as the invoice is still in draft. Each position has an action menu which offers the action "Edit invoice position". Clicking on this action opens the corresponding dialog.

All properties can be changed as already described under Create Invoice Position.


To the Top ↑


Copy Invoice Position

An existing invoice item can be copied, provided that the invoice is still in a "draft" status. Click via the action menu on action "Copy invoice position" which opens the corresponding dialog. This dialog shows all position data of the selected position in order to adapt them for the new position. See also the descriptions under Create invoice position.

Copy Invoice Position


In addition, a checkbox "Take over discounts?" is offered. Activate this checkbox if discounts of the selected invoice item are to be included in the new invoice item.

With the action "Save" the new invoice position is created with the corresponding values. With the action "Reset" the values specified from the selected invoice item are restored. The action "Cancel" cancels the copying process and closes the popup dialog.


To the Top ↑


Create Text Position

An invoice might consist not only of invoice items that define services, but can also contain additional descriptive texts. Therefore, foreknown offers the possibility to create not only introductory and closing texts, but also explanatory texts between the invoice positions.

Invoice - Initial Presentation


In an empty invoice you will find for the areas "Introductory text" and "Closing text" respectively the action "Add introductory text" and "Add closing text".

As soon as a text position has been created in an area, the actions "Create text above" or "Create text below" can be used to add further text position. These actions are also available in the action menu of an invoice position and thus allow the insertion of text positions there as well.

Invoice - Action Menu for Text Positions


The action menu of a text position contains the following actions:

  1. Edit text: This action opens a dialog that allows you to enter an individual text via an editor with simple formatting options. Alternatively, a text based on a pre-defined text block can be copied into the text position. Placeholders (drop-down list) can be used to integrate data of the customer and the invoice.
  2. Create text above: This action opens a dialog for creating a new text position, which will be inserted above the selected text position.
  3. Create text below: This action opens a dialog for creating a new text position, which will be inserted below the selected text position.
  4. Add/Remove separator above: With this action a separator line can be added/removed above a text position.
  5. Add/Remove separator below: This action adds or removes a separator line below a text position.
  6. Delete text: This action deletes the currently selected text position if deletion has been confirmed before.

The action menu of the invoice position also has actions to create text positions.

Invoice - Action Menu - Invoice Position


Again, it can be decided whether a text is to be inserted above or below an invoice position.


To the Top ↑


Deposit Discounts

Discounts can also be stored in an invoice. These discounts can be applied to individual positions as well as to the entire invoice.

Position Discounts

Clicking via the action menu on the action "Edit position discount" dialog opens the corresponding dialog which allows you to enter a discount in the form of a percentage value or a fixed amount.

Invoices - Position Discounts


Percentage values can be > 0 and <= 100. For a fixed amount, you can enter all values > 0. If the value is greater than the value of the position, it will result in a minus value, which is equivalent to a credit.

You can see if a position contains a discount by the fact that on the one hand the "Label" symbol is displayed in green and on the other hand the discount is displayed in green letters below the title.

If you want to delete a position discount, you can also do this via the "Edit Position Discount" dialog. By clicking on the red "Delete Discount" button, which appears next to the "Save" button, as soon as a position discount exists, the discount will be removed immediately.


To the Top ↑


Total Discount

Clicking on the "Add Discount" link opens the "Edit total Discount" dialog. Since multiple total discounts can be specified, a descriptive name for the total discount must be specified first, e.g. "10% loyalty discount". Total discounts can also be specified as a percentage or as a fixed amount.

Percentage values can be > 0 and <= 100. For a fixed amount, you can enter all values > 0. If the fixed amount is greater or even the total of discounts is greater than the invoice total, it will result in a minus amount, which is equivalent to a credit.

Invoices - Total Discounts


You can see if a total discount has already been deposited by the entries that appear below the "Total Net". A "Total Net incl. total Discount" is then also displayed.


To the Top ↑


Delete Invoice

An invoice can only be deleted if it is still in "Draft" status. All invoices with a more advanced status have already been assigned an invoice number and may not be deleted to ensure a complete traceability.

To delete an invoice in the "Draft" status, click on the "Delete Invoice" button in the top right corner of the detail view. This opens a confirmation dialog, which is closed with the action "Delete". After that, the invoice is irrevocably deleted, and you return to the overview of invoices.


To the Top ↑


Copy Invoice

An existing invoice can be copied from the detail view via the action "Copy invoice". A dialog opens to allow settings to be made for the new invoice.

Copy invoice


  1. Invoice Date: A new invoice date can be selected via a date picker dialog.
  2. Reference Number: The reference number of the invoice, which is usually named by the customer, can be adjusted.
  3. Title: The title should be adapted so that the new invoice can be clearly identified.
  4. Take over Customer Data: A checkbox can be used to determine whether the customer data should be taken over for the new invoice.
  5. Take over Discounts?: A checkbox can be used to determine whether the item and total discounts of the selected invoice should be taken over for the new invoice.

With the "Save" action, the new invoice is generated with the corresponding values in the "draft" status and can be edited directly. The "Reset" action restores the values specified from the selected invoice. The "Cancel" action cancels the copying process and closes the popup dialog.


To the Top ↑


In order to print an invoice, a template must be assigned to it. Click on the "Print (Preview)" button in the detail view at the top right. This will automatically download the current invoice as a PDF document.


To the Top ↑


Send Invoice

An invoice can be sent as a PDF document via e-mail regardless of its status. This makes it possible, for example, to send a draft invoice to a customer and only finalize the invoice after approval. If the customer has change requests, these can be easily implemented without having to cancel the invoice.

As soon as an invoice is finalized, foreknown also creates the final PDF document with the invoice data.

Sending via e-mail is triggered with the "Send Invoice" action. The "Send e-mail" dialog opens, which is preset with data from the "Standard Settings for Invoices and Activity Reports".

Send Invoice via E-Mail


Further details on the "Default Settings for Invoices and Activity Reports" can be found in the online documentation under "System Administration / Settings".

The following properties can be set for sending the invoice via e-mail:

  1. Template: An e-mail template can be selected to be used as a frame for the subsequent text. You can add your own e-mail templates via the template management under "System Administration / Templates". A simple standard template, which only displays the text entered, is already supplied.
  2. From: The sender of the e-mail can be selected via a drop-down list. This is preset with the logged in user by default.
  3. To: One or more e-mail addresses can be entered in a text field, separated by commas. The field is prefilled with the e-mail address of the contact person stored in the invoice, provided that this person has been maintained and has an e-mail address.
  4. CC: If the "CC" button is selected, a further "CC" field appears, where e-mail addresses can also be entered, separated by commas. These will receive the e-mail in CC.
  5. BCC: If the "BCC" button has been selected, a further "BCC" field appears, where e-mail addresses can also be entered separated by commas. These will receive the e-mail in BCC.
  6. Subject: An e-mail subject can be entered. This is preset with the text "Invoice {invoiceNumber}".
  7. E-Mail Text: The text of the e-mail can be edited using a text editor with limited formatting options. If a text block has been selected in the "Standard Settings for Invoices and Activity Reports", the text is preset with replaced placeholders and can still be edited.
  8. Attachments: The file attachment of the invoice is displayed with the file name defined via the "Standard Settings for Invoices and Activity Reports" is displayed. If the activity report was not printed directly in the invoice, a second file attachment is displayed with the file name defined for activity reports. The activity report can be removed again using the "X" if required.

The "Send" action sends the invoice and, if applicable, the activity report to the specified recipients with the specified subject, e-mail text and attachment. In addition, an entry is created under "Notes" which documents that the invoice and the activity report was sent by e-mail by the current user at the current time.


To the Top ↑


Activity Report

If invoice items of an invoice have been generated via the invoice wizard and are therefore based on services or additional services, there are additional options for outputting the services on the invoice.

Invoices - Drop-down Menu - Activity Report


In this case, an additional "Activity Report" button is offered below the "Print" button, which provides a drop-down menu with various actions.


To the Top ↑


If the invoice is based on services and/or additional services, this action can be used to generate an activity report and to download it as a PDF document based on a previously selected template of the type "Activity Report".


To the Top ↑


Send Activity Report

If the invoice is based on services and/or additional services, this action can be used to send an activity report as a PDF document via e-mail. The invoice can also still be in "Draft" status. In this way the activity report can be sent to the customer for approval before the invoice is finalized and therefore does not have to be cancelled again immediately in the event of change requests.

Sending via e-mail is triggered with the "Send Activity Report" action. This opens the dialog "Send E-Mail" dialog, which is preset with data from the "Standard Settings for Invoices and Activity Reports".

Send Activity Report via E-Mail


Further details on the "Default Settings for Invoices and Activity Reports" can be found in the online documentation under "System Administration / Settings".

The following properties can be set for sending the activity report via e-mail:

  1. Template: An e-mail template can be selected to be used as a frame for the subsequent text. You can add your own e-mail templates via the template management under "System Administration / Templates". A simple standard template, which only displays the text entered, is already supplied.
  2. From: The sender of the e-mail can be selected via a drop-down list. This is preset with the logged in user by default.
  3. To: One or more e-mail addresses can be entered in a text field, separated by commas. The field is prefilled with the e-mail address of the contact person stored in the invoice, provided that this person has been maintained and has an e-mail address.
  4. CC: If the "CC" button is selected, a further "CC" field appears, where e-mail addresses can also be entered, separated by commas. These will receive the e-mail in CC.
  5. BCC: If the "BCC" button has been selected, a further "BCC" field appears, where e-mail addresses can also be entered separated by commas. These will receive the e-mail in BCC.
  6. Subject: An e-mail subject can be entered. This is preset with the text "Invoice {invoiceNumber}".
  7. E-Mail Text: The text of the e-mail can be edited using a text editor with limited formatting options. If a text block has been selected in the "Standard Settings for Invoices and Activity Reports", the text is preset with replaced placeholders and can still be edited.
  8. Attachments: The file attachment of the activity report is displayed with the file name defined via the "Default Settings for Invoices and Activity Reports".

The "Send" action sends the activity report to the specified recipients with the specified subject, e-mail text and attachment. In addition, an entry is created under "Notes" which documents that the activity report was sent by e-mail by the current user at the current time.


To the Top ↑


Select Template

This action is only available for invoices with the status "Draft" and enables the assignment of a template for the creation of the activity report (PDF). Once an invoice has been finalised, the activity report, like the invoice itself is saved as a PDF document and can no longer be changed.

Note: A standard template of the type "Activity Report" is already provided via the template management. This template can be downloaded and customised. See the chapter in the documentation "System Administration / Templates"


To the Top ↑


Export Service Entries

In addition to generating an activity report (PDF), it is also possible to export service entries to MS Excel using a "service entry export" template. This action opens a pop-up dialogue that allows you to select a template.

Service exports can always be carried out regardless of the status of the invoice.

Note: A function that exports all additional service entries of an invoice to an MS Excel document, is not yet available.


To the Top ↑


Show Service Entries

This action opens the "Billing / Service Entries" dialogue with a filter on the current invoice, so that all the service entries on which this invoice is based are listed.

Note: A function that lists all additional services on an invoice is not yet available.


To the Top ↑


Edit Notes

Notes can be added to an invoice, e.g. from communication via telephone or e-mails, in order to document important information chronologically. Since notes are used in many areas of foreknown, you can find a detailed description of this functionality at Getting Started / Basics / Notes


To the Top ↑


Change Invoice Status

Invoices can have different statuses that make it clear where an invoice is currently in the process and what actions are possible. All statuses and the possible actions are shown below.

Invoices - Status Overview


Each invoice is initially created with the status "Draft". This status still allows for full editing and deletion of the invoice. Furthermore, these invoices have not yet received an invoice number from the associated number range. Once the invoice has been completed, it can be finalized (see Finalize Invoice).

If a final invoice has been dispatched to the customer and the customer has paid, the invoice can be set to "paid". However, if the invoice was incorrect, it can be cancelled again. In this case, a cancellation invoice is also generated as an offsetting entry with negative values and assigned to the cancelled invoice.


To the Top ↑


Finalize Invoice

This action assigns an invoice number to an invoice and sets the status to the final state. A pop-up dialog will open to indicate whether all conditions for finalization are met.

The following conditions must be met to "Finalize" the invoice:

  1. Template: An invoice template is needed to generate the print version.
  2. Invoice position: At least one invoice position must have been created.

Furthermore, notes on missing information are given:

  1. Title: A title for the invoice should be stored so that the invoice can be better identified.
  2. Introductory text: An introductory text can be entered in the overview area.
  3. Closing text: In the overview area a closing text can be entered.

If "Finalize Invoice" is clicked in the pop-up dialog, the invoice status will be set to "Final".

NOTE: This action cannot be undone.


To the Top ↑


Dispatch Invoice

When an invoice has been sent to the customer, the status can be set to "Dispatched". This can be achieved by clicking on the green "Set as 'Dispatched'" button. A pop-up dialog will open where the action must be confirmed.

Once the status is set to "Dispatched" the invoice can only be set to paid, cancelled, send or printed.

NOTE: This action cannot be undone.


To the Top ↑


When an invoice has been paid by the customer, the status can be set to "Paid".

This can be achieved by clicking on the green "Set as 'Paid'" button. A pop-up dialog will open where the action must be confirmed with "Invoice paid".

Once the status is set to "Paid" the invoice can only be cancelled, send or printed.

NOTE: This action cannot be undone.


To the Top ↑


Cancel Invoice

An invoice can be cancelled, if necessary, by clicking the red "Cancel Invoice" button in the detail view. If the invoice status is "Cancelled", the invoice can only be printed.

Cancel invoice


A popup dialog will open offering two actions for selection:

  1. Create Cancellation Invoice: The status of the selected invoice will be set to "Canceled" and a cancellation invoice will be created as an offsetting entry.
  2. Create Cancellation Invoice & new draft Invoice: The status of the selected invoice will be set to "Canceled". and a reversal invoice will be created as an offsetting entry (negative values) and a copy of the reversed invoice will be created in status "Draft" is created.

The generated cancellation invoice can have two statuses:

  1. Cleared: In this case, the cancelled invoice was not yet in the "Paid" status. Thus the cancellation invoice represents the offsetting entry for the canceled invoice and the customer account is cleared.
  2. Not cleared: In this case, the canceled invoice is already marked as "Paid". Thus, another offsetting entry to the canceled invoice is generated with the cancellation invoice. Action is therefore still required to balance the customer account. As soon as this has been taken care of, the "Cleared" action can be used to set the status of the cancellation invoice to "Cleared".

Both the cancelled invoice and the cancellation invoice offer a link in an info block above the master data to jump to the respective other invoice.

If the invoice status is "cancelled", the invoice can only be printed or copied. A cancelled invoice can only be printed and will then show the necessary information:

  • Title is "Canceled Invoice"
  • A reference to the cancelled invoice is given with invoice number and date.

NOTE: This action cannot be undone. Furthermore, when customizing the invoice template it should be noted that the above information is always taken into account for printing a cancellation invoice, since there is exactly one template exists for all invoice types.


To the Top ↑