 | Loading… |
|
|
|
Outstanding Items
Outstanding Items
Outstanding Items
By using the report function for outstanding items it is possible to create a
report either for the outstanding or closed items. Thus we may for example
browse posts, create a report of warnings or messages on due claims, create a
report on browsed due claims or liabilities as well as create a report on browse
posts that shall be due by the definite time in the future, and so on.
 |
To create an outstanding items report correctly it is necessary to enter the
accounts in the module settings, financials, general of the Administrator
panel. On the basis of the two initial numbers of the account ID the program
shall recognize whether the account in question is of the customer or supplier.  |
|
|
Outstanding items are those items used in posting to subject accounts/general
ledger that do not have the equivalnet contra account for the same subject, to
the same account, with a reference to the same linked document, in the same
currency.
|
The choice window of any outstanding items report includes the following fields
that refer to data from journal entry items where
claims/liabilities and their respective closings are posted:
Report type
| there are seven typical preset report types or
rather outstanding items reports:
- Outstanding items, due to _____ (recovery
of due UNPAID outstanding items) - it enables the making of reports
of outstanding items with a restriction to documents due to a
certain definite past date and still have not been paid. It thus enables
us to restrict the recovery of outstanding items by documents that are
already due and have not been paid yet.
- Status of outstanding items
(bank reconciliation) - it is the most often used report. It is
designated for displaying the status of ALL the outstanding items
regardless if the documents and payments are due. For example we use it
in bank reconciliation when we want to establish which documents have
not been paid yet.
- Ooutstanding items on the_____ (balancing
of the outstanding items status with the subject) - the report
answers the question of what was the status of ALL outstanding items on
a certain past date, e.g. last day in the previous month.
- Past status of due outstanding items on
the _____ (report of ALL outstanding items due) - the report
answers the question of what was the status of outstanding items DUE on
a certain definite past date. In the overview shall NOT be included
payments made after the date entered here.
- Overview of documents,
issued from_____ to _____, paid till _____ (analysis of outstanding
items by document date and payment date) - control report answering
the question which documents drawn up in the selected date period were
still unpaid on a specific past day.
- Any report of the outstanding items -
when establishing the status of outstanding items it considers all
posts (see
Journal entry items), which according to
date criteria belong to the selected period. The post is any payment and
any posted claim/liability. It makes sense to enter only the end due
date of the document and/or posting (dates to) with this report type,
because it is essential in this report to establish the actual
outstanding items and possible inappropriately closed documents or
payments.
- Any payment analysis by documents -
when establishing the status of outstanding items it considers all documents,
which accordnig to date criteria belong to the selected period. This
report type is designated for more complex analysis of outstanding items.
Yet these in the first step are related to issued documents and only
later on their respective pamyent.
If we create 6.
Any report of the outstanding items WITHOT restriction of date
criteria and the status in
7.
Any payment analysis by documents by the same criteria differes, is
this due to a mistake that occurred by the closing of documents. Or we have
a posted payment, for which the document has not been yet posted. See Comparison of the outstanding items report and
payment analysis.
| Account
| We enter the ID of the account, from which we want to get outstanding
items.
This is by default the first account of the customer from the parameters (Program
parameters | Financials | General).
| Account
| the second account field is designated for overview and creating a
report of two accounts at the same time
(e.g. 1200 and 1210 or 1200 and 1300).
| Subject
| we may enter the
subject name, for which we want to print the
list of outstanding items. We thus restrict the report by individual
subject.
| | Subject type | we may create a report of outstanding items also for individual
subject type.
With this we have to define where the program finds this data.
The subject may as a customer have a different type of subject assigned
than the supplier. That is why thus option is related to the Outstanding
item type option and is used only with the analysis number 7 - Custom
payment analysis by documents, in the customer or supplier option. |
Department
| the
report may be restricted by individual
department (e.g. individual cost centre or
profit centre)
| | Cost drv. | the report may be restricted also by individual cost driver
|
| Country |
the report may be restricted by the country, in which the
subject from the posting item has its registered office. |
DATE CRITERIA
- by outstanding items reports in postings we may choose only between
end dates
(due dates, document dates and/or posting dates). In reports by documents we may,
however, choose between the start and end dates. By the overview the
program uses data from the date fields of the same name found in journal entry
items, where these claims/liablities and their subsequent payments
are posted.
Restrictive date criteria are added together!
|
Due
from
| (only
in reports by documents) start date of the posting that is due
(see
Journal entry items
) and documents (from journal entry items ),
which we want to include in the report.
| Due to
| end date of the document or posting that is due and which we want
to include in the report, so as to establish what are the amounts of the
due items on the current date.
| | Document from | (only
in reports by documents) start date of the document, which should be
included in the overview
(see
Journal entry items)
| Document to
| end date of documents or postings (from journal entry items),
which we want to include in the report
| Posting per. from
| (only
in reports by documents) start date of document posting
(from journal entry header), which we want to include in the report
| Posting per. to
|
end
date of document posting
(from journal entry header) that we want to include in the report
| | Date of
balance | it is used only in the Overview of documents issued
from _____ to _____, paid till _____ and Any payment analysis by documents
reports as an additional border date criteria for inclusion of claims as
well as their closings. For examples of use see the above mentioned
topics.
If other conditions are considered then the payments with due date
AFTER the entered date of status shall be excluded from the report.
| | Currency | the report may be restricted by the individual currency used in posting (from
journal entry item). If this field is left empty then the outstanding
itmes shall be displayed in all currencies. | Document
| the report may be restricted by individual internal document ID by the
use of
wildcard characters as well as by the set
of documents used.
| | Linked document | the report may be restricted by the linked document ID
| Outstanding only
| (only
in reports by documents) the field id selected, if we want to display
only actual outstandin items (see example).
Of course this option affects the report only if it is restricted by any
date criteria (due date, document date, posting date).
| Type of outstanding items
| In type 1
(Outstanding items on) and 7
(Custom payment analysis by documents) we
may select what type of the outstanding items are displayed:
- Customers – outstanding items of customers are displayed
- Suppliers – outstanding items of suppliers are displayed
- Include overpayments – items where the received/paid payment
amount larger than the amount of invoice receivable/payable should be
included in the report
The Include overpayments option is active only in the type 7.
Custom payment
analysis by documents (see example of usage with the example
Document closed
inappropriately). With other report types of outstanding
items the choice is automatic.
The outstanding items type Customers shall be automatically selected
for accounts of class 1 and the item type Suppliers for accounts
of class 2.
| Document status
| we select which documents we want to display (on the basis of the date
period of the documents due date):
- Outstanding – documents, which are opened with the given
criteria, are displayed
- Closed – documents, which are closed with the given criteria,
are displayed
- All – open and closed documents are displayed
| Amounts
| if postings in a foreign currency are allowed on the
account we may select in which currency
the report should be made:
If the posting is in the local currency, then the reports shall be
equivalent for both in the local currency and in the foreign currency!
|
Debit balance
| if this field is selected the items with the debit balance of claims/liabilities
are displayed
| Debit credit
| if this field is selected the items with the credit balance of claims/liablities
are displayed
|
Clerk
| (only
in reports by clerks) the report may be restricted by individual clerki. In
the Detailed by clerks and Summary by clerks
reports the clerk is a person who signed the documents of receiving and
issuing.
|
Sort by amounts
| (only
in reports summary by subjects) if this field is selected then the
outstanding items report shall be sorted accordnig to the amounts of the
outstanding items
| Balanced
| (only
in reports summary by subjects) if the field is selected the items where
the amount is balanced are displayed. See also examples of this
reports.
| Report type
| we select the format of the report which may be:
|
|
|
Certain of the functions described are inactive by the preset simple reports
of outstanding items!
|
|
|
The date criteria used in the report (e.g. due TO) are displayed in the header
ofthe report. To display individual date data from the report criteria see
Date reports from its criteria. |
|
|
See Taskbar for a general
description of its functions. |
| Loading… |
| Loading… |
|
|
|
|