Credit management- Check after due date
Usually my client creates a Sales Order for a party for 1000 units and then as per the requirement they keep on creating Delivery against this Sales Order.
Now their requirement is to check if any open Delivery or Billing is there for more than 3 days the system should not allow to create the Delivery or PGI, even if the user try to create the Delivery with respect to already created sales Order.
For Example :-
Credit Limit of Customer XYZ is 100000 INR, Update group :- 000015, Automatic Check
Sales Order 123 created on 01.07.2009 for Customer XYZ for 1000units and 50000 INR
Created three Deliveries D1, D2 and D3 for total quantity 100 units and 5000 INR on 02.07.2009
Now again on 05.07.2009 the user wants to create another delivery say D4 with respect to Sales Order 123, for 1 unit and value 50 INR, the system should NOT allow the user to create the same, or give a warning and stop doing PGI.
I have tried doing it by maintainig the Oldest open Item for 3 days in OVA8, but unable to achieve the result.
So experts, will you please guide me?
thanks in advance