Skip to main content

Posts

Showing posts from February, 2014

Show Random number in MSD axapta

To Show Random number in axapta you can try below code through job. Random is class name which has nextInt method to get next random number. Random Random = new Random(); int RandomNo,RandomwithMod; ; RandomNo=Random.nextInt(); RandomwithMod=Random.nextInt() MOD 1000; info(Strfmt('%1%2',RandomNo,RandomwithMod));

display current system time in MSD axapta

To display time in axapta,timenow,display current system time in axapta you can try below code in job. Only timenow() will not display in time in time format it will display like number but to show time in time format you can try below code. time2str(timenow(),1,1) To show in message box info(time2str(timenow(),1,1));

How to get purchase invoice amount total at the time of invoicing in MSD axapta PO

To  get purchase invoice amount total at the time of invoicing in axapta Purchase order you can try below  code in a method and just need to call that method on any event to get show total amount which will be invoice amount. vendPackingSlipJour _vendPackingSlipJour_1; real TotalInvoiceAmt; purchParmTable parmtable; purchParmUpdate parmupdate; PurchId _PurchId; PurchTotals purchtotal; ; While Select parmtable where parmtable.ParmId == PurchParmTable.ParmId && parmtable.Ordering == DocumentStatus::Invoice { Select parmupdate where parmupdate.ParmId == parmtable.ParmId; _PurchId = parmtable.PurchId; if(parmupdate) { purchtotal = PurchTotals::newPurchParmTable(parmtable, PurchUpdate::All, AccountOrder::Auto, parmtable.ParmId, _PurchId, PurchParmTable.Ordering); purchtotal.calc(); TotalInvoiceAmt+= purchtotal.purchTotalAmount(); } } You can get total after select single packing slip or multiple packing slip.

Start Ax client in Single user mode MSDAX

To run Ax in single user mode you need to reject new user from online user form as following steps 1. Click Area Page node: Administration -> Online users. Form name: Online users Fig 1 2. Switch to the Server Instances tab on the Online users form. Fig 2 3. Click the Reject new clients button. Form name: Dialog Fig 3 4. Click the OK button. 5. Close the Online users form. Same as Fig 2 Accept New Client To Accept new user you can follow step 6 to 9 6. Click Area Page node: Administration -> Online users. Form name: Online users Same as Fig 2 7. Switch to the Server Instances tab on the Online users form. 8. Click the Accept new clients button. 9. Close the Online users form.

Create Duplicate company account in MSD axapta

To Create Duplicate company account in axapta you can follow below steps. 1. Click Area Page node: Administration -> Company accounts. Form name: Company: , Fig 1 2. Click the Duplicate button. Form name: Duplicate company accounts 3. Change Duplicate to company accounts from '' to ' tst'. 4. Change Company accounts from '' to ' tst'. 5. Click the OK button. Fig 3 7. Make sure the selection is changed in table Company data to: Company accounts Name of company accounts tst tst

Set Employee User Relation for user in MSD axapta

 To Set Employee  for Relating to user in axapta you can follow below steps. 1. Click Area Page node: Administration -> Users. Form name: User Fig 1 2. Make sure the selection is changed in table User Information to: Alias Network domain User ID User name Company Enabled External test A bc.com test sk Singh test true false 3. Click the User relations button then go to general tab Form name: User relations Fig 2. 4. Switch to the General tab on the User relations form. Fig 3 5.  Change Employee from '' to ' 1005'. 6. Save the record in the User relations form. 7. Close the User relations form. 8. Close the User form.

Clear Usage data to improve performance in MSD axapta

Sometimes Ax forms and module becomes slow due to high usage data so that you can clear usage data to improve performance of Ax client. 1. Click the Microsoft Dynamics AX -> Tools -> Options... menu item. Fig-1 2. Click the OK button. 3. Click the Usage data button. Fig2 4. Click the Reset button. 5. Click Yes in the Reset Usage Data form. 6. Close the Usage data form.

Step by step to Export table template in axapta using Excel Template Wizard MSDAX

If  You need to import any table data through template then you need to export template then fill the data then you need to import that template. To Get template of particular table  you can follow steps below.. 1. Click Navigation Pane node: Administration -> Periodic -> Data export/import -> Excel spreadsheets -> Template Wizard. Form name: Microsoft Office Excel Template Wizard Fig 1. 2. Click the Next > button. 3. Switch to the Open workbook tab on the Microsoft Office Excel Template Wizard form. Fig2 4. Change File name from '' to ' E:\test\doc\filename.xls'. 5. Click the Next > button. 6. Switch to the Select tables tab on the Microsoft Office Excel Template Wizard form. Fig3 7. Click the > button. 8. Click the Next > button. 9. Switch to the Generate field list tab on the Microsoft Office Excel Template Wizard form. Fig4 10. Click the Next > button. 1

