Reg: Dynamic Credit limit exceeded Value for reporting purpose.

[ravi_kumar100]

Dear All,

We are in the process of creating a Report for Monitoring Customer Credit Limit release date & time along with the value exceeded for every Sales Order.

If anybody have worked on a similar requirement kindly provide suggestions as the value gets determined dynamically and not stored in any table.

Regards,

SRK

[VeselinaPeykova]

Value exceeded at which point in time?

Imagine the following scenario: customer A limit 100 eur, no documents pending.

order 1: 110 eur, gets blocked. Should you write 10 here or nothong?

order 2: 120 eur, blocked and released, so now we are with 20 EUR over the limit

order 1: we release it from credit and are 130 over the limit. What the user expects to see in the report - 130, 20, 10, nothing?

order 2: rejected, we are 10 over the limit - what value to show for each order?

Incoming payment for 50 EUR + order recheck. Order 1 should become approved instead of released. What value to show in the report then?

I wonder why the business needs that specific piece of information information and how it is meant to be used. Probably there is a very good reason why they requested that, so if you manage to clarify these topics with the business users, the technical part will be easier - most likely you will end up populating the values in some z-table on certain events.