In this article
To calculate Sales History Adjustment from Item Ledger Entries
The Calculation Rule using Item Ledger Entry helps you to create Sales History Adjustment for a specified location based on the Sales History entries for another location using predefined filters.
When items are sold through eCommerce, B2B commerce and so on, there are no physical stores present and the stocks are directly consumed from the warehouse. The sales from this channel are not included in the Average Usage calculation and therefore are not considered for replenishment.
With Replen. Sales History Adjustment Calculation Rules using Item Ledger Entries, the historical sales from this channel can be consolidated into a virtual location and Sales History Adjustment Entries will be created to simulate the sales. With this, these sales will also be taken into consideration when calculating the Average Usage for replenishment.
To calculate Sales History Adjustment from Item Ledger Entries
- Click the
icon, enter Replen. Sales Hist. Adj., and select the relevant link. - Click Calculate - Calculation Rules to open the Replen. Sales History Adjustment Calculation Rules page.
- Click New to create a new Replen. Sales History Adjustment Calculation Rule with Type Item Ledger Entries. Alternatively, open an existing one.
- Fill in the fields on the Filters and Item Ledger Entries FastTabs as described in the following table:
- Click Calculate.
Alternatively, you can select the relevant Replen. Sales History Adjustment Calculation Rule and click the Calculate action on the Replen. Sales History Adjustment Calculation Rules page.
| Field | Description |
|---|---|
| Source Location Code | This field specifies the source location to copy the Sales History entries from. This is a mandatory field to calculate the adjusted sales quantity using Rule Type Item Ledger Entries. |
| Destination Location Code | This field specifies the destination location to copy the Sales History entries to. This is a mandatory field to calculate the adjusted sales quantity using Rule Type Item Ledger Entries. Only Locations with Data Source Calculated (from Item Ledger Entries) can be used as Destination Location Code. For more information on setting up the Data Source for locations, see Setting Up a Location for Replenishment. |
| Division Code Filter | This field specifies the Division that will be used to filter the items. |
| Item Category Code Filter | This field specifies the Item Category that will be used to filter the items. |
| Retail Product Filter | This field specifies the Retail Product Group that will be used to filter the items. |
| Item No. Filter | This field specifies the item number that will be used to filter the items. |
| Replenishm. Calc. Type Filter | This field specifies the replenishment calculation type that will be used to filter the items. |
| Consider All Source Types | This field specifies if Item Ledger Entries of all Source Types will be considered in the calculation. If the field is not selected, only Item Ledger Entries of Source Type Customer are considered. |
| Retail Customer Group Filter | This field specifies the Retail Customer Group that will be used to filter the customers. When this filter is used, only Item Ledger Entries of Source Type Customer are considered. If Consider all Source Types is selected, then this filter is not applicable. |
| Customer No. Filter | This field specifies the customer number that will be used to filter the customers. When this filter is used, only Item Ledger Entries of Source Type Customer are considered. If Consider all Source Types is selected, then this filter is not applicable. |
| Calculation Method | This field specifies if the Replen. Sales History Adjustment Calculation Rule will run manually or using job scheduler. |
| Last Run Date | This field specifies the last system date when the Replen. Sales History Adjustment Calculation Rule was executed, either manually or using job scheduler. |
| Last Calculated Date | This field specifies the last WORKDATE when the Replen. Sales History Adjustment Calculation Rule was executed, either manually or using job scheduler. Note: Manually changing this field might cause existing Sales History Adjustment entries to be overwritten on the next calculation. |
See also
Sales History Adjustment Calculation Rules