Microsoft Dynamics AX

Forums

Home » Microsoft Dynamics AX » Microsoft Dynamics AX Forum
Related Search Results

Sort Sales Invoice in Axapta on Serial Number

by
on 29 Apr 2010
  • Not Answered

Create pdf of control documents in X++ ?

by
on 10 Feb 2010
  • Not Answered

Need Help in Binding ResultSet with Grid in Axapta

by
on 6 Feb 2010
  • Not Answered
Troubleshooting an Issue?

Our support engineers have assembled the top recommended solutions for you.

Microsoft Dynamics AX 2012

CRM Connector in Microsoft Dynamics AX 2012

Financials Management in Microsoft Dynamics AX 2012

Upgrading to Microsoft Dynamics AX 2012


Microsoft Dynamics AX 2009

Application Object Server (AOS)

Enterprise Portal and Role Centers

Inventory Costing in Microsoft Dynamics AX 2009 

 Invoice Settlements/Discounts/Reversals

 SSRS and SSAS Integration

 Workflow

Need Urgent Help in Salesline table Synchronization

This question is not answered
Azwar Alam
Posted by
on 26 May 2010 6:05 AM

Hello

I have added a field with the name Print in salesline table then i deleted it from AOT but when i m going to synchronize table it is giving me error "cannot execute a data definition language command on sql database has issue an error". Then i deleted this field from sql server in salesline table and after that when i am going to synchronize it again it gives me the same error then i goto Eventviewer and in EventViewer it is giving me the error "Incorrect syntax near the keyword Print.The statement was Alter Table salesline drop column print".

because there is no field with the name Print in salesline table in sql server and it seems that salesline table executing Alter statement somewhere from configuration and i dnt know how to modify configuration.

Anyone have any idea about this ?

AX Axapta Report Overlap Sections AX Active Directory AX 2009 AX 4.0 Product Builder Hierarchy axapta invalid cursor state nativeerror ax product builder hierarchy AX 2009 upgrade problem ax layers ax 2009 outside operations subcontracted manufacturing vendor AX 4.0 AX 2009 2009 Inventory close AX 2009 SP1 AX 2009 Company information AX 3.0 AX 2009 Citrix AX 2009 Project Invoicing AX2009 AX 2009 AOS clustering load balancing AX 2009 Payroll Ax 3.0 Client software AX 2009 EP Development Axapta email Axapta AX 2009 AOS ax database company merged AX 2009 CRM AX2009 Security AX2009 Service Subscription (To Date Field) AX 2009 EP Installation AX 2009 Reporting AX 2009 Project Module AX report axaptaobject AX 2009 templates AX 2009 Client AX 2009 Number of Sequence Reference AX 2009 Purchase Requisition AX Payroll demo license AX and Project Server integration with existing project plans ax 2009 create!form bottomline AX 2009 2009 AX 2009 Inventory Axapta fax integration AX 2009 archive AX2009 - Sales Tax Setup AX 2009 2009 VAT PO Invoice axapta reporting service AX 2009 import contacts AX 2009 alerts workflow email notification Axapta 3.0 AX filter comma AX 2009 slow ax 2009 2009 batch multiple jobs AX 2009TFS AX 2009 sql 2000 AX 2009 Enterprise Portal Sharepoint
All Replies
  • Yousef Shawareb
    Posted by
    on 27 May 2010 2:39 AM

    Hi,

    Please add that field again print to salesline and then try restarting the AOS see if this is gana work.

    Regards,

    Yousef Shawareb
  • abdul samad
    Posted by
    on 1 Mar 2011 6:57 PM

    This an issue with AX you can not use print named field in AX because this is a system field and it generates an issue in the select statement.

    -ABdul
  • RAK....
    Posted by
    on 2 Mar 2011 3:25 AM

    Hi,

    It seems that Ax meta data table has the reference of salesline 'print' field.

    AX metadata  is stored into the table called 'sqldictionary ' which you will get it into the system node i.e. \System Documentation\Tables\SqlDictionary. or from a SQL Server.

    You need to search it for table id '359'  (salesline) into the field of tabid from Sql dictionary table.

    If you find the record for a 'print' field then delete the record and synchronize the Data dictionary.

    Please keep in mind that when you delete delete the record from this table the values which was stored against this field will be vanish/purge.

    Hope this should resolve your issue.

    -- Rakesh Darge