SELECT vfact_aptransaction_datepart.openamountusd AS OpenAmtUSD,
       dim_site.siteid,
       dim_site.sitename,
       dim_site.division,
       vfact_aptransaction_datepart.duedate,
       dim_vendor.vendorname,
       dim_vendor.vendorclass,
       vfact_aptransaction_datepart.weekdue,
       vfact_aptransaction_datepart.yeardue,
       dim_site.sitedescription
FROM   vfact_aptransaction_datepart
       INNER JOIN dim_site
               ON vfact_aptransaction_datepart.siteid = dim_site.siteid
       INNER JOIN dim_vendor
               ON vfact_aptransaction_datepart.vendorid = dim_vendor.vendorid  

SELECT v.openamountusd AS OpenAmtUSD,
	SUM(Case when v.duedate > getdate() then v.openamountusd else 0 end) as OpenPastDue,
	s.siteid,
	s.sitename,
	s.division,
	v.duedate,
	ven.vendorname,
	ven.vendorclass,
	v.weekdue,
	v.yeardue,
	s.sitedescription
FROM   vfact_aptransaction_datepart v
       INNER JOIN dim_site s 
               ON v.siteid = s.siteid
       INNER JOIN dim_vendor ven
               ON v.vendorid = ven.vendorid  
group by v.openamountusd, 
       s.siteid,
       s.sitename,
       s.division,
       v.duedate,
       ven.vendorname,
       ven.vendorclass,
       v.weekdue,
       v.yeardue,
       s.sitedescription