Forum Stats

  • 3,686,738 Users
  • 61,106 Discussions


Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out:
Virtual Event: Getting the Most Out of NetSuite Standard Costing Capabilities

You asked for it, you got it! Join the webinar Getting the Most out of NetSuite Standard Costing Capabilities on June 28, 2022 at 11AM PT. Register here!

AE:Payment amount of the invoice

edited Nov 21, 2021 10:52AM in Ask A Guru 14 comments

I am trying to add to the Invoice Advanced PDF the payment amount of the invoice.

I created a custom Transaction Body Field that extracts the value with the following Transaction Saved search :

Criteria :

  • Type = Is Invoice 
  • Applying Transaction : Type = Deposit, Deposit Application, Payment 

Results :

  • Applying Transaction : Amount 
  • SUMMARY TYPE  Maximum

Available Filters 

  • Reference Number

There is a payment PYM_1 of the total of $1000 for 2 invoices :

INV_1 $700

INV_2 $300

The value of the Transaction Saved search for INV_1 is $1000 and not $700.

Any idea what I'm doing wrong ?

Thanks !

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!


This Week's Leaders

This Month's Leaders

All Time Leaders