![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3f565f0d-38db-4db0-a7a0-35b6009b4e12.png)
Currently the date that I’m using is the sales order date(according to the calendar date). However, I want it to display according to our Financial Year (1apr-31mar), whereby it shows the total of each Financial Year.
I’m thinking of adding a column for financial year in the Sales Order generic inquiry, but would require a formula to calculate the financial year from the sales order date. Any idea how to do it?
Best answer by lauraj46
View original