Finance | Project Operations, Human Resources, ...

Open customer transactions report

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Teodora,

See link below and see if it helps.

docs.microsoft.com/.../open-transactions-report-custtransopenperdate

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Teodora,

The open transactions reports should have this information.

Please check: AR/inquiries&reports/open transactions report

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

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.

Regards,

Teodora

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Best report based on what you are looking for might be detailed aging report.

Was this reply helpful? Yes No
Tristan Chisci 80 on at

Like (0)

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Regards,

Teodora

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for the suggestion Satish, however this report is not built for this purpose as well.

Was this reply helpful? Yes No
Suggested answer

Bianca Vlad 10 on at

Like (1)

Report

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

Was this reply helpful? Yes No