BIPeriods - Sage 50 Accounts Periods Definitions

by Hugh Johnson, Posted on 4/17/2018 9:34:06 PM

 OData, Sage 50 Accounts

BIPeriods - Sage 50 Accounts Periods Definitions

Sage 50 Accounts OData feed for Power BI

The BIPeriods table is part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  It contains definitions of the accounting periods 1 through 12 for the currently open accounting year in Sage 50 Accounts.

This table is essential if you want automatically to detect the start and end of the financial year for a Sage 50 Accounts company.  It would be very useful for anyone such as an accountant in practice who is using Power BI to deliver reporting solutions to multiple clients.  

BIPeriods table

PeriodTextPeriod # 1 through to 12 - this is the accounting period (month) e.g. "1" for April if the accounting year starts on 1st April
DescriptionTextE.g. "Month 1, April 2017"
PeriodIDTextInternal record ID for the OData feed.  Links to the BIDates table.
StartOfPeriodDate/TimeFirst day of the period e.g. 01/02/2018
DaysInPeriodWhole Number# of days in the period - e.g. 28
EndOfPeriodDate/TimeLast day of the period e.g. 28/02/2018
LastSageYearOpenTrue/FalseTrue if the previous year is still open in Sage
MonthText3-alpha text description of the month of the date - e.g. "Jan", "Feb", "Mar" etc. 
MonthNumWhole NumberMonth # - e.g. "2" for February
YearWhole NumberCalendar year that the period is in - e.g. "2018"

BIPeriods relationships

The BIPeriods table in the OData feed has no direct relationships with other tables in the data feed, but it is there to enable the definition of analysis periods in the Dates table such as "Last Year", "This Year", and "Next Year".

To try our this OData feed for your Sage 50 Accounts data, why not create your own Suntico BI trial account?



Copyright © 2019,
Accounting Insights Ltd.
All Rights Reserved.

Our Office :
Unit 4, Roof Garden Offices,
Clarehall Shopping Centre,

+353 1 567 4069

[email protected]