vivek


How to Calculate Month Difference Between Two Dates – Excel Formula 1

Excel is an essential tool for a consultant life and especially for functional ones. In this interesting and helpful excel series, we will try to share few quick excel formulas which we may need on regular basis. Today I got stuck into one situation where I wanted to calculate month […]


How to Remove Un-Marked Transactions, Marked for Settlement in Ax 2012 1

By navigating to Vendor ‘Settle Open Transactions’ or Customer ‘Settle Open Transactions’, you can see some transactions are marked for settlement with red hand sign in “Is marked” column. Un-marking such transactions is only possible by finding the offset transaction and deleting the link. Though it could be a nightmare if […]


How to Open Details Form in Default Edit / View Mode in Ax 1

When you open a record from list page, the default behaviour of record is to open in view mode. In cases where you do a lot of editing, you would like to cut down your no. of clicks. To open a record in default edit mode may save you one […]


Auto-Complete Text in the Windows Client for Ax Users

Ax has an in-built parameter to remember text that user typed in the past and recalled that text when you type it next time in the future. This is a handy tool and minimise your text typing. There is a parameter to turn off this option if you do not like […]


Set Up to Restrict Quantity Change at Purchase Order Invoice Form in Ax 2012

This blog is in continuation of following blog where we spoke about costing issue if quantity is changed at purchase order invoice form; http://dynamicsteaching.com/costing-issue-in-ax-2012-changing-quantity-at-purchase-order-invoice-form/ To restrict changing the quantity at PO Invoice form at lines level, refer the following set up; Accounts payable – Set up – Accounts payable parameters […]


Costing Issue in Ax 2012 – Changing Quantity at Purchase Order Invoice Form

A prominent costing issue could lead you in trouble if purchase order invoicing is done (using wrong method) with less quantity against what is physically received. Let’s understand this issue in detail; Let us discuss a scenario – PO is issued with the quantity of 10 iPhone @ Price of […]


How to Edit Number Sequence for Purchase Requisition in Ax 2012 1

While working on one of the requirement, I had to enable Purchase requisition process. While trying to change the number sequence for purchase requisition, I couldn’t find the way. When investigated, I found it is not a company specific but a global set-up (1 sequence for all companies). When you […]


What is the difference between SSIS, SSRS and SSAS?

SSIS: SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including the extraction, transformation, and loading (ETL) of packages for data warehousing. SSIS is the new name assigned to the component formerly branded as Data Transformation Services (DTS). SSIS (SQL Server Integration Services) is […]