Finance | Project Operations, Human Resources, ...

Price difference for moving average - Stock

(0) Share

Report

Posted on by NZNZ123

Hi team

Would greatly appreciate your help! Hopefully it makes sense :)

I would expect any postings to be small for this account, but every now and then this happens.

Vendor invoice $16,306.10 ex GST, $4,015.31 booked to stock, $516.60 booked to GRNI and $11,777.79 booked to price difference.

I assumed this was for price differences between the purchase order and the vendor invoice.

That being the case I would have expected the GRNI posting and a difference to price difference.

Would appear that 2 products below originally went thru GRNI

But all these are split between Trading stock and price difference

Thank you sooooo much!

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello NZNZ123,

Its a bit difficult identifying why there is such a large price difference posted because there is not much information available.

Have you checked the inventory transactions that have been posted for the item that caused the large difference?

There must be some larger fluctuations in the prices the item has been purchased.

Often, you see that typing errors (Ex: price units, missing 0, etc.) are responsible for those fluctuations.

I would thus recommend that you check the inventory transactions for this item first especially for the last couple of weeks before 25/02.

Maybe you can share some additional screen-prints for your item transactions.

Best regards,

Ludwig

Was this reply helpful? Yes No
NZNZ123 90 on at

Like (1)

Report
Copy link

Link copied!

Thank you - will have a look and see if I can spot anything further and let you know

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,045 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are selling your stock or reserving stock against sales before product receipt? That can also cause this difference. Also check you price unit for these products.

It will be good if you give one PO end to end example before creating PO and then complete cycle to understand the problem.

Was this reply helpful? Yes No
KevinHill 15 on at

Like (0)

Report
Copy link

Link copied!

As for the moving average - there is no ideal period for making money - you can only find the best one by experimenting. I can guess why you did it. Surely you did this because you did not follow the securities market well enough and were not interested in what investments could be made the most profitable, given the trends in the global market. I understand that this is not easy, but there are special services for this. This resource can help you search for the most profitable offers. Try to do this.this resource can help

Was this reply helpful? Yes No