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?"
Exporting Item Pricing (with Quantity Pricing) in a Format ready for Import
I am trying to build a saved search that will export Item Pricing in a format that can be re-imported with no changes required to the data.
Our Item Quantity pricing is typically set up like this:
Items without quantity pricing just have the Qty 0 price set:
We also use Quantity Pricing when Items are on special offer by setting a lower price for Qty 1:
In this example the offer price is cheaper than all our normal bands, but often this is not the case. If the special offer for this Item was for 6.49, then we would add Qty1 pricing of 6.49 for Base, Trade, Trade+, Silver, and then the others would have the same as their Qty 0 price (because they are entitled to it at a lower price anyway). We have to do this rather than use promotions as NetSuite doesn't seem to have an option for 'best pricing' (to take the lowest price for an item that the customer is entitled