I want to find the total value of PR(Purchase requisition) by plant wise.
The PRs created will have single line item or multiple line items.There is no specific field for net value of PR.
Though it is known that quantity should be multiplied with price by line item and the total must be summed up to get the total PR value,but how to figure out the total number of line items in PR ?
Is there any programmatic logic that can be made or any other means to find the the total value of PR?
Please suggest me for further proceedings for which I will be grateful.
Thanks and regards,