GI question - trying to pull both ytd and mtd sales from ARTran. I can filter ytd in GI conditions, can I then filter the MTD on the results grid? Do you have an example of the result grind filter somewhere for this ?
Solved
GI filter question
Best answer by lauraj46
Hi
You can use a formula in the results grid, like this:
=Iif(year([ARTran.TranDate])=year(Today()) and month([ARTran.TranDate])=month(Today()), [ARTran.CuryTranAmt], 0)
You can also use an aggregation to sum.
Hope this helps!
Laura
+9Hi
You can use a formula in the results grid, like this:
=Iif(year([ARTran.TranDate])=year(Today()) and month([ARTran.TranDate])=month(Today()), [ARTran.CuryTranAmt], 0)
You can also use an aggregation to sum.
Hope this helps!
Laura
Perfect - I love community --- I get faster answers here than from my company with a dozen consultants (or however many there are)
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.