remussmc
Member
Hi All,
Would like to know if anyone encoutner problem where related to Average Cost... we have two and consider quite serious one, but RL can't provide us any solution :
1. Weighted Average Cost shown strange figure.
When we issue item ABC, where it been configured using Cost Method Weighed Average Cost, it shown strange figure where no one know where this figure came from.
We check on P4105 (Item Cost Revision), item ABC shown $1.40 at Weighted Average Cost, but the issue trancation in F4111 shown $1.10.
This happen once in a full moon, and we can troubleshoot the problem, and just enter the database and patch it using SQL ISQL_W
2. Averaga Cost calculate incorrectly, after a revise an item received.
For example, we purchase item ABC in $1.00 for 10 unit, then later we purchase item ABC in $2.00 for 10 unit. The total 20 unit shown average cost of $1.50 per unit.
But then when we perform a revise on item received of 2nd batch (10 unit of $2.00), the system calculate the balance 10 with cost of $1.50, where it should be $1.00, right ?
Hope that you guys can help, as we really can't solve these issues.
Best Regards !!
Remus Shai
Yee Lee Corporation Bhd
OW B732.1, NT4.0, SQL 6.5,
Would like to know if anyone encoutner problem where related to Average Cost... we have two and consider quite serious one, but RL can't provide us any solution :
1. Weighted Average Cost shown strange figure.
When we issue item ABC, where it been configured using Cost Method Weighed Average Cost, it shown strange figure where no one know where this figure came from.
We check on P4105 (Item Cost Revision), item ABC shown $1.40 at Weighted Average Cost, but the issue trancation in F4111 shown $1.10.
This happen once in a full moon, and we can troubleshoot the problem, and just enter the database and patch it using SQL ISQL_W
2. Averaga Cost calculate incorrectly, after a revise an item received.
For example, we purchase item ABC in $1.00 for 10 unit, then later we purchase item ABC in $2.00 for 10 unit. The total 20 unit shown average cost of $1.50 per unit.
But then when we perform a revise on item received of 2nd batch (10 unit of $2.00), the system calculate the balance 10 with cost of $1.50, where it should be $1.00, right ?
Hope that you guys can help, as we really can't solve these issues.
Best Regards !!
Remus Shai
Yee Lee Corporation Bhd
OW B732.1, NT4.0, SQL 6.5,