Project report which includes payments received - ByDesign

[crobinson1]

Hello. We are trying to create a report which will include the project information, invoiced amount and payment received all on one report. Has anyone else been able to create this report? We are not seeing a standard report option.

Thank you!

Christie Robinson

[AhmedYasser1]

Hello christie,

I wanted to know if you resolved this issue as Iam having the same requirement.

Thanks and regards,

Ahmed

[Olivier_R]

Hi Christie,

There is no standard report for that and you can build one but it may be a bit complex. The issue is that receivables are recorded only at invoice level but projects (and other cost objects) are assigned at the level of invoice line.

To build your report, you need to join the needed data sources as per the following schema : project => invoice line => invoice => receivable => payment.

If you always assign only one projet to one invoice (= all invoice lines are assigned to the same project), no need for specific calculation and you can assign the receivable / payment amount to the project. If not (=different projects on invoice lines in one invoice), you will then need to create some calculated key figures to distribute the receivable / payment amount among the invoice lines and so the project.

And if you have payments directly on projects (payment allocation to G/L account with project info), the schema will not work as you don't have business documents and so no receivable, just a revenue entry.

Hope this helps !

Olivier