0

Macro to sum amount of Invoices for the year

Nahuel 2 years ago in Something Else 0

We're working on preparing a Macro to gather all invoices amounts for the month, we need help determining which variables and parameters we should be using to gather this.

Would something like "$Invoice.DueDate.year == 122" or "$Invoice.FinalDate.year == 122" work? 


Also, if we wanted to use the month parameter, how would that go instead? "$Invoice.DueDate.month == ??"


Lastly, what's the parameter for gathering the total amount for the invoices? Would "$invoice.TotalNetto" work?

Thank you in advance!