Sage 100

Finance Charges - v4.5 - Which table does one find Customer finance charges? Client is looking for amounts (not number) charged to California accounts for the past two years. They found a report but they would like the amount. Are records written to the Invoice history file? I am think not.

They are in the open invoice file.

Doesn't a lot of good once the open invoice is purged......... I personally think this is a serious design flaw. A REAL invoice should be created when finance charges are applied.

You could probably use the transaction history file?

We have a client that wanted to send out finance charge invoices. They determined they are more likely to get the FC paid if it's in the form of an invoice. So we created a VI job to create A/R '-FC' invoices from the Finance Charge calculation files. They would calculate finance charges, import into AR Invoice data Entry, clear Finance Charge calculation, print and post. They could then use Paperless Office to deliver the invoices, too.

AR Transaction history file only hangs around as long as the open invoice file detail. Unless they have changed that.

Interesting concept Bill on producing the finance charge invoice. Thanks for posting

@BillPfahnl - An oldie but goodie. I am assuming that you are pulling the data via ODBC connection directly from the AR_FinanceCharge table. If so, how are you creating the invoice number? It doesn't appear that you can pick a column from the table for the next function. v2013

@JeffSchwenk Yes, pulling data via ODBC. The invoice number simply mimics the Finance Charge system where it's mmm####-FC, where mmm = month and then a sequence starting at 0001.