Parts Month End Setup

The Month End button in the Parts Window is used to move the sales, demand, bin trips and lost sales data to previous months, so that the current month can be tracked for parts usage. This feature tracks 24 months of history for these statistics.

When the Month End process is run, it will move the statistics for each part to the previous months' buckets. For example, if the Month End process is run on October 31st, 2021, it will take the demand for a part from the Demand 1 bucket and move it to Demand 2, the demand from Demand 2 and move it to Demand 3, and so on. In this example, Demand 1 would represent November 2021, Demand 2 would represent October 2021, and so on.

In addition to moving the statistics, the Month End process also updates the status of a part based on the "Phase In/Phase Out" setup of the Parts Group that the part belongs to. This process helps identify parts that are frequently sold or picked and "phases them in" for users to stock accordingly, and also identifies parts that are no longer being sold or picked and "phases them out" to prevent ordering them.

The "Phase In/Phase Out" setup is done by Parts Group in the Setup Toolbar button on the Parts Window. The criteria for determining whether a part should be phased in or out include Average Demand per Month and Total Bin Trips over a selected number of months, which can be set in the Parts Group Tab. The process also includes a "Phase Out Criteria" section, which includes the same parameters to determine whether a part should be phased out or not.

When the Month End process runs, it looks at the Part Group for each part to gather the information needed to determine whether the part should be phased in or out. To be considered for phasing in, the part must meet the criteria set in the "Phase In Criteria" section, including average demand per month and total bin trips over a selected number of months. To be considered for phasing out, the part must meet the criteria set in the "Phase Out Criteria" section.

Here is an example of how the Month End process would affect the statistics for a specific part:

Let's say a part is currently in the Demand 1 bucket, which represents the demand for the current month, November 2021. When the Month End process is run on November 30th, 2021, the demand for this part will be moved from the Demand 1 bucket to the Demand 2 bucket, which represents the demand for the previous month, October 2021. The demand for October 2021 will then be moved from the Demand 2 bucket to the Demand 3 bucket, which represents the demand for the month before that, September 2021, and so on.

In addition to moving the statistics, the Month End process will also check the "Phase In/Phase Out" setup for the Parts Group that the part belongs to, to determine if the part should be phased in or out based on the criteria set in the setup. For example, if the Average Demand per Month is set to 5 and the part's average demand over the past 3 months is 7, the process would determine that the part should be phased in because it meets the criteria.

It's worth noting that the Month End process will analyze all the parts in the system based on the criteria set in the Phase In/Phase Out setup in order to determine which one should be phased in or out.

Phase In Statuses

When a Part meets the Phase In criteria and is in a status of; New, Phase Out or Delete the Part Status will be updated to the Phase In and the Prior Status will be set to it's previous value.  

When a Part meets the Phase In criteria and is in a status of; Phase In the Part Status will be updated to Current and the Prior Status will be set to Phase In. 

Phase Out Statuses

When a Part meets the Phase Out criteria and is in a status of; Current or Phase In the Part Status will be updated to the Phase Out and the Prior Status will be set to it's previous value. 

When a Part meets the Phase Out criteria and is in a status of; Phase Out the Part Status will be updated to Delete and the Prior Status will be set to Phase Out.