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.