Introducing Payment Times Analysis in Business Central (2023 release wave 2)
Payment Times Analysis in Business Central (2023 release wave 2) analyzes whether vendor and customer payments happen on or after due dates. It can aggregate by company size or by custom period, and the video demos both, including drill-down, history and printing.
- Introduction to Payment Times Analysis
- Regulatory Requirements and Global Scope
- Feature Overview and Analysis Options
- Demo: Aggregation by Company Size
- Demo: Aggregation by Period
- Analysis Insights and Customer Payments
- Summary and Resources
Overview
The video introduces Payment Times Analysis, a global feature that checks how a company pays its vendors, and optionally how customers pay it, against due dates. It was prompted by Swedish rules requiring companies with 250 or more employees to report payment times for purchases to the Swedish companies registration office. The feature replaces a similar earlier feature in the United Kingdom base app, which was made obsolete.
The demo covers two aggregation options: by company size, as required in Sweden, and by period, using periods set up in the Payment Periods table. It shows generating the lines, the statistics, drilling down to invoice and payment entries, viewing stored historical data and printing the report.
Key points
- Authorities currently require the analysis for vendors only, but the feature lets you choose vendors, customers or both.
- Aggregation by company size is the Swedish requirement; company sizes are specified on vendor cards, and only vendors with a specified size are included in the report.
- Aggregation by period uses periods set up in the special Payment Periods table, where you can specify any periods you want to see in the report.
- Statistics include average agreed payment period, average actual payment period and percentage paid on time; amount-based analysis can replace invoice count where a country prefers it.
- Click generate on the Payment Practices page to collect the data; lines can be drilled into to see invoice and payment entries, dates and amounts.
- Results are stored for historical viewing and can be printed with the layout selected automatically.
- A similar earlier feature in the United Kingdom base app was made obsolete in favor of this global app.
Features
Every feature below: status not stated, demoed.
| Feature | At |
|---|---|
| Payment Times Analysis | 0:47 |
| Aggregation by Company Size | 2:33 |
| Aggregation by Period | 5:43 |
| Payment Analysis Statistics | 2:54 |
| Payment Analysis Drill-Down | 4:28 |
| Historical Payment Data Storage | 4:48 |
| Payment Analysis Print Reports | 5:08 |
AL objects mentioned
As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.
Not found in BC28-30: page “Payment Practices”, table “Payment Periods”.
Quotes
- 0:47 “we simply want to analyze how you behave against your vent when it comes to the payments on or after due dates”
- 1:08 “Swedish companies with 250 and more employees must report Swedish companies registration office that payment times they have for purchase is from a company”
- 1:42 “we decided to create this app as a global feature for this kind of reporting as it can be useful in other countries”
- 1:53 “as we had a similar feature earlier in United Kingdom Bas app we decided to obsolute this code”
- 2:33 “per company size is required in Sweden but in other countries he mentioned it is required to provide analyzis per period”
- 2:54 “now you can choose between vendors customers or both of them”
- 3:48 “you just need to click generate and the line will be generated so the data will be collected”
- 5:56 “those periods are set up in special table payment periods where you can specify any periods you desire to see in this report”
Disclaimers in the video
- 1:53 other: as we had a similar feature earlier in United Kingdom Bas app we decided to obsolute this code and deize it
Presenters (as heard): Alexander, Vadim.