PANTHEON™ Help

 Категории
 Главна страна - Добре дојдовте во помош за PANTHEON
[Collapse]PANTHEON
 [Collapse]PANTHEON упатства
  [Expand]Водич за Datalab PANTHEON™
  [Expand]Водич за PANTHEON Farming
  [Expand]Водич за PANTHEON Ретал
  [Expand]Водич за PANTHEON Вет
 [Collapse]PANTHEON кориснички прирачници
  [Collapse]Кориснички прирачник Datalab PANTHEON™
   [Expand]Како да започнете?
   [Expand]Често поставувани прашања за PANTHEON
   [Expand]еРаботење
   [Expand]Подесувања
   [Expand]Нарачки
   [Expand]Материјално
   [Expand]Производство
   [Expand]Сервис
   [Collapse]Финансии
    [Expand]Кредити и лизинг
    [Expand]Сметководствена конзола
    [Expand]Posting
    [Expand]Set-off
    [Expand]Payment Transactions
    [Collapse]Subject Accounts
     [Expand]Close Manually
     [Expand]Close by Reposting
     [Expand]Close Prepayments
     [Expand]Rounding Differences and Cash Discounts
     [Collapse]Outstanding Items
      [Expand]Comparing Outstanding Items Report and Payment Analysis
      [Expand]Reports
       SQLI and Outstanding Items Reports
     [Expand]Balance Report and Debt Structure
      Debt Collection
      Преглед на плаќања на сметки
     [Expand]Interest Calculation
      Подсетници
    [Expand]Finances
    [Expand]Fixed Assets
    [Expand]FAS - Financial Accounting Statistics
    [Expand]Accruals and Deferrals
    [Expand]Fiscal Year
     Changing Chart of Accounts
   [Expand]Кадри
   [Expand]ЗЕУС Деловен аналитички систем
   [Expand]Помош
   [Expand]Надоградба
   [Expand]Персонал
   [Expand]PANTHEON Изданија
    Предговор
    Ценовник
    Договор за лиценца на крајниот корисник
  [Expand]Корисничко упатство за PANTHEON Ретал
  [Expand]Корисничко упатство за PANTHEON Vet
  [Expand]Корисничко упатство за ПАНТЕОН Земјоделство
[Collapse]PANTHEON Web
 [Collapse]Водич за PANTHEON Web
  [Expand]Водич за PANTHEON Web Light
  [Expand]Водич за PANTHEON Chronos Mini
  [Expand]Водич за PANTHEON Web Terminal
  [Expand]Водич за PANTHEON Web Legal
  [Expand]Архива на стари производи
 [Collapse]Кориснички прирачник за PANTHEON Web
  [Expand]Најава во PANTHEON Web
  [Expand]Како да започнете со PANTHEON Web
  [Expand]Кориснички прирачник за PANTHEON Web Light
  [Expand]Кориснички прирачник за PANTHEON Web Terminal
  [Expand]Кориснички прирачник за PANTHEON Web Legal
  [Expand]Стара архивa на производи
[Collapse]PANTHEON Гранула
 [Collapse]Водич за PANTHEON Гранули
  [Expand]Гранула Кадри
  [Expand]Гранула Патни налози
  [Expand]Гранула Документи и задачи
  [Expand]Гранула Контролна табла
  [Expand]Гранула B2B нарачки
  [Expand]Гранула Сервис на терен
  [Expand]Инвентаризација на фиксни средства
  [Expand]Гранула Попис на магацини
 [Collapse]Кориснички прирачник за PANTHEON Гранули
   Започнување
   Користење на PANTHEON Гранули во фиктивната компанија Текта
  [Expand]Гранули и активација
  [Expand]Гранула Кадри
  [Expand]Гранула Патни налози
  [Expand]Гранула Документи и Задачи
  [Expand]Гранула Б2Б нарачки
  [Expand]Гранула Контролна табла
  [Expand]Гранула Сервис на терен
  [Expand]Инвентаризација на фиксни средства
   PANTHEON Гранула - FAQ
  [Expand]Гранула Попис на магацин
   Архива
[Expand]Кориснички сервер

Load Time: 464,8219 ms
"
  1247 | 1594 | 18648 | Localized
Label

Comparing Outstanding Items Report and Payment Analysis

Comparing Outstanding Items Report and Payment Analysis

Comparing Outstanding Items Report and Payment Analysis

010380.gif010381.gif010411.gif010382.gif010383.gif

You can use two types of report for displaying outstanding items:

  • Use Custom outstanding items report to see their status. It looks through all posts (see lines of journal entry) belonging to the selected period. Post is any payment and posted receivable or payable. You should enter only end due dates, document dates and/or posting dates (dates to) using this type of report in order to find outstanding items and incorrectly closed documents and payments.
  • Use Custom payment analysis by documents to see the status of outstanding items. It looks through all documents belonging to the selected period. Use it to create complex analyses of outstanding items. These analyses are based on issued documents. This is followed by subsequent payments in the later stages of the analysis.

