Replenishment Journal Detail lines show the quantity to replenish down to an individual store or location and variants.
The Add Items to Journal function in Replenishment Journals creates one line for each Item No., Variant Code, and Location Code, where it calculates system-suggested quantity and then takes into account the stock on hand in the store or warehouse to decide the quantity to be ordered. The system uses the Replenishment Journal Detail lines to create the Purchase and Transfer Order Lines. For BOM Replenishment Journal, Assembly Order Lines will be created.
The Replenishment Journal Detail record contains information that is used to determine the quantity to be ordered. It also contains the item related information such as the Direct Unit Cost, Unit Price, Weight, and Cubage. For BOM Replenishment Journal, this includes the BOM Method used and whether the BOM will be assembled in the warehouse or store.
The quantity can be manually adjusted, and this will also recalculate the item related information on the Replenishment Journal Detail, such as the Direct Unit Cost. If you want to skip the Direct Unit Cost recalculation in the Purchase Replenishment Journal, you can activate the Skip Cost Recalculation on Qty. Change setting in Replen. Setup, under the Purchase group in the Replen. Journals FastTab. This improves the performance for Replenishment Journals with many Replenishment Journal Detail records. This feature does not apply to the BOM Replenishment Journal.
To work with lowest price vendor
During replenishment calculation, for an item with Select Lowest Price Vendor activated, the system will consider the different prices offered by various vendors for the item and automatically select the vendor with the lowest price in the Replenishment Journal. When the quantity is manually adjusted in the Replenishment Journal Detail lines, it is possible to recalculate the lowest price vendor for the item by using the following actions in the Purchase Replenishment Journal Details page:
- Recalc. Vendor (All)
- Recalculates the vendor for all the Replenishment Journal Detail lines of the selected item.
- The lowest price vendor will be calculated based on the total quantity from all the Replenishment Journal Detail lines. For purchases that replenish the warehouses, the total quantity used to select the vendor will always be grouped by item. Whereas, for purchases that replenish the stores directly, the total quantity will be grouped by item and location by default, but there is an option to have the quantity grouped by item instead, by using the Select Lowest Cost By setup in the Replenishment Template. For more details, see Replenishment Calculation With Lowest Price Vendor.
- Recalc. Vendor (Line)
- Recalculates the vendor for the selected Replenishment Journal Detail line only.
- The lowest price vendor will be calculated based on the quantity of the selected Replenishment Journal Detail line only.
The lowest price vendor recalculation feature will be disabled, when the Skip Cost Recalculation on Qty. Change setting is activated in the Replen. Setup.
Note: In BOM Replenishment Journal, lowest price vendor is not considered as vendor selection is irrelevant.
Journal Detail Lines and Redistribution
Replenishment Journals with Replenishment Type of Redistribution contain information about the calculated trips, which are the established routes between store and warehouse locations to fulfill the demand. This information can be retrieved with the Show Trips action in the Replenishment Journal's Functions menu.
When you change the Quantity field in the Replenishment Journal Detail Line or deletes a Replenishment Journal Detail Line, the system will recalculate the established trips according to the applied change.
See also
Order Multiple and Transfer Multiple Validation