Cross Check Ledger balances from tables data for trial balance checking in MSD axapta

If you are facing any amount mismatch problem in trial balance report then you can cross check data with ledgertrans and ledgerbalancedimtrans table. You can check amount dimension wise. You can get hints from below query. select Sum(AmountMST) from _LedgerTrans group by AccountNum,transdate,Dimension[1],Dimension[2] ; select sum(DebitMst),Sum(CreditMst) from _LedgerBalancesDimTrans where LedgerBalancesDimTrans.AccountNum ==_LedgerTrans.AccountNum && _LedgerBalancesDimTrans.transdate==_LedgerTrans.transdate && _LedgerBalancesDimTrans.Dimension[1]==_LedgerTrans.Dimension[1] && _LedgerBalancesDimTrans.Dimension[2]==_LedgerTrans.Dimension[2]; amt= _LedgerBalancesDimTrans.DebitMST + _LedgerBalancesDimTrans.CreditMST

Tax regulation and tax calculation class,tables,methods for sales order in MSD axapta

Following Tax classes used to calculate tax for sales order in axapta 1. Taxsales 2. Tax 3. TaxRegulation. In Tax class there is  a method CalcTax on which tax calculate for particular tax code. First tax itemgroup takes from Sales Line then its take formula then formula evaluated by using evabuf method. tmptaxworkTrans is a temporary table which shows temporary tax calculation.If there is tax adjustment then you need to apply tax button on salestax form to get effects.  Corrected Tax or tax adjustment stored in field SourceRegulateAmountCur of Tmptaxworktrans and  Regular tax  field is  sourceTaxAmountCur. Before posting table is  tmptax and tmptaxworktrans,tmptaxregulation After posting Tax table is  TaxTrans,ledgerTrans,CustInvoiceJour.

Code to get total Tax amount from sales order in MSD axapta

To gett total Tax amount of sales order in axapta you can try below code in job . SalesTotals salesTotals; SalesTotals_Trans salesTotals1; SalesTable salesTable; SalesLine salesLine; TaxAmountCur Amount,amt1; Tax tax; ; salesTable = SalesTable::find("S0000343_052"); salesLine = SalesLine::find(salesTable.SalesId); salesTotals = SalesTotals::construct(salesTable); tax = Tax::construct(NoYes::No); Amount = salesTotals.totalTaxAmount(); info(Strfmt("The tax amount is %1",Amount ));

Code to Read Html File in MSD Axapta

Follow code is to Read from html file using Axapta x++. str page; str filename; commaIO myfile; int handle; WinInet _WinInet = new WinInet(); ; filename = "C:\\HTMLfl.txt"; myfile = new commaIO(filename,"w"); handle = _WinInet.internetOpenUrl('http://www.test.com'); if (handle) { page = _WinInet.internetReadFile(handle); myfile.write(page); } _WinInet.internetCloseHandle(handle);

Code to get Sales and purchase Quantity and amount date and item wise in MSD Axapta

To  get Sales and purchase Quantity and amount date wise in Axapta you can try following code in Fetch method of customized Report to get the same. Query q; QueryRun qr; QueryBuildDatasource qbds; QueryBuildRange qbr; InventTable inventtab; CustInvoiceTrans _custInvoiceTrans; vendInvoiceTrans _vendInvoiceTrans ; q = this.Query(); qbds = q.addDataSource(tablenum(InventTable)); qr = new QueryRun(q); while(qr.next()) { inventtable = qr.get(tableNum(InventTable)); select sum(Qty),sum(LineAmount) from _vendInvoiceTrans where _vendInvoiceTrans.ItemId==_ItemId &&_vendInvoiceTrans.InvoiceDate >= fromDate &&_vendInvoiceTrans.InvoiceDate <= ToDate; _PurchQty=_vendInvoiceTrans.Qty; _PurchAmount=_vendInvoiceTrans.LineAmount; select sum(Qty),sum(LineAmount) from _CustInvoiceTrans where _CustInvoiceTrans.ItemId==_ItemId &&_CustInvoiceTrans.InvoiceDate >= fromDate &&_CustInvoiceTrans.InvoiceDate <= ToD