SELECT 	ii.invoiceid,
			ii.createdate, 
			ii.salesid,
			ii.shipdate,
			ii.bol,
			ii.terms,
			ii.shippingcharge,
			ii.discount,
			ii.comments,
			si.purchaseorder,
			si.instructions,
			si.fob,
			si.createdate as salesdate,
			cb.company as bill_company,
			cb.address1 as bill_address1,
			cb.address2 as bill_address2,
			cb.city as bill_city,
			cb.state as bill_state,
			cb.zipcode as bill_zipcode,
			cb.country as bill_country,			
			cs.company as ship_company,
			cs.address1 as ship_address1,
			cs.address2 as ship_address2,
			cs.city as ship_city,
			cs.state as ship_state,
			cs.zipcode as ship_zipcode,
			cs.country as ship_country,
			p1.productno,
			p1.name as productname,
			sii.quantity as productqty,
			iii.quantity as productqtyship,
			IsNull(sii.quantity - iii.quantity, 0) As qtybackorder,
			sii.price As productprice
			--sii.qtyship,
			--sii.qtybackorder,
			--sii.price
	FROM invoice_info AS ii 
		LEFT JOIN invoiceitem_info As iii ON ii.invoiceid = iii.invoiceid
		LEFT JOIN sales_info AS si ON ii.salesid= si.salesid
		LEFT JOIN salesitem_info As sii ON si.salesid = sii.salesid
		LEFT JOIN customer_billing AS cb ON si.billingid = cb.billingid
		LEFT JOIN customer_shipping AS cs ON si.shippingid = cs.shippingid
		LEFT JOIN product_info As p1 ON iii.productid = p1.productid
	WHERE ii.invoiceid = @invoiceid