Tweaks for the “Sales by Item Summary” report list form

Sales by Item Summary report list form:

• Datagrid:
  • “Total Cost” column:
    • total cost includes -> Commission, Shipping Cost, Avg Landed Cost, Avg COGS;
  • “Shipping Cost” column:
    • the value is calculated with the Package Label Cost which was generated on the Shipping for e-commerce form;
    • if for the order was generated label and Amazon has not made shipping -> to the SO will be added service item which previously was marked as a “freight item” with label cost and this sum (cost) by freight items is added to the Shipping cost; 
    • if for the order was generated label and Amazon has made shipping -> value is taken from Amazon;
  • “Cost Per Item” column:
    • the value is calculated based on the next formula:
      • Total Cost / Qty Sold;
  • next values were made clickable:
    • Shipping Charge;
    • Total Cost;
    • Commission;
    • Shipping Cost;
    • Other Cost;
  • after clicking on one of these values -> the “Channel Fees” panel is opened;
• “Channel Fees” panel:
  • Datagrid:
    • is displayed Sale Order data grouped by the Chanel -> for example, Amazon;
    • are displayed columns, the same as:
      • on the Sale Order edit form -> Cost tab -> Profit & Loss -> Actual Cost value -> Item panel -> Channel Fees tab;
      • data is presented in separate vertical columns;
      • all Fees are taken from the appropriate Channel;
  • “Cancel” button:
    • after clicking on the button -> the panel is closed without changes;
• also, the logic was added on next Report List forms:
  • Sales by Item Detail; 
  • Sales by Customer Summary;
  • Sales by Customer Detail; 
  • Sales by Item Class Summary;
  • Sales by Department Summary; 
  • Sales by Brand Summary;
  • Sales by Category Summary.

Sale Order edit form:

• Cost -> Profit & Loss tab:
  • Channel column:
    • was added after the “Item Cost” column;
    • the Channel name is displayed;
  • Actual Cost column:
    • is displayed the actual cost total cost.