Small and medium business | Business Central, N...

Need to Know the link between Posted Statement and General Ledgur Entries

(3) Share

Report

Posted on by CU03120658-0

Dear all,

As you know, on posted stetement list, thier is Navigate option to show summery for your specific posted statement (Find Entry Page).

Then, when click on G/L Entry system will open General Ledger Entries for only your document.

I need to know what is the link between two pages (open statement and GL entries).

By another words, what is exactly filiter that apply when showing general ledger entries page (when check page filter comes empty).

I am using Business Central 20.4

Thanks

Categories:

Dynamics 365 Business Central

All responses (8)

Answers (0)

Sort by

Suggested answer

VC-29041637-0 114 on at

Like (0)

Report
Copy link

Link copied!

when check page filter comes empty

You have to switch between the table fields/extensions and page filters tab two times. The first time you go to the Page Filters tab it will be empty. The 2nd time it will show your filters

Valentin Castravet

Zander ERP Services
CU03120658-0 51 on at

Like (0)

Report
Copy link

Link copied!

Hi

I am trying more than three times and didn't get filter.

Thanks
Suggested answer

YUN ZHU 103,085 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, generally this is searched through Posting Date and No. fields.
The clues to this can be found in the code.

Hope this can give you some hints.

Thanks.

ZHU
CU03120658-0 51 on at

Like (1)

Report
Copy link

Link copied!

Hi

Thanks YUN ZHU

can we know this filter for which table ?

Thanks
Suggested answer

YUN ZHU 103,085 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, the table is table 265 "Document Entry", but because it is a temporary table, there is no data when opening the table directly.

Thanks.

ZHU
Jun Wang 8,220 Moderator on at

Like (0)

Report
Copy link

Link copied!

could you get a screenshot of what statement you refer to? bank account statement?
CU03120658-0 51 on at

Like (1)

Report
Copy link

Link copied!

Hi All

Posted Statement List :

And when open G/L entry showing bellow:

On GL showing two document no (it's right) but need to know on gl page what exactly the link to master page (posted statement list).

Hope now is clear.

Thanks
Suggested answer

YUN ZHU 103,085 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, the function you mentioned is not a BC standard function, it seems to be part of LS Central.
It is recommended that you ask the partner directly.

https://help.lscentral.lsretail.com/Content/LS-Retail/Safe-Management/Calculating-And-Posting-Statements.htm?TocPath=LS%C2%A0Central%7CBackOffice%7CStore%20Management%7C_____6

Thanks.

ZHU