EX001 Accruals and Simulated Common Library (SGL)

Provides the ability to post simulated general ledger entries and register G/L accruals for sales & purchase documents

Simulated General Ledger and G/L Accruals

Dependency graph

graph TD; Main(Accruals and Simulated Common Library) --> Dep0(EOS Administration Library); click Dep0 href "/it/docs/apps-tech/8bb96677-5112-4566-b742-12eebbb9a058.html" Main(Accruals and Simulated Common Library) --> Dep1(Common Data Layer); click Dep1 href "/it/docs/apps-tech/4e2a89a2-9049-496c-8b3a-f4eee6399b0e.html" Main(Accruals and Simulated Common Library) --> Dep2(Finance Common Data Layer); click Dep2 href "/it/docs/apps-tech/0961643d-d357-43ac-b8ee-0097e9be07c1.html"

Dependencies from

Objects

Codeunit

IDNameDescription
18004101EOS001 Simulated GL Tests
18004102EOS001 DTI Event Handlers
18004103EOS Analisys By Dimensions
18004104EOS Sim. Gen. Jnl.-Post Line
18004105EOS Comp. Post.-Preview Hndlr
18004106EOS001 PostingSubscribers v26
18004107EOS001 PostingSubscribers v25
18004108EOS001 Test Handlers
18004109EOS Sim. G/L Analysis Mgt.
18004115EOS001 SimGL Test Library
18004116EOS001 DTI Tests
18004119EOS001SGL Event Handlers
18004121EOS Sim. G/L Management
18004123EOS G/L Accruals Management
18004125EOS EX001 Navigate Handler
18004132EOS G/L Sim. Reversal
18122511EOS001 DTI Sales Handler
18122512EOS001 DTI Purch. Handler
18122513EOS001 DTI Entry-EditHandles manual changes to a DTI entry from the page.
18122514EOS001 DTI Settlement
18122515EOS001 DTI - Calculate
18122516EOS001 Notifications
18122517EOS001 Test Commit Blocker

PermissionSet

IDNameDescription
18004100EOS001 USER

Enum

IDNameDescription
18004100EOS Accrual Period Type
18004101EOS Accrual Description Source Type
18004102EOS Acc. Schedule Line Source
18004103EOS Depreciation Destination
18004104EOS Simulation Filter
18004105EOS001 Allow G/L Accruals
18004106EOS001 GL Accr. Account Method

Page

IDNameDescription
18004100EOS G/L Balance by Dimension
18004101EOS G/L Balance by Dim. Matrix
18004102EOS001 Acc. Bal. by Entry Type
18004105EOS G/L Accrual Entries
18004108EOS Sim. G/L DimOver.
18004109EOS Sim. G/L DimOver. Matrix
18004110EOS G/L Accrual Templates
18004111EOS G/L Accrual Preview
18004112EOS Competence Dates Setup
18004121EOS Sim. G/L Ledger Entries
18004124EOS001 AccSched Missing Acc.
18004137EOS Calculate G/L Accruals
18122511EOS001 DTI Entries
18122512EOS001 DTI Documents

PageExtension

IDNameDescription
16Chart of Accounts
17G/L Account Card
20General Ledger Entries
39General Journal
46Sales Order Subform
47Sales Invoice Subform
54Purchase Order Subform
55Purch. Invoice Subform
96Sales Cr. Memo Subform
98Purch. Cr. Memo Subform
100Accounting Periods
101General Journal Templates
103Account Schedule Names
104Account Schedule
108Financial Reports
110Customer Posting Groups
111Vendor Posting Groups
116G/L Registers
119User Setup
133Posted Sales Invoice Subform
135Posted Sales Cr. Memo Subform
139Posted Purch. Invoice Subform
141Posted Purch. Cr. Memo Subform
256Payment Journal
350G/L Acc. Balance/Budget Lines
408G/L Balance by Dimension
422G/L Balance/Budget
489Column Layout
490Acc. Schedule Overview
526Posted Sales Invoice Lines
527Posted Sales Credit Memo Lines
529Posted Purchase Invoice Lines
530Posted Purchase Cr. Memo Lines
555Analysis View Card
558Analysis View Entries
569Chart of Accs. (Analysis View)
570Chart of Accounts (G/L)
18123702EOS CDL Source Code Setup
18123706EOS Sales Document Summary
18123708EOS Sales Posted Inv Summary
18123709EOS Sales Posted CM Summary
18123712EOS Purchase Document Summary
18123714EOS Purch. Inv. Summary
18123715EOS Purch. Cr. Memo Summary
18123728EOS066 MDI G/L Account Card

