How do I stop my custom report from adding the voided prices into the Food, Drink?
Everything else is working however the reported continues to add the voided jobs which don not total up to the correct price.
here is my custom report
[Gardenroom]
Food: {REPORT ORDER TOTAL:(TE=GardenRoom) and (MG=Food)}
Beverages: {REPORT ORDER TOTAL:(TE=GardenRoom) and (MG=Beverages)}
Opening Day: {REPORT ORDER TOTAL:(TE=GardenRoom) and (MG=Opening Day)}
Cash Total: {REPORT PAYMENT TOTAL:(PT=Gardenroom Cash)}
Credit Card: {REPORT PAYMENT TOTAL:(TE=GardenRoom) and (PT=Credit Card)}
Total Earnings: {REPORT PAYMENT TOTAL:(TE=GardenRoom)}
[Greenside]
Food: {REPORT ORDER TOTAL:(MG=Food) and (TE=GreenSide)}
Beverages: {REPORT ORDER TOTAL:(MG=Beverages) and (TE=GreenSide)}
Opening Day: {REPORT ORDER TOTAL:(MG=Opening Day) and (TE=GreenSide)}
Cash Total: {REPORT PAYMENT TOTAL:(PT=Greenside Cash)}
Credit Card: {REPORT PAYMENT TOTAL:(TE=GreenSide) and (PT=Credit Card)}
Total Earnings: {REPORT PAYMENT TOTAL:(TE=GreenSide)}
[Greenwood]
Food: {REPORT ORDER TOTAL:(TE=GreenWood) and (MG=Food)}
Beverages: {REPORT ORDER TOTAL:(TE=GreenWood) and (MG=Beverages)}
Opening Day: {REPORT ORDER TOTAL:(TE=GreenWood) and (MG=Opening Day)}
Cash Total: {REPORT PAYMENT TOTAL:(PT=Greenwood Cash)}
Credit Card: {REPORT PAYMENT TOTAL:(TE=GreenWood) and (PT=Credit Card)}
Total Earnings: {REPORT PAYMENT TOTAL:(TE=GreenWood)}
Any help would be great.