Finance | Project Operations, Human Resources, ...

Inventory Weighted Average Calculation

(0) Share

Report

Posted on by Mustafa Quraitem

Hi,

We use Weighted Average Costing method ;

If We have a Stock of "10" Qty from Item "A" ,

3 Nos issued in Favor of Project (X) in Sep'21

& then we Closed The Period ,

In Oct'21 A new Purchases received from Item "A" with Higher Prices & No Issues happened within Oct'21

As per my Understanding ; Only The On-hand Inventory will be affected with the New Prices & Since there is No Issues within Oct21 So there shouldn't be Cost debited to Project "X"

Is this True, Or The Inventory Calculation will affect also On the Previous "Coles" Period Issues?

Rgds

Mustafa

I have the same question (0)

All responses (4)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mustafa,

Have you received an invoice updated the 10 pcs that you had in stock in September or did you receive the invoice just recently?

Also, what is the cost price that has been used when you took out the items from inventory and used them for your project?

Is this the price for which you purchase the items?

Best regards,

Ludwig

Was this reply helpful? Yes No
Mustafa Quraitem 63 on at

Like (0)

Report

Hi,

The 10 PCs is Old Stock,

The Cost Price for the Issued Items in Sept'21 was KWD 100/- for Each (Total=3*100=300)

The On-Hand Inventory after Sept. 21 Closing is 7 Qty (10-3)

The New Shipment (Oct'21) Qty is (15) & The Price is KWD 140/- for Each Total (15*140=2100)

I am asking if the new WA Calculation will affect On Sept'21 Project Cost & Posted in Oct'21 Or the Impact will be Only On the On-hand Stock?

Rgds

Mustafa

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mustafa,

If you use the weighted average date valuation method then there should not be an influence.

In case you use the 'simple' weighted average valuation method then there might be an influence.

Can you check what valuation method has been selected?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

If you have performed inventory closing process along with recalculation, it will impact only on hand else it will impact other issues as well.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Inventory Weighted Average Calculation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Inventory Weighted Average Calculation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates