Skip to main content

Notifications

Announcements

Forum Structure Changes Coming Soon!
News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Filter by legal entity...
Finance forum
Answered

Filter by legal entity when exporting database in LCS

(0) ShareShare
ReportReport
Posted on by AB-24101041-0 15
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?
Categories:
Lifecycle Services
  • AB-24101041-0 Profile Picture
    AB-24101041-0 15 on at
    Filter by legal entity when exporting database in LCS
     
    Thanks, much appreciated!
  • Verified answer
    Anthony Blake Profile Picture
    Anthony Blake 2,052 Super User 2024 Season 2 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 1,595 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 83 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 1,595 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

News and Announcements

Forum Structure Changes Coming Soon!

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Replay: Dynamics 365 Community Call ERP Edition | October 9, 2024

Another great gathering of our Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,782 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,067 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans