Hello everyone,
Is there a report in Finance and Operations 365 where I can get information about open transactions per customer on a specific date?
Regards,
Teodora
Hi Teodora,
There is a parameter to exclude future settlements on the Open Transactions report. if you set to true then the balance should be reflected accurately when you set the as of date in the past.
Thanks
Bianca
Thank you for the suggestion Satish, however this report is not built for this purpose as well.
Yes, the aging report does the same.
I am just wondering whether this report ( the open transactions report) used to work differently and now something is changed?
Currently, we have not managed to find a way to overcome this with any other report.
Hello Teodora,
We are facing the exact same issue here.
We tried to do as Satish said but the Customer Aged Balance report face the exact same problem.
Let's say a customer got 2 invoices : first one on 10/09/2019 for 100 euros and second one on 20/09/2019 for 200 euros.
Balance as of 30/09/2019 : 300 euros
Balance as of 15/09/2019 : 300 euros -> Should be 100 euros.
We have created a ticket about this problem on the vendor side, I think I will also raise the issue for the customer side.
Does everyone knows if there is an "update financial" or "rebuild balance" which could fix this issue?
Regards.
Tristan.
Best report based on what you are looking for might be detailed aging report.
Hi Ludwig,
We checked this report already and this does not serve our purpose exactly.
For example, if we generate this report on two different calendar dates ( let's say 15.10.2019 and 01.11.2019) with the exact same entry date (let's say 30.09.2019), the report will not show the same results if there were payments between these periods. If a payment was made after the initial generating of the report on 15.10 that will reflect on the report and will not show the transaction the next time we generate the report, even by using the same entry date.
The open transactions reports should have this information.
Please check: AR/inquiries&reports/open transactions report
Best regards,
Ludwig
See link below and see if it helps.
docs.microsoft.com/.../open-transactions-report-custtransopenperdate
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 846 Super User 2025 Season 2
CA Neeraj Kumar 838
Sohaib Cheema 818 User Group Leader
