Krish,
Adding to Andy's reply... This comes up a lot. Standard BC will not work so I have always created a customization/extension to accommodate this. It is not super hard but you will need your Developer. The customization looks like this: NOTE - My example I did for AP side so you'll have to incorporate on AR side and yes, I did this back in NAV v2..5.
AP Multiple Due Dates allows the user to set up payable items to be paid in more than one installment.
- Multiple payments may be set for fixed amounts or percentages of the total amount due.
- Feature is available in either Purchase Orders or Purchase Invoices.
- As scheduled payments are made, payment date is recorder on Multiple Due Date table.
- Multiple Due Dated are recognized when running “Suggest Payments”.
Set Up Requirements:
None.
To Assign Multiple Due dates to a Purchase Order or Invoice:
At the Payment Tab on the form, clicking on the “Multiple Due Dates” box will open the Multiple Due Dates Table:
Spread Amount: - By % of Invoice Amount, Amount($) (US Dollars), Amount (Local Currency)
Amount Due ($): - Installment Amount in US Dollars
Due Date : - Date Installment to be Paid
Total Amount Due ($) must equal Invoice Amount ($) in order to close the screen.
Using “Suggest Payments”; - NOTE: When running “Suggest Payments” and more than one multiple payment appears for an item, they must be combined on one line in the Payment Journal in order for a check to print. When posted, the payment will be applied to the multiple payment table for the item in the proper sequence.
Hope this give you some ideas to resolve.
Hope this helps.
Thanks,
Steve
