Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Have questions or experiences to share? Post your Release 2026.1 questions and join discussions in the Release 2026.1 category.
Intelligent Payment Automation, powered by BILL (formerly Bill.com), lets you automate payments, manage vendor details, and bank account information within NetSuite.
The SuiteApp is available to organizations based in the U.S. with a valid U.S. address, or to global customers (except Canada, China, and Japan) with U.S. business subsidiaries. It only supports payments to vendors operating in the United States.
For more information, visit this thread.
Accessing "purchase price" and "sale price"
We use NSSB, so we have limited (aka none) access to scripting and ODBC, but here goes.
We need to access the "purchase price" value of an item, and the "sale price" in order to determine our current margins based on the cost price of an item and the current price list sale price. The majority of our items are drop ship, are usually purchased in USD and are sold in either USD OR AUD.
When we attempt to include "purchase price" in a report or search, it provides the value of the purchase price as at the last time the item record was updated, in AUD. This figure is one that I would normally have related to the last purchase price. This makes it useless to perform any margin analysis because the values are all costed at different times.