Description
#####MUST BE A POSTGRESQL EXPERT!#######
Objective:
This exercise assesses your ability to troubleshoot and optimize an existing PostgreSQL table leveraging the provided data from the Excel file. The task is to download the invoice sample data.xlxs file, download PostgreSQL if not already downloaded, copy, paste, and analyze the already existing code within the get_sales table, upload the same the invoice sample data excel file to PostgreSQL as this will be where you will spot the issues in addition to the data that will be leveraged, in the issues listed below you will see the problem that need to be fixed in addition to examples on where to spot the problems. Provide detailed explanations, annotations, and screenshots of the issues being fixed which will be within the get_sales table.
Issues:
Unpaid Invoices are showing up as fully paid by a credit memo even if the credit memo is only covers part of the invoice
Invoice example 67849
Invoices that have been fully paid by credit memo should be automatically marked as paid in retool
example 67272
When manually changing the sales agency for an invoice on the invoice page there are duplicates of every agency
Invoices paid from bank deposits in Quickbooks are not being calculated correctly
Invoice example 66937
PostgreSQL database schemas, queries, and tables:
SELECT
“RefId” as ref_id, — this is either the sales_receipt id or invoice id, depending on which quickbooks table this row came from
“SaleDate” AS “Sale Date”,
“CustomerName” AS “Customer”,
“State”,
“AgencyID” AS agency_id,
“AgencyName” AS agency_name,
“CustomerPO” AS “Cust PO #”,
“RefNumber” AS “Invoice or receipt #”,
“SaleTotalAmount” AS “Total $”,
“PaidAmount” AS “Payment Recv”,
“Credits/Refunds” AS “Cred Memo or Refund”,
“CommissionableAmount” AS “Comm Amt”,
“DatePaid” AS “Date Paid”,
CASE WHEN “PaidAmount” >= “SaleNetAmount” THEN ‘Paid’ WHEN “PaidAmount” = 0 THEN ‘Unpaid’ ELSE ‘Partial paid’ END AS paid_status,
“CommissionPaidDate” AS “Comm Date Paid”,
“CommissionPercent” AS “%”,
“Notes” AS notes,
“Voided” AS voided,
“SaleType” AS sale_type
FROM (
select ‘NEW’ as “Source”
, t.”InvoiceId” as “RefId”
, i.txndate::date as “SaleDate”
, i.duedate::date as “DueDate”
, i.customerref__name as “CustomerName”
, i.billaddr__countrysubdivisioncode as “CustomerState”
, ic.stringvalue as “CustomerPO”
, t.”InvoiceNumber” as “RefNumber”
, GREATEST(0, (i.totalamt::numeric – COALESCE(t.”CreditMemo”, 0))) as “SaleNetAmount”
, i.totalamt::numeric as “SaleTotalAmount”
, COALESCE(t.”PaidAmount”, 0) as “PaidAmount”
, LEAST(COALESCE(t.”CreditMemo”, 0), i.totalamt::numeric) as “Credits/Refunds”
, GREATEST(0,
i.totalamt::numeric – COALESCE(iline_ship.amount::numeric, 0) –
COALESCE(t.”CreditMemo”, 0),
0) as “CommissionableAmount”
, t.”PaymentDate”::date as “DatePaid”
, sta.commission_paid_date::date as “CommissionPaidDate”
, sta.notes as “Notes”
, t.”Voided”
, COALESCE(sta.override_commission_percent, ca.commission_percentage) as “CommissionPercent”
, ‘INVOICE’ as “SaleType”
, sta.agency_ref as “AgencyID”
, ca.agency_name as “AgencyName”
, i.billaddr__countrysubdivisioncode as “State”
from (select i.docnumber as “InvoiceNumber”
, i.id as “InvoiceId”
, CASE
WHEN i.privatenote ~~* ‘voided%’::text
THEN true
ELSE false
END AS “Voided”
, SUM(cm.totalamt::numeric)
FILTER (WHERE plineex_cm.value__value is not null) as “CreditMemo”
, SUM(pline.amount::numeric) FILTER (WHERE cm.totalamt is null) as “PaidAmount”
, MAX(p.txndate::date) FILTER (WHERE p.totalamt::numeric > 0) as “PaymentDate”
, MAX(cm.txndate::date) FILTER (WHERE cm.totalamt::numeric > 0) as “CreditMemoDate”
from quickbooks.invoices i
left join quickbooks.payments__line__linkedtxn plinetxn
ON i.id = plinetxn.txnid
AND plinetxn.txntype = ‘Invoice’
left join quickbooks.payments p
ON plinetxn._sdc_source_key_id = p.id
left join quickbooks.payments__line pline
ON pline._sdc_source_key_id = p.id
AND pline._sdc_level_0_id = plinetxn._sdc_level_0_id
left join quickbooks.payments__line__lineex__any plineex_inv
ON plineex_inv._sdc_source_key_id = p.id
AND plineex_inv.value__name = ‘txnReferenceNumber’
AND plineex_inv.value__value = i.docnumber
left join quickbooks.payments__line__lineex__any plineex_cm
ON plineex_cm._sdc_source_key_id = p.id
AND plineex_cm.value__name = ‘txnReferenceNumber’
AND exists (select 1
from quickbooks.credit_memos cm
where cm.docnumber = plineex_cm.value__value)
left join quickbooks.credit_memos cm
ON cm.docnumber = plineex_cm.value__value
group by 1, 2, 3) as t
inner join quickbooks.invoices i
on t.”InvoiceId” = i.id
left join quickbooks.sale_to_agency sta
on sta.ref_id = i.id
and sta.sale_type = ‘INVOICE’
inner join quickbooks.commission_agencies ca
ON ca.agency_id = sta.agency_ref
AND ca.yr = EXTRACT(YEAR FROM {{daterangepicker1.startFormattedString}}::DATE)
left join quickbooks.invoices__line iline_ship
on i.id = iline_ship._sdc_source_key_id
and iline_ship.salesitemlinedetail__itemref__value = ‘SHIPPING_ITEM_ID’
and iline_ship.detailtype = ‘SalesItemLineDetail’
left join quickbooks.invoices__customfield ic
on ic._sdc_source_key_id = i.id
and ic.name = ‘Customer PO’::text
left join commission_overrides co
on t.”InvoiceId”::integer = co.ref_id
and co.sale_type = ‘INVOICE’
left join (select agency_id
, start_date
, previous_month_commission_percent
from quickbooks.commission_reports
where id in (select max(id)
from quickbooks.commission_reports
group by agency_id, start_date)
and previous_month_commission_percent is not null) cr
on ca.agency_id = cr.agency_id
and date_trunc(‘month’, i.txndate::date) = cr.start_date
union all
SELECT ‘NEW’ as “Source”,
sr.id as “SalesReceiptId”,
sr.txndate::date as “SalesReceiptDate”,
sr.txndate::date as “DueDate”,
sr.customerref__name AS “CustomerName”,
sr.shipaddr__countrysubdivisioncode AS “CustomerState”,
src.stringvalue AS “CustomerPO”,
sr.docnumber AS “SalesReceiptNumber”,
sr.totalamt::numeric – COALESCE(r.refund_amount::numeric, 0) AS “SalesReceiptNetAmount”,
sr.totalamt::numeric AS “SalesReceiptTotalAmount”,
sr.totalamt::numeric AS “PaymentReceived”,
COALESCE(r.refund_amount::numeric, 0) AS “RefundAmount”,
sr.totalamt::numeric – COALESCE(srline_ship.amount::numeric, 0) –
COALESCE(r.refund_amount::numeric, 0) AS “CommissionableAmount”,
sr.txndate::date AS “PaymentDate”,
sta.commission_paid_date::date AS “CommissionPaidDate”,
sta.notes AS “Notes”,
CASE
WHEN sr.privatenote ~~* ‘voided%’::text THEN true
ELSE false
END AS “Voided”,
COALESCE(sta.override_commission_percent, ca.commission_percentage) AS “CommissionPercent”,
‘SALES RECEIPT’ AS “SaleType”,
sta.agency_ref AS “AgencyID”,
ca.agency_name AS “AgencyName”,
sr.shipaddr__countrysubdivisioncode AS “State”
FROM quickbooks.sales_receipts sr
LEFT JOIN (SELECT split_part(rr.docnumber, ‘-‘::text, 1) AS paymentrefnum,
sum(COALESCE(rr.totalamt::numeric, 0)) AS refund_amount
FROM quickbooks.refund_receipts rr
GROUP BY 1) r
ON r.paymentrefnum = sr.paymentrefnum
left join quickbooks.sale_to_agency sta
on sta.ref_id = sr.id
and sta.sale_type = ‘SALES RECEIPT’
left join quickbooks.commission_agencies ca
ON ca.agency_id = sta.agency_ref
AND ca.yr = EXTRACT(YEAR FROM {{daterangepicker1.startFormattedString}}::DATE)
left join quickbooks.sales_receipts__line srline_ship
on sr.id = srline_ship._sdc_source_key_id
and srline_ship.salesitemlinedetail__itemref__value = ‘SHIPPING_ITEM_ID’
and srline_ship.detailtype = ‘SalesItemLineDetail’
left join quickbooks.sales_receipts__customfield src
on src._sdc_source_key_id = sr.id
and src.name = ‘Customer PO’::text
left join commission_overrides co
on sr.id::integer = co.ref_id
and co.sale_type = ‘SALES RECEIPT’
left join (select agency_id
, start_date
, previous_month_commission_percent
from quickbooks.commission_reports
where id in (select max(id)
from quickbooks.commission_reports
group by agency_id, start_date)
and previous_month_commission_percent is not null) cr
on ca.agency_id = cr.agency_id
and date_trunc(‘month’, sr.txndate::date) = cr.start_date
where sr.txndate::date >= ‘2023-07-01’
) as “InvoicesUnionSalesReceipts”
where
(“SaleDate” between {{daterangepicker1.startFormattedString}}::date AND {{daterangepicker1.endFormattedString}}::date)
AND (“AgencyID” IS NOT NULL AND “AgencyID” NOT IN (29,30)) — not unknown
ORDER BY “RefId” DESC
Unformatted Attachment Preview
ref_id
167849
167848
167847
167844
167843
167842
167841
167840
167839
167838
167837
167836
167835
167831
167830
167829
167827
167826
167824
167823
167821
167819
167818
167817
167816
167813
167812
167802
167801
167794
167792
167777
167776
167775
167774
167772
167770
167768
167767
167765
167764
167763
167762
167761
167760
167759
167758
167757
167756
Sale Date Customer State
agency_id agency_name
Cust PO # Invoice or receipt
Total $#
2024-02-28Denali Lighting,
MI LLC.
24 T.J. Schaefer & Associates
72842
694.29
2024-02-28Loeb Electric
OH
24 T.J. Schaefer & Associates
72841
1020.0
2024-02-28Lumen Nation
OH
24 T.J. Schaefer & Associates
72840
163.01
2024-02-27EmeryAllenCA
Online Sales
8 EmeryAllen Online Sales
72839
25.02
2024-02-27CED Napa CA
9 ENVSN Sales
72838
138.0
2024-02-27Wright Lighting
CA And Fireside 9 ENVSN Sales
72837
41.95
2024-02-27Nedco Supply
NV
7 EmeryAllen
72836
1320.0
2024-02-27EmeryAllenNJ
Online Sales
8 EmeryAllen Online Sales
72835
450.0
2024-02-27Wishes Lighting
OK & Decor
7 EmeryAllen
72834
628.47
2024-02-27Landscape Lighting
TX
Supply
7 EmeryAllen
72833
1059.88
2024-02-27EmeryAllenCA
Online Sales
8 EmeryAllen Online Sales
72832
74.73
2024-02-27Gleam Electrical
IN and Lighting Design
7 EmeryAllen
72831
3646.79
2024-02-27EmeryAllenMI
Online Sales
8 EmeryAllen Online Sales
72830
29.65
2024-02-27Konekt
PA
7 EmeryAllen
72829
548.81
2024-02-27L & M Lighting
FL
7 EmeryAllen
72828
52.45
2024-02-27Southern Lights
MN
11 Group 1
72827
880.0
2024-02-27EmeryAllenCA
Online Sales
8 EmeryAllen Online Sales
72826
99.0
2024-02-27Winsupply Lakeville
MN
MN
11 Group 1
72825
103.95
2024-02-27GenerationILBrands/ Visual Comfort
7 EmeryAllen
72824
4987.5
2024-02-27EmeryAllenNY
Online Sales
8 EmeryAllen Online Sales
72823
52.73
2024-02-27EmeryAllenMN
Online Sales
8 EmeryAllen Online Sales
72822
23.21
2024-02-27Vermont Lighting
VT
Co dba The Lighting
7 EmeryAllen
House
72821
120.45
2024-02-27EmeryAllenCA
Online Sales
8 EmeryAllen Online Sales
72820
300.0
2024-02-27Replacement
SCBulbs
7 EmeryAllenMadison Lighting
72819
0
2024-02-27Replacement
SCBulbs
7 EmeryAllenBrendan Ravenhill
72818
0
2024-02-27The Light House
MO Gallery
18 Marsh Sales
72816
100.57
2024-02-273-D Lighting
7 EmeryAllen
72815
75.45
2024-02-27Lucia Lighting & Design
7 EmeryAllen34594
72814
41.45
2024-02-27EmeryAllen Online Sales
8 EmeryAllen492943
Online Sales
72813
51.5
2024-02-27CS Illumination, Inc.-Vista
12 Innovative Lighting
492932 Sales
72812
145.95
2024-02-27LBU Lighting (Pinecrest)
7 EmeryAllenPNC1068622
72811
86.95
2024-02-27EmeryAllen Online Sales
8 EmeryAllenBLK50-0227
Online Sales
72810
95.0
2024-02-27Southern Lights Electric Co.
7 EmeryAllen492814
72809
235.0
2024-02-27Felt Lighting
4 CMS Enterprises
101939
72808
476.54
2024-02-27R.D. White Company
7 EmeryAllenepstein
72807
508.18
2024-02-27EmeryAllen Online Sales
8 EmeryAllen492795
Online Sales
72806
87.94
2024-02-27Service Lighting
11 Group 1 PO440186 72805
53.5
2024-02-27EmeryAllen Online Sales
8 EmeryAllen492758
Online Sales
72804
650.48
2024-02-27EmeryAllen,SCSamples
7 EmeryAllenKristen Yeti72803
0
2024-02-27Read Lighting, Inc
21 Sunburst Designs
SP46360 72802
27.65
2024-02-27Wright Lighting And Fireside 9 ENVSN Sales
492716
72801
450.06
2024-02-27Commercial Lighting Supply Inc.
35(TN)
Marshall Sales
24915
Group 72800
250.45
2024-02-27EmeryAllen Online Sales
8 EmeryAllen15
Online
Buena
Sales
vista
72799
terrace 140.0
2024-02-27CED Raybro (Naples, FL)
7 EmeryAllen4977-MS958586S
72798
682.5
2024-02-27Complete Lighting of Tampa, Inc.
19 Ryan Davidson
35498
Sales 72797
61.7
2024-02-27United Electric Supply Co.
18 Marsh SalesP1072850 72796
718.5
2024-02-27EmeryAllenCA
Online Sales
8 EmeryAllen Online Sales
72795
540.0
2024-02-27Hubbardton Forge
7 EmeryAllen161036
72794
387.5
2024-02-27EmeryAllen Online Sales
8 EmeryAllen492517
Online Sales
72793
73.02
Payment Recv
Cred Memo
0
0
0
0
163.01
0
25.02
0
0
0
41.95
0
0
0
450.0
0
628.47
0
0
0
74.73
0
0
0
29.65
0
548.81
0
52.45
0
0
0
99.0
0
0
0
0
0
52.73
0
23.21
0
120.45
0
300.0
0
0
0
0
0
0
0
0
0
41.45
0
51.5
0
145.95
0
86.95
0
95.0
0
235.0
0
0
0
508.18
0
87.94
0
53.5
0
650.48
0
0
0
0
0
450.06
0
0
0
140.0
0
0
0
0
0
0
0
540.0
540.0
0
0
73.02
0
167754
167753
167752
167751
167728
167727
167724
167723
167722
167720
167719
167713
167712
167711
167709
167708
167694
167693
167692
167691
167649
167648
167647
167646
167645
167644
167643
167641
167639
167638
167637
167636
167635
167634
167633
167632
167630
167629
167623
167622
167621
167610
167608
167606
167605
167602
167599
167598
167597
167596
2024-02-27LyteWorks
38 Electric Lighting
41708Agencies
72792
Florida 105.7
2024-02-27EmeryAllen Online Sales
8 EmeryAllen492475
Online Sales
72791
45.02
2024-02-27Dulles Electric Supply Corp
15 Lighting Environments
P1135263 72790
35.45
2024-02-27EmeryAllen Online Sales
8 EmeryAllen492445
Online Sales
72789
133.0
2024-02-27Replacement
SCBulbs
7 EmeryAllenBetsy Briley72788
0
2024-02-27Pro Lighting Group Inc.
24 T.J. Schaefer106798
& Associates
72787
17.0
2024-02-27Responsible Lights, LLC
7 EmeryAllen3629
72786
1921.5
2024-02-27Naples Lighting & Fan Depot 38 Electric Lighting
25114Agencies
72785
Florida 62.45
2024-02-27Doug H. Kresge, LLC.
7 EmeryAllen492300
72784
436.21
2024-02-27Corday Lighting, Inc.
9 ENVSN Sales
31508
72783
96.83
2024-02-27Pro Lighting Group Inc.
24 T.J. Schaefer106777
& Associates
72782
282.0
2024-02-27Doug H. Kresge,
FL LLC.
7 EmeryAllen
72781
321.0
2024-02-27Pro Lighting Group Inc.
24 T.J. Schaefer106758
& Associates
72780
7.0
2024-02-27Pro Lighting Group Inc.
24 T.J. Schaefer106753
& Associates
72779
55.0
2024-02-27Pro Lighting Group Inc.
24 T.J. Schaefer106750
& Associates
72778
21.0
2024-02-27Light Bulbs Unlimited, West Palm
38 Electric
Beach Lighting
114994
Agencies
72777
Florida 161.45
2024-02-27TEC ElectricAR
6 Elite Sales Group
2052428 72775
338.75
2024-02-27House Electric
35 Marshall Sales
14784
Group 72774
86.77
2024-02-27Pro Lighting Group Inc.
24 T.J. Schaefer106747
& Associates
72773
73.5
2024-02-27Pro Lighting Group Inc.
24 T.J. Schaefer106744
& Associates
72772
16.5
2024-02-27The LightingFLLizards LLC
37 Ryan Lee 490816
72769
31.0
2024-02-27Mid South Night Lights, LLC
7 EmeryAllen492048
72768
2000.0
2024-02-27EmeryAllen Online Sales
8 EmeryAllen492007
Online Sales
72767
40.47
2024-02-27Pinnacle Lighting Group, LLC 7 EmeryAllenVorhoff 72766
578.69
2024-02-27EmeryAllen Online Sales
8 EmeryAllen491819
Online Sales
72765
45.02
2024-02-27EmeryAllen Online Sales
8 EmeryAllenOTW
Online Sales
72764
117.0
2024-02-26Loeb Electric
24 T.J. SchaeferP100297206
& Associates
72763
4790.0
2024-02-26EmeryAllen Online Sales
8 EmeryAllen233S1
Online Sales
72762
73.73
2024-02-26EmeryAllen Online Sales
8 EmeryAllen491406
Online Sales
72761
72.83
2024-02-26EmeryAllen Online Sales
8 EmeryAllen491402
Online Sales
72760
43.43
2024-02-26EmeryAllen Online Sales
8 EmeryAllen491295
Online Sales
72759
77.99
2024-02-26EmeryAllen Online Sales
8 EmeryAllen491191
Online Sales
72758
15.65
2024-02-26EmeryAllen Online Sales
8 EmeryAllen491190
Online Sales
72757
16.15
2024-02-26Lightology, LLC
25 Tri-State Sales
708853-00
& Service
72756
25.5
2024-02-26Kendall Electric Inc
24 T.J. SchaeferS114011363
& Associates
72755
38.95
2024-02-26EmeryAllen Online Sales
8 EmeryAllenBaltera
Online Sales
72754
360.0
2024-02-26Stokes Electric Company
35 Marshall Sales
4226634
Group 72753
30.2
2024-02-26EmeryAllen Online Sales
8 EmeryAllen491001
Online Sales
72752
22.97
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490969
Online Sales
72751
95.0
2024-02-26Pro Lighting Group Inc.
24 T.J. Schaefer106720
& Associates
72750
66.0
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490940
Online Sales
72749
26.02
2024-02-26EmeryAllen,SCSamples
7 EmeryAllenLTF Sample72748
295.0
2024-02-26Pro Lighting Group Inc.
24 T.J. Schaefer106706
& Associates
72747
46.0
2024-02-26Lightology, LLC
25 Tri-State Sales
708302-00
& Service
72746
34.5
2024-02-26The Lighting Lizards LLC
37 Ryan Lee 490816
72745
360.2
2024-02-26Beautiful Things Lighting Inc. 38 Electric Lighting
20351Agencies
72744
Florida 850.5
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490753
Online Sales
72743
48.65
2024-02-26WALTERS – BREA – CDC
12 Innovative Lighting
P101260278
Sales
72742
51.33
2024-02-26Pro Lighting Group Inc.
24 T.J. Schaefer106691
& Associates
72741
28.5
2024-02-26Napa Electric
9 ENVSN Sales
92221
72740
410.93
0
45.02
0
133.0
0
0
0
62.45
436.21
0
0
321.0
0
0
0
0
0
0
0
0
31.0
2000.0
40.47
578.69
45.02
117.0
0
73.73
72.83
43.43
77.99
15.65
16.15
0
0
360.0
0
22.97
95.0
0
26.02
0
0
0
360.2
0
48.65
0
0
0
0
0
0
0
0
0
0
0
0
0
0
321.0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
295.0
0
0
0
0
0
0
0
0
167593
167592
167591
167590
167589
167588
167587
167586
167585
167583
167582
167581
167576
167562
167561
167560
167557
167556
167555
167554
167553
167549
167548
167547
167543
167534
167533
167532
167529
167526
167525
167524
167523
167522
167521
167520
167519
167518
167517
167516
167515
167514
167512
167511
167510
167509
167508
167507
167506
167505
2024-02-26Littman Brothers Lighting
25 Tri-State Sales
PO203134890
& Service
72739
200.0
2024-02-26TK Distribution
19 Ryan Davidson
22322
Sales 72738
362.26
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490662
Online Sales
72737
25.15
2024-02-26Central BulbFLInc. LBU Lighting (Winter
19 RyanPark)
Davidson
97065
Sales 72736
395.26
2024-02-26Lit Outdoor Lighting
7 EmeryAllen490644
72735
67.4
2024-02-26Light Your Nights Landscape Lighting,
37 RyanLLC
Lee 490622
72734
279.86
2024-02-26Corday Lighting, Inc.
9 ENVSN Sales
31497
72733
121.0
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490560
Online Sales
72732
2150.0
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490521
Online Sales
72731
198.0
2024-02-26Maris Lighting Company, LLC 7 EmeryAllen54701-028358.03
72730
67.33
2024-02-26CommercialBulbs.com
25 Tri-State Sales
Ds-130491
& Service
72729
43.5
2024-02-26Rainbow Lighting (Hillside, IL) 25 Tri-State Sales
490379
& Service
72728
3234.0
2024-02-26Southern Lights (Altamonte Springs,
19 Ryan
FL)Davidson
93434-0226
Sales 72727
66.95
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490304
Online Sales
72726
27.65
2024-02-26Paloma Lighting Inc DBA CopperMoon
7 EmeryAllen8833
72725
496.0
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490236
Online Sales
72724
15.71
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490191
Online Sales
72723
164.0
2024-02-26Nisha Tailor Interior Design 18 Marsh Sales490180
72722
426.66
2024-02-26Simplified Solutions & Co
1 Simplified Solutions
490162
72721
23.45
2024-02-26Corday Lighting, Inc.
9 ENVSN Sales
31495
72720
251.29
2024-02-26Pro Lighting Group Inc.
24 T.J. Schaefer106650
& Associates
72719
16.5
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490100
Online Sales
72718
57.65
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490097
Online Sales
72717
114.0
2024-02-26Tops Supply
7 EmeryAllen131277
72716
747.37
2024-02-26Creative Lighting by Bellacor 11 Group 1 490055
72715
66.5
2024-02-26Electric Supply dba Frontier Lighting,
19 Ryan
IncDavidson
– Ft. P1452714
Myers
Sales 72714
150.95
2024-02-26EmeryAllen Online Sales
8 EmeryAllen490002
Online Sales
72713
44.47
2024-02-25Conserve-A-Watt Lighting, Inc. 4 CMS Enterprises
489514
72712
58.95
2024-02-25EmeryAllen Online Sales
8 EmeryAllen489384
Online Sales
72711
39.73
2024-02-25EmeryAllen Online Sales
8 EmeryAllen489153
Online Sales
72710
25.57
2024-02-25EmeryAllen Online Sales
8 EmeryAllen489061
Online Sales
72709
26.83
2024-02-25EmeryAllen Online Sales
8 EmeryAllen489039
Online Sales
72708
220.5
2024-02-25Synergy Lighting Supply
38 Electric Lighting
488873
Agencies
72707
Florida 86.45
2024-02-25Inscape Lighting
37 Ryan Lee 488810
72706
67.55
2024-02-25EmeryAllen Online Sales
8 EmeryAllen488761
Online Sales
72705
57.63
2024-02-25EmeryAllen Online Sales
8 EmeryAllen488674
Online Sales
72704
193.5
2024-02-25EmeryAllen Online Sales
8 EmeryAllen488644
Online Sales
72703
28.57
2024-02-25EmeryAllen Online Sales
8 EmeryAllen488292
Online Sales
72702
58.43
2024-02-25EmeryAllen Online Sales
8 EmeryAllen488246
Online Sales
72701
157.5
2024-02-24EmeryAllen Online Sales
8 EmeryAllen488128
Online Sales
72700
30.73
2024-02-24EmeryAllenOR
Online Sales
8 EmeryAllen Online Sales
72699
73.02
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487882
Online Sales
72698
66.57
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487861
Online Sales
72697
53.23
2024-02-24Water in Motion, Inc (WIM)
7 EmeryAllen487823
72696
1242.0
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487727
Online Sales
72695
16.15
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487712
Online Sales
72694
18.52
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487706
Online Sales
72693
39.57
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487637
Online Sales
72692
64.02
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487568
Online Sales
72691
56.15
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487410
Online Sales
72690
132.0
0
0
25.15
0
67.4
279.86
0
2150.0
198.0
0
43.5
3234.0
66.95
27.65
0
15.71
164.0
0
23.45
0
0
57.65
114.0
0
0
0
44.47
58.95
39.73
25.57
26.83
220.5
86.45
67.55
57.63
193.5
28.57
58.43
157.5
30.73
73.02
66.57
53.23
1242.0
16.15
18.52
39.57
64.02
56.15
132.0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
167504
167503
167502
167501
167500
167499
167498
167497
167496
167495
167494
167493
167490
167489
167487
167486
167485
167484
167483
167482
167481
167480
167479
167478
167475
167474
167472
167471
167470
167469
167468
167467
167466
167465
167461
167460
167459
167458
167452
167451
167448
167447
167446
167445
167444
167443
167442
167441
167440
167439
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487334
Online Sales
72689
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487269
Online Sales
72688
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487212
Online Sales
72687
2024-02-24Just Lights Inc
7 EmeryAllen57477
72686
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487183
Online Sales
72685
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487131
Online Sales
72684
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487070
Online Sales
72683
2024-02-24EmeryAllen Online Sales
8 EmeryAllen487037
Online Sales
72682
2024-02-24Neil Graves, Tri-State Sales & Service,
25 Tri-State
Inc. Sales & Service
72681
2024-02-24Southside Electric & Lighting 24 T.J. Schaefer173212
& Associates
72680
2024-02-23Furbay Electric – Canton
24 T.J. Schaefer1123999
& Associates
72679
2024-02-23EmeryAllen Online Sales
8 EmeryAllen486544
Online Sales
72678
2024-02-23Regency Supply
12 Innovative Lighting
1580321Sales
72677
2024-02-23Luxe Lighting Company LLC 39 CBK Lighting25443
LLC
72676
2024-02-23Cappadonnas of AZ, Inc.
7 EmeryAllen486215
72675
2024-02-23Lightology, LLC
25 Tri-State Sales
708958-00
& Service
72674
2024-02-23Lightology, LLC
25 Tri-State Sales
708637-00
& Service
72673
2024-02-23Stevens Lighting
7 EmeryAllen45498
72672
2024-02-23Lightology, LLC
25 Tri-State Sales
708917-00
& Service
72671
2024-02-23Lightology, LLC
25 Tri-State Sales
706808-00
& Service
72670
2024-02-23Best Lighting Supply
7 EmeryAllen4084992 72669
2024-02-23Glass Designs
9 ENVSN Sales
486104
72668
2024-02-23Lebanon Electric Supply
24 T.J. Schaefer32371
& Associates
72667
2024-02-23Main Electric Supply – NV
7 EmeryAllenLV 912555672666
2024-02-23Trinity Lighting Inc.
6 Elite Sales Group
52791
72665
2024-02-23Innovative Lighting Sales, Inc. 12 Innovative Lighting
485988 Sales
72664
2024-02-23Energy Plus Wholesale Lighting and
9 ENVSN
Design
Sales
Inc.
59063
72663
2024-02-23Stanford Electric Works
9 ENVSN Sales
0223-24D 72662
2024-02-23Bulbs.com, Inc.
7 EmeryAllenFG1820 72661
2024-02-23Lumenate TN
7 EmeryAllen485929
72660
2024-02-23EmeryAllen Online Sales
8 EmeryAllen485906
Online Sales
72659
2024-02-23Elaine Everett’s Lighting
7 EmeryAllen485877
72658
2024-02-23EmeryAllen Online Sales
8 EmeryAllen485870
Online Sales
72657
2024-02-23Beautiful Lights LLC
35 Marshall Sales
9320
Group 72656
2024-02-23Modern Lighting
7 EmeryAllen485793
72655
2024-02-23EmeryAllen Online Sales
8 EmeryAllen485778
Online Sales
72654
2024-02-23Pro Lighting Group Inc.
24 T.J. Schaefer106622
& Associates
72653
2024-02-23Aiken Electrical
41 The Mills Company,
2242445 INC72652
2024-02-23Beautiful Lights LLC
35 Marshall Sales
9315
Group 72651
2024-02-23Green Foundry Co.
7 EmeryAllen3470
72650
2024-02-23Champlain Valley Electric Supply
10Co,
Grillo
Inc.Group70942
72648
2024-02-23EmeryAllen Online Sales
8 EmeryAllen485683
Online Sales
72647
2024-02-23EmeryAllen Online Sales
8 EmeryAllen485646
Online Sales
72646
2024-02-23Colonial Electric Supply
15 Lighting Environments
WD3455 72645
2024-02-23EmeryAllen Online Sales
8 EmeryAllen485619
Online Sales
72644
2024-02-23Commercial Lighting Supply Inc.
35(TN)
Marshall Sales
24891
Group 72643
2024-02-23Richards Lighting
35 Marshall Sales
92175
Group 72642
2024-02-23HB Architectural Lighting, Inc. 7 EmeryAllen485508
72641
2024-02-23Lyons Electrical Supply Co.
24 T.J. Schaefer07-118247
& Associates
72640
2024-02-23Replacement
SCBulbs
7 EmeryAllenBerkeley Lighting
72639
52.93
62.73
91.61
109.45
21.07
53.07
41.15
31.81
264.0
156.64
174.2
95.5
137.0
175.39
39.95
20.0
28.0
111.97
94.5
7.0
184.51
335.79
1036.25
305.29
6022.5
36.0
415.29
167.08
550.0
275.0
35.57
1262.5
352.21
36.51
132.95
230.0
63.0
103.53
324.51
48.05
111.95
45.01
52.02
36.26
31.43
450.0
20.95
27.45
31.95
0
52.93
62.73
91.61
109.45
21.07
53.07
41.15
31.81
0
0
0
95.5
0
0
0
0
0
0
0
0
0
335.79
0
0
0
0
415.29
167.08
0
275.0
35.57
0
352.21
0
0
230.0
0
0
0
0
111.95
45.01
52.02
36.26
31.43
0
0
27.45
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
36.0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
167437
167434
167433
167432
167431
167429
167427
167426
167425
167419
167415
167405
167404
167403
167402
167401
167391
167390
167389
167386
167385
167384
167383
167381
167380
167379
167376
167375
167374
167373
167372
167370
167369
167367
167366
167365
167363
167362
167361
167360
167341
167337
167335
167332
167321
167320
167316
167315
167314
167313
2024-02-23Georgia Lighting
35 Marshall Sales Group 72638
143.45
2024-02-23FSG – Hayward
7 EmeryAllen1167130-0072637
850.0
2024-02-23American Electric Company
4 CMS Enterprises
1932-PM941137S
72636
12.25
2024-02-23Landscape Lighting Supply
7 EmeryAllen62734
72635
1252.0
2024-02-23Pro Lighting Group Inc.
24 T.J. Schaefer106592
& Associates
72634
80.5
2024-02-23Replacement
SCBulbs
7 EmeryAllenProSource Supply
72633
0
2024-02-23Replacement
SCBulbs
7 EmeryAllenBarb Lennander
72632
0
2024-02-23EmeryAllen Online Sales
8 EmeryAllen4875340
Online Sales
72631
23.07
2024-02-23EmeryAllen Online Sales
8 EmeryAllen485330
Online Sales
72630
115.0
2024-02-23EmeryAllen,SCSamples
7 EmeryAllenKirk Marshall
72629
0
2024-02-23BBC Lighting & Supply
25 Tri-State Sales
B2010-24
& Service
72628
680.0
2024-02-23Bulbs.com, Inc.
7 EmeryAllen485274
72626
881.25
2024-02-23EmeryAllen Online Sales
8 EmeryAllen485241
Online Sales
72625
39.83
2024-02-23Light Up Your Life
38 Electric Lighting
485245
Agencies
72624
Florida 134.51
2024-02-23Atlas Specialty Lighting
19 Ryan Davidson
4-022324001RF
Sales 72623
220.0
2024-02-23Leslie Electric Co
24 T.J. Schaefer119159
& Associates
72622
63.95
2024-02-23CED Twin State Electric Supply 7 EmeryAllen485139
72621
51.75
2024-02-23Hansen Electrical Supply, Inc. (Naples,
38 Electric
FL) Lighting
485111
Agencies
72620
Florida 288.78
2024-02-23EmeryAllen Online Sales
8 EmeryAllen485067
Online Sales
72619
46.57
2024-02-22EmeryAllen Online Sales
8 EmeryAllenOffice
Online Sales
72618
46.73
2024-02-22EmeryAllen Online Sales
8 EmeryAllen484570
Online Sales
72617
32.23
2024-02-22EmeryAllen Online Sales
8 EmeryAllen484565
Online Sales
72616
352.21
2024-02-22EmeryAllen Online Sales
8 EmeryAllen484561
Online Sales
72615
24.07
2024-02-22EmeryAllen Online Sales
8 EmeryAllen484547
Online Sales
72614
56.15
2024-02-22Dulles Electric Supply Corp
15 Lighting Environments
S2623612 72613
19.95
2024-02-22EmeryAllen Online Sales
8 EmeryAllen484524
Online Sales
72612
32.93
2024-02-22EmeryAllen Online Sales
8 EmeryAllen484504
Online Sales
72611
64.47
2024-02-22Lighting Concepts and Design 21 Sunburst Designs
23769
72610
16.65
2024-02-22EmeryAllen Online Sales
8 EmeryAllen484451
Online Sales
72609
44.65
2024-02-22Landscape Lighting Supply
7 EmeryAllen62707
72608
815.85
2024-02-22ENVSN Sales
9 ENVSN Sales
cityLightssample0224
72607
15.0
2024-02-22Lightology, LLC
25 Tri-State Sales
708670-00
& Service
72606
21.0
2024-02-22EmeryAllen Online Sales
8 EmeryAllen484247
Online Sales
72605
103.95
2024-02-22EmeryAllenTN
Online Sales
8 EmeryAllen Online Sales
72604
400.0
2024-02-22Trinity Lighting Inc.
6 Elite Sales Group
52789
72603
1815.0
2024-02-22Lightology, LLC
25 Tri-State Sales
708202-00
& Service
72602
88.0
2024-02-22SCI Powertech
7 EmeryAllen1803
72601
156.0
2024-02-22Premier Lighting (Bakersfield, CA)
12 Innovative Lighting
19981 Sales
72600
173.95
2024-02-22EmeryAllen Online Sales
8 EmeryAllen484006
Online Sales
72599
27.02
2024-02-22Kendall Electric Inc
24 T.J. SchaeferP101522698
& Associates
72598
34.5
2024-02-22EmeryAllen,SCSamples
7 EmeryAllenTom Garber72597
13.0
2024-02-22EmeryAllen Online Sales
8 EmeryAllen483873
Online Sales
72596
132.0
2024-02-22Light Bulb Wholesaler, Inc
15 Lighting Environments
500532
72595
43.75
2024-02-22EmeryAllen,SCSamples
7 EmeryAllenJennifer Poremba
72594 samples
184.8
2024-02-22Northern Lighting
24 T.J. Schaefer12329
& Associates
72593
156.75
2024-02-22FSG – Hayward
7 EmeryAllen1167083-0072592
326.64
2024-02-22Complete Lighting of Tampa, Inc.
19 Ryan Davidson
35458
Sales 72591
600.28
2024-02-22EmeryAllen Online Sales
8 EmeryAllen483781
Online Sales
72590
75.73
2024-02-22AM Studio Lighting
ON
Inc
7 EmeryAllen22224
72589
1000.0
2024-02-22Replacement
SCBulbs
7 EmeryAllenLeslie Cohen
72588
0
0
0
0
0
0
0
0
23.07
115.0
0
680.0
0
39.83
134.51
0
0
0
0
46.57
46.73
32.23
352.21
24.07
56.15
0
32.93
64.47
0
44.65
0
0
0
103.95
400.0
0
0
0
0
27.02
0
0
132.0
0
0
0
0
0
75.73
1000.0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
15.0
0
0
400.0
0
0
0
0
0
0
13.0
0
0
184.8
0
0
0
0
0
0
167312
167297
167282
167281
167280
167279
167278
167277
167268
167263
167262
167260
167258
167257
167255
167254
167253
167252
167251
167250
167249
167248
167247
167244
167243
167235
167234
167233
167232
167231
167229
167228
167226
167225
167224
167223
167222
167221
167220
167219
167218
167217
167216
167215
167213
167212
167211
167210
167209
167208
2024-02-22EmeryAllen Online Sales
8 EmeryAllen483718
Online Sales
72587
2024-02-22Mid South Night Lights, LLC
7 EmeryAllen483673
72586
2024-02-22Coast Lighting Products
9 ENVSN Sales
176293
72585
2024-02-22Service Lighting
11 Group 1 PO440056 72584
2024-02-22Kendall Electric Inc
24 T.J. SchaeferP101522595
& Associates
72583
2024-02-22EmeryAllen Online Sales
8 EmeryAllen483579
Online Sales
72582
2024-02-22Focus Lighting
10 Grillo Group35353
72581
2024-02-22Lightopia, LLC
12 Innovative Lighting
30134617472580
Sales
2024-02-22EmeryAllen Online Sales
8 EmeryAllen483494
Online Sales
72577
2024-02-22Brecher’s Lighting
24 T.J. Schaefer238310
& Associates
72575
2024-02-22Accent Lighting, KS
18 Marsh Sales1016867 72574
2024-02-22Chuckanut Lighting
39 CBK Lighting23361
LLC
72573
2024-02-22EmeryAllenWY
Online Sales
8 EmeryAllen Online Sales
72572
2024-02-22ELA – Lighting
7 EmeryAllen66940
72571
2024-02-22EmeryAllen,SCSamples
7 EmeryAllenUpdate Sales
72570
Kits
2024-02-22Winsupply Owensboro KY
24 T.J. Schaefer00153-111961
& Associates
72569
2024-02-22Lightology, LLC
25 Tri-State Sales
708321-00
& Service
72568
2024-02-22The Grillo Group
10 Grillo Group483272
72567
2024-02-22EmeryAllen Online Sales
8 EmeryAllen2929
Online Sales
72566
2024-02-22FSG – Austin, TX
7 EmeryAllen1167037-0072565
2024-02-22Replacement
SCBulbs
7 EmeryAllenTesco – Fairbanks
72564
2024-02-22Pinnacle Lawn & Lighting LLC 37 Ryan Lee 483182
72563
2024-02-22John Pomp Studios
7 EmeryAllenPO 3010 72562
2024-02-22Pro Lighting Group Inc.
24 T.J. Schaefer106463
& Associates
72561
2024-02-22Corday Lighting, Inc.
9 ENVSN Sales
31470
72560
2024-02-22JL Lights
37 Ryan Lee 483096
72559
2024-02-22T. J. Schaefer-& Associates, Inc.24 T.J. Schaefer22024LW
& Associates
72558
2024-02-21EmeryAllen Online Sales
8 EmeryAllen482651
Online Sales
72557
2024-02-21Berkeley Lighting Company
9 ENVSN Sales
022124B 72556
2024-02-21EmeryAllen Online Sales
8 EmeryAllen482561
Online Sales
72555
2024-02-21EmeryAllen Online Sales
8 EmeryAllen482473
Online Sales
72554
2024-02-21EmeryAllen Online Sales
8 EmeryAllen482472
Online Sales
72553
2024-02-21EmeryAllen Online Sales
8 EmeryAllen482364
Online Sales
72552
2024-02-21EmeryAllen Online Sales
8 EmeryAllen482352
Online Sales
72551
2024-02-21EmeryAllen Online Sales
8 EmeryAllen482300
Online Sales
72550
2024-02-21Riverside Lighting and Electric 9 ENVSN Sales
022124FR 72549
2024-02-21Trinity Lighting Inc.
6 Elite Sales Group
52778
72548
2024-02-21Corday Lighting, Inc.
9 ENVSN Sales
31468
72547
2024-02-21Lightology, LLC
25 Tri-State Sales
708215-00
& Service
72546
2024-02-21EmeryAllen Online Sales
8 EmeryAllen482141
Online Sales
72545
2024-02-21Standard Electric div of USESI – Wilmington,
7 EmeryAllenS124992119
MA
72544
2024-02-21Splashlight
4 CMS Enterprises
26502
72543
2024-02-21Madison Lighting
WI
25 Tri-State Sales & Service
72542
2024-02-21Pro Lighting Group Inc.
24 T.J. Schaefer106434
& Associates
72541
2024-02-21House Electric
35 Marshall Sales
14775
Group 72540
2024-02-21EmeryAllen Online Sales
8 EmeryAllen481989
Online Sales
72539
2024-02-21Lighting Inc-BA
6 Elite Sales Group
P1270209 72538
2024-02-21Lit Outdoor Lighting
7 EmeryAllen481929
72537
2024-02-21Lightology, LLC
25 Tri-State Sales
707892-00
& Service
72536
2024-02-21EmeryAllen Online Sales
8 EmeryAllenLIME
Online
ORCHARD
Sales
72535
23.07
70.82
642.25
172.25
35.0
47.43
290.77
82.23
184.0
865.0
98.45
57.95
184.0
759.0
1579.5
29.45
42.0
12.75
133.0
133.33
0
102.65
1291.31
19.0
11.0
454.06
34.5
23.97
317.81
66.23
46.73
1820.5
83.1
65.5
787.5
1159.0
234.82
78.95
20.0
140.0
172.5
292.46
39.2
26.25
126.95
95.0
118.45
172.83
21.0
110.0
23.07
70.82
0
172.25
0
47.43
0
0
184.0
0
98.45
0
184.0
0
0
0
0
0
133.0
0
0
102.65
1291.31
0
0
454.06
0
23.97
0
66.23
46.73
1820.5
83.1
65.5
787.5
1159.0
0
0
0
140.0
0
0
0
0
0
95.0
0
172.83
0
110.0
0
0
0
0
0
0
0
0
0
0
0
0
184.0
0
1579.5
0
0
12.75
0
0
0
0
0
0
0
0
34.5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
167207
167206
167205
167203
167202
167201
167199
167198
167197
167195
167194
167193
167191
167190
167189
167177
167175
167174
167173
167172
167171
167169
167163
167162
167161
167160
167152
167151
167150
167149
167148
167147
167146
167145
167143
167141
167140
167138
167137
167136
167135
167134
167133
167132
167131
167130
167127
167126
167125
167124
2024-02-21Tesco – Fairbanks
3 Barry Sales 2346-TKM958374S
72534
108.0
2024-02-21L & M Lighting
7 EmeryAllen481816
72533
41.45
2024-02-21McNally Electric & Lighting
12 Innovative Lighting
28263 Sales
72532
208.83
2024-02-21EmeryAllen Online Sales
8 EmeryAllen481687
Online Sales
72531
66.65
2024-02-21Cregger Company – N.CHS
41 The Mills Company,
p1682646INC72530
33.0
2024-02-21Replacement
SCBulbs
7 EmeryAllenATELIER ANAKA
72529
0
2024-02-21EmeryAllen,SCSamples
7 EmeryAllenATELIER ANAKA
72528
sample11.0
2024-02-21Atelier Anaka
Quebec
7 EmeryAllen240220
72527
2851.5
2024-02-21Charleston Lighting & Interiors41 The Mills Company,
223061 INC72526
165.0
2024-02-21TK Distribution
19 Ryan Davidson
22314
Sales 72525
277.68
2024-02-21EmeryAllen Online Sales
8 EmeryAllen481511
Online Sales
72524
57.83
2024-02-213-D Lighting
7 EmeryAllenhya/01695572523
157.95
2024-02-21ProSource LLC – Easley
41 The Mills Company,
P127659 INC72522
140.45
2024-02-21EmeryAllen Online Sales
8 EmeryAllen481398
Online Sales
72521
48.73
2024-02-21EmeryAllen Online Sales
8 EmeryAllen481378
Online Sales
72520
165.0
2024-02-21Advance Electrical Supply Company
25 Tri-State
LLC Sales
P1286220
& Service
72519
70.45
2024-02-21EmeryAllen,SCSamples
7 EmeryAllenHollis + Morris
72518
14.4
2024-02-21EmeryAllen Online Sales
8 EmeryAllen24020
Online Sales
72517
210.0
2024-02-21Pro Lighting Group Inc.
24 T.J. Schaefer106398
& Associates
72516
52.0
2024-02-21Anzalone Electric
10 Grillo Group481154
72515
79.45
2024-02-21Elements
10 Grillo Group481147
72514
131.2
2024-02-21EmeryAllen Online Sales
8 EmeryAllen481119
Online Sales
72513
35.52
2024-02-21Replacement
SCBulbs
7 EmeryAllenGALLERIA LIGHTING
72512
0
2024-02-21Replacement
SCBulbs
7 EmeryAllenCherie Long72511
0
2024-02-21Replacement
SCBulbs
7 EmeryAllenKevin Lynch72510
0
2024-02-21Paloma Lighting Inc DBA CopperMoon
7 EmeryAllen8829
72509
101.4
2024-02-21E.D. Supply Co.
15 Lighting Environments
6675-TM-924529S
72508
38.0
2024-02-21Regency Architectural Lighting Inc.
7 EmeryAllen822772
72507
34.95
2024-02-21Regency Architectural Lighting Inc.
7 EmeryAllen822771
72506
29.95
2024-02-21Pro Lighting Group Inc.
24 T.J. Schaefer106354
& Associates
72505
78.0
2024-02-21Pro Lighting Group Inc.
24 T.J. Schaefer106346
& Associates
72504
20.0
2024-02-21EmeryAllenFL
Online Sales
8 EmeryAllen Online Sales
72503
95.61
2024-02-21Alpine Commerce, LLC dba PNW7Supply
EmeryAllenEMA026 72502
2212.5
2024-02-20EmeryAllen Online Sales
8 EmeryAllen480668
Online Sales
72501
770.0
2024-02-20EmeryAllen Online Sales
8 EmeryAllen480448
Online Sales
72500
27.02
2024-02-20Solterra Lighting
12 Innovative Lighting
PNB05388
Sales
72499
161.33
2024-02-20EmeryAllen Online Sales
8 EmeryAllen480335
Online Sales
72498
210.0
2024-02-20QED – Galleria Ltg & Design
4 CMS Enterprises
P1717393 72497
1661.75
2024-02-20EmeryAllen Online Sales
8 EmeryAllen7275-123
Online Sales
72496
1353.86
2024-02-20KIE Supply Corp
39 CBK Lighting1021003
LLC
72495
605.0
2024-02-20City Lights
9 ENVSN Sales
266119
72494
800.75
2024-02-20Main Electric Supply – NV
7 EmeryAllenLV912435772493
825.0
2024-02-20Specialty Lighting & Bulbs, Inc. 7 EmeryAllen805134
72492
229.51
2024-02-20EmeryAllen Online Sales
8 EmeryAllen480169
Online Sales
72491
64.57
2024-02-20Lighting Design Center (NV)
7 EmeryAllen41815
72490
110.95
2024-02-20Techlight
7 EmeryAllen48405
72489
22.0
2024-02-20Landscape Lighting Pro of Utah37 Ryan Lee 513
72488
749.0
2024-02-20Althea Lighting + Living
1 Simplified Solutions
480049
72487
629.5
2024-02-20Jackson Lighting Supply, Inc. 7 EmeryAllenPO31102 72486
46.35
2024-02-20Landscape Lighting Pro of Utah37 Ryan Lee Luann 2.20.2024
72485
9691.1
0
41.45
0
66.65
0
0
0
2851.5
0
0
57.83
0
140.45
48.73
165.0
70.45
0
210.0
0
0
0
35.52
0
0
0
0
0
34.95
29.95
0
0
95.61
2212.5
770.0
27.02
161.33
210.0
0
1353.86
0
0
0
0
64.57
0
0
749.0
629.5
0
9691.1
0
0
0
0
0
0
11.0
0
0
0
0
0
0
0
0
0
14.4
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
167123
167122
167121
167120
167117
167116
167034
167033
167032
167031
167027
167025
167021
167015
167013
167011
167010
167009
167008
167006
166997
166995
166993
166992
166984
166983
166982
166981
166980
166979
166978
166977
166976
166974
166973
166971
166970
166969
166968
166967
166966
166965
166964
166963
166962
166961
166960
166959
166958
166957
2024-02-20EmeryAllen Online Sales
8 EmeryAllen479935
Online Sales
72484
23.15
2024-02-20CED Vero Beach
7 EmeryAllen479915
72483
13.5
2024-02-20Dominion Electric Supply Company,
15 Lighting
Inc Environments
P100448552
72482
60.2
2024-02-20Replacement
SCBulbs
7 EmeryAllenFSG Austin 72481
0
2024-02-20EmeryAllen Online Sales
8 EmeryAllen479838
Online Sales
72479
59.73
2024-02-20Generation Brands/ Visual Comfort
7 EmeryAllen30454574 72478
2660.0
2024-02-20Remilux, LLC dba Remington Lighting
7 EmeryAllen107220
72477
106.8
2024-02-20EmeryAllen Online Sales
8 EmeryAllen302957
Online Sales
72476
44.41
2024-02-20Robinson Lighting
MB
11 Group 1 P000006730
72475
351.42
2024-02-203-D Lighting
7 EmeryAllen
72474
169.2
2024-02-20Bulbs.com, Inc.
7 EmeryAllenFG1221 72473
152.0
2024-02-20TK Distribution
19 Ryan Davidson
22313
Sales 72472
67.68
2024-02-20Jackson Lighting Supply, Inc. 7 EmeryAllenPO31100 72471
504.0
2024-02-20AK Lighting LLC
37 Ryan Lee 479549
72470
396.72
2024-02-20Pro Lighting Group Inc.
24 T.J. Schaefer106330
& Associates
72469
24.75
2024-02-20Lighting & Bulbs Unlimited
41 The Mills Company,
28248 INC72467
70.7
2024-02-20EmeryAllen Online Sales
8 EmeryAllen479236
Online Sales
72466
66.73
2024-02-20Hubbardton Forge
7 EmeryAllen160857
72465
362.5
2024-02-20Dulles Electric Supply Corp
15 Lighting Environments
P1135006 72464
33.0
2024-02-20EmeryAllen Online Sales
8 EmeryAllen479078
Online Sales
72463
15.65
2024-02-20EmeryAllen Online Sales
8 EmeryAllen49191
Online Sales
72462
900.0
2024-02-20Light Up Nashville
7 EmeryAllen478684
72461
41.7
2024-02-20Pro Lighting Group Inc.
24 T.J. Schaefer106301
& Associates
72460
9.0
2024-02-20LyteWorks
38 Electric Lighting
41609Agencies
72459
Florida 172.51
2024-02-20EmeryAllen Online Sa