AX 2012 R2 CU7 Sample India TDS Setup for 194C Contract for company with threshold and accumulative

In this example following is real scenario to setup TDS 194C for contract (company) in year 2014:

• If PAN status is "not available" or "not received" yet then the TDS rate is 20% . See sample A below.
• If PAN status is "Received" then
• If single invoice more than 30,000 Rs then TDS rate is 2% . See sample B below.
• If single invoice less than 30,000 Rs then calculate cumulative invoice amount within current fiscal year for the vendor. 
• If cumulative is  <=75,000 Rs per annum then TDS rate is 0%. See sample C below.
• If cumulative is > 75,000 Rs per annum then TDS rate is 2%. Note the first invoice which make the cumulative reach threshold of 75K, will recalculate TDS for previous non-taxed invoices. (See sample D below)

Sample A:

Vendor AXE000A,PAN information status is "Not available".
8 Jan 2014 there is invoice INV001 1000 Rs. So the rate for TDS should be 20% * 700 = 140 Rs.

Sample B:

Vendor AXE000B, PAN information status is "Received".
8 Jan 2014 Invoice# INV002, amount 32,000.00 Rs. TDS tax amount = 2% * 32,000 = 640 Rs

Sample C & D:

Vendor AXE0001, PAN information status is "Received".
1st Jan 2014 Invoice# INV003, amount 10,000.00 Rs. TDS tax amount = 0% * 10,000 = 0        Rs (10K p.a.)
2nd Jan 2014 Invoice# INV004, amount 20,000.00 Rs. TDS tax amount = 0% * 20,000 = 0        Rs.(30K p.a.)
3rd Jan 2014 Invoice# INV005, amount 25,000.00 Rs. TDS tax amount = 0% * 25,000 = 0        Rs.(55K p.a.)
4th Jan 2014 Invoice# INV006, amount 25,000.00 Rs. TDS tax amount = 2% * 80,000 = 1600     Rs (80K p.a.)
5th Jan 2014 Invoice# INV007, amount 20,000,00 Rs. TDS tax amount = 2% * 20,000 =  400     Rs (100 p.a.)

TDS Setup for 194C Contract Company step by step :

If you don't understand this steps, refer to following msdn:

http://technet.microsoft.com/en-us/library/dn527712.aspx

1. GL parameter>Activate TDS

2. GL>set up>Withholding tax>India>Withholding tax component group

3. GL>set up>Withholding tax>India>Withholding tax component

4. GL>set up>Witholding tax code

4.1 GL>Set up>Threshold definition

Create structure like below for 2014.

4.2. GL>Set up>Withholding tax code>>Threshold reference button>>Designer button.

5. GL>Set up>Withholding tax group

5.1 GL> Set up >Withholding tax group>>Designer button

6. AP>All vendor>>Invoice and delivery tab>>Tick calculate TDS and TDS group.

Any question?

Didn't manage to have correct value?

Having problem with setting up concession tax?

Email me and i would love to help.

India Localization for Dynamics AX 2012 R2 CU7 Withholding Tax TDS Threshold not calculated correctly

Symptoms:

1. To generate Withholding  Tax in general journal line, then you have already key in the withholding tax group (set as TDS type and within the withholding tax set "Apply threshold" to "True" with the threshold reference being set up).
   
2. But when click "Withholding tax" button in the journal line, there is no withholding records being created/calculated.

Issue:
There is "hidden" setup for tax value data which for my case i need to spent 2 days debugging to resolve this issue.
You must fill in this setup at the leaf node of your threshold designer screen.

The table name is Taxvaluedata_IN.

Resolution:

Just go to designer from Withhold profile. Follow exact step on following picture:

Cheers.

Ledger Exchange adjustment Not calculated correctly

I would like to share a problem with dynamics AX exchange adjustment function.

Symptoms:
1. You run exchange adjustment in December period (any year)
2. But the result your ledger balance in company currency (MST) / Ledger balance in transaction currency is not equal to the December end exchange rate

