• A Confluence está sendo executada atualmente com todos os plugins que não são do sistema desabilitados. Pode haver perda de algumas funcionalidades
Páginas filhas
  • General Accounts Payable Status Report - FINR330 - Financial - P12

Index

Objective

 

 This report presents a general position of Accounts Payable, enabling the control of payments performed in a selected period.

The report allows you to analyze all transactions in the period by topic, in quantity and values, divided by:

  • Purchases (in the month), with the respective values paid in cash and divided in installments;
    1. In cash
    2. On credit
  • Values posted:
    1. Received
    2. Interest Rate
    3. Fine
    4. Discounts
    5. Advance Payment
    6. Accessory Values
    7. Original
  • Bills due, listed by period:
    1. Up to 15 days
    2. From 16 to 30 days
    3. From 31 to 60 days
    4. From 61 to 90 days
    5. Over 90 days
  • Bills overdue, listed by period.
    1. Up to 15 days
    2. From 16 to 30 days
    3. From 31 to 90 days
    4. From 61 to 90 days
    5. Over 90 days
  • By bill type:
    1. Duplicate invoices (DP)
    2. Invoices (NF)
    3. Predated Checks (CH)
    4. Payment voucher (BOL, FT)
    5. Taxes
    6. Advance Payments (PA)
    7. Debit Memos (NDF)
    8. Other
  • Late Purchase Orders, bills from the Purchases module:
    1. Up to 15 days
    2. From 6 to 30 days
    3. From 31 to 60 days
    4. From 61 to 90 days
    5. Over 90 days
  • Advance Purchase Orders, bills from the Purchases module:
    • Up to 15 days
    • From 16 to 30 days
    • From 31 to 90 days
    • Over 90 days


Formulas

The report displays the bills values based on mathematical formulas:

Name

Formula

Description

Mean Absolute Term (PMA)

S (a-b) / n

a = Bill's actual due date

b = Bill's issue date

n = Number of open bills

Weighted Average Term (PMP)

S [ (a-b) * c] / S c

a = Bill's actual due date

b = Bill's issue date

c = Bill balance

S = Sum

Quotient of Delay (QA)

QA = (S (a+b+c+d+e) / Sf) * 100

a = Balance of bills overdue - deductions + interest lower than 15 days

b = Balance of bills overdue - deductions + interest between 15 and 30 days

c = Balance of bills overdue - deductions + interest between 30 and 60 days

d = Balance of bills overdue - deductions + interest between 60 and 90 days

e = Balance of bills overdue - deductions + interest higher than 90 days

f = All bills - deductions + interest, with and without delay

S = Sum


Example

Below is an example of how the report is displayed in the system:

Questions (F12)

List of parameters applied to FINR330 and their processing


On the main page of the routine, the following options are available:

Related Contents