-
a GST Software that do not require you to have much GST Knowledge!
Support Center > Knowledge base> Article: Optimum-How to change system cut off date by execute SQL scripts

Optimum-How to change system cut off date by execute SQL scripts

Article ID: 73415 Email Print
Question
Optimum-How to change system cut off date by execute SQL scripts

Answer

Use the "Database Utility" from the QNE Optimum to execute script:

-For example the month you want to change to April, then execute below script, the number 4 is stand for the month and you can change it.

update systemData set systemdatavalue = 4 where systemdatacode = 'AccountStartMonth'

-For example the year you want to change to 2016, then execute below script, the number 2016 is stand for the year and you can change it.

update systemData set systemdatavalue = 2016 where systemdatacode = 'AccountStartYear'


related articles

Article Details
Views: 819 Created on: Feb 25, 2016
Date updated: Feb 25, 2016
Posted in: Optimum Misc

Poor Outstanding