I have created a quick report that displays total order values for the Sales Group (CATALOG_GROUP)
i.e. MTD, YTD, O/S Value, Overdue, Month+1, Month+2, Month+3, Month+4, Month+5 and Month+6.
The report works fine, however, in there old system the report displays the Period Date From and Date To values instead of Month+1, Month+2…..etc
e.g. Select net_value AS Date_FRom‘27/04/20 - 26/05/20’
I know I can get this information from ACCOUNTING_PERIOD_API.Get_Date_From and Accounting_Period_Api.Get_Date_Until BUT I didn’t think I could set column heading using these values.
Could anyone please elaborate or confirm my suspicions.
