You can manage it by using the A/R aging report to show only prepayments.  Add an optional field to the customer master for the plan's balance, then customize the aging report to show the difference between the plan and the sum of prepayment total.

You can manage it by using the A/R aging report to show only prepayments.  Add an optional field to the customer master for the plan's balance, then customize the aging report to show the difference between the plan and the sum of prepayment total.

Thanks Jay, But this will only provide the Balance.

To manage the Payment Plan and query the following Payment Dates missed, expected payments per date etc