This content has been marked as final. Show 6 replies
How was the price at the line level changed? Was it done via an API or was it done by direct update to po_lines_all table?
it was updated directly
And therein lies your problem.
You should avoid updating Oracle tables directly unless you are 100% sure that no relationships are getting violated.
Updating po line price should be done via interface. I would suggest that you use the po documents interface to change the po line prices. Then you will see the header totals get updated automatically.
Hope this answers your question
Will it work for Closed POs?
Don't know of API will work for closed PO's or not. But the price you are looking for which is being displayed on Header level is being calculated from po_distributions_all.
Suggest you to download the fmb file of PO form & Check the formula for it's calculation. We did the same few years back & it was helpfull.
First thanks for the replies.
I have found a different solution for this problem. There is an override price stored in po_line_locations_all, which is used to calculate the header total.