cancel
Showing results for 
Search instead for 
Did you mean: 

statement/aging

Former Member
0 Kudos

We are on 2005 and I am currently re-writing the aging and statement report, our customers are used to seeing only the open invoices on statements and the built in statement report shows everything- and the aging shows full invoice amounts for invoices that have been partially paid and that confuses our collections/AR people as they are used to only seeing open amounts.

My question is, has this changed at all in 2007?

Also there is no service charge built into statements, so since I am doing a custom statement I will have to pull dunning info from the tables, has this been integrated at all in 2007? Thanks!

CH

Accepted Solutions (1)

Accepted Solutions (1)

former_member583013
Active Contributor
0 Kudos

Chris,

I don't think dunning charges have been added to the Customer Aging in 2007. But I wish to differ from you in your statement that the Aging shows all Invoices.

Infact if the payment has been posted on an Invoice, then only the balance due amount show on the Aging and also the statements.

I am not sure if the payments you are talking about have been received against the invoice or they are payments on account for that BP.

Also, run your Aging reports By Sales documents.

Regards

Suda

Former Member
0 Kudos

Ok I will have them try by sales doc- When they run by journal entries the total balance seems ok but the past 30/past 60 days amt etc appears to show full invoice amounts even if they are partially paid against that invoice.

The statement was the one that did seem to show invoices that had been paid, but maybe running by sales doc will fix this as well?

Could you educate me on how the 'by sales document' and 'by journal entry' differs? You can tell I am not in accounting

Thanks!

former_member583013
Active Contributor
0 Kudos

I think when you run by Sales document, the query goes by the Documents posted and the amounts found in the Documents as BalanceDue and DocTotal and so on.

When you are doing it by Journal Postings, it shows all the Journal entries pertaining to that BP and does not recognize the reconcilations (unless you have Display Reconciled transactions unchecked)

Recommendation is to use by Sales documents.

Suda

Former Member
0 Kudos

Ok running it that way sorted things out, thanks for that!

One other question- I just need to add the interest amount that is generated by the dunning report to the statements in PLD, should I be able to access that info, I know it is in the DWZ2 table- also there seems to be a calculated interest field on the screen when you run statements, but I'm not sure where that is pulling from or if that is accessible to the PLD as well. Thx,

former_member583013
Active Contributor
0 Kudos

Chris,

I really wish I could say it would be easy to get this but unfortunately, I think the Statement or Aging provides access to Header tables like Dunning letters and Dunning terms.

You can try to hold the Shift+Alt key as you click on the table selection drop down. This lets you see all the tables in the database.

You might be able to add the field you want but I am not sure about the results.

Regards

Suda

Former Member
0 Kudos

Ok got the field to show but it shows all records not just this bp or related invoice- I assume I should be able to use relate to the document field- is there a link to PLD docs somewhere, I can't seem to locate them. Thanks!

Answers (0)