Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Invoice paid partial or full report
We need the following reported daily if any amount was paid against an invoice. This payment could be partial or full.
We also need to filter the report based on the department that the sales rep belongs to.
Payment made date, Invoice#, Sales Order#, Customer Name, Sales Rep, Amount Paid
Assuming that this is going to be based off a saved search.
Quesitons:
1) How do extract amount that was paid against an invoice (this could be a full payment or partial)
2) What date field do we use
3) Narrow down sales rep to those belonging to Sales department
Any pointers would be greatly appreciated.
0