Hi All,
Is it possible to display the Last Invoic...
# suiteanalyticsr
Rachael
10/12/2018, 10:36 AMHi All,
Is it possible to display the Last Invoice Date per line item of a sales order?
We are trying to clean up Sales Order backlog and there was a request to show last invoice date per unique line of the sales order
g
Gregory Jones
10/12/2018, 2:02 PMDo you usually bill line items multiple times?
Gregory Jones
10/12/2018, 2:12 PMyou could summarize Applying Transaction : Date using Maximum on a sales order saved search. You'd also have to control for other types of Applying Transactions in your criteria, if you are just looking for invoices.
r
Rachael
10/12/2018, 7:45 PMHey, I got it.
I used the applying transaction : date and the document number. I also used type so I could the different between the last interaction being a fulfilment or invoice.
👍 1
g
Gregory Jones
10/12/2018, 7:49 PMGlad to hear you got to where you needed to be!
2 Views