OK, more experimenting, and I am stuck at the following issue:
I want to use the Current Period functionality of the formulas in my financial report.
The financial report file I use, brings in a sheet called settings, hidden
Within it, this sheet seems to specify the current period and company from sage.....and looks like this:
|LSSDAT||Little Short Stop Stores Ltd||2018||2||CAD|
|LSSDAT||Little Short Stop Stores Ltd||2018||5||CAD|
Weird thing....why does it bring in two rows?
Secondly, the period is actually period 5.
If I manually change these, nothing changes in the file, or the amounts reported in my income statement. My data seems to e using period 2, and if I manually change the formula in the file, I can get the data to change....but I really want to use the functionality I am seeing, either my changing the current period field, or specifying that in sage.
I dont believe in sage itself, I have anything that is specifying what the year and period is now, except the gl calendar....where am i going wrong?