Order Management System. What's new
← Version 1.37.70.0

The logic for Negative stock

“Support negative” module:

  • was added to the system;
  • if the module is switched on -> it’s possible to make negative stock on Sale Order and POS Sale mode;
  • it’s possible to switch off negative if in the system there is no one negative transaction.

Sale Order / Ship Order edit form:

  • Negative substatus for order:
    • if at list one item has linked negative transaction -> the substatus is displayed;
  • Negative substatus for line item:
    • is displayed for items that have linked negative transaction;
    • on SO/SHO first is displayed main item status then is displayed negative (color red);
    • for example 
      • SO: Ready to ship / Negative;
      • SHO: Shipped / Negative.

Negative transaction:

  • is deleted automatically:
    • after clicking on the Delete line item / Unreserve line item / Void line item / Convert to Draft / Void Order / Delete Order / Close Order on SO;
    • after Deleting Invoice:
      • if a negative was created for Not Reserved / Check Stock / Backorder items:
        • once Invoice has been deleted:
          • SHO has been unshipped (logic not change);
          • Sale Order the line item is moved to the previous status (for example Backorder item has Backorder status);
          • the negative transaction is deleted;
      • if a negative was created for an item with allocation type “Create Negative Stock Qty”:
        • SHO has been unshipped (logic not change); 
        • Sale Order the line item is moved Not Reserved status; 
        • the negative transaction is deleted;
  • is updated automatically:
    • after making  Increase item / Decrease Item.

Decrease Invoice with negative transaction:

  • If invoice was decreased and Ship Order -> is unshipped:
    • SO/SHO are in negative substatus;
    • SO/SHO line items are in negative substatus.

Ship Order edit form /  Shipping Schedule / Shipping for e-commerce:

  • Create Negative Stock Qty for: Not Reserved / Check Stock / Backorder items:
    • if item has one of such allocation types and module is switched on -> After clicking on the Ship button on SHO edit form / Shippings Scheduled / Shipping for e-commerce:
      • negative transaction is created for Not Reserved / Check Stock / Backorder items:
        • on Transaction History panel -> transaction is negative with Type = “OUT”;
      • SHO has “Negative” substatatus;
      • Line item on SHO will have status “Shipped” and substatus: “Negative”;
      • SO has “Negative” substatatus;
      • Line item on SO will have status “Shipped” and substatus: “Negative”;
  • Ship Qty field:
    • if module is switched on -> it’s possible to enter ship qty more than available qty;
    • If user enters Ship Qty > Available qty:
      • warning is displayed: “Negative Qty transaction will be created”.

Fix Negative Transaction:

  • Negative Transaction is deleted -> if IRC or Inv Adj were created by next rules:
    • IRC or Inv Adj were created to stock same as SO;
    • item qty is not linked to any order;
    • item qty is not less than qty on SO;
  • once order has been created by previous rules -> the negative transaction is deleted and instead of it, the new IRC or Inv Adj partially or fully is linked to SO;
  • once new positive transaction linked to SO:
    • negative substatus is deleted from SO/SHO;
    • negative substatus is deleted from line items on SO/SHO.

Item List -> Item Statistic calculations:

  • In Stock:
    • In Stock = (Allocated include Negative transactions) + Available;
  • Allocated:
    • Allocated = (In Stock include Negative transactions) – Available;
  • Available:
    • Available = (In Stock not include negative) –  Allocated.