Tab Calendar

Information provided in the Calendar tab refer to a financial situation of a company by time ranges. The Calendar tab presents information in accordance with the criteria selected in tab Payment Estimate.

Note
If the option <All in system currency> is selected in filter pane of a payment estimate, then when proceeding to tab Calendar, the system controls whether all the objects are expressed in the same system currency. In case of various currencies, the message: “Impossible to display the calendar for all currencies. Select different value in the filter.” will be displayed when attempting to open the tab Calendar.
Tab Calendar in the payment estimate window

The tab Calendar has a tree structure and its layout is the following:

  • Level 1 − Analysis Period
  • Level 2 − receipts and expenses structure elements:
    • Resources – cash/bank transactions value
    • Payments – payments associated with documents
    • Planned – entered directly from the level of payment estimate or the list of payables/receivables

Level 2 is displayed only if the parameter By receipts and expenses structure has been checked in the filter.

  • Level 3 − Document

The list Calendar is composed of the following columns:

  • Period/Document Number − for the level 1 it presents the period, for the level 2 it presents the names of the elements of elements of receipts and expenses structure and for the level 3 it presents the system number of a document. The period depends of the value of the parameter Group which is available in the filter.
  • Reference Number − presented for the level 3
  • Entity Code − presented for the level 3
  • Receipts − on the third level the amount of receivable or receipt for a given document is presented, whereas on the first and the second level the total value of all the amounts from the third level is presented.
  • Expenses − on the third level the amount of receivable or expense for a given document is presented, whereas on the first and the second level the total value of all the amounts from the third level is presented.
  • Balance − presented on the first and second level. It is calculated as a difference between receipts and expenses.
  • Current Balance − current balance of the account at the end of a given period, presented on the first level

and columns hidden by default:

  • Cash Register/Bank
  • Description
  • Document Description
  • Amount Remaining
  • Applied
  • Value
  • Owner
  • Affects Balance

Detailed description of hidden columns can be found in article <<Tab Payment Estimate>>.

Filtering on Payment Estimate tab

The Calendar list has general filter which allows for filtering by the following parameters:

  • By inflows and outflows structure – parameter unchecked by default; if the parameter is checked, the level 2 is displayed
  • Group – parameter determines the method of presenting values on the list:
    • Daily − default value
    • Weekly
    • Monthly
    • Quarterly
    • Yearly
  • Skip periods without sales – parameter checked by default

Detailed description of functioning of the filters can be found in category <<Searching and filtering data>>>

 

Czy ten artykuł był pomocny?