Arrears Report problem.

zulq
zulq Member Posts: 204
edited 2007-04-06 in NAV/Navision Classic Client
Want to develop a report that shows all customers that are owing for a specific period.
Tables are Customer and Gen. Journal Line. I've being able to display all customers who've not paid for a specific period.
Now my problem is: I want to check the last amount an employer paid in the Gen. Journal Line and the date it was made. Then take that date and subtract it from the current date and multiply it by the amount. Payments are made monthly...So for example if a customer didn't paid for 3 months and the last amount was $500, the the total Arrear will be $1500.
Any ideas please...
Few years ago we were not existing and few years to come we would be in the grave! So what will benefit us in the grave?

Categories