# AnniesApp report console test

Generated: 2026-08-13 04:37
Database: `C:\Users\josh\Documents\projects\sync_coordinator\AnniesApp.mdb`
Scope: unlocked Report Console (28 options + Product Tags)

## Summary

| Check | Result |
|-------|--------|
| Tested | 29 |
| OK (opened with data) | 29 |
| FAIL | 0 |
| SKIP (no seed rows) | 0 |

## Results

| Option | Report | Seed | Status | Detail | ms |
|--------|--------|------|--------|--------|---:|
| 0 Customer Age Analysis | `rptAgeAnalysis` | invoices=31875 as-of=Date() | OK | HasData=True pages=1 srcRows=1 daoRows=31875 | 147592 |
| 1 Customer Statement: Summary | `rptStatement_Sum` | CustomerID=15730 | OK | HasData=True pages=1 srcRows=1 daoRows=1 | 967 |
| 2 Customer Statement: Detail | `rptStatement_Detail` | CustomerID=2 GetData | OK | HasData=True pages=1 srcRows=1 daoRows=32 stagingRows=32 | 1263 |
| 3 Customer History | `rptCustomerHistory` | CustomerID=29312 2023/02/15..2023/02/15 | OK | HasData=True pages=1 srcRows=1 daoRows=1 | 1435 |
| 4 Stock Out | `rptStockOut` | CustomerID=33980 txtDate=2025/03/12 | OK | HasData=True pages=5 srcRows=0 daoRows=21 | 1611 |
| 5 Product History | `rptProductHistory` | ProductID=96568 2023/04/05..2023/04/05 | OK | HasData=True pages=1 srcRows=1 daoRows=1 | 2191 |
| 6 Top X Products | `rptTopProducts` | txtDate=2025/10/01..2025/10/31 txtX=10 | OK | HasData=True pages=0 srcRows=0 daoRows=1110 | 1103 |
| 7 Top X Customers | `rptTopCustomers` | txtDate=2025/10/01..2025/10/31 txtX=10 | OK | HasData=True pages=0 srcRows=0 daoRows=1110 | 672 |
| 8 Stock List | `rptStockListOwner` | OwnerID=1 | OK | HasData=True pages=460 srcRows=1 daoRows=19804 | 2828 |
| 9 Owner Commission | `rptOwnerCommission` | OwnerID=0 2023/02/08..2025/05/27 | OK | HasData=False pages=2 srcRows=0 daoRows=1643 | 1281 |
| 24 Sales Person Commission | `rptSalesPersonCommission` | txtDate=2025/10/01..2025/10/31 goodsType=1 | OK | HasData=False pages=2 srcRows=0 daoRows=1077 | 1439 |
| 10 Customer Balances | `rptInvoicePayment` | CustomerID=15730 | OK | HasData=True pages=1 srcRows=1 daoRows=1 | 1019 |
| 11 Delivery Notes - Not Invoiced | `rptDN_NotInvoiced` | prepDN_NotInvoiced rows=69 | OK | HasData=True pages=2 srcRows=1 daoRows=69 rows=69 | 39585 |
| 12 Delivery Notes - Invoiced | `rptDN_Invoiced` | txtDate=2025/10/01..2025/10/31 | OK | HasData=True pages=17 srcRows=0 daoRows=1077 | 849 |
| 13 Delivery Notes - Payments | `rptDN_Payments` | txtDate=2018/10/01..2018/10/31 | OK | HasData=True pages=25 srcRows=0 daoRows=1563 | 802 |
| 14 Customer by Type: Summary | `rptCustomerType_Sum` | CustomerTypeID=22 | OK | HasData=True pages=1 srcRows=1 daoRows=38 | 1363 |
| 15 Customer by Type: Detail | `rptCustomerType_Det` | CustomerTypeID=22 | OK | HasData=True pages=2 srcRows=1 daoRows=38 | 1655 |
| 16 Wardrobe Person by Type: Summary | `rptWardrobePersonType_Sum` | WardrobePersonTypeID=1 | OK | HasData=True pages=47 srcRows=1 daoRows=3000 | 2191 |
| 17 Wardrobe Person by Type: Detail | `rptWardrobePersonType_Det` | WardrobePersonTypeID=1 | OK | HasData=True pages=121 srcRows=1 daoRows=3000 | 2584 |
| 18 Invoice List for Pastel | `rptInvoicePastel` | InvoiceID>=25229 | OK | HasData=True pages=5577 srcRows=1 daoRows=31875 | 53296 |
| 19 Delivery Note List | `rptDN` | DeliveryNoteID>=38275 | OK | HasData=True pages=221 srcRows=1 daoRows=14115 | 5727 |
| 20 DN by Job Type and Goods Type | `rptDN_Job_Goods` | JobTypeID=2 GoodsTypeID=2 | OK | HasData=True pages=7 srcRows=1 daoRows=413 | 426772 |
| 21 Daily Turn-Over | `rptDailyTurnOver` | txtDate=2025/10/01 | OK | HasData=True pages=1 srcRows=0 daoRows=1110 | 1077 |
| 22 Daily Turn-Over (Invoice) | `rptDailyTurnOverInvoice` | txtDate=2025/10/01 | OK | HasData=True pages=2 srcRows=0 daoRows=1077 | 1499 |
| 23 Daily Turn-Over (Invoice Cleaning) | `rptDailyTurnOverInvoice3` | txtDate=2025/10/01 | OK | HasData=True pages=4 srcRows=0 daoRows=1077 | 29867 |
| 25 Customer Age Analysis (to End Date) | `rptAgeAnalysisDate` | txtDate2=2081/12/15 | OK | HasData=True pages=58 srcRows=0 daoRows=31875 | 76534 |
| 26 Discount | `rptDiscount` | InvoiceDate 2025/10/01..2025/10/31 | OK | HasData=True pages=35 srcRows=1 daoRows=1077 | 48113 |
| 27 Payment Type | `rptPaymentType` | PaymentDate 2018/10/01..2018/10/31 | OK | HasData=True pages=29 srcRows=1 daoRows=1563 | 18989 |
| tag Product Tags | `rptProductTag` | ProductID 119344..119349 | OK | HasData=True pages=0 srcRows=1 daoRows=6 | 2700 |