Is it possible to refer to date of last dunning?

[Former Member]

Hello,

I want to refer to the date of the last dunning in the Dunning text.

The technical solution is no problem with Coresuite Designer, but where to get the needed value?

I know there is the value DunnDate in OCRD (BusinessPartners), but this value is overwritten by the Dunning Wizard and so there is always the actual date in this field.

Is there a standard SAP Business One Solution e.g. a special field?

Or has anybody had the same problem and designed a pragmatic solution which he/she wants to share here?

Thanks in advance,

Daniel

[K_Pauquet · Accepted solution]

Hi Daniel,

past dunning dates are kept in the field 'DunnDate' in the ACRD, only the last dunning date is kept in the OCRD.

You could create a query looking for the latest date in the ACRD & bring that into a udf on BP header level.

All the best,

kerstin