| Table of Contents |
|---|
...
There are two types of buffers, detailed buffers and global buffers. The first will be assigned and deducted at endpoint level, the second will be assigned without a notion of endpoint and will be deducted once the stock locations have been aggregated. As a result, the global buffers are only taken into account in the stock query with unification by stock llocation.
Detailed Buffer
Declaration by item, stock location ID pair (BufPairs)
The simplest buffers, corresponding to a number of buffered units for a couple item_id , endpoint_id.
Stock Location ID | Item ID | Quantity | Buffer group |
|---|---|---|---|
store_1 | i1 | 2 | FR |
store_1 | i1 | 3 | US |
Declaration by key requests (BufKeyRequest)
Similar to previous, but more flexible. Allows to apply the buffer based on an existing Item and Stock Location Key Request. Key requests are prefilled Item queries, which allow for example retrieveing items from Spring Season, or Stock Locations from London
Stock Locations | Items | Quantity | Buffer group |
|---|---|---|---|
London stores | Spring 25 | 3 | UK |
Paris stores | Spring 25 | 2 | FR |
Global Buffer (BufGlob)
Allows a buffer to be allocated globally, i.e. without filtering the stock locations affected. If an endpoint filter is declared, it will be ignored. Allows a number of units to be buffered globally.
Stock Locations | Items | Quantity | Buffer group | Global |
|---|---|---|---|---|
London stores | Spring 25 | 15 | UK |
|
Spring 25 | 10 | FR |
|
Creating buffers
...
Impact of buffers on stock calculations
Taken into account in stock requests
Buffers are categorized into buffer groups. This categorization allows for efficient referencing from a stock query, making the management of buffers more structured and organized.
Bufferes are taken into account in Stock Queries when their groups are referenced in the query.
Global buffers will only take effect when the Stock Query is unified by stock location, otherwise it will not be taken into account.
...
When buffers are taken into account in a stock request, available stock is calculated as follows:
Legend
BufPairs = Detailed Buffer - Declaration by item, stock location ID pair
BufKeyRequest = Detailed Buffer - Declaration by key requests
BufGlob = Global Buffer
Detailed stock query
...
(Without stock location unification)
| Code Block |
|---|
Stock per stock location :
MAX(
RawStock - ResStockLocation - Dispositions - MAX(BufPairs, BufKeyRequest) ,
0
) |
...
Unified stock query (With stock location unification)
| Code Block |
|---|
MIN( SUM( MAX_per_stock_location( RawStock - ResStockLocation - Dispositions - MAX(BufPairs, BufKeyRequest), 0 ) ), SUM(RawStock - ResStockLocation- Dispositions) - BufGlob ) |
...