Daily Transaction report tweaks

Daily Transaction report list form:

• Datagrid -> were added new columns:
  • Net Sales:
    • Net Sales = Taxable Sales + Non Taxable Sales + Tax Exempt Sale +  Gift Card Sales;
    • if was made POS Sale -> all Account is Positive;
    • if was made Return -> all Account is negative;
  • Taxable Sales:
    • Taxable Sales = sum (item amount) with tax type = tax;
    • Tax is written to Tax Amount;
    • if was made POS Sale -> all Account is Positive;
    • if was made Return -> all Account is negative;
  • Non Taxable Sales:
    • Non Taxable Sales = sum (item amount) with tax type = non tax exclude Gift card;
    • if was made POS Sale -> all Account is Positive;
    • if was made Return -> all Account is negative;
  • Tax Exempt Sale:
    • Non Taxable Sales = Order sub total if Tax item = Non taxable option or Customer is non taxable;
    • if was made POS Sale -> all Account is Positive;
    • if was made Return -> all Account is negative;
  • Gift Card Sales:
    • if the user bought a Gift card is a non-taxable sales;
    • displays the sum (amount)  of bought gift card sale;
    • if was made POS Sale -> all Account is Positive;
    • if was made Return -> all Account is negative;
  • Tax Amount:
    • displays the Tax amount from taxable Sale;
    • if was made POS Sale -> all Account is Positive;
    • if was made Return -> all Account is negative;
  • On Account:
    • The account is a payment;
    • displays the amount which was put on the Customer’s account;
    • if was made POS Sale -> payment on Account is negative;
    • if was made Return -> payment on Account is positive;
    • if Account was made as separate payment -> value is positive -> payment type (cash/credit card -> negative);
  • Cash/Check/Credit Card/Gift Card:
    • if was made POS Sale -> all payment transactions is negative;
    • if was made Return -> all payment transactions is positive;
  • Total Sale:
    • Total Sale = Taxable Sales + Non Taxable Sales + Tax Exempt Sale +  Gift Card Sales + Tax Amount;
  • Total Payment:
    • Total Payment = on Account + Check + Cash + Credit Card + Gift Card.