Leaderboard

See CORE-2010 which describes the ability to create order forms that are not publicly available, but available to authenticated clients who belong to select client groups. I believe this will more effectively fit your purpose, and it's an item we've been discussing internally over the past few weeks.

I'm curious to know why you have database upgrades being processed when re-saving a package rather than upgrading the module?

Hi, As Cody suggested in my previous post about MySQL queries that might give you some insights about critical situations, now I'm making custom report to make it easy to use and export from Blesta admin interface. Output Preview (CSV data): Setup 1. Create a new custom report 2. Put the name you want to the report 3. Paste the following code in Query: SELECT DATE(invoices.date_closed) Day, count(*) "Paid invoices", GROUP_CONCAT(invoices.id SEPARATOR ', ') "Invoices ID", SUM(invoices.paid) "Total Paid" from invoices where invoices.date_closed IS NOT NULL AND MONTH(invoices.date_closed) = MONTH(:chosen_date) AND YEAR(invoices.date_closed) = YEAR(:chosen_date) AND currency = ":currency" GROUP BY DAY(invoices.date_closed); 4. Add the following fields: --- Label: Month Name: chosen_date Type: Date Required: Yes --- Label: Currency Name: currency Type: Text Required: Yes --- 5. Click on Save and now it's ready to be used You can also put the currency field as a Select field with the currency codes you use instead of having to write "USD" (or whatever you use) every time. I'm using this query to get the invoices ID to look and generate e-invoices with a 3rd party API, which is required in my country.

It's in our short-term bucket, so it's not planned for a specific release at the moment. Our short term bucket is what we dig through when planning releases and when we are ahead of schedule. The earliest it would appear is 4.0, but more likely 4.1 or 4.2

I've added these to our "short term" bucket, so they are at least prioritized

Just a note on this. Since this thread was started, we added a setting under Settings > Company > Billing/Payments > Invoice Customization called "Payments/Credits". If this is checked, invoices will show any payments already applied to the invoice. If sending all open invoices to a client, they will be able to see how much is effectively due for each invoice when payments/credits are displayed. The only issue I think, is that it does not show a summary of the total due across all open invoices.

Thanks, that does look strange. Added as CORE-2009.

Thanks, it works!