Skip to main content

Posts

Showing posts from March, 2016

Table Replication Error on Synchronization in Ax 2012

Getting this error on data dictionary synchronization.. Error Synchronise database Cannot execute a data definition language command on  (). The SQL database has issued an error. Info Synchronise database SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot alter column 'VOUCHER' because it is 'REPLICATED'. Info Synchronise database SQL statement: ALTER TABLE "DBO".BANKCHEQUETABLE ALTER COLUMN VOUCHER nvarchar(30) NOT NULL Error Synchronise database Cannot execute a data definition language command on  (). The SQL database has issued an error. Info Synchronise database SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot alter column 'VOUCHER' because it is 'REPLICATED'. Info Synchronise database SQL statement: ALTER TABLE "DBO".BANKDEPOSIT ALTER COLUMN VOUCHER nvarchar(30) NOT NULL Error Synchronise database Cannot execute a data definition languag...

Purchase order Budget validation Error in Ax 2012

Problem: Purchase order Budget validation Error in Ax 2012 coming during purchase invoice . This PO is previous year purchase order on which period is stopped/closed. "The accounting date for the invoice must be in the same fiscal year as the related purchased order. Run the purchase order year-end process or change the date to the current fiscal year" Solution: Check the option in below menu. Go to budgeting -Setup->Budget control->Budget control configuration and make changes in projectsourcedoucuemntlineitemHelper class of projTranstype method by comparing class at Hotfix Ax 2012 R2 KB2921204