Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Filter by legal entity when exporting database in LCS

(1) ShareShare
ReportReport
Posted on by 38
When exporting the database of a UAT environment (sandbox) in lifecycle services, I want to filter the exportation by legal entity.
Means I don't want the bacpac file to contain all the legal entities.
Is there any way to filter before beginning with the export process?
  • AB-24101041-0 Profile Picture
    AB-24101041-0 38 on at
    Filter by legal entity when exporting database in LCS
     
    Thanks, much appreciated!
  • Verified answer
    Anthony Blake Profile Picture
    Anthony Blake 2,302 Super User 2025 Season 1 on at
    Filter by legal entity when exporting database in LCS
    Hi,
     
    Not possible unfortunately, the export/backup is a database level operation, and the legal entities are all in the same DB & tables. 
     
    You could investigate removing the other legal entities prior to the backup?
     
    Anthony
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 2,179 Super User 2025 Season 1 on at
    Filter by legal entity when exporting database in LCS
    It is not possible to do from LCS, since it does not understand the data model of F&O.

    If you only want specific legal entities in your BACPAC file, your best option is to import it into a staging environment, and clear out the data you don't want, and then export it from that environment.

    So some sort of data clearing process following your exports.
  • CU09091357-0 Profile Picture
    CU09091357-0 259 on at
    Filter by legal entity when exporting database in LCS
    I'm currently facing the same issue, when creating a bacpac file, I don't want to include all companies (legal entities) in it
  • Suggested answer
    Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 2,179 Super User 2025 Season 1 on at
    Filter by legal entity when exporting database in LCS
    No, you cannot order LCS to export only specific legal entities.
    Question: Why do you only want to export some legal entities and not all?
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,234 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,994 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans