Go Back > Forum > Baan Quick Support: Functional & Technical > Manufacturing & Supply Chain

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 39

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 19th January 2017, 07:05
ntkiet73 ntkiet73 is offline
Join Date: Jan 2017
Posts: 1
ntkiet73 is on a distinguished road
Baan: IV - DB: SQL - OS: Windows
Cost Price Calculation
Baan: Other/Unknown

Dear All:

We are using Baan IV. We set the Method of Calculating Average Purchase Price as Current Inventory.

We have data from the beginning of one purchased item as attached file.

The system computed the month-end average prices differ to the manual calculation.

Could you please help to take a look and advise the differences between them?

Thanks a lot!
Attached Files
File Type: xls Average Cost Calculation.xls (50.0 KB, 16 views)
Reply With Quote
Old 27th January 2017, 13:36
erplncons erplncons is offline
Join Date: Oct 2008
Posts: 88
erplncons is on a distinguished road
Baan: All - DB: All - OS: All
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
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
cost price to standard price updation Babuplus Blogs and Web links 0 12th July 2011 19:02
Calculate Cost Price jinseong Finance, Invoicing and Integration 4 13th March 2009 06:30
cost price calculation for purchased items j3ruk07 Finance, Invoicing and Integration 3 17th November 2007 03:59
Cost Price Question on Standard Items Eddie Monster Manufacturing & Supply Chain 3 8th February 2007 22:15
5.0c -> Cost price calculation for customized items in pcs-project Andreas Manufacturing & Supply Chain 1 21st September 2004 09:05

All times are GMT +2. The time now is 23:24.

©2001-2017 - -