Note - The qns below may not be in readable format. So I am attaching a text file.
I am creating a crystal report for finding the cost of production order.In this report,I have considered that the total sum of receipt from production gives the net cost of raw material of the production order.i.e.
strQuery = "SELECT SUM(LineTotal) As 'Actual_Cost' FROM IGN1 WHERE BaseType=202 AND BaseEntry=" &
objDTHeader.Rows(intI).Item("DocEntry") & " AND TranType ='C'"
dblActualRMCost = GetDataByScaler(strQuery)
Here DocEntry is the docentry of production order.
Then I have considered issue for production.I have created a query which gives the net cost of issued material i.e.
strQuery = "SELECT (SELECT SUM(LineTotal) As 'Issue' FROM IGE1 WHERE BaseType=202 AND BaseEntry=" &
objDTHeader.Rows(intI).Item("DocEntry") & ")" _
& "- (SELECT SUM(LineTotal) As 'Return' FROM IGN1 WHERE BaseType=202 AND BaseEntry=" &
objDTHeader.Rows(intI).Item("DocEntry") & " AND TranType IS NULL)"
dblComponentCost = GetDataByScaler(strQuery)
Then I have evaluated the variance as ,
dblVariance = dblActualRMCost - dblComponentCost
So the net cost of production order is as,
dblCost= dblActualRMCost - dblVariance
If the variance is positive then I deduct it else I add it.
The variable dblCost gives the net cost of production order.Is the correct formula for evaluating the cost of production
order.
I have created heirarchical structure of production orders as follows -
A
A->B
B->C
B->D
D->E
A is parent PO.B is included in A.B is having two children C and D.And D is having one child E.For evaluating the cost of PO,
I have used the formula as described at the begining. Now assume that the cost of all these PO's is as follws -
A = 1000
B=80
C=35
D=20
E=5
In the report I want to display the cost of all the PO's.I am displaying it as ,
E=5
D= 20-5=15
C=35
B = 80 - 35 -(20-5) -5 =15
A = 1000 - (80 - 35 -(20-5) -5) - 35 -(20-5) - 5 =930
This formula does not work for all the PO's. How do I evaluate the cost of PO.
I have created heirarchical structure of production orders as follows -
A
A->B
B->C
B->D
D->E
A is parent PO.B is included in A.B is having two children C and D.And D is having one child E.For evaluating the cost of PO, I have used the formula as described at the begining. Now assume that the cost of all these PO's is as follws -
A = 1000
B=80
C=35
D=20
E=5
In the report I want to display the cost of all the PO's.I am displaying it as ,
E=5
D= 20-5=15
C=35
B = 80 - 35 -(20-5) -5 =15
A = 1000 - (80 - 35 -(20-5) -5) - 35 -(20-5) - 5 =930
This formula does not work for all the PO's. How do I evaluate the cost of PO.
Hi,
I am afraid your formula has problem. If the cost of D is 20, you do not need to include E in calculating B.
To me, it should be:
D without E = 15
B Without C&D = 25
A without B = 920
It that the result you need? If not, please show you complete production order.
Thanks,
Gordon
Add a comment