report help
We have been using quickbooks for quite a while and it was brought to my attention yesterday that one of the reports that is constantly used is not functioning properly anymore and I am not sure what happened?
In this report (attached) there are columns for;
Job/item#/Description/unit price/Bid quantity/unit of measure/bid amount (tot) /quantity installed (tot)/ and revenue(tot)
What is use to do was; take the unit price multiped by the bid quantity and that would give the Bid Amount (tot).
Then the quantity installed would multiply by the unit price to give the revenue total (which still works for all of them).
Now it adds the Unit Price for every daily log that our crewman enters that uses that item number.
ie: the first highlighted on the report the 691,439.95 was multipied 3 times because there was 3 daily logs entered which is throwing off the whole total off the bid amount. The bid amount should be 691,439.95 but it has it as 2,074,319.85
the other highlighted are doing the same because they have more than one daily log entered.
But the rest on the report are fine and working because there is only 1 daily log entered using those item numbers.
I'm hoping that someone can help me figure out what happened here and how I can change it so the Bid amount once again is a total of the unit price and
