We have an expression field called ‘Total Price’ on our Request screen that contains the formula below.
sum(part_need.extended_price). Also shown below.
This was created by a consultant some years ago. What has been reported by users is that is counts the part need lines twice. Example below where the Total Price calculates as double the expected value.
On investigating I noticed that the part need table does not have a field called extended price so I dont know how this works at all.
Further investigation reveals that when only the part need is present the Total Price calculates correctly. Only when the part need is shipped to create a part usage goes the value double. This would suggest that although the formula below seemingly sums only part needs. It is in fact summing part needs and part usages.
sum(part_need.extended_price)
Any advide would be appreciated.
Thanks,
Barry
