How to bring LCY (Local currency ) from BC to MS fabric

(2) Share

Report

Posted on by areghuraman

I am ingesting BC data to MS fabric Bronze layer . How can I bring flowfields like LCY to fabric or how can I get the backend calculation to replicate same during transformation to silver layer in fabric . I need to bring the LCY but can't find the back end calculation . What would be the correct approach to achieve this .

Categories:

Dynamics 365 general

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report
Hi there,

When ingesting data from Business Central (BC) into Microsoft Fabric, especially flowfields like LCY (Local Currency), it's important to understand that flowfields are calculated fields, not stored directly in the database.

Here’s how you can approach this:

Use OData or APIs:

When extracting data via OData or BC APIs, flowfields like LCY are typically not included unless explicitly exposed.

Consider creating a custom API page in BC that includes the LCY field as a calculated field.

Replicate the Calculation in Fabric:

If you can't extract LCY directly, replicate the logic in the Silver layer using transformation rules.

LCY is usually calculated using:

Amount × Exchange Rate

You’ll need to bring in the Currency Exchange Rate table and apply the correct rate based on the transaction date and currency code.

Use Dataflows or Notebooks:

In Fabric, use Dataflows Gen2 or Notebooks to apply the transformation logic during the Bronze-to-Silver transition.

Documentation Reference:

Microsoft’s documentation on flowfields and currency exchange can help you replicate the logic accurately.

Let me know if you’d like help building the transformation logic or creating a custom API page in BC!

Please verify if this response was helpful.

Best regards!

Was this reply helpful? Yes No