How to add disc. amount in Saved Search to calculate
Hi teams!
I am trying to build a Saved Search where I can see the vendor bill and bill payment amounts including the discounted amounts.
I know that NetSuite has an Enhancement to display/expose disc. amount but here is my request and need some guidance:
A bill is of 1000 SUD, has a 200 USD discount and total Bill Payment is 800 USD
I would like the Saved Search to show in 3 columns the following:
Column 1: Vendor Bill 1000 USD
Column 2: Disc. Amount 200 USD
Column 3: Bill Payment Amount 800 USD (or at least Column 1 – Column 2)
I managed to make the above work however when there are 2 bills for the same vendor and 1 bill payment for both vendor bill the Saved Search and formula don’t like it
Any help will be highly appreciated
Best,
Jalabert