D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

BYOD - General Journal Account Entry Entity

  • 1.  BYOD - General Journal Account Entry Entity

    Posted Aug 27, 2020 05:16 PM
    Hi

    We're currently on version 10.0.11 and using BYOD to export General Journal Account Entry Entity (daily 60k records).  Incremental push no longer works, we've had to move to full push which also regularly fails but gets fixed by dropping entity.  Has anyone else had issues with this entity?
    One of the proposed solutions (apart from moving to 10.0.12) was to use a new entity General Journal Account Entry Reporting however testing on this has also been unsuccessful.

    Regards

    Eric
    #Financeandoperations #BYOD


    ​​

    ------------------------------
    Eric McMahon
    Brisbane
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: BYOD - General Journal Account Entry Entity

    SILVER CONTRIBUTOR
    Posted Aug 28, 2020 07:17 AM
    Hello Eric;

    You're not alone on the BYODB Incremental Export woes...
    We experienced these challenges early on in our D365 journey starting with v7+, through v8+ and onto v10+...
    Our record volumes were just too high to execute a full nightly export across multiple Entities; our solution was to build our own Incremental process through the following steps: (high level overview)
    1. Creation of an 'Azure' (BYODB) Production database
      1. Onetime Full Entity export to populate the Production database Entity tables
    2. Creation of an 'Azure' (BYODB) Staging database
    3. Nightly Data Management Export projects with Entity specific filtering on targeted key fields (Created/Modified date) 
      1. Entities have to be reviewed for key target filtering fields
    4. Custom Stored Procedures to "Merge Into [AX_PRODUCTION].[dbo].[GeneralJournalAccountEntryStaging] as Target"
    5. SQLAgent execution jobs to validate that the 'filtered' Entity was in a READY state and then Execute the MERGE Stored procedure
    Be more than glad to talk this through off line if you desire.
    Joe

    ------------------------------
    Joe MacPherson
    Coldwater Creek
    Hingham MA
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: BYOD - General Journal Account Entry Entity

    Posted Aug 28, 2020 03:10 PM
    Hi Eric,

    We also had an issue with this entity, and many others.  We ended up having to create custom entities.  If you need more information, please feel free to reach out directly.

    BYOD has been a big struggle for us, so we feel your pain!

    ------------------------------
    Sarah Poe
    Luck Stone Corporation
    Richmond VA
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: BYOD - General Journal Account Entry Entity

    Posted Aug 29, 2020 01:57 AM
    Thank you Sarah & Joe. Despite strong advice not to go the custom entity route we may need to do that as well as some filtering.  I'll let you know how we go.

    Regards

    Eric

    ------------------------------
    Eric McMahon
    Senior Advisor
    Queensland Treasury Corporation
    Brisbane
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: BYOD - General Journal Account Entry Entity

    Posted 12 days ago
    Glad to report our issue was resolved and now runs in less than a minute (60k rows per day incremental load). The MS backend team discovered that the query plan on the table was was sub optimal and updated statistics to force a better query plan. On going a full scan is set with Persist_sample_percent set to on. It's been running successfully for a number of weeks now. 😄

    ------------------------------
    Eric McMahon
    Senior Advisor
    Queensland Treasury Corporation
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role