40
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".
Hi! Thanks for the help. Seems the only solution is to create a custom API.
My API link looks like this:
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.
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.
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?
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.
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.
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.
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.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,430
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