Report

IDNameDescription
18004100EOS001 Update DTI Entries
18004106EOS Close Income Stmt.
18004107EOS C/O Balance Sheet
18004108EOS Calculate Depreciation
18004122EOS AS Balance Sec. Comp.
18004124EOS Close G/L Accruals
18004126EOS Copy Sim. Entries To Jnl.
18004128EOS G/L Account - Entries
18122511EOS001 DTI Get Documents

Table

IDNameDescription
18004102EOS Competence Dates Setup
18004104EOS Document G/L Accrual Entry
18004121EOS Sim. G/L Entry
18004127EOS G/L Accrual Entry
18004128EOS G/L Accrual Template
18122511EOS001 DTI Entry

TableExtension

IDNameDescription
15G/L Account
17G/L Entry
37Sales Line
39Purchase Line
45G/L Register
49Invoice Post. Buffer
50Accounting Period
55Invoice Posting Buffer
80Gen. Journal Template
81Gen. Journal Line
85Acc. Schedule Line
88Financial Report
89Financial Report User Filters
91User Setup
92Customer Posting Group
93Vendor Posting Group
113Sales Invoice Line
115Sales Cr.Memo Line
123Purch. Inv. Line
125Purch. Cr. Memo Line
179Reversal Entry
334Column Layout
361Analysis by Dim. Parameters
363Analysis View
365Analysis View Entry
367Dimension Code Buffer
376G/L Account (Analysis View)
5621FA Journal Line
18123702EOS CDL Source Code Setup
18123709EOS066 MDI G/L Account

Query

IDNameDescription
18004120EOS Analysis View Sim. G/L Src

Build environment

TypeValue
Version26.0.30.0
Application26.0.0.0
Platform15.0
Runtime15.0
TargetCloud
LocaleW1
Commit

Obsolete Items

VersionObjectTypeNameReason
26.0Table 18004128 EOS G/L Accrual TemplateFieldCr.Memo Opposite AccountsUse the field “Account Selection Method” instead.
26.0Codeunit 18004107 EOS001 PostingSubscribers v25CodeunitObjectEOS001 PostingSubscribers v25This codeunit is for BC <=25 posting implementation.
26.0Codeunit 18004123 EOS G/L Accruals ManagementMethodDeclarationCreateGLAccrualEntryNo longer available.
26.0Page 18004110 EOS G/L Accrual TemplatesPageFieldUse Opposite Accounts in CrMemoUse the field “Account Selection Method” instead.
26.0Page 18004112 EOS Competence Dates SetupPageActionImportDataNo longer used.
26.0TableExtension 18004130 EOS_TableExt18004130FieldEOS Accrued by Entry No.Moved to TableExt55 for new posting
25.0PageExtension 18004101 EOSPageExt18004101PageActionEOSPrintBalanceSectCompMoved to Financial Reports Page
25.0PageExtension 18004138 EOS_PageExt18004138PageActionEOSPrintBalanceSectCompMoved to Financial Reports Page
24.0Codeunit 18004123 EOS G/L Accruals ManagementMethodDeclarationOnUpdateSourceRecordNo longer used.
20.0TableExtension 18004126 EOS_TableExt18004126FieldEOS Entry Type FilterFeature no more supported due to technical limits.
19.0Table 18004102 EOS Competence Dates SetupFieldDefault Settlement TemplateNo longer used
19.0Table 18004102 EOS Competence Dates SetupFieldService Settlement TemplateNo longer used
18.0Table 18004121 EOS Sim. G/L EntryFieldSource TypeUse ‘Source Type v2’ instead.
16.0Table 18004121 EOS Sim. G/L EntryFieldEOS Calc. G/L AccrualsUnused
16.0Table 18004121 EOS Sim. G/L EntryFieldAccrual Document TypeUnused
16.0Table 18004121 EOS Sim. G/L EntryFieldAccrual Document No.Unused
16.0Table 18004121 EOS Sim. G/L EntryFieldAccrual Document Line No.Unused
16.0Table 18004127 EOS G/L Accrual EntryFieldTarget Journal TemplateUnused
16.0Table 18004127 EOS G/L Accrual EntryFieldTarget Journal BatchUnused
16.0Table 18004127 EOS G/L Accrual EntryFieldSource TypeUnused
16.0Table 18004127 EOS G/L Accrual EntryFieldSource SubtypeUnused
16.0Table 18004127 EOS G/L Accrual EntryFieldSource IDUnused
16.0Table 18004127 EOS G/L Accrual EntryFieldSource Ref. No.Unused
16.0TableExtension 18004125 EOS_TableExt18004125FieldEOS Calc. G/L AccrualsUnused
16.0TableExtension 18004125 EOS_TableExt18004125FieldEOS Doc. to Invoice Entry No.Unused

