Overview
It is occasionally reported that users are unable to route Orders for approval. In such an instance, the error message "Conversion failed when converting the varchar value" may appear - see Fig.1.
The error message appears when the delivery date of the user’s Order surpasses that of the latest Fiscal Period. To resolve this issue, the user will need to create a new Fiscal Calendar year.
Solving the Problem
Creating a New Fiscal Calendar

Fig.2 - Creating a New Fiscal Calendar
Please note: If using a Fiscal Calendar (13 periods), ensure that the dates are entered for all 13 periods, as opposed to 12 periods of a physical calendar.
If using a 12 period calendar, the start and ending dates do not need to correspond to the regular calendar dates if the property so chooses.
If the property uses a single cycle, then there is only one to choose.
Some properties use multiple cycles throughout the year (i.e. Quarterly and Monthly). These cycles can be modified throughout the year in advance of Starting Inventory of the particular period(s).
The Period Closed check box is filled in automatically by the system when the period is closed, it is not selected manually by any user.
It is occasionally reported that users are unable to route Orders for approval. In such an instance, the error message "Conversion failed when converting the varchar value" may appear - see Fig.1.

Fig.1 – Error message
The error message appears when the delivery date of the user’s Order surpasses that of the latest Fiscal Period. To resolve this issue, the user will need to create a new Fiscal Calendar year.
Solving the Problem
Creating a New Fiscal Calendar
- Go to Property > Setup > Accounting > Fiscal Calendar
- Select New, as per Fig.2

Fig.2 - Creating a New Fiscal Calendar
- In the Fiscal Year box, type the year as a numerical value
- In the Starting Date list, choose the Starting Date of Fiscal Period 1
- In the Ending Date list, choose the Ending Date of Fiscal Period 1
- Continue to enter the Starting Date and Ending Date for each Fiscal Period until fully completed
Please note: If using a Fiscal Calendar (13 periods), ensure that the dates are entered for all 13 periods, as opposed to 12 periods of a physical calendar.
If using a 12 period calendar, the start and ending dates do not need to correspond to the regular calendar dates if the property so chooses.
- In the Inventory Cycle list, choose an Inventory Cycle for each period

Fig.3 – New Fiscal Year
If the property uses a single cycle, then there is only one to choose.
Some properties use multiple cycles throughout the year (i.e. Quarterly and Monthly). These cycles can be modified throughout the year in advance of Starting Inventory of the particular period(s).
The Period Closed check box is filled in automatically by the system when the period is closed, it is not selected manually by any user.
- Once all needed information is correct, select Save
Comments
0 comments
Please sign in to leave a comment.