Flag or record when period rollover done

Discussions relating to plugin development, and the Jiwa API.

Flag or record when period rollover done

Postby DannyC » Wed May 08, 2024 3:19 pm

I've been hunting through the database and documentation to find out if there is something that indicates when a period rollover is completed.
I can't find anything.

Is there something? A boolean somewhere? A record written to some table?

If not, I could probably knock up a plugin that checks if the process button has been clicked and write a record to a custom table.
User avatar
DannyC
Senpai
Senpai
 
Posts: 638
Joined: Fri Mar 22, 2013 12:23 pm
Topics Solved: 30

Re: Flag or record when period rollover done

Postby Scott.Pearce » Wed May 08, 2024 5:51 pm

If you want a database-level indicator you could look at the system settings "CreditorLastWeeklyRolled", "CreditorLastFortnightlyRolled", "CreditorLastMonthlyRolled", "DebtorLastWeeklyRolled", "DebtorLastFortnightlyRolled", "DebtorLastMonthlyRolled", "DebtorLastCustomRolled". The date of the selected roll type(s) gets recorded.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 743
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: Flag or record when period rollover done

Postby DannyC » Wed May 08, 2024 5:58 pm

That'll do Scott. Should be sufficient for what I need.

Thanks
User avatar
DannyC
Senpai
Senpai
 
Posts: 638
Joined: Fri Mar 22, 2013 12:23 pm
Topics Solved: 30

Re: Flag or record when period rollover done

Postby SBarnes » Wed May 08, 2024 7:05 pm

Sometimes having the full story helps, Danny is looking to fire something else off when Month end is run/finshed by the user i.e a real month end, unfortunately there is a slight problem with looking at the fields Scott mentioned if you run a Recalculation of Balances Only the fields get updated, I just tried it to be sure.

To do it and be sure you would need to attach to PeriodRollover object's RollDebtorsEnd event in the form and then look at the OnlyRecalculateBalances property on the object and write some other flag to look for in the database, you could still do this to SY_SysValues you would just have to set up your own unique row.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1621
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 176


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 1 guest