If posts and related documents do not match trying to create an outstanding items report WITHOUT specifying date criteria, it occurs due to incorrect closing of documents or due to the fact that you posted payment whose related document has not been posted.

Trying to display the report including date restrictions, incongruities occur due to invoices that are posted with different due dates.

The distinction between both types of report can best be presented through examples.

Example 1: Incorrectly Closed Document

  1. Issued invoice with ID of linked document 07300000024, due date (currency) April 13th, 2007, €1,000 debit
  2. Received payment with ID of linked document 001, due date (currency) April 16th 2007, €1,000 credit

Creating an outstanding items report using such data, the report and payment analysis differ:

1.Payment Analysis by Documents

a) Outstanding items type "Customer"

Returns information that the linked document 07300000024 has not been paid. The customer has an outstanding amount of €1,000 pending since payments without documents were not included in the report.

b) Outstanding items type "Include Overpayments"

returns information that the linked document 07300000024 has not been paid. Because you checked Include Overpayments, the report will include all payments which do not close open linked documents. That is why customer's outstanding amount is €0,00. Since the two items are not mutually closed, they both appear in the outstanding items report.

2. Custom Outstanding Items Report (by Posts)

returns information that the linked document 07300000024 has not been paid. Because all payments which do not close open linked documents are included in the report, the customer's outstanding amount is €0,00. Since the two items are not mutually closed, they both appear in the outstanding items report.

Manually closing outstanding items closes the invoice and its payment mutually. Hence both overviews give equivalent results regardless of the selected criteria.

For examples of reports see Incorrectly Closed Document.

Example 2: Invoice Containing Different Due Dates

Issued invoice with ID of linked document 07300000025 in the amount of €6,000 with maturities:

Date Amount Due Outstanding Item - Cumulative

01.03.07

1,000.00 EUR

1,000.00 EUR

16.03.07

1,000.00 EUR

22,000.00 EUR

16.04.07

1,000.00 EUR

33,000.00 EUR

16.05.07

1,000.00 EUR

44,000.00 EUR

16.06.07

1,000.00 EUR

55,000.00 EUR

16.07.07

1,000.00 EUR

6,000.00 EUR

1a. Payment Analysis by Documents Including Due Dates and without Date of Balance

Enter May 1st, 2007 to May 31st, 2007 as due date. Do not enter date of balance. Since due dates are used in payment analysis by documents, it affects whether document is displayed in report or not. Leaving date of balance field empty, the displayed report contains ALL receivables of the linked document.

 

Due Date Amount Due Outstanding Item - Cumulative

01.03.07

1,000.00 EUR

1,000.00 EUR

16.03.07

1,000.00 EUR

22,000.00 EUR

16.04.07

1,000.00 EUR

33,000.00 EUR

16.05.07

1,000.00 EUR

44,000.00 EUR

16.06.07

1,000.00 EUR

55,000.00 EUR

16.07.07

1,000.00 EUR

6,000.00 EUR

 

1b. Payment Analysis by Documents Including Due Dates and Date of Balance

Let us continue with the above example and enter maturity period from May 1st, 2007 to May 31st, 2007:

Let us assume that you want to find out the balance of documents on June 30th, 2007. Enter June 30th 2007 as date of balance. In contrast to the above example the list of outstanding items in this case contains ONLY receivables and closing of receivables for the linked document. Further, they are dated with due dates ON or PRIOR TO June 30th, 2007. Lines containing due dates of July 16th, 2007 are not be included in the outstanding items report.

 

Due Date Amount Due Outstanding Item - Cumulative

01.03.07

1,000.00 EUR

1,000.00 EUR

16.03.07

1,000.00 EUR

22,000.00 EUR

16.04.07

1,000.00 EUR

33,000.00 EUR

16.05.07

1,000.00 EUR

44,000.00 EUR

16.06.07

1,000.00 EUR

55,000.00 EUR

 

2. Custom Report - Overview of Posts Including Due Date

Enter maturity period TO May 31st, 2007. All records with due dates ON or PRIOR TO May 31st, 2007 will be included in the outstanding items report. Lines containing due dates of June 16th, 2007 and July 16th, 2007 are not included in the outstanding items report.

 

Due Date Amount Due Outstanding Item - Cumulative

01.03.07

1,000.00 EUR

1,000.00 EUR

16.03.07

1,000.00 EUR

22,000.00 EUR

16.04.07

1,000.00 EUR

33,000.00 EUR

16.05.07

1,000.00 EUR

44,000.00 EUR

 

For examples of reports see Invoice with Different Due Dates.

 

Related topics

For a general description of functions see:

 

 

 



 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!