OMS Desktop Tweaks

Invoice edit form:

• If the Invoice was synced from QB -> It’s Non-trackable Order;
• Datagrid in the Non-trackable-Invoice:
  • “Item Cost” column:
    • was added after the “UOM” column; 
    • is editable;
    • is optional;
    • is calculated based on UOM specified in Invoice;
    • by default value is taken from QB;
    • was added to the column selector;
    • is displayed only on the Non-trackable Invoice edit form;
    • Item Cost is displayed for Reports:
      • Sales by Item Summary;
      • Sales by Item Detail;
  • “Total Cost” column:
    • is editable;
    • is optional;
    • is calculated based on UOM specified in Invoice;
    • was added to the column selector;
    • is displayed only on the Non-trackable Invoice edit form;
    • Total Cost = Qty * Item Cost;
• the same logic was added to the Customer Credit edit form:
  • Item Cost / Total Cost columns were added; 
  • the logic is the same as for Non trackable-Invoice edit form.

Sales by Item Summary / Sales by Item Detail Report list form:

• If Invoice was synced from QB -> It’s Non trackable Invoice
  • Datagrid:
    • “Avg COGS” column:
      • for Non-trackable Invoice -> value is taken from:
        • Invoice edit form -> Item Cost;
    • “Total Cost” column:
      • for Non-trackable Invoice -> value is calculated;
        • Total Cost = (Avg COGS + Landed Cost * Qty);
        • formula not change -> is the same as for general Invoice;
  • Filters panel:
    •  “Exclude Non-trackable” checkbox:
      • was added under the “Show Cost” checkbox;
      • isn’t checked by default;
      • if the checkbox is checked:
        • in the Datagrid isn’t displayed Non-trackable Orders.