General Ledger

Summary

Use general ledger to define and manage the legal entity’s financial records.

Dynamics 365 Menu Item(s)

• General ledger > Inquiries and reports > Trial balance > All transactions (Button)
• General ledger > Inquiries and reports > Voucher transactions

Legacy data model’s data entities

• PMBI_deFACTGeneralLedger
• PMBI_deFACTGeneralLedgerv2

New data model’s data entities

• FNBI_GeneralJournalAccountEntryEntity
• FNBI_GeneralJournalEntryEntity
• PMBI_EnumsTableEntity
• FNBI_FiscalCalendarPeriodEntity
• FNBI_Ledger
• FNBI_CompanyInfo

Synapse link approach tables

• GeneralJournalAccountEntry
• GeneralJournalEntry
• PMBIENUMSTABLE
• FiscalCalendarPeriod
• Ledger
• CompanyInfo
  

Field level functional description

• AccountingCurrencyAmount_: The amount of the transaction in the accounting currency.
• AccountingDate: The date when the accounting entry was recorded.
• AllocationLevel: The level at which the allocation is performed (typically a code or number).
• GeneralJournalEntryCREATEdBy: The user or system that created the general journal entry.
• GeneralJournalEntryCREATEdDateTime: The date and time when the general journal entry was created.
• HistoricalExchangeRateDate: The date used for determining the historical exchange rate for the transaction.
• IsCorrection: Indicates whether the entry is a correction (typically a flag or code).
• IsCredit: Indicates if the entry is a credit (typically a flag or code).
• JournalCategory: The code or identifier for the journal category.
• JournalCategoryName: The name of the journal category associated with the entry.
• JournalNumber: The unique number assigned to the journal entry.
• Ledger: The identifier for the ledger in which the entry is recorded.
• LedgerAccount: The account number or code in the ledger where the entry is posted.
• LedgerEntryJournal: The identifier for the ledger entry journal.
• LedgerPostingJournal: The identifier for the posting journal in the ledger.
• LedgerPostingJournalDataAreaId: The data area ID for the ledger posting journal.
• MainAccount: The main account code associated with the entry.
• PaymentReference: Reference information related to the payment.
• PeriodType: The type of accounting period (e.g., month, quarter, year).
• PostingLayer: The code or identifier for the posting layer.
• PostingLayerName: The name of the posting layer (e.g., current, tax, operations).
• ProjTableDataAreaId: The data area ID for the related project table.
• Quantity_: The quantity associated with the transaction.
• ReasonRef: Reference code indicating the reason for the entry.
• ReportingCurrencyAmount_: The amount of the transaction in the reporting currency.
• SubledgerVoucher: The voucher number from the subledger.
• SubledgerVoucherDataAreaId: The data area ID for the subledger voucher.
• Text: A textual description or note for the entry.
• TransactionCurrencyAmount_: The amount of the transaction in the transaction currency.
• TransactionCurrencyCode: The code for the currency in which the transaction was made.
• TransferId: Identifier for the transfer transaction.