Invoice Purchase order(Packing slips)


static void invoicePurchaseOrder_Packingslip(Args _args) { Purchformletter_invoice Purchformletter; Purchtable purchtable; vendPackingSlipJour vendPackingSlipJour; vendPackingSlipTrans vendPackingSlipTrans; TmpFrmVirtual tmpFrmVirtual; List selectedList = new List(Types::Record); purchParmUpdate purchParmUpdate; purchParmtable purchParmtable; ParmId parmId; VendInvoiceInfoTable vendinvoiceinfoTable; ; try { ttsbegin; tmpFrmVirtual.setTmp(); // Add the packing slips into tmpFrmVirtual while select vendpackingslipjour where vendpackingslipjour.packingslipid == ‘Packingslip1’ { tmpFrmVirtual.clear(); tmpFrmVirtual.TableNum = vendpackingslipjour.TableId; tmpFrmVirtual.RecordNo = vendpackingslipjour.RecId;…

Multi-select on form datasource grid


First Method: callerForm = element.args().caller(); formDataSource = callerForm.dataSource(); ; for(projTable = formDataSource.getFirst(1); projTable; projTable = formDataSource.getNext()) { info(strFmt(“%1 – %2”,projTable.ProjId, projTable.Name)); } Second Method: Inventtable inavnettable; MultiSelectionHelper helper = MultiSelectionHelper::construct(); helper.parmDatasource(Inventtable_DS); itemid = helper.getFirst(); while (inavnettable.RecId != 0) { info(inavnettable.Itemid); itemid = helper.getNext(); } Third Method: multiSelectionContext = element.args().multiSelectionContext(); inventtable = multiSelectionContext.getFirst(); while (inventTable) {…

How to refresh caller datasource


One Way: #Task FormRun formRun; // Get an instance of the calling form. formRun = element.args().caller(); // If the caller is a form, refresh that form. if(formRun) { formRun.task(#taskF5); } Second Way: FormRun         callerForm; ;     // Get an instance of the calling form callerForm          =…

Installation the Data import/export framework(R3)


Hi All, DIXF Components must be installed as follows: The Data Import/Export Framework service must be installed on a computer that is running SQL Server Integration Services. The Data Import/Export Framework server must be installed on a computer that is running an instance of Microsoft Dynamics AX Application Object Server (AOS). The Data Import/Export Framework…

Maximum number of Tables in a join error


Hi All, You might encounter this error if you trying to make new relations with table that already have high number of relations defined on it Like “InventTable”. On showing the field to form you might see a warning message that “The table exceeds the max join limit…….” Solution: Maximum number of Tables in a…

Sequence of methods in form and table in AX


Form: Sequence of Methods calls while opening the Form Form — init () Form — Datasource — init () Form — run () Form — Datasource — execute Query () Form — Datasource — active () Sequence of Methods calls while closing the Form Form — canClose () Form — close () Sequence of Methods…

How to view document file(.pdf,.doc) in AX


HI Guys , Today I want to explain how to view a document file in ax. Go to the development workspace ,AOT>>Form and Right click and select New Form Change the Name Property as DocReader Go to the Design Node. Right click on Design and select ActiveX control shown in below. When  select ActiveX control,…

Play Audio and Video in Ax


HI Guys , Today I want to explain how to play video and audio file in ax. Go to the development workspace ,AOT>>Form and Right click and select New Form Change the Name Property as Video Go to the Design Node. Right click on Design and select ActiveX control shown in below. When we select…