Problem:
There is closing transaction exist for the year. Turn out the user run the year end closing (GL>Periodic>Fiscal year close>Opening transaction) prior the exchange adjustment in december  period.

Solutions:
1. Cancel the opening transactions : GL>Periodic>fiscal year close>Opening transaction and set "Balance accounts" to "Reset"

2. Rerun exchange adjustment
3. Rerun the opening transaction, this time choose per normal parameter "Balance accounts" set to "Closing>Opening"

Hope it helps :)

Cheers.

Copy user groups from one user to another X++

Hi All,

Below job can be used to copy user groups from one user to another.

Relevant for AX 2009, AX 4.0 and Axapta 3.0

static void AXEcopyUserGroup(Args _args)
{
    usergrouplist usergrouplist,ins;
    userid src,dest;
    dialogfield srcdf,destdf;
    dialog dialog;
    ;
    dialog = new dialog("copying user's user groups");
    srcdf = dialog.addField(typeid(userid),"Source");
    destdf = dialog.addField(typeid(userid),"Destination");
    

    
    if(dialog.run())
    {
        src = srcdf.value();
        dest = destdf.value();
        if(src!="" && dest !="")
        {
            ttsbegin;
            while select * from usergrouplist
            where usergrouplist.userId == dest
            {
                info(strfmt("Before update: '%1'-'%2'",usergrouplist.userid,usergrouplist.groupId));
            }
            
            info("Deleting user groups from destination user");
            delete_from usergrouplist
                where  usergrouplist.userId == dest;
                
                
            info("Copying user groups to destination user");
            while select * from usergrouplist
            where usergrouplist.userId == src
            {
                info(strfmt("source user: '%1'-'%2'",usergrouplist.userid,usergrouplist.groupId));
                ins.clear();
                ins.data(usergrouplist);
                ins.UserId = dest;
                ins.insert();
            }
            ttscommit;
            info("User groups has been copied!");
        }
    }
    else
    {
        info("Canceled by user");
    }
    
   
}

Optimizing performance Microsoft Dynamics AX 2012 R2 Solution Demos Virtual Machine VM on your laptop

Update: Microsoft Dynamics AX 2012 R3 was released on May 2014. You might want to have it on your laptop instead of AX 2012 R2. Read the newest guide here (with full screenshot):
http://daxetlbi.blogspot.sg/2014/09/optimize-ax-2013-r3-virtual-machine.html


Usually people use use Virtual Box, VM ware or Hyper-V for the purpose of exploring new function of AX 2012 or preparing for pre-sales activity to prospect.

I found those method are not effective since you may only have limited resource on the laptop.
You may want to remote to your server at office but don't rely on prospect's internet access or your mobile 3G/4G connection to remote to your office. You don't want to take a risk for this.

Here is a simple method that you can do it in  30 minutes (excluding downloading the VHD from Partner source).
Yes, you hear me correctly 30 minutes.



This method use the feature to attach VHD to your disc management and create bootup file.

System specification that i use:

1. Existing windows 7 ( i believe it should work for windows 8 too)
2. SSD 1 GB
3. RAM 16 GB
4. i7 CPU, 2.3 Ghz

