Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / LedgerTransType and Le...
Finance forum
Answered

LedgerTransType and LedgerPostingType

Posted on by 30

Hi,

I am working on BYOD to push data into Azure SQL DB. 

I have setup [dbo].[GeneralJournalAccountEntryEntity] 

It has 2 fields PostingType and JournalCategory(which I came to know is LedgerTransType from google search)

How do I add these entities in BYOD? I couldn't see these entities in the entity list

Regards

Raj

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: LedgerTransType and LedgerPostingType

    Hi Raj,

    These are sequential and starts from value 0. So, in this case, None is 0, "Transfer" is 1.

    Some of the enum elements have a property enum value from which you can find their actual int values.

    pastedimage1602091046904v1.png

  • RajMaddala Profile Picture
    RajMaddala 30 on at
    RE: LedgerTransType and LedgerPostingType

    Sorry, I couldn't see int values. I can see only descriptions

    pastedimage1602087984808v1.png

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: LedgerTransType and LedgerPostingType

    Yes you can find the values for the enums under and their corresponding int value under AOT\BaseEnums.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: LedgerTransType and LedgerPostingType

    Hi Raj,

    These fields are present in the GeneralJournalAccountEntryEntity.

  • RajMaddala Profile Picture
    RajMaddala 30 on at
    RE: LedgerTransType and LedgerPostingType

    Ok, these are not in Entities?

    I can see in AOT as BaseEnum

    All values are listed there

  • RajMaddala Profile Picture
    RajMaddala 30 on at
    RE: LedgerTransType and LedgerPostingType

    Hi Gunjan,

     These two fields available in the entity mentioned in the original post.

    These are Ints.

    When I google it, it came as LedgerTransType

    docs.microsoft.com/.../gg882656(v=ax.60)

    In BYOD, I need to select entities. Which entity these values are stored?

    How do I know the entity name

    Thanks

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: LedgerTransType and LedgerPostingType

    Hi Raj,

    These two fields are available in the entity. These are fields of type enum and will appear as integers.

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

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 …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans