Forum Stats

  • 3,686,738 Users
  • 61,106 Discussions
  • 206,428 Comments

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: https://lnkd.in/gGRN78A3
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.

Register

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

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders