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.