I have tried to find the correct way (either by field name or by formula) to extract the "UNIT PRICE (WITHOUT VAT)" on purchase order lines.
I thought I had it figured out by using:
However, I am having the following issue.
In some cases I get the correct value. In other cases it is slightly higher.
Example: Actual PO Price = 6188.50 RMB. BUT, Saved Search shows 6600.00 RMB.
NOTES:
I did try removing the "/{exchangerate" portion of the formula but that did not solve the issue.
I tried pulling in the price by using various versions of the RATE value, but none resolved the issue.
Is there a way to retrieve the value under the column of UNIT PRICE (WITHOUT VAT) that will not vary?