Obtaining DunningLevelInformation

[jnemo]

This here is Invoice A as shown in Invoices and Memos -> Financial Details (AR301000)

And this is Invoice B found in the same place

The same can be seen in Dunning Letter History in ERP where, as expected, we find Invoice B and not Invoice A.

But querying CustomerInvoice for Invoice A via API gives me

"dunningLetterDate": "2021-01-26T00:00:00",
"dunningLetterLevel": 1,

and for Invoice B

"dunningLetterDate": "2021-11-04T00:00:00",
"dunningLetterLevel": 1,

I don't really understand this result. I've been unable to differentiate between these two via API. Am I missing something obvious?

[Yıldırım]

Hello,

We're unable to reproduce the mentioned issue. Please review and send us the details of the following modules/steps with print screens.

How do you fetch the Invoice A & B, is that a GET Specific Customer Invoice request ? Please send the URL. 

1) Go to > Dunning letter history by document <ScreenId=AR408500> and check the listed invoices based on the customer. (Make sure the start date set ">=" 2021-01-26  based on Invoice "A" dunningLetterDate.)

2) e.g Customer Invoice: "00228" > Dunning Level: "0" > Does not show Dunning Information in the Customer Invoice:"00228"(ERP UI) and does not return the following information via the GET /api/v1/customerinvoice/00228

"dunningLetterDate": "xxx",
"dunningLetterLevel": x

3- What is the company Customer Ledger Preferences > Dunning Settings <ScreenId=AR101000> ? 

[jnemo]

Ok, that's probably good.

The JSON was from

GET https://integration.visma.net/API/controller/api/v1/customerinvoice/INVOICENUMBER
GET https://integration.visma.net/API/controller/api/v1/customerinvoice?dunningLevel=1

<ScreenId=AR101000>

So it seems I was too hasty looking at Dunning Letter History yesterday. Here is A

And for B

Ok, so it seems api/CustomerInvoice includes Drafts when returning dunningLetterDate/dunningLetterLevel?

I'm after Invoices with a DunningLetterLevel that is 1 where the DunningLetter also has Status Released. Is there a way of doing this? Or getting the list of the actualy DunningLetters?

[Yıldırım]

Hello, 

---

@jnemo wrote:

Ok, so it seems api/CustomerInvoice includes Drafts when returning dunningLetterDate/dunningLetterLevel?

---

That's true.

---

@jnemo wrote:

I'm after Invoices with a DunningLetterLevel that is 1 where the DunningLetter also has Status Released. Is there a way of doing this? Or getting the list of the actualy DunningLetters?

---

currently, it's not possible to filter the data based on "Dunning letter status".   

This can be registered as a wish for improvement in the "Ideas" part of the community.