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 30 days ago
    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 30 days ago
    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 29 days ago
    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 29 days ago
    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


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