Skip to main content

Posts

Showing posts from June, 2014

Code for Tax adjustment in Free text Invoice in MSD axapta

This is a Code for Tax adjustment in Free text Invoice in axapta. You can try this code in job to check the effect of adjustment. CustInvoiceTable _custInvoiceTable; CustInvoiceCalcTax custInvoiceCalcTax; TaxFreeInvoice _taxFreeInvoice; TaxRegulation _taxRegulation; ; ttsbegin; select firstonly _custInvoiceTable where _custInvoiceTable.InvoiceId == "test5"; custInvoiceCalcTax = new CustInvoiceCalcTax_Table(_custInvoiceTable); _taxFreeInvoice = new TaxFreeInvoice(custInvoiceCalcTax); _taxFreeInvoice.calc(); _taxRegulation = TaxRegulation::newTaxRegulation(_taxFreeInvoice); _taxRegulation.allocateAmount(33.47); _taxRegulation.saveTaxRegulation();

Code to Tax adjustment for Ledger Journal in MSD axapta

This is a Code to Tax adjustment for Ledger Journal in axapta You can try this code in Job in AOT. I hope it can help you to get class and method details for tax adjustment. LedgerJOurnalTrans LJTrans; TaxLedgerJournalCalculate taxLedgerJournalCalculate; TaxLedgerJournal taxLedgerJournal; TaxRegulation TaxReg; ; ttsbegin; select firstonly LJTrans  where LJTrans.JournalNum == "000787_j"; taxLedgerJournal = TaxLedgerJournal::construct(TaxJournalCall::Journal, LJTrans, null); TaxReg = new TaxRegulation(); taxLedgerJournal.calcAndPost(); TaxReg.setTax(taxLedgerJournal); TaxReg.createSumsFromTmp(); TaxReg.allocateAmount(7.8); TaxReg.saveTaxRegulation();

Inventory Value By Inventory Dimension report in MSD Axapta

If you want to know inventory value with dimension details then you can Go to Inventory Report from following menu path. Inventory Management -> Reports -> Status -> Inventory Value By Inventory Dimension In this report you can select dimension like batchid,warehouse, inventory location etc. Inventory value you will get correct after inventory recalculation and closing.

Trial balance report in MSD axapta

Trial balance report is to show closing balance of particular period. If you want to know opening debit,credit,current period debit and credit amount and balance till date for particular account then you can get details from following report. General Ledger -> Reports -> Transaction -> Periodic -> Trial Balance You can view  report by using summary and details option. You can check other option to know more details about report.

Critical Hotfixes for Inventory in MSD Axapta 2009 Rollup 5(RU 5) or Higher

Change current session date in MSD axapta

To Change current session date in axapta you can find in following menu. Tools- > Session date If you will change session date for your client then it will change for your client session only it will not affect other users session. Once you will close your ax client then real current date will be set automatically.

Could not find user at SysWorkflowDueDateProvider Error in Workflow axapta MSDAX

If you are getting below error on workflow . Stopped (error): X++ Exception: Could not find user at SysWorkflowDueDateProvider-resolve SysWorkflowDueDateProvider-resolveDueDate Then you need to check following things. 1. Check workflow configuration is user assigned for workflow approval elements . 2. Check user relation form if there is not employee assigned then you need to assign employee on user relation form.

Execute or call SQL Stored Procedure in MSD Axapta by code

To Execute or call SQL Stored Procedure in Axapta by code you can get hints from below code. You can also pass parameter with stored procedure in string format. UserConnection Conn; Statement Stmt; str SqlStmt; SqlSystem sqlSystem; SqlStatementExecutePermission sqlPermission; ResultSet resultSet; str StrFromdate,StTodate; StrFromdate =strFmt("2010-01-01"); StTodate =strFmt("2014-03-31"); sqlSystem =new SqlSystem(); SqlStmt =strFmt('Exec SP_StoredProc \'%1\',\'%2\'',StrFromdate,StTodate) ; Conn =new UserConnection(); Stmt = Conn.createStatement(); sqlPermission =new SqlStatementExecutePermission(SqlStmt); sqlPermission.assert(); Stmt.executeUpdate(SqlStmt); CodeAccessPermission::revertAssert();

How to Call query in MSD Axapta by code

To Call query in Axapta by code you can try below code. You need to create query in aot query node then pass query using querystr method in queryrun object. QueryRun queryRun; int cnt; ; queryRun = new QueryRun(queryStr(Query1)); if (queryRun.prompt()) { while (queryRun.next()) { cnt++; }

Re-Index All Tables or All Indexes in MSD Axapta

To Re-Index All Tables or All Indexes in Axapta You can do from this menu path. Go to Administration -> Periodic -> SQL Administration ->Select All Table/All Indexes->Go to Index Action button_>Re-index. Re-Index All tables from SQL Database

Show all fields in MSD axapta

To see all fields of table in Axapta mostly we go to table element of AOT and browse table to get all fields name but if you are in any form and want to see all fields then its very easy. Just right click on form control go to recordinfo then click on show all fields you can see all fields in form. I hope it will save your time.

Blogging in MSD Axapta ERP

If you want to write blog on Ax then you should select you excellent area to get success. If you are functional then do not write topic of technical code you should be strict with your area so it can get more success on functional area. Write topics as per version wise from lower version to highest. You will get more traffic on latest version because lot of companies implementing project in latest versions and they do not know much more about latest version so they will search more on latest version. If you are writing something in old version then do not write large theory type posts it should be short and valuable. In old version most people search for error and troubleshooting so your post should be type of answering for solution of error and troubleshooting. If you are Indian and working for Indian project then there are lot of complex question for tax related,excise ,cst,tds,wct,server tax,vat,additional duty ,custom duty,reverse service charge calculation etc so if you w