codbex / codbex-electra

e-Commerce Backoffice Management Application
https://codbex.com
Eclipse Public License 2.0
0 stars 0 forks source link

Collect commonly used widgets and reports #124

Open iliyan-velichkov opened 6 months ago

iliyan-velichkov commented 6 months ago

Collect commonly used widgets and reports. Add collected widget and report types in the comments.

MinaDoncheva commented 6 months ago

REPORTS

1. Unpaid Sales Orders

  • Basic report filtering all unpaid orders
  • Ordered by unpaid orders per customer
  • Ordered by unpaid amount per customer
  • Ordered by due date of the unpaid order

2. Unpaid Purchase Orders

  • Basic report filtering all unpaid orders
  • Ordered by unpaid orders per customer
  • Ordered by unpaid amount per customer
  • Ordered by due date of the unpaid order

3. Cashflow Report

  • monthly report of SUM(Income - Expenses) according to invoices

4. VAT report

  • monthly report of SUM(Sales VAT - Purchase VAT)

5. Inventory records

  • Inventory in Hand - shows current availability of goods

6. Top Customers

  • Report of customers, ordered by total amount of closed orders

7. Top Sales Orders

  • Report of sales orders, ordered by amount

8. Top Products

  • Report of products, ordered by number of orders
  • Report of products, ordered by revenue
  • Report of product categories, ordered by units

9. Shipping

  • Report about shipping costs
  • Pending shipments
  • Processing shipments
  • Complete shipments
  • Cancelled shipments