Sterling OMS Status

By | 09/27/2018

Sterling OMS Status

OOB Status

Sterling OMS Status

In this post we are going to learn about various statuses used part of Sterling OMS system.

When we talk about statuses below few statuses comes to our mind. In this page we are going to learn how to configure and use them.

  • Order Status
  • Item Status

Order Status

How to view Existing Order Status ?

  • Open from menu Configuration — Launch Applications Manager
  • Applications — Application Platform
  • Change the customer name by clicking the hammer (left hand side) : Some time configured at DEFAULT level
  • Click on Process Modelling
  • Click on Order tab — Order Fulfillment (Process Types section)
  • Open Statuses tab
  • You can view OOB (Out of box) and user defined status

Sterling OMS Status

How to configure Custom Order Status – Sent To Fullfilment Center (3200.03) ?

  • Open from menu Configuration — Launch Applications Manager
  • Applications — Application Platform
  • Change the customer name by clicking the hammer (left hand side) : Some time configured at DEFAULT level
  • Click on Process Modelling
  • Click on Order tab — Order Fulfillment (Process Types section)
  • Open Statuses tab
  • You can view OOB (Out of box) statuses
  • Select any one of status (Released) right click and select create option
  • Enter 03 (zero three) in first text box and enter status name (Sent To Fullfilment Center) in 2nd text box
  • Click Save
  • Now new status “Sent To Fullfilment Center” created with number 3200.03

Note : We can not create new status directly. We can add the statuses for the existing status. For example we can add “Sent To Fullfilment Center” status under Released status. Here Released is out of the box status. Sent To Fullfilment Center is custom order status which is added on top of release status. 

View Order Statuses

How to view Existing Item Status and add custom Item Status ?

  • Open from menu Configuration — Launch Applications Manager
  • Applications — Catalog management
  • Under Catalog Configurations — Item Statuses
  • Click on + and enter Item Status and Description as shown below

Item Status

How to associate Item Status with Item ?

  • Open from menu Configuration — Launch Applications Manager
  • Applications — Catalog management
  • Change the customer name (Using Hammer) as Matrix
  • Catalog management — Products — Items
  • Search for one item

Item Details Screen

Order Status Related Question and Answer ?

  • Where order status information is stored in database ? Answer : yfs_status
  • How to find the order status related to Return Fulfillment flow ? Answer : select * from yfs_status where process_type_key=’RETURN_FULFILLMENT’;
  • How to find order status is custom defined or Out of the box ? Answer :  select * from yfs_status where process_type_key=’RETURN_FULFILLMENT’ and STATUS_TYPE=’USER’;
  • Where we can use these order statuses ? Answer : Statuses can be configured in transactions under pickup and drop status tabs. Which can be used part of pipelines to derive the order flow.

Item Status Related Question and Answer ?

  • Where item status information is stored in database ? Answer : select * from yfs_common_code where code_type=’ITEM_STATUS’;
  • Can item status can be configured for particular enterprise ? Answer : No; Configured only at DEFAULT level
  • How to find item status is custom defined or Out of the box ? Answer : SYSTEM_DEFINED_CODE column from yfs_common_code table

If you have any question or suggestion please email to : support@activekite.com

Happy Learning !!!

Register with us to get more updates

Sterling OMS Forum : View/Ask Questions

Join our channel for updates

One thought on “Sterling OMS Status

Leave a Reply

Your email address will not be published. Required fields are marked *