Replenishment Journal Detail

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.

The Replenishment Journal Detail record contains information that is used to determine the quantity to be ordered.

The quantity can be manually adjusted, and there is an option to create the Purchase Order in Purchase Unit of Measure.

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.

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

How to: Create a Purchase Order in Purchase Unit of Measure