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

How do you get the "closed at date" field from the customer entries table?

(0) Share

Report

Posted on by phkGZ

I need to find this field, in order to calculate our average "days late" in customer payments.

In old NAV I could just take a copy of table 21 (customer ledger entries), and the field is there.

But in BC; it's missing. If I pull the odata for table 21, a lot of other fields are there, but not closed at date. I have tried to check all the tables I can that are available, like "applied customer entries" but none have "closed at date".

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Vaishnavi J 3,096 on at

Like (0)

Report
Copy link

Link copied!

Hi,

In CLE table there is Closed at date. You cannot see in the page itself but it is in table of CLE. If you check on Inspection page of CLE you can see Closed at Date.

You cannot add this field Closed at date in CLE page using personalize method but if you are working on sandbox use design option to get the field in the page.

If you want this field in CLE page in production then you need to set the visible true for this field by writing a piece of code.

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

Was this reply helpful? Yes No
phkGZ 44 on at

Like (0)

Report
Copy link

Link copied!

Hi

If it's part of CLE how come it does not download as part of the CLE ODATA file? I have not come across that problem before, where it only downloads an incomplete portion of the underlying dataset.

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

I am not sure what API you use to pull the customer ledger entries.

But if the API is not providing you the data you need you can create your own custom API and make sure the needed fields show there.

learn.microsoft.com/.../devenv-develop-custom-api

Was this reply helpful? Yes No
phkGZ 44 on at

Like (0)

Report
Copy link

Link copied!

Hi Inge. I'm using the standard one - but I have also tried to create my own dataset. Based on object 25 (customer ledger entries), I can select from exactly the same set of fields as are included in the standard API.

But "closed at date" is missing :-(

I suspect "closed at date" is part of another object, but I can't find which one. I have tried a number of them without success.

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

It is not a part of another object. It is part of table 21. And its field no. 45. It is not even a flow field.

field(44; "Closed by Entry No."; Integer)

field(45; "Closed at Date"; Date)

{

Caption = 'Closed at Date';

}

Can you share the code for your API?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you are using Custom API page, then you have to show that field into that same page and again call the OData API.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Vaishnavi J 3,096 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you are creating your own custom API you can add closed at date. Refer the below screenshot.

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

Was this reply helpful? Yes No
phkGZ 44 on at

Like (0)

Report
Copy link

Link copied!

Hi! Thanks for the help. Seems the only solution is to create a custom API.

My API link looks like this:

https://api.businesscentral.dynamics.com/v2.0/MyTenantID/Production/ODataV4/Company('My Company')/Debitorposter_Excel

Was this reply helpful? Yes No