Changelog

26.0.30.0

Released: OnPremise: 21. October 2025 | Saas: 21. October 2025

  • 19472: EX001 SGL - In “Chart of Accounts”, if the “Balance at Date” and “Balance at Date (Sim.)” columns are not displayed, the “Balance at Date (Total)” column is not calculated.

26.0.29

Released: OnPremise: 13. October 2025 | Saas: 13. October 2025

  • 18550: EX001 SGL: Do not allow posting of accruals from journals, if “VAT Prod. Posting Group” or “VAT Bus. Posting Group” is set
  • 19438: EX001 SGL In “General Journal”, selecting “Post” having accruals and deferrals returns error “It’s not possible to specify “VAT Business Posting Group”…(COMPLETE TITLE IN SYSTEM INFO)

26.0.28

Released: OnPremise: 09. September 2025 | Saas: 10. September 2025

  • 19064: EX001 SGL - Add Invoice Discount Amount on Accruals amount

26.0.25

Released: OnPremise: 02. September 2025 | Saas: 02. September 2025

  • 19048: EX001 SGL For “Purchase invoice”, trying to launch function “Preview Posting” returns error “Accrued Expense Account must have a value in G/L Accrual Template: Code=(code). It cannot be zero or empty.”

26.0.24

Released: OnPremise: 22. July 2025 | Saas: 22. July 2025

  • 17693: EX001 - SGL - Add filter on field “Blocked” and “Update on Posting” in Analysis Posting

26.0.23

Released: OnPremise: 21. July 2025 | Saas: 21. July 2025

  • 18799: EX001 SGL: “Copy to Journal” report fails with “Cannot convert Record18004121 to Int32”
  • 18550: EX001 SGL: Do not allow posting of accruals from journals, if “VAT Prod. Posting Group” or “VAT Bus. Posting Group” is set

26.0.21

Released: OnPremise: 08. July 2025 | Saas: 08. July 2025

  • 18605: EX001 SGL Generated deadlock and lock timeout, for “EOS001 DTI Settlement”(CodeUnit 18122514).PostAll line 15

26.0.20

Released: OnPremise: 04. July 2025 | Saas: 05. July 2025

  • 18605: EX001 SGL Generated deadlock and lock timeout, for “EOS001 DTI Settlement”(CodeUnit 18122514).PostAll line 15

26.0.19

Released: OnPremise: 02. July 2025 | Saas: 02. July 2025

  • 18605: EX001 SGL Generated deadlock and lock timeout, for “EOS001 DTI Settlement”(CodeUnit 18122514).PostAll line 15

26.0.18

Released: OnPremise: 24. June 2025 | Saas: 25. June 2025

  • 18602: Reduced Locks on DTI Posting

26.0.16

Released: OnPremise: 11. June 2025 | Saas: 12. June 2025

  • 18062: EX001 SGL With negative line in purchase invoice with competence dates, posting are used different g/l accounts
  • 18105: EX001 SGL Posting purchase invoice with n lines, same unit cost and nondeductible VAT %, in ‘G/L Accrual Entries (SGL)’ the field ‘Amount (LCY)’ wrongly rounded

26.0.15

Released: OnPremise: 30. May 2025 | Saas: 03. June 2025

  • 18420: EX001 SGL Add accruals and deferral fields on posted document subpages

26.0.14

Released: OnPremise: 26. May 2025 | Saas: 26. May 2025

  • 18366: EX001 SGL: The field “Source Type v2” is not copied from the original G/L Entry when using “Balance in Sim.”

26.0.13

Released: OnPremise: 15. May 2025 | Saas: 15. May 2025

  • 18233: EX001 SGL - Add parameters to events in Report 18004126 “EOS Copy Sim. Entries To Jnl.”

26.0.12

