Good morning community,
I have been asked on the Transactions for Period report to set up the parameter to be able to search by the last 6 numbers of the subaccount ID.
I have tried adding “Left” in the formula and 6 at the end and that is not working on the parameters or the formula field.
Any best practices to get this to work?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/acb97d50-8c49-4b9a-bc15-bdbdb4d1d930.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/9d31cca3-2b70-4e46-ac90-e007628c52bc.png)
Thank you in advance for any pointers!
Thank you,
Trisha