View Single Post
  #2  
Old 27th January 2017, 13:36
erplncons erplncons is offline
Member
 
Join Date: Oct 2008
Posts: 88
erplncons is on a distinguished road
Baan: All - DB: All - OS: All
Hi:
As per my knowledge, BaaN uses following formula to calculate the moving average purchase prices:
MAPP1 = (Quantity 1 x Purchase Price 1 + Quantity 2 x Purchase price 2) / (Quantity 1 + Quantity2 )
MAPP2 = (MAPP1 x (Quantity 1 + Quanitity 2) + (Purchase Price 3 x Quantity 3) / (Q1 + Q2 + Q3)
This goes on with subsequent purchase receipts and if you calculate using the above formula the MAPP at the end of Oct 15 is 2.4638 whereas the as per BaaN it is 2.45398. The difference could be due to rouding factors, which you may have to check.
Reply With Quote