Released: OnPremise: 08. May 2025

  • 18177: EX001 SGL In “Financial report” the lines don’t include simulated value, if in “(Financial Report) Row Definition” the field “Show” is equal to “No”

26.0.10

Released: OnPremise: 22. April 2025 | Saas: 23. April 2025

  • 18071: EX001 SGL: ‘Acc. Schedule - Missing Accounts’ does not apply filter “Posting Account” unless manual filters are set
  • 17971: EX001: Add support for “Show” field on “Acc. Schedule Line” for simulated G/L entries
  • 17914: EX001 SGL: Using “Get Documents to Invoice” on general journals will now always use LCY
  • 17887: EX001 SGL With field ‘Column type’ = ‘Year to date’ in (Financial report) column definitions’ and ‘Date filter’ filled on ‘Financial report’, here the values of columns about current year and simulated only are discordant
  • 12951: EX001 Add new fields in Financial reports
  • 17736: BC 26 Compatibility

25.0.41

Released: OnPremise: 10. March 2025 | Saas: 12. March 2025

  • 17665: EX001 SGL: Add option to configure which G/L accounts can be accrued

25.0.39

Released: OnPremise: 21. February 2025 | Saas: 24. February 2025

  • 17540: EX001 SGL Add event, in order to calcolate contained entries the subdivided amounts by competence period, considering parameters on selected template

25.0.38

Released: OnPremise: 20. February 2025 | Saas: 21. February 2025

  • 17566: EX001 SGL: Documents to invoice do not correctly handle documents with “Prices Including VAT” = true

25.0.34

Released: OnPremise: 22. January 2025 | Saas: 22. January 2025

  • 16972: EX001 SGL Manage new posting engine for BC26
  • 16582: EX004 EAL Convert permissions from XML to AL

25.0.26

Released: OnPremise: 09. January 2025 | Saas: 10. January 2025

  • 16951: EX001 SGL In page ‘Financial report’, the value of the column that shows the total amount has wrong value

25.0.24

Released: OnPremise: 16. December 2024 | Saas: 17. December 2024

  • 16588: EX001 SGL Optimize run times of codeunit 18122514 ‘EOS001 DTI Settlement’

25.0.20

Released: OnPremise: 21. November 2024 | Saas: 21. November 2024

  • 16582: EX004 EAL Convert permissions from XML to AL

25.0.11

Released: OnPremise: 04. October 2024 | Saas: 07. October 2024

  • 14845: EX001 SGL In page ‘G/L Accrual Entries (SGL)', function ‘Reverse’ set in header of the opened page a specific G/L account

25.0.10

Released: OnPremise: 02. October 2024 | Saas: 03. October 2024

  • 16206: EX001 SGL In page ‘Sim. G/L Entries (SGL)', field content is limited to 50 characters
  • 16140: EX001 SGL Remove obsolete objects for BC25

24.0.22

Released: OnPremise: 03. June 2024 | Saas: 04. June 2024

  • 15156: EX001 SGL In page ‘G/L Accrual Entries (SGL)', when selected ‘Reverse’ for entries posted in G/L linked to invoice or credit memo returns error ‘Impossible to reverse entry (number) because it’s a Invoice document.’
  • 15157: EX001 SGL In page ‘G/L Accrual Entries (SGL)', when selected ‘Reverse’ for entries posted in G/L linked to invoice or credit memo returns error ‘Impossible to reverse entry (number) because it’s a Invoice document.': Development
  • 15271: EX001 SGL Remove page filter ‘Reversed’ equal to ‘No’, in page ‘Sim. G/L Entries (SGL)’ opened from reversed simulated entries in page ‘G/L registers’

24.0.17

Released: OnPremise: 10. May 2024

  • 11039: EX001 SGL Accounting records reversal, reversal of the possible linked accruals

24.0.15

Released: OnPremise: 18. April 2024

  • 14821: EX001 SGL Add, in page ‘G/L Balance/Budget’, fields ‘EOSdebit Sim’ e ‘EOSCredit Sim’
  • 13480: EX066 CDL In ‘G/L entries’, if ‘Source type’ is equal to ‘Customer’/Vendor/bank/fixed asset then add decoding
  • 14610: EX001 SGL Add fields ‘Accrual starting date’, ‘Accrual ending date’, ‘Accrual period’ and ‘Accrual template’ on pages ‘Sales Lines’ (516) and ‘Posted Sales Invoice’ (132)

EOS Labs -