• Login

DataSoft Corporation

Sage 50 Fiscal Periods Class

The Sage50FiscalPeriods_Class allows the following functions:

NumberofPeriods - returns the number of periods per accounting year.

GetPeriod(Date) - returns the period number for the supplied date.  Returns 0 (zero) if out of range.


GetPeriodStartDate(PeriodNumber) - returns the start date for the supplied PeriodNumber.  Returns Nothing if PeriodNumber is out of range.

GetPeriodEndDate(PeriodNumber) - returns the end date for the supplied PeriodNumber.  Return Nothing if PeriodNumber is out of range.

Examples inside report script:


Imports DSStudioSupport
Imports System.Data


Dim FP as Sage50FiscalPeriods_class

Private Sub label1_BeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs)
label1.Text = fp.GetPeriod(GetCurrentColumnValue("RowDate"))
End Sub

Private Sub DSReport_BeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs)
FP = new Sage50FiscalPeriods_class(FindSQLDataSourceByName(DSReport,"sqlDataSource1"))
End Sub

Related Links

Related Articles
Wednesday, 26 June 2019 Posted in Sage 50 Specific Features and Functions
 DataSoft Store  Knowledgebase  Contact Us
 Sitemap  Privacy Policy
    Customer Service


Copyright © 2019 DataSoft Corporation All rights reserved.