Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th January 2017, 06:05
ntkiet73 ntkiet73 is offline
Newbie
 
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, 14 views)
Reply With Quote
Sponsored Links
  #2  
Old 27th January 2017, 12:36
erplncons erplncons is offline
Member
 
Join Date: Oct 2008
Posts: 86
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
Reply


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 18:02
Calculate Cost Price jinseong Finance, Invoicing and Integration 4 13th March 2009 05:30
cost price calculation for purchased items j3ruk07 Finance, Invoicing and Integration 3 17th November 2007 02:59
Cost Price Question on Standard Items Eddie Monster Manufacturing & Supply Chain 3 8th February 2007 21:15
5.0c -> Cost price calculation for customized items in pcs-project Andreas Manufacturing & Supply Chain 1 21st September 2004 08:05


All times are GMT +2. The time now is 17:29.


©2001-2017 - Baanboard.com - Baanforums.com