Dynamics Community Forum Thread Details

I'm trying to go live with Usage-Based Billing (Subscription Billing module) and every usage data import ends with the same error, no matter what I change in the file or setup.

Environment

1. Business Central version: 28.1

2. Module: Subscription Billing / Usage-Based Billing (UBB)

3. Usage Data Supplier: Type = Generic, Data Exchange Definition = USAGEBASED (used the existing standard definition built by Microsoft - Table ID 8018, Mapping Codeunit 8030, all Column No. → Field ID mappings correct)

What happens

After running Process Data on an imported file:

Field	Value
No. of Usage Data Blobs	1
No. of Imported Lines	0
No. of Imported Line Errors	0
Processing Step	Process Usage Data Billing
Processing Status	Error
Reason (Preview)	No data found for processing step Process Usage Data Billing.

So the file is accepted (blob count = 1), but zero lines ever make it into the Usage Data Generic Import table, with zero line-level errors logged to explain why - and the pipeline only reports failure four steps later, at the billing stage, rather than where the data actually stops flowing (Create Imported Lines).

What I've already ruled out

Tested independently, with no change in outcome each time:

Column Separator: tried Comma and Semicolon (matching the Column Separator setting each time)

Date format/culture: tried MM-DD-YYYY/en-US and dd.MM.yyyy/de-DE (matching Column Definitions each time)

Decimal culture: tried en-US (period) and de-DE (comma)

Line endings: tried LF and CRLF (matching the Line Separator setting)

Column Count: tried matching it to both the number of Column Definitions rows (16) and the highest Column No. used (24)

Subscription Lines: confirmed Usage Based Billing = Yes, linked to a Customer Subscription Contract, and connected to a Usage Data Supplier Reference (Type = Subscription)

Every combination produces the identical result: 0 imported lines, 0 line errors, then "No data found" at the billing step.

Question

Since the file content and every format variable appear to be ruled out, has anyone seen this specific error and found what actually causes Create Imported Lines / Process Imported Lines to silently produce zero output? Is there a setting outside the Data Exchange Definition (e.g., on the Usage Data Supplier, the Subscription, or the Usage Data Supplier Reference) that's required for lines to actually populate table 8018?

Any working example file + Data Exchange Definition combo would be hugely appreciated.

Regards,

Jeel (https://in.linkedin.com/in/jeel-paun)