Discussions
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
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!
Learn how to Refer A Member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!