Set multiplied amount (quantity x price) as column in temp table and call that amount as a column in another temp table?

See more:

SQL

I'm trying to get all the different types of items to become its own column for each invoice (instead of getting one line per type of item per invoice). Since there are so many invoices, I've created two temp. tables in SQL Server Management. Then I'm creating a query to pivot the tables based on the total price of the item (price*quantity) by item type. I get the error "Invalid column name 'totalprice'. I think it has to do with the data types (unit price and decimals and quantity are both decimals i.e. unit price = 160.405 and units = 1.0000). Could anyone assist? Thank you!

Create table #temp1 (
invoicenumber int,
store varchar(255),
purchasedate datetime, 
itemtype varchar(255),
totalprice money
)


Create table #temp2 (
invoicenumber int,
amount money
)

Insert INTO #temp1

 SELECT A.invnum,
 L.locationname,
 R.pdate,
 A.type,
 A.unitprice * A.quantity
 
From acct A
 inner join locations L
 on A.store = L.name
 inner join reports R
 on A.invoice = R.invnum

Insert INTO #temp2
Select invoicenumber, sum(totalprice)
From #temp1
Group by invoicenumber