Customer Aging Report Invoice not set off

(0) Share

Report

Posted on by Community Member

Dear experts

I am using Dynamics AX 2009. My problem is that from last 3 years I didn't set off the invoices against receipt from the customer. So all the invoices of customer still show open status in customer aging report while the payment is already received. Now I want to set off all the invoices.

Can any one suggest me that how can i set off the invoices against all previous receipt. My aging report is not showing the actual information.

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (3)

Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

You could probably write a program to settle all open invoices against all open payment according to a first in/first out mechanism. Three years is a long time and you could have quite a lot of transactions across quite a lot of customers, in theory.

It might just be easier to write-out (the previous day) and write-in (the next day) the current customer balance across all customers, and then use a starting date on the customer external statement to ignore all transactions prior to your "starting over" date. Basically this would just ignore all prior history, but give you a single starting transaction to form the basis for a new series of history.

Either way, there's programming involved, no doubt about it.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,194 Super User 2025 Season 2 on at

Like (0)

Report

Hi Daud,

The customer aging report is able to go back in time based on date selections. Most neat solution would be settling like it was done on the dates in the past. I can imaging this is now too much work when you have to think of date entries.

The best to do would be starting the customer form and per customer try to settle open transactions.

I don't know the number of transactions/customers you have. It might be a hell of a job if you haven't done it for three years. I will not ask you how it would be possible to skip this as this also influences your possibilities of e.g. sending collection letters.

When it would be too much, you can consider a customization which will mark the entries and try to settle the transactions where possible.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ohh you are saying that i will change the session dates to prior date and reverse the entry and then again enter the receipt with setting off the invoice.

you cant imagine it is hell of work and there is thousands of entries even i dont know how much work i have to do with this solution.

Was this reply helpful? Yes No
Verified answer

Brandon Wiese 17,788 on at

Like (1)

Report

You would not have to reverse anything in the past.

You can select an open payment and an open invoice in the past, and as long as you avoid cash discount posting, settle those two transactions together without having any ledger effect at all. My first suggestion was to write an X++ program to do exactly that, in the same way that the CustOpenTrans form lets you do it manually, i.e. using a CustVendOpenTransManager class. Basically, start with the oldest open invoice and the oldest open payment, and settle them, and repeat. They probably won't line up precisely, but if it works you'll simply end up with the most recent open invoices as the only open transactions left on each customer account.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I need some more ellaboration i dont know exactly X++ as im not AX technician or some kind of Ax developer, I am simple finance boy. I can work alot on this project for a week. Please guide me in simple way that from where and how i can settle these open invoices.

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

You're suggesting that you could do it by hand?

How many customers are we talking about, and how many transactions total would you estimate for the full 3 years?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Around 1200 customer and each customer average 30 transactions means total 36,000 transactions. This is all in past three years.

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

Do you have a developer resource that could help you resolve this through code?

Are you using Centralized A/R, which would obviously make the issue more complex?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Our developer resource is in India, but they are not quick to respond, so I want to fix this issue on my own. Tell me how is it possible what is the maximum way to resolve this issue??? Need your kindly reply Thank you

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

You didn't answer my question about whether you're using Centralized A/R, or is all of your A/R within the same company?

Was this reply helpful? Yes No