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!
NSC | Show the Vendor Purchase Price in a Dataset
Scenario
User is trying to add the Purchase Price field under the Vendor sublist of the Item record in a SuiteAnalytics Dataset.
However, when using the Purchase Price field, the results only show up to 2 decimal places.
Solution
If you want to show the Purchase Price under the Vendors sublist of the Item Record, then you need to use the Vendor Cost field under Vendors in the Dataset fields:
Another option is to use a formula field (String) with this formula: TO_CHAR({itemvendor.purchaseprice},'9,999.99999')
-----
If you find this information useful, let us know by reacting or commenting on this post!