Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How To Extract PO Line "UNIT PRICE (WITHOUT VAT)" - In NetSuite OneWorld?
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.
Jay Schwausch
P.R.I. - KACE Valves, NetSuite Administrator