Jump to content
  • 0

Retrospective Aged Debtor Report


Jolo35

Question

5 answers to this question

Recommended Posts

  • 0

You can take a look at the documentation on generating custom reports in Blesta. Knowledge of SQL will be necessary, as well as the ability to find the information you need from the database schema.

While not the same, the Aging Invoices report could be used to identify clients that are late on payment for 30/60/90+ days.

Link to comment
Share on other sites

  • 0

Yes i read the Blesta documentation which is an absolute joke. I am OK with SQL but the documentation does not provide a map of the database tables and fields so is completely useless.

Can you point me in the direction of anything that explains how the database is structured or can anyone share their own sql for this type of report?

 

Link to comment
Share on other sites

  • 0

The documentation is directed toward user and developer Blesta system documentation rather than database schema documentation. We don't currently share any UML or ER diagrams, but there are certainly tools available for viewing database schemas (e.g. phpmyadmin, MySQL Work Bench) that can be used for that purpose.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...