topic Re: Count Moving Average Unit Cost (MAUC) in script on the certain date in App Development

Count Moving Average Unit Cost (MAUC) in script on the certain date

jozisvk11 — Sat, 16 Nov 2024 02:08:17 GMT

Hello,

I have a table:

DATE	ITEM	MOVE	AMOUNT	ACTUAL STOCK (quantity)	PRICE	ACTUAL STOCK (money)	MAUC
1.3.2020	M01	Income	5	5	1	5 €	1 €
7.3.2020	M01	Income	5	10	2	15 €	1,5 €
9.3.2020	M01	Expenditure	2	8	1,5	12 €	1,5 €
17.4.2020	M02	Income	3	3	5	15 €	3 €
19.4.2020	M02	Income	6	9	4	33 €	3,6667 €
7.5.2020	M01	Expenditure	3	5	1,5	7,5 €	1,5 €
7.5.2020	M02	Income	1	10	5	38 €	3,8 €

INCOME - is calculated in MAUC

Expenditure - is always in actual value of MAUC

How can I calculate value of MAUC in different time period ?

For example MAUC for M02 in 17.4.2020 is 3 € and in 7.5.2020 is 3,8 €.

Thank you

Re: Count Moving Average Unit Cost (MAUC) in script on the certain date

Taoufiq_Zarra — Tue, 16 Jun 2020 13:22:44 GMT

@jozisvk11

what is the formula you use for MAUC calculating ?

Re: Count Moving Average Unit Cost (MAUC) in script on the certain date

sunny_talwar — Tue, 16 Jun 2020 13:59:02 GMT

MUAC is based off of PRICE column? If it is, then on 17.4.2020, are you doing 1 (1.3.2020) + 2 (7.3.2020) + 5 (17.4.2020) divided by 3? If that is true, then 8/3 should be 2.66667? If that is not what you are doing, then what is the calculation which gives you 2 here?

Re: Count Moving Average Unit Cost (MAUC) in script on the certain date

jozisvk11 — Wed, 17 Jun 2020 08:45:46 GMT

Hello Sunny,

here is link with explanation - https://docs.infor.com/ln/10.3/en-us/lnolh/help/wh/onlinemanual/000347.html

Re: Count Moving Average Unit Cost (MAUC) in script on the certain date

jozisvk11 — Wed, 17 Jun 2020 08:46:28 GMT

Hello,

here is a link, how is MAUC calculated - https://docs.infor.com/ln/10.3/en-us/lnolh/help/wh/onlinemanual/000347.html

Re: Count Moving Average Unit Cost (MAUC) in script on the certain date

jozisvk11 — Wed, 17 Jun 2020 09:06:07 GMT

17.4.2020 is another item M02.

Re: Count Moving Average Unit Cost (MAUC) in script on the certain date

jozisvk11 — Wed, 24 Jun 2020 05:29:34 GMT

Sunny, could you give me some solution ?

Thank you