I've finally had a chance to get back to this, and I'm doing a complete rebuild from the ground up. Progress on this can be viewed at http://demo.fido-x.net. You can log in to the admin with username/password pair of "demo/demo", and you'll find it under "Fido-Xtras->Financial Statements" (or under "Extensions->Modules", where you'll find a "Financial Statements" module).
This is still in development, so not everything I had before is in there (eg. the charts), but they will be back.
The summary page provides an overview of your website operations as at the current date and default order status (whatever was set in the settings), while financial pages provide data based on the specified date range (and order status). The default date range being the current financial year.
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
keeping my eye to this stuff and to get updating my link collection
I have a question for Financial Statements - Customers. Is the percentage is represent the Geographical info or buying info? I think much interesting when you have a report with geographical information of sales. So we know which customer country had the most selling.
Look forward to seeing more of this.
A question that may be cross-polinating but once a report is generated is there any possibility of, say, usng a customer/product combination to extract emails for use in the "mail" function? Or alternately "dumping" to a csv or rtf for sending emails?
Cheers
A stupid question is the one you -don't- ask.........(Anon)
)C1.5.0.1 (IN devel)
OC V1.4.9.5
OC V1.4.9.2
OC V1.4.7
OC V1.3.4
I've just updated the preview at my demo site (http://demo.fido-x.net/). There's still a lot of work to do, but I thought I'd upload what I've got working at the moment, so you can see how things are going.
Currently provides the following information:
- Summary an overview of your website's operations as at the current date
General Information such as geographical zones, shipping methods, tax rates and currencies
Sales Figures for the selected period
Profit and Loss Statement for the selected period
Sales by Store for the selected period
Sales by Category for the selected period
Sales by Manufacturer for the selected period
Customer Demographics about where your customers come from
Printable Report
Enhanced printable report. Now allows you to add a title to the report. You can also write your own introduction.
The default report provides a summary of your website's operations as at the current date. The report can be tailored to suit your needs by allowing you to select individual pages to include. When finished, hit the "Print to PDF" button to print the report out to a PDF file (not working yet). At the moment, it just opens up in a new window as a web page formatted for printing.
What do you think?

Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!

Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
I dunno. I went to bed one night (well, about 3am), woke up the next day (well, same day), and there I was - green.i2Paq wrote:Fido-x, what the hell happened to you, your as green as...., I am


Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Yep and your as ugly as the other green fellowfido-x wrote:I dunno. I went to bed one night (well, about 3am), woke up the next day (well, same day), and there I was - green.i2Paq wrote:Fido-x, what the hell happened to you, your as green as...., I am![]()

Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
i2Paq wrote:Yep and your as ugly as the other green fellow

Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!


Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
Good to see fido has gone green
As for the financial reports - my initial thought was "I'll pay money for this". It is brilliant and it even caters for Australian financial years. Yay ! I had a hard time with version 0.7.9, trying to make it match the aussie fin year.
With the stock status, it would be good to enable selection by categories or some sort of filter, maybe manufacturer or something.
I modded 0.7.9 to assign products to suppliers. This enables me to call up products by suppliers so I could see what I had to re-order from that supplier. I did it under the product page but it could be in a report.
It would also be good to have a stock-take feature where admin can go down the list and update stock in bulk without having to go into every product individually, but that is not part of a reporting. I am going off topic on this one.
Thanks fido-x. The admin features of oc could do with a bit more but then it all takes time and even more time when the chief architect is trying to run the show with one ubroken arm

Now he needs to get on with his Invoice and Packing-slip add-on

Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
It should only take in calculation the orders with a certain status liked: shipped, instead of every order with every status.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
I have PM'd Fido-x about thisscoobs001 wrote:Any update buddy. ??
I'll also quite happpily pay for this FULL REPORT module.
Scott.

Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
He was away for Christmas plus he has some large paid projects running but he will try to squeeze in some extra time to finish his Full Report.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
Users browsing this forum: No registered users and 14 guests