---
id: post/bertverbeek-nl/1173
type: post
title: Late Payment prediction in Fabric instead of BC
summary: Building a late payment prediction model in Microsoft Fabric using AutoML instead of the native Business Central feature. The post demonstrates how to export BC customer ledger data, engineer features from payment history, train an automated machine learning model, and score open invoices to forecast payment dates for cash flow planning.
tier: community
language: en
tags:
  - late payment prediction
  - automl
  - machine learning
  - microsoft fabric
  - cash flow forecasting
  - data export
  - feature engineering
system: finance
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:59:23.708Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 62940af9d577f2f60a5c642df24a3d72168098b15d6cd08fdb9a763f449e01d1
evidence:
  - kind: blog
    url: https://www.bertverbeek.nl/blog/2025/09/10/late-payment-prediction-in-fabric-instead-of-bc/
    title: Late Payment prediction in Fabric instead of BC
    date: "2025-09-10"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://www.bertverbeek.nl/blog/2025/09/10/late-payment-prediction-in-fabric-instead-of-bc/
    title: Late Payment prediction in Fabric instead of BC
    date: "2025-09-10"
    commit: null
    t: null
    quote: Only closed invoices (where you know exactly how long it took to pay) are used to train the model.
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "1173"
source_id: bertverbeek-nl
source_name: Discover MS BC - Bert Verbeek
url: https://www.bertverbeek.nl/blog/2025/09/10/late-payment-prediction-in-fabric-instead-of-bc/
published_at: "2025-09-10T12:06:03.000Z"
author: Bert Verbeek
full_text: false
words: 715
quotes:
  - text: Only closed invoices (where you know exactly how long it took to pay) are used to train the model.
    why_it_matters: Critical principle for ensuring model accuracy by using only reliable historical data without future information leakage
code_objects_mentioned: []
systems:
  - finance
  - reporting
  - integration
versions_mentioned:
  - October 2018 release
preview:
  embeddable: true
  frame_url: https://www.bertverbeek.nl/blog/2025/09/10/late-payment-prediction-in-fabric-instead-of-bc/embed/
  image: https://www.bertverbeek.nl/wp-content/uploads/2026/02/d365businesscentral_512x512.png
  image_alt: null
  image_w: null
  image_h: null
  site_name: Discover Microsoft Business Central - The wonderful world of Business Central
  favicon: https://www.bertverbeek.nl/wp-content/uploads/2026/02/d365businesscentral_256x256.png
  probed_at: "2026-10-07T11:50:55.176Z"
---

# Late Payment prediction in Fabric instead of BC

[Read the post](https://www.bertverbeek.nl/blog/2025/09/10/late-payment-prediction-in-fabric-instead-of-bc/) · Discover MS BC - Bert Verbeek (Bert Verbeek) · 2025-09-10 · 715 words · tier community · reviewed (checked by Opus)

> Building a late payment prediction model in Microsoft Fabric using AutoML instead of the native Business Central feature. The post demonstrates how to export BC customer ledger data, engineer features from payment history, train an automated machine learning model, and score open invoices to forecast payment dates for cash flow planning.

## Key points

- AutoML in Fabric automates model selection, hyperparameter tuning and feature engineering, opening ML to non data scientists
- Business Central customer ledger data reaches Fabric via API or bc2adls; features include payment term days, posting month and weekday, and per-customer payment history
- Only closed invoices train the model; open invoices get predicted days open plus a customer-average baseline and an expected close date
- The trained model is registered in MLflow, and scored results go to a lakehouse table usable in Power BI for cash flow
- The author calls it an experiment; training can take up to 30 minutes

## Quotes

- "Only closed invoices (where you know exactly how long it took to pay) are used to train the model." (Critical principle for ensuring model accuracy by using only reliable historical data without future information leakage)

## Context

- Features: AutoML, Late Payment Prediction, MLflow Model Management, Feature Engineering, Data Export via API, bc2adls Integration, Lakehouse Storage
- Versions: October 2018 release

Source: Discover MS BC - Bert Verbeek, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.