Posts

Showing posts with the label AX

Modified Event Handler In D365 AX X++ Fianance & Operations

[DataEventHandler(tableStr(InventJournalTable), DataEventType::ModifiedField)] public static void InventJournalTable_onModifiedField(Common sender, DataEventArgs e)     {         InventJournalTable                  inventJournalTable = sender;         ModifyFieldEventArgs           args = e as ModifyFieldEventArgs;         FieldId                                     fieldId = args.parmFieldId();                   switch(fieldId)             {                 case fieldNum(InventJournalTable, InventSiteId) :                     //Logic         ...
Post a Comment
Read more

Create Transfer Order Line Through Code AX X++ D365 Finance & Operations

    public void createPurchLine(ItemId _ItemId, InventDimId _InventDimId, Qty _qty SalesId _salesId)     {         InventTransferLine                      inventTransferLineNew;         InventDim                                    inventDimLocal;         InventTransferTable                     inventTransferTable = InventTransferTable::find(_inventTransferId);         inventDimLocal                          = InventDim::find(_InventDimId, );         inventDimLocal.InventSiteId     = InventLocation::find(inventTransferTable.InventLocationIdFrom).InventSiteId;        ...
Post a Comment
Read more

Create Purchase Order Line Through Code AX X++ D365 Finance & Operations

    public void createPurchLine(ItemId _ItemId, InventDimId _InventDimId, Qty _qty SalesId _salesId)     {         PurchLine                               purchLine;         InventTable                             inventTable;         InventDim                               inventDim;         InventLocation                          inventLocation;              InventItemBarcode                       inventBarCode;         PurchTable            ...
Post a Comment
Read more

Create Sales Line Through Code AX X++ D365 Finance & Operations

public void createSalesLine(ItemId _ItemId, InventDimId _InventDimId, Qty _qty SalesId _salesId)     {         SalesLine                               salesLine;         InventTable                            inventTable;         InventDim                              inventDim;         InventLocation                       inventLocation;         InventItemBarcode                 inventBarCode;         SalesTable                               salesT...
Post a Comment
Read more

Counting Journal Line Creation Through Code AX X++ D365

 public boolean createCountJourLines(ItemId _itemId, InventDimId _inventDimId, Real _qty, InventJournalId _inventJournalId)     {           InventTable                                   inventTable;         InventJournalTable                      inventJournalTable = InventJournalTable::find(_inventJournalId);         InventItemBarcode                       inventBarCode;         InventDim                                    inventDim;         InventLocation                             inventLocat...
Post a Comment
Read more

Database restoration in finance & operations D365 AX

******************************************************************************* 1.Run command prompt as an administrator. 2.Run the below command to Import the database. cd C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin SqlPackage.exe /a:import /sf:J:\BackupFile.bacpac /tsn:localhost /tdn:AxDB_New /p:CommandTimeout=1200 where, •tsn (target server name) – The name of the SQL Server to import into. •tdn (target database name) – The name of the database to import into. The database should not already exist. •sf (source file) – The path and name of the file to import from. ********************************************************** Go to > windows > Microsoft SQL server Tools  > Microsoft SQL server Management > run as Administrator use > sql server Authentication > user "axdbadmin" and respective password (from LCS) Execute below queries one by one :- USE [AxDB_New] GO CREATE USER axdeployuser FROM LOGIN axdeployuser EXEC sp_addrole...
Post a Comment
Read more

Sales order creation from sales quotation through code AX 2012/D365 x++

public void createSalesOrder(FormDataSource _SalesOrderDS) { int recordsCount; SalesQuotationLine salesQuotationLine; SalesQuotationTable salesQuotationTable; SalesTable salesTable; SalesLine salesLine; NumberSeq numberSeq; boolean headerCreated = false; recordsCount = _SalesOrderDS.recordsMarked().lastIndex(); salesQuotationLine = _SalesOrderDS.getFirst(1); ttsbegin; while (salesQuotationLine) { try { if (!headerCreated) { salesQuotationTable = salesQuotationLine.salesQuotationTable(); salesTable.clear(); numberSeq = NumberSeq::newGetNumFromCode(SalesParameters::numRefSalesId().numberSequenceTable().NumberSequence); salesTable.SalesId = numberSeq.num(); salesTable.initValue(); salesTable.initFromSalesQuotationTable(salesQuotationTable); salesTable.S...
Post a Comment
Read more

Form data source activation code D365 AX X++

  [FormDataSourceEventHandler(formDataSourceStr(BOMConsistOf, BOMVersion), FormDataSourceEventType::Activated)]     public static void BOMVersion_OnActivated(FormDataSource sender, FormDataSourceEventArgs e)     {         BOMVersion                      bOMVersion;         FormDataSource                  fds;         FormRun                         formRun;         bOMVersion                      = se...
Post a Comment
Read more

Create route through code AX2012/D365 X++

 Public RouteVersion createRoute()     {         RouteVersion                    routeVersion;         NumberSeq                       numberSeqRoute;         InventDim                       inventDim;         RouteTable                      routeTable;         ItemId                   ...
Post a Comment
Read more

Cretae BOM through code AX2012/D365 x++

Public BOMVersion createBOM()     {         BOMVersion                      bomVersion;         ItemId                                 _itemId = "ItemId";         InventTable                         inventTable = InventTable::find(_itemId);         BOMTable                          bomTable;       ...
Post a Comment
Read more