Skip to main content

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

​@MWAMAITTEAM 

Hi Barry,

The expression for total price is more than just part need it is ‘sum(part_usage.extended_price) + sum(non_part_usage.extended_price) + sum(part_need.extended_price)’ and this is a baseline expression for total price.

Part_need.extended_price is a non-database field. it is not saved within the database. 

If the field in question only has the part_need sum, you may want to update it to baseline. You can see the baseline expression by looking at the baseline request screen and clicking on total price.

Cheers,

Morris 

 

Hi ​@Morris,

Thanks for coming back to me. I can now see that the expression in the baseline screen is as you describe,

sum(part_usage.extended_price) + sum(non_part_usage.extended_price) + sum(part_need.extended_price)

On our custom REQUEST screen, Total Price had been added a second time in the header. The original in the Details tab was still present. I found that the expression needed to be amended in the original field in the Details tab. I had only amended the expression in the header field.

Now resolved.

Thanks,

Barry

Reply


Terms & ConditionsCookie settings