Kontakt

Ansicht
Dokumentation

RFFOPL_OVRDUE_INV - Overdue Invoices

RFFOPL_OVRDUE_INV - Overdue Invoices

ROGBILLS - Synchronize billing plans   BAL Application Log Documentation  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

You use this report to generate a list of all customer invoices and vendor invoices that are not settled within their payment due date.

In Poland, all companies that do not pay invoices within the due date as per the terms specified by the law are subjected to additional financial burden. This report helps generate a list of all customer and vendor overdue invoices.

Integration

Prerequisites

You have specified the interval (in days) between the baseline date and the payment due date of invoices:

  • Directly in the customer invoice or the vendor invoice if no payment term is assigned to an invoice
  • In Customizing for Financial Accounting under Accounts Receivable and Accounts Payable → Business Transactions → Outgoing Invoices/Credit Memos → Maintain Terms of Payment, if a payment term is assigned to an invoice

Features

This report displays the following details:

  • List of overdue invoices of all customers and vendors based on the company code
  • List of customer and vendor overdue invoices based on the payment status (open or cleared) of invoices after the payment due date
  • List of customer and vendor overdue invoices based on the interval (in days) between the baseline date and the payment due date of invoices

Selection

On the selection screen, you need to mandatorily specify the following parameters:

  • Company code
  • Fiscal year

In addition, you can specify the invoice document number range if you only want to display the overdue invoices within a specific number range.

You can also specify additional restrictions for the display using the following fields:

  • In the General Selectiongroup box, specify the following:
  • Posting date of invoices

  • Reference number of invoices

  • In the Other Selectiongroup box, specify the following:
  • Tax reporting date (VAT date)

  • Invoice document date

  • Business area

  • Document type

  • Specify either KR (for vendor invoices) or DR (for customer invoices)

  • In the Date Selectiongroup box, specify the following:
  • Payment due date of invoices

  • Reconciliation key date

  • Specifies the date with reference to which you want to execute this report.

  • In the Further Selectiongroup box, select either one or both of these options:
  • Vendors

If you select this checkbox, the system displays the list of vendor overdue invoices for the specified company code.
You can additionally specify restrictions for display using the following fields:
- Vendor account number
- Vendor reconciliation account number
- Natural person
If you select this field, vendors for which the Sole Properties checkbox is selected in the Control tab page of vendor master are excluded from the output.
- Vendor trading partner
If you specify the vendor trading partners in these fields, vendors with the specified trading partners are excluded from the output.
  • Customers

If you select this checkbox, the system displays the customer overdue invoices for the specified company code.
You can additionally specify restrictions for display using the following fields:
- Customer account number
- Customer reconciliation account number
- Natural person
If you select this field, customers for which the Natural Personcheckbox is selected in the Controltab page of customer master are excluded from the output.
- Customer trading partner
If you specify the customer trading partners in these fields, customers with the specified trading partners are excluded from the output
  • In the Arrears group box, you can specify the arrear days range.
  • In the Line Item Selection group box, select one of the following:
  • Open Items

If you select this radio button, the system only displays the open overdue invoices.
  • Cleared Items

If you select this radio button, the system/report only displays the overdue invoices that are cleared after the payment due date.
If an overdue invoice is already cleared for a future date, but you execute the report before this future clearing date, the system displays this overdue invoice in the output with status Open. However, when you execute the report after the future clearing date, the system displays this invoice in the output with status Cleared. For example, consider an invoice with payment due date 29.03.2013 that is already cleared for the future date 01.05.2013. If you execute this report on 01.03.2013, the system displays this invoice as an open invoice in the output. If you execute this report after 01.05.2013, the system displays this invoice as a cleared invoice in the output.
Note
If you select the Cleared Itemsradio button, the system additionally displays the following fields:
- Clearing Datefield in the Date Selectiongroup box
- Production Runcheck box in the Line Item Selectiongroup box
If you select the Production Runcheckbox, the system updates the clearing status of the displayed invoices in the Invoice Selection(FIAPPLD_INV_DATE) table. When you rerun this report for the same execution date, the system will no longer include these cleared invoices in the output. However, if you do not select this checkbox, the system does not update the clearing status and therefore, in the subsequent run of the report, you can see these invoices again.
- Reverse Documentcheckbox in the Reversed Documentsgroup box
If you select this checkbox, the system displays the following:
- Documents cleared after the payment due date
- Documents cleared and reversed after the due date
  • In the Payment Termsgroup box, select one of the following:
  • Less than or equal to 60 days

If you select this radio button, the system only displays overdue invoices for which the interval (in days) between the baseline date and the payment due date is less than or equal to 60 days.
  • Greater than 60 days

If you select this radio button, the system only displays overdue invoices for which the interval (in days) between the baseline date and the payment due date is greater than 60 days.
  • Both

If you select this radio button, the system displays overdue invoices which satisfy both the above mentioned conditions.
  • In the Output Selectiongroup box, select one of the following:
  • ALV Tree Output

If you select this radio button, the system displays the output in a tree format based on the sorting criteria that you specify in the Sorting Variantgroup box.
  • ALV List output

If you select this radio button, the system displays the output in a tabular form. On the output screen, you have the option to calculate the subtotals based on fields such as account type and document type. You can also export the data to a spreadsheet by choosing the menu option List →. Export Spreadsheet → Excel (MHTML)
  • In the Sorting Variantgroup box, select one of the following options:
  • Vendor/Customer

If you select this radio button, the system sorts the output based on the vendor and the customer.
If an invoice has more than one vendor/customer line items, then it will be displayed under the Special Documents node on the output screen.
  • Posting Period

If you select this radio button, the system sorts the output based on the posting period of invoices.

The report does not generate any postings in the system. It needs to be done manually by the user.

Standard Variants

Output

The system generates an output ALV based on the selection criteria that you specify on the report selection screen.

Activities

To access this report on the SAP Easy Access screen, choose Accounting → Financial Accounting → Accounts Payable → Reporting → Poland → Overdue Invoices.

Example






General Material Data   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 11794 Date: 20240520 Time: 141642     sap01-206 ( 176 ms )