Accounting 2.0 - Prompted Message: Error during upgrade to 2.0-The object ‘DF TMCS IPho Recei XXXXXXXX’ is dependent on column ‘ReceiptHeader’

From AutoCount Resource Center

Question: When upgrade AutoCount Version 1.9 to Version 2.0 for user who use iAutoCount, error prompted “Invalid Data Defination Language Statement… The object ‘DF_TMCS_IPho_Recei_XXXXXXXX’ is dependent on column ‘ReceiptHeader’. Why?


IPho Recei1.png


Possible Reason:

The column ReceiptHeader & ReceiptFooter will affect the process when upgrade AutoCount Version 1.9 to AutoCount Version 2.0.


Solution:

1) Go to SQL Management Studio and choose the selected database that need to upgrade from Version 1.9 to Version 2.0. Then expand the Database and expand the Tables.

IPho Recei2.png


2) Expand the table name ‘dbo.TMCS_iPhoneSetting’, then expand the Constraints. There were 2 constraints for DF_TCMS_IPhon_Recei_XXXXXXXX.

IPho Recei3.png


3) Select the first constraints name ‘DF_TCMS_IPhon_Recei_XXXXXXXX’, right click and select Script Constraint as > CREATE To > New Query Editor Window.

Continue to do the same step for the second constraints ‘DF_TMCS_Iphone_Receip_XXXXXXXX’.
Do not close that two new query editor windows for now, you will need to use it.

IPho Recei4.png


IPho Recei5.png


IPho Recei6.png


IPho Recei7.png


4) Right click on first the constraint and select Delete and repeat the same step for the second constraint.

IPho Recei8.png


IPho Recei9.png


IPho Recei10.png


IPho Recei11.png


5) Then, upgrade AutoCount version 1.9 to version 2.0.


6) After successfully upgraded, click on Execute for the two new query editor windows.

IPho Recei12.png


IPho Recei13.png


7) You may request from your software dealer (if needed) the version 2 iAutoCount plug in.


By: Cit Ta 220621, Lay Swan 220722, P220725


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations