| Update MAUC values - examples |  |
| Initial situation (no inventory present)
Item | Warehouse | Warehouse Valuation Group | Valuation Method | By Warehouse Valuation Group
--- | --- | --- | --- | ---
A | W1 | G1 | MAUC | Yes
A | W2 | G1 | MAUC | Yes
A | W3 | G1 | MAUC | No
Note In the MAUC (by Warehouse) columns in the following tables, the values marked with an asterisk are shown for information purposes only, because valuation in the related warehouses is by By Warehouse Valuation Group. Transaction #1 Receipt of 10 items A in W1 at 10 euros each. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 10 | 10*
A | W2 | 0 | 0*
A | W3 | 0 | 0
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 10 | 10
Transaction #2 Receipt of 10 items A in W2 at 12 euros each. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 10 | 10*
A | W2 | 10 | 12*
A | W3 | 0 | 0
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 20 | 11
Transaction #3 Receipt of 10 items A in W3 at 14 euros each. No changes for MAUC by warehouse valuation group appear, because valuation in W3 is not By Warehouse Valuation Group. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 10 | 10*
A | W2 | 10 | 12*
A | W3 | 10 | 14
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 20 | 11
Transaction #4 Issue of five items A from W1. Issue is made at 11 euros each, which is the MAUC for the warehouse valuation group. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 5 | 10*
A | W2 | 10 | 12*
A | W3 | 10 | 14
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 15 | 11
Transaction #5 Receipt of 10 items A in W1 at 14 euros each. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 12.67*
A | W2 | 10 | 12*
A | W3 | 10 | 14
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 25 | 12.2
Transaction #6 Issue of five items A from W3. Issue is made at 14 euros each, which is the MAUC for the warehouse. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 12.67*
A | W2 | 10 | 12*
A | W3 | 5 | 14
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 25 | 12.2
Transaction #7 Change valuation method for W3 from MAUC to By Warehouse Valuation Group. The new inventory value is chosen to be equal to the current inventory value. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 12.67*
A | W2 | 10 | 12*
A | W3 | 5 | 14*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 30 | 12.5**
** | New MAUC is calculated as follows:
    (25 * 12.2 + 5 * 14) / 30 = 12.5
Transaction #8 Change valuation method for W2 from By Warehouse Valuation Group to MAUC. The new inventory value is chosen to be equal to the current inventory value. Therefore, MAUC in W2 becomes 12.5 as well. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 12.67*
A | W2 | 10 | 12.5
A | W3 | 5 | 14*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 20 | 12.5
Transaction #9 MAUC correction for all warehouses in warehouse valuation group G1. MAUC must be made equal to, for example, the current fixed transfer price, which is 13 in W1 (no receipt surcharges), 14 in W2 (warehouse receipt surcharge of 1), and 15 in W3 (warehouse receipt surcharge of 2). Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 13.17*
A | W2 | 10 | 14
A | W3 | 5 | 16.5*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 20 | 13.5
Transaction #10 Invoice of the receipt of 10 items A in W1 (transaction #5) states 15 euros each, rather than 14 euros each. The total variance of 10 euros is assigned to inventory. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 13.83*
A | W2 | 10 | 14
A | W3 | 5 | 16.5*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 20 | 14
Transaction #11 Transfer of two items A from W3 to W1. MAUC by warehouse valuation group remains unchanged. Results after issue:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 13.83*
A | W2 | 10 | 14
A | W3 | 3 | 16.5*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 18 | 14
Results after receipt:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 17 | 13.85*
A | W2 | 10 | 14
A | W3 | 3 | 16.5*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 20 | 14
Transaction #12 Transfer of two items A from W1 to W3. Upon receipt, MAUC by warehouse valuation group changes, because a receipt surcharge of 2 is defined in W3. Results after issue:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 13.85*
A | W2 | 10 | 14
A | W3 | 3 | 16.5*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 18 | 14
Results after receipt:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 13.85*
A | W2 | 10 | 14
A | W3 | 5 | 16.3*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 20 | 14.2**
** | New MAUC is calculated as follows:
    (18 * 14 + 2 * 16) / 20 = 14.2
Transaction #13 Transfer of two items A from W3 to W2. This transaction will not affect MAUC by warehouse valuation group, because valuation in W2 is not By Warehouse Valuation Group. Results after issue:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 13.85*
A | W2 | 10 | 14
A | W3 | 3 | 16.3*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 18 | 14.2
Results after receipt:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 13.85*
A | W2 | 12 | 14.02
A | W3 | 3 | 16.3*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 18 | 14.2**
Transaction #14 Issue of 10 items A from W3. Issue is made at 14.2 euros each, which is the MAUC for the warehouse valuation group, and because sufficient inventory is available in this warehouse valuation group, even though insufficient inventory exists in W3. For W3, a line for 7 items will be created in the Negative Inventory Consumptions (whina1520m000) session. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 15 | 13.85*
A | W2 | 12 | 14.02
A | W3 | -7 | 16.3*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 8 | 14.2
Transaction #15 Issue of 10 items A from W1. Issue is made at 14.2 euros (MAUC by warehouse valuation group) for eight items, and at 13 euros (FTP in W1) for two items, because the inventory in the warehouse valuation group is insufficient, even though sufficient inventory exists in W1. For W1, no line is created in the Negative Inventory Consumptions (whina1520m000) session. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 5 | 13.85*
A | W2 | 12 | 14.02
A | W3 | -7 | 16.3*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | -2 | 13
Transaction #16 Receipt of one item A in W1 for 15 euros each. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 6 | 14.04*
A | W2 | 12 | 14.02
A | W3 | -7 | 16.3*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | -1 | 13
Note A value correction of -2 is logged to correct the inventory value, because the received item of 15 euros was already issued for 13 euros. Transaction #17 Receipt of 10 items A in W3 at 16 euros each. Results:
Item | Warehouse | Quantity | MAUC (by Warehouse)
--- | --- | --- | ---
A | W1 | 6 | 14.04*
A | W2 | 12 | 14.02
A | W3 | 3 | 16*
Item | Warehouse Valuation Group | Quantity | MAUC
A | G1 | 9 | 16
Note A value correction of -3 is logged to correct the inventory value for the item that was left in negative inventory, because the item was already issued for 13 euros. Related topics Inventory valuation |