Replenishment Journals are used to calculate the Purchase Order and Transfer Order proposals for Replenishment based on the current stock situation and the demand in the stores. The calculation of the journals depends on the Replenishment Item Quantity table, which needs to be calculated up front.
Each Journal has a Template and a Batch:
- The Template defines what should be calculated in the Journal and it provides filters for items, stores, vendors, and more.
- The Batch defines when the Journal should be calculated.
Refer to the topics Replenishment Templates and Replenishment Batch for a more detailed description of the fields in these tables.
Add Items to Journal
The journal can be populated by manually adding lines to the journal by executing the Add Items to Journal function. The Add Items to Journal function will then run the Add Items to Replenishm. Jrnl. report.
In the Add Items to Replenishm. Jrnl. report's request page:
- If you select the Calculate Inventory option, the system recalculates the Replenishment Item Quantity table before executing the Replenishing Process of adding items to the Replenishment Journal.
- If you select the Skip 0 Lines option, the Replenishment Process will not insert lines if the result of the calculation is 0.
Tip: It is advisable not to skip 0 lines when logging the replenishment result, as it is not possible to look at the Replenishment Log unless the record exists in the journal.
The process steps through the Replenishment Item Quantity table according to the filtering in the Replenishment Template/Add Items to Journal function. The report inherits the filtering from the Replenishment Template record, but the buyer can alter the filtering for that specific execution of the Replenishment Journal.
Note: The Replenishment Journal can also be populated by using the Scheduler. It is convenient for companies to have the Replenishment Item Quantity calculation and population of the Replenishment Journals to be scheduled to run overnight, so that everything is ready for the buyer when he or she shows up for work.
The Replenishment Batch record is used to control when the Replenishment Journal should be populated by the Scheduler Job. Irregular Replenishment Journals are set to Manual and the buyer executes them as needed.
Replenishment Journal Lines
The Replenishment Journal Lines show the items that the Add Items to Journal function created, and each line is a total line for the item number. You can access the Replenishment Journal Detail records by drilling down the Quantity column in the Replenishment Journal Lines. The detail lines show the quantities per individual store/location and variant.
If you change the value of the Quantity field, the system changes the quantity of the Replenishment Journal Detail records according to the proportion of the previous quantity in the records.
If you create a record manually to the journal, you must also create the Replenishment Journal Detail lines for each store/location and variant. The total quantity of the detail lines will update the quantity of the journal line when you exit the detail lines.
For an item with Select Lowest Price Vendor activated, when you change the value of the Quantity or Unit of Measure Code field in the Replenishment Journal Lines, the system will recalculate the lowest price vendor immediately if the Recalc. Vendor on Item Quantity Change setup has been activated in Replenishment Template. Alternatively, you can use the Recalc. Vendor (All) and Recalc. Vendor (Line) actions in the Replenishment Journal Details page to recalculate the lowest price vendor manually. For more details about the actions, see To work with lowest price vendor in the Replenishment Journal Detail page.
Replenishment Log Lines
If you want to check in detail the calculation steps that the system performed, you can do so in Calculation Log Lines.