Hello everyone, I am creating a saved search on In...
# general
u
Hello everyone, I am creating a saved search on Invoice Record to get the amount after discount. There is an Invoice with following information. Amount: 30 Discount: 3% So according to this information the Amount after Discount should be 29.1. However, in results it is showing 700+. What could be the factors for this kind of behavior. Thanks.
c
If you are using a formula to get the amount after discount, that would be an issue with the formula. If you are trying to source the Amount that's directly spelled out on the document, then it's possible you are referencing the wrong field. Do you have screenshots of an example invoice and the saved search itself?
u
Found the problem, there is a NetSuite bundle for tax and discount calculation. This bundle adds a field on sales order which contains the amount after discount. However, when user updated the price to 0 it didn't update the amount after discount field. And when invoice is created, it showed the 700 even though invoice was for only 30. Thanks for the suggestion😊