Questions [Solved] Filtering by date inside a report

Acumatica Report Designer

Last Post by Gustavo Carrasquillo 6 years ago

3 Posts

2 Users

1 Reactions

2,479 Views

RSS

Posts: 37

Gustavo Carrasquillo

Topic starter

October 28, 2019 3:13 pm

(@gustavo-carrasquillo)

Trusted Member

Joined: 5 years ago

Greetings to all! I am trying to do something similar to this report in Report Designer:

However, I do not know the correct way to code the "Day" , "Month" and "Year" columns. I've tried several expressions returning an error, and being a newbie in Report Designer I'd appreciate some help. For example in the "Day" column I will need to display the sales completed today only. I used: "=FILTERIF((sum([ARTran.NetSalesAmount])-sum([ARInvoice.CuryDiscTot]))*0.835)<>[@Today]" , also tried using FILTER only instead of FILTERIF, and also tried multiplying the formula by [@Today], none of the options work. Please help!

2 Replies

Posts: 3193

Tim Rodman

Admin

December 5, 2019 9:58 pm

(@timrodman)

Famed Member

Joined: 10 years ago

I don't think you want to combine ARTran (the invoice line level) with ARInvoice (the invoice header level), but I'll use your fields to outline a technique that should work.

What about something like this?

=SUM(IIf([ARInvoice.DocDate]=@Today,[ARTran.NetSalesAmount]-[ARInvoice.CuryDiscTot],0))
=SUM(IIf([ARInvoice.DocDate]>=@MonthStart and [ARInvoice.DocDate]<=@MonthEnd,[ARTran.NetSalesAmount]-[ARInvoice.CuryDiscTot],0))