1. Step 1. Download the VHD image from the partner source here (https://mbs.microsoft.com/customersource/downloads/servicepacks/AX2012DemoToolsMaterials.htm) .
   If you already have on your disk skip this step and use it instead. You can use also existing vhd that has been used by VirtualBox Vmware or HyperV.
   
2. Setup dual booting of windows 7  and Windows server 2012 (use VHD from step 1)
   
   Follow the step on this great blog: http://blogs.technet.com/b/blainbar/archive/2012/09/25/step-by-step-4-ways-to-dual-boot-microsoft-windows-8-and-windows-server-2012-with-or-without-windows-7.aspx
   
   There are 4 articles there, make sure you just pick up the first tutorial
   1. Dual Boot to Windows 8 or Windows Server 2012 from within the Windows 7 Operating System using an existing .VHD
   Once reached the step number 8, you can have dual OS, Windows 7 and Windows server 2012 with the AX 2012 demo solution inside.
   You can still access your drive in the windows 7 from the windows 2012 so not to worry to copy your data over.
   
   At this point you can use AX 2012 demo VM at full resource of my laptop (16 GB RAM, i7 CPU). Cool isn't it.
3. Optional - Wireless LAN feature setup. By default you don't have Wifi manager in the new server. You can go to the windows feature to activate the wifi lan manager then restart.
4.  Role Center and Enterprise portal. You can edit the host file as usual. Go to C:\Windows\System32\drivers\etc\hosts and open up with notepad.
   And just add two lines below:
   127.0.0.1 dynamicsax.contoso.com
   127.0.0.1 sharepoint
   Basically this is to intercept DNS to point the website back to local host.
   Go to your IIS Manager then open up site>dynamics AX and on the right side click "Edit binding" then change the ip address to 127.0.0.1 as well.

Chandra W. Setiawan
Freelance Dynamics AX Consultant

Dynamics AX 2012 R2 Demo virtual machine version 4 issue - unable to reboot

Please check the latest way of maximize virtual machine without Virtual Box or VMWare on my other posting:

http://daxetlbi.blogspot.sg/2014/09/optimize-ax-2013-r3-virtual-machine.html


Unfortunately the latest release of VM of AX 2012 got a little bit hiccup for the installation.

I am using oracle virtual box and got following message:

Windows failed to start. A recent hardware or software change might be the cause.
To fix the problemm:
1. Insert your windows installation disc and restart your computer.
2. Choose your language setting, and then click "Next"
3. Click "Repair your computer"

If you do not have this disc, contact your system administrator or computer manufacturer for assistance.

Status: 0xc000000e
Info: A required device isn't connected or can't be accessed.

I found a blog for the resolution is Germany:
http://www.dynamics-community.at/post/2013/12/11/Neue-Dynamics-AX-2012-R2-VM-mit-CU7-Behebung-des-Boot-Problems.aspx

Resolution:

Don't use latest release of VirtualBox as it is keeping give me error when running the fix. I uninstall 4.3.4 and install the older version 4.2.20

1.  Prepare the DVD installation of Windows server 2012 .If you have disc  for  Windows Server 2012 installation then mount it to your Virtual BOX machine else download the trial iso image here : http://technet.microsoft.com/en-US/evalcenter/hh670538.aspx
2. Mount into your virtual box

3. Start your virtual machine and make sure the boot sequence is CD follow by the virtual harddisk

4. Start your machine, choose "Repair your computer"  > select language >

5. Choose command prompt and enter following command:
type: bootrec /fixmbr  and press enter
and do the same for following:bootrec /fixboot bootrec /rebuildbcd

once finished then just type "y" and enter to complete. Then type "exit" enter

It will return to previous menu, but this time choose turn off.



6. Start again your Virtual box machine then that's it.
7. In my case i got another common issue. First the AOS is stuck at starting state.
To fix this just read following post: http://community.dynamics.com/ax/f/33/t/106726.aspx

8. And last and final step is issue regarding role center / EP / sharepoint portal not loaded.
Old method really go to C:\Windows\System32\drivers\etc\hosts and open up with notepad.
And just add two lines below:
127.0.0.1 dynamicsax.contoso.com
127.0.0.1 sharepoint

Basically this is to intercept DNS to point the website back to local host.


Go to your IIS Manager then open up sites>dynamics AX and on the right side click "Edit binding" then change the ip address to 127.0.0.1 as well.

Then there you go...

Usually i like to use RDP since smoother interface then the virtual box console session.
Make sure u setup a bridge network then in your RDP just put address: Ax2012R2A



Author:
Chandra W. Setiawan
Freelancer for Dynamics AX Technical & Functional