Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
weighted average costing
12-16-2015, 06:54 PM (This post was last modified: 12-16-2015 08:07 PM by kimoweberp.)
Post: #1
weighted average costing
when i create a vendor credit note the weighted average costing mis calculated
and give me a wired cost
i tried so many to know how he calculate it with no hope

plz help
Find all posts by this user
Quote this message in a reply
12-17-2015, 12:10 AM
Post: #2
RE: weighted average costing
This is a known behavior:
http://www.weberp.org/forum/showthread.php?tid=2384
Find all posts by this user
Quote this message in a reply
12-20-2015, 12:55 AM
Post: #3
RE: weighted average costing
Hi,
There is a bug in SupplierCredit.php which make the material cost wrong calculated. It's fixed in the trunk.
The file is attached for your reference.

Thanks and best regards!

Exson


Attached File(s)
.php  SupplierCredit.php (Size: 60.54 KB / Downloads: 1)
Find all posts by this user
Quote this message in a reply
12-20-2015, 03:18 AM
Post: #4
RE: weighted average costing
(12-20-2015 12:55 AM)Exsonqu_Qu Wrote:  Hi,
There is a bug in SupplierCredit.php which make the material cost wrong calculated. It's fixed in the trunk.
The file is attached for your reference.

Thanks and best regards!

Exson

thanks for the replay but still the average dos not have a meaning
buy 10 @ 510 average 510
buy 15 @ 515 average 513
Creadit 5 @ 515 average 511

while is suppose to give me 512.5

Plz Help
Find all posts by this user
Quote this message in a reply
12-20-2015, 06:13 PM
Post: #5
RE: weighted average costing
Hi,

If the average is 512.5, is your inventory vale equal to the GL inventory amount?

Thanks and best regards!

Exson
Find all posts by this user
Quote this message in a reply
12-24-2015, 03:18 AM
Post: #6
RE: weighted average costing
(12-20-2015 06:13 PM)Exsonqu_Qu Wrote:  Hi,

If the average is 512.5, is your inventory vale equal to the GL inventory amount?

Thanks and best regards!

Exson

now start with 0 stock average 500
buy 10 @ 510 average 510 ok
buy 15 @ 515 average 513 ok
credit 5 @ 510 average 511 Wrong
account balance now 10275 ok

Please help
Find all posts by this user
Quote this message in a reply
12-24-2015, 11:42 AM
Post: #7
RE: weighted average costing
Hi,
Why do you think the average is wrong?
Best regards!
Exson
Find all posts by this user
Quote this message in a reply
12-27-2015, 09:02 PM
Post: #8
RE: weighted average costing
(12-24-2015 11:42 AM)Exsonqu_Qu Wrote:  Hi,
Why do you think the average is wrong?
Best regards!
Exson

because the value of the stock is not equal to the value in the GL

and because when i try to calculate the value it dosn't seem right
Find all posts by this user
Quote this message in a reply
12-28-2015, 11:23 AM
Post: #9
RE: weighted average costing
Hi,

Could you post all of those gl amount and inventory value at each step?
Thanks and best regards!

Exson
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: