“Daily Transaction Report” List form

Reports List from the Menu:

• was added the next Report to the List:
  • “Daily Transaction” Report;
• after clicking on the report -> the corresponding form of the Report is opened.

Report “Daily Transaction”:

• Rules:
  • data is filtered by date and is grouped by date and site;
• Filters:
  • Date From / To -> required date pickers for separated date;
  • Store -> dropdown;
  • “Synced” checkbox:
    • isn’t checked by default;
    • if the checkbox is checked -> in the Datagrid are displayed only “Synced” Orders;
  • “Not Synced” checkbox:
    • isn’t checked by default;
    • if the checkbox is checked -> in the Datagrid are displayed only “Not Synced” Orders;
  • “Search” button:
    • is always clickable;
    • after clicking on the button -> the Datagrid is filtered based on the selected filters;
• Datagrid:
  • were added next columns:
    • checkboxes;
    • Status;
    • Number;
    • Date;
    • Waherouse;
    • Sales;
    • Returns;
    • Discount;
    • Net Sales;
    • Taxes;
    • Cash;
    • Check;
    • Credit Card;
    • Gift Card;
    • Taxable Sales;
    • Non Taxable Sales;
    • Tax Exempt Sales;
    • Gift Card Sales;
    • On Account;
    • Applied on Account;
    • Total Sale;
    • Total Payment;
    • Total;
  • At the bottom are displayed next Total values:
    • Sales;
    • Returns;
    • Discount;
    • Net Sales;
    • Taxes;
    • Cash;
    • Check;
    • Credit Card;
    • Gift Card;
    • Taxable Sales;
    • Non Taxable Sales;
    • Tax Exempt Sales;
    • Gift Card Sales;
    • On Account;
    • Applied on Account;
    • Total Sale;
    • Total Payment;
    • Total;
• “Sync” button:
  • is disabled if no one row is checkedl
  • after clicking on the button:
    • the transactions per selected day are synched to QB as “Sales Receipt”;
    • synching will be one way from OMS to QB;
• “Export to Excel” button:
  • after clicking on the button the excel is downloaded with data from datagrid;
  • if some lines are checked -> are downloaded only checked lines;
  • if no one line is checked -> are downloaded all lines from Datagrid;
• was added column selector.

Settings -> Daily Transaction Sync Settings button:

• was added to the Settings List;
• after clicking on the button -> “Daily Transaction Sync Settings” pop-up is opened;
• “Daily Transaction Sync Settings” pop-up:
  • the pop-up contains:
    • Left side:
      • “Add New” button:
        • after clicking on the button -> the new empty line is added in the end of the list;
        • once the store has been selected on the right side -> the name is appeared in the tab;
      • Tabs:
        • displays the list of added Stores;
        • if settings are marked as default -> the “Default” label is displayed;
        • “x” button:
          • after clicking on the button:
            • the message is displayed “Are you sure you want to delete Store synch setting? Yes/No”;
            • if Yes -> the selected store with settings is deleted;
    • Right Side:
      • “Store” drop-down:
        • is required;
        • contains the list of the Stores in the system;
        • single select;
        • the store can selected only once on the form;
        • if the store has been already selected in the drop-down in another tab -> the validation is appeared: “Store has been already selected”;
      • Transaction Types:
        • was added enum with list of transactions for each Store, such as:
          • Cash;
          • check;
          • credit card;
          • Gift card;
          • Sales;
          • Returns;
          • Taxes;
        • for each transaction is added drop-down with Item list;
      • “Item” drop-down:
        • single select;
        • contains list of items in the system;
      • “Default” checkbox:
        • isn’t checked by default;
        • could be checked only for the one store;
        • if the checkbox is checked:
          • setting from the current store is used for all stores which do not have synch transaction settings;
    • Buttons at the bottom:
      • Cancel:
        • after clicking on the button, the form is closed without changes;
      • Save:
        • after clicking on the button:
          • the form is closed;
          • the item is linked with the transaction;
          • once the transaction has been synched to QB -> the selected item is displayed in QB in Sale Receipt order.

Sales Receipt in QB:

• In QB Sales receipt will be looks like:
  • Item -> transaction type;
  • Rate -> Transaction Amount;
  • Class -> Site.

OMS Web -> Settings -> Permission:

• was added new permission to Reports tab -> Reports List:
  • Can View Daily Transaction Report:
    • if for user the checkbox is unchecked:
      • The “Daily Transaction” Report is hidden from the Report Menu List form.