web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

LedgerTransType and LedgerPostingType

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    35,423 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.

  • RajMaddala Profile Picture
    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

  • RajMaddala Profile Picture
    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

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

    Hi Raj,

    These fields are present in the GeneralJournalAccountEntryEntity.

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

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

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

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

    pastedimage1602087984808v1.png

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    35,423 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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,028

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 878 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 579 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans