DUNDON Posted June 15, 2001 Share Posted June 15, 2001 I am currently having a difficult time trying to determine the correct calculation that would asses finance charges on all outstanding bills thirty days past due. Any info would be a great help. thank you Link to comment Share on other sites More sharing options...
Chuck Posted June 15, 2001 Share Posted June 15, 2001 I'm not sure which aspect of such a calculation you're having trouble with, but try something like this: Case( Link to comment Share on other sites More sharing options...
BobWeaver Posted June 16, 2001 Share Posted June 16, 2001 Interest charges are generally easier to handle if you are keeping track of customer balances rather than individual invoices or bills. If you have a customer balance and issue statements once a month it's easy to add interest. Customer balance is calculated as total charges minus total payments. If the balance is not zero at the time of month when you issue statements, you simply create a finance charge billing item equal to the customer's balance times the monthly interest rate. If you do it this way, the interest will compound automatically (and correctly) every month. Link to comment Share on other sites More sharing options...
Chuck Posted June 16, 2001 Share Posted June 16, 2001 Great tip Bob! Chuck Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8372 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now