When call the reports endpoints we can sometimes encounter the error: AsOfDate is before the conversion period. This error is indicating that the AsOfDate is before the creation of the company file.
Example:
Endpoint: Report/BalanceSheetSummary?AsOfDate=2012-07-31&YearEndAdjust=true
{
"Errors": [
{
"Name": "DateBeforeConversion",
"Message": "AsOfDate is before the conversion period",
"AdditionalDetails": "",
"ErrorCode": 60012,
"Severity": "Error",
"LearnMore": null
}
],
"Information": "Warning, error messages have not been finalised in this release and may change"
}
To confirm the details of the company file we can use the endpoint /GeneralLedger/AccountingProperties which will return the following details
{
"ConversionDate": "2015-07-01T00:00:00",
"CurrentFinancialYear": 2021,
"LastMonthFinancialYear": 6,
"RowVersion": "-3362769452134301696"
}
Once you have confirmed the conversion date and the Last Month in the financial year you will need to edit your dates to be after these dates.
If you have any questions, feel free to log a ticket with the Customisation & Integration Team.
Comments
0 comments
Article is closed for comments.