Parallel Item Balancing Pre-Calculation

In this article

To pre-calculate parallel item balancing with a Scheduler Job

To pre-calculate parallel item balancing manually

To view the Replen. Item Quantity Template Balancing entries

When the Out of Stock or Replenishment Item Quantity (RIQ) calculation is run in parallel, the items are split and shared across multiple linked jobs, and the items to be processed by each job are specified in the Job Filter String of the linked job. It is possible to pre-calculate the item balancing as a separate job and following that, during the Out of Stock or RIQ calculation, the master job skips the item balancing calculation and the system proceeds with the Out of Stock or RIQ calculation based on the pre-calculated item range.

To pre-calculate parallel item balancing with a Scheduler Job

The item balancing can be pre-calculated for the parallel linked jobs for the Out of Stock or RIQ process with a scheduler job.

To set up the item balancing pre-calculation scheduler job:

  1. Click the icon, enter Scheduler Job List, and select the relevant link.
  2. Create a new scheduler job by clicking the New action, or select an existing job.
  3. In the General FastTab, define the Job ID and Description.
  4. In the Object Setup FastTab, select Codeunit in the Object Type field and assign the Object No. with 10012241 (LSC Replen. Calc. Item Bal.).
  5. Go to the Schedule Details FastTab, define the date and time for when you would like the job to be executed. This includes Time Units, Time Between Check, Next Check Date, and Next Check Time.

Next, you need to configure the master job for the Out of Stock or RIQ calculation, for it to be considered for item balancing pre-calculation.

  1. Click the icon, enter Scheduler Job List, and select the relevant link.
  2. Select and open the Scheduler Job page of the master job for the Out of Stock or RIQ calculation.
  3. Click Related - Job - Replenishment Parallel Jobs to open the Replen. Parallel Jobs page.
  4. Set the Balancing Method field to Pre-Calculate with Scheduler Job. The pre-calculation job will only consider the master jobs with this setting.

For RIQ calculation, if Replen. Item Quantity Template is used, there are additional steps that need to be taken:

  1. Click the icon, enter Replen. Item Quantity Templates, and select the relevant link.
  2. Select and open the Replen. Item Quantity Template page of the Replen. Item Quantity Template to be considered for item balancing pre-calculation.
  3. In the Linked Master Job for Balancing field, select the relevant master job for the RIQ calculation. The pre-calculation job will only consider the Replen. Item Quantity Templates with link to master job and with a Next Run Date that is older than or equal to the Workdate.

When the item balancing is calculated, for Out of Stock and RIQ calculation without Replen. Item Quantity Templates, the item range is populated directly into the Job Filter String field of the respective linked jobs.

Whereas, for RIQ calculation with Replen. Item Quantity Templates, the item range is first populated into the Replen. Item Quantity Template Balancing table, and during the RIQ calculation, the system copies the pre-calculated item range from the Replen. Item Quantity Template Balancing table into the Job Filter String of the parallel linked jobs.

To pre-calculate parallel item balancing manually

The item balancing can be pre-calculated manually for a specific master job for the Out of Stock or RIQ process.

  1. Click the icon, enter Scheduler Job List, and select the relevant link.
  2. Select and open the Scheduler Job page of the master job for the Out of Stock or RIQ calculation.
  3. Click Related - Job - Replenishment Parallel Jobs to open the Replen. Parallel Jobs page.
  4. Click the Calculate Balancing action.

When the item balancing is calculated, for Out of Stock and RIQ calculation without Replen. Item Quantity Templates, the item range is populated directly into the Job Filter String field of the respective linked jobs.

Whereas, for RIQ calculation with Replen. Item Quantity Templates, the item range is first populated into the Replen. Item Quantity Template Balancing table, and during the RIQ calculation, the system copies the pre-calculated item range from the Replen. Item Quantity Template Balancing table into the Job Filter String of the parallel linked jobs. The pre-calculation process will only consider the Replen. Item Quantity Templates with a Next Run Date that is older than or equal to the Workdate.

To view the Replen. Item Quantity Template Balancing entries

When Use Replen. Item Quantity Template is enabled in the Replen. Setup, running the item balancing pre-calculation for the RIQ populates the item range into the Replen. Item Quantity Template Balancing table. You can review the pre-calculated item range for the linked jobs from the Replen. Item Quantity Template Balancing page, which is accessible from the Replen. Item Quantity Template page and the Replen. Parallel Jobs page of the master job, using the Show Balancing action.

The table lists the fields on the Replen. Item Quantity Template page:

Field Description
RIQ Template Code This field shows the code of the Replen. Item Quantity Template where its specified filters were used for the item balancing calculation.
Master Job ID This field shows the ID of the master job for the Out of Stock or RIQ process.
Linked Job ID This field shows the ID of the linked job for the Out of Stock or RIQ process.
% Share This field shows the workload distributed to each linked job.
Job Filter String This field specifies the range of items calculated and assigned to each linked job. You can manually adjust the value if needed.

See also

Parallel Replenishment Item Quantity and Out of Stock Calculations

Replen. Item Quantity Templates