Skip to main content

Cash Flow Protection within SourceDay Insights

  • Updated
Follow

The Cash Flow Protection Dashboard will help you to understand how move outs in your POs affect your business.  This can help you better understand trends in when changes are happening and how late or missing inventory is affecting your ability to do business.

 

Let's Take a Look

Use the numbers in the image to help identify the sections for a deep dive of the functionality below.

mceclip0.png

  1. Filters
  2. PO Lines Moved Out
  3. PO Spend Moved Out
  4. Quantity Ordered Minus Quantity Received
  5. Move In and Moves Out By Month
  6. Download Data

1) Filters

Filters can help you to change the data based on how your company sees value.  You are able to change the time periods, PO spend or line groupings, and PO statuses. 

Available filters: 

  • Company Name - This value will default to your main company name.  If you have more than one company in SourceDay linked together you can choose to show data for one company or multiple companies in your data
  • PO Spend vs PO Line Look - Are you wanting to aggregate the level based on PO lines or PO spend 
  • Supplier Name - This filter is a valuable tool that will let you see supplier performance across all suppliers, one supplier, or maybe even a group of suppliers that sell the same types of parts
  • Buyer Name - This filter allows you to see information for one buyer, all buyers, or a grouping of buyers
  • PO Statuses - The value of the "Status" field for that PO line displayed on the PO table.
    • All
    • Awaiting Approval
    • Cancelled
    • Completed
    • Late
    • Ontime
    • Pending
    • Pending Approval in ERP
    • Projected Late
    • Shipped
  • Job - This filter allows you to segment based on specific job numbers that you are using with your suppliers.  If you are using a custom job num field you will not be able to filter on that value
  • By Month vs By Day - This changes the groupings of the "buckets" on the x-axis of the chart, to either +/- months or +/- useful numbers of days.
  • Buyer or Supplier Driven Change - Who initiated the change to the PO
    • All
    • Buyer and Supplier
    • Buyer
    • No Move
    • Supplier Change

2) PO Lines Moved Out

The number of active PO lines where the current due date is more then one month (or one day if day grouping selected) greater than the original due date.  "Active" is defined as not cancelled, completed, or deleted.  This will help you to identify where there are changes to your POs to help get a high level understanding of how PO changes are affecting your business.

 

3) PO Spend Moved Out

The sum of PO Spend for active PO lines where the current due date is more then one month (or one day if day grouping selected) greater than the original due date.  By looks at the costs you can start to understand how PO changes are affecting your capital.  Items not received on time can affect warehouse space, and whether or not you are able to manufacture your items, or whether you have to switch to manufacturing a different item.  When you start to see what changes are costing you it can help leadership to understand what constant changes are doing to incoming and outgoing revenue.

 

4) Quantity Ordered Minus Quantity Received

This is the difference between received and ordered quantities trending by the original due date on the purchase order.  It allows you to see what inventory is coming in versus what is delayed.  This chart can help you to understand where your inventory is and what it is costing you.

 

5) Move In and Moves Out By Month

This graphic can help you easily see what is going on with your purchase orders and get an easy to understand visual showcasing early, on time and late orders.

 

By clicking on the bars you can also do a deep dive into the orders affecting the numbers

Step5MoveInOutAnimation.gif

  • Supplier Name - Name of the supplier
  • PO Spend - Spend for the affected lines
  • PO Lines - Number of lines affected

 

6) Download Data

You can download any of your data from these charts for use and additional analysis.  You can download to either excel or csv.

  1. Click the download data link
  2. When you are taken to the downloads tab, click on "Choose your data download"
  3. You will see a pop up box that will allow you to choose either:
    1. Lead Time:  Data Download
    2. Moves:  Data Download
    3. OTIF:  Data Download
    4. PPV:  Data Download
  4. Choose the format:  Excel or CSV
  5. Then click download

The download will include all lines of data that were used to make the dashboard (it will not contain the actual charts)

 

 

Keep Going

Next Up:  Let's take a look at understanding the demand planning dashboard

 

 

 

Related articles

Powered by Zendesk