[ ax2012 ] default user group

Image

import from AD to Ax

ad_import( the user menu will be based on user role )

 

NOTE : don’t forget to assign the profile to user

System administration > Common > Users > User profiles

select profile, then `Add user`

ax_user_profile

 

 

Advertisements

[ windows server ] account not authorized for remote login

account not authorized for remote login

solution

– add user to `Remote Desktop User` Group, or `Administrator` Group ( recommended to add to administrator group )

– can add AD user group as well

NOTE : this should be set at the server that user have to login, not an AD server

add_user_to_this_group

Alternative way to add user to `Remote Desktop User` Group is via Server Manager > Configure Remote Desktop > Select User > Add

Image

[ ax2012 ] excel add-in API

1. new C# Form project

2. add reference to

– .NET > DocumentFormat.OpenXml.dll

– C:\Program Files (x86)\Microsoft Dynamics AX\60\OfficeAddins\Microsoft.Dynamics.AX.Framework.OfficeAddin.XmlParts.dll

– .NET > WindowsBase  ( to fix The type ‘System.IO.Packaging.Package’ is defined in an assembly that is not referenced ref : imak47 )

using System.Text;
using Microsoft.Dynamics.AX.Framework.OfficeAddin.XmlParts;
using DocumentFormat.OpenXml.Packaging;

 

 // Create a connection to the spreadsheet. Make the spreadsheet editable.
                SpreadsheetDocument myWorkbook = SpreadsheetDocument.Open(@"C:\Users\LocalUser\Documents\MySpreadsheet.xlsx", true);

                // Get the XML metadata from the spreadsheet.
                WorkbookXmlPart workbookXml = Serializer.GetWorkbookXmlPart(myWorkbook);

                // If the spreadsheet is locked, remove the lock.
                workbookXml.WorkbookOptions.IsDesignLocked = false;
 
                // do something

                // Lock the spreadsheet to prevent changes from the Dynamics AX tab
                workbookXml.WorkbookOptions.IsDesignLocked = true;

                // To show the change to the filter, refresh the spreadsheet when it opens.
                workbookXml.WorkbookOptions.RefreshAllDataOnOpen = true;

                // Update the XML metadata of the spreadsheet.
                Serializer.SetWorkbookXmlPart(myWorkbook, workbookXml);

 

 

 

ref : microsoft, msdynamax

 

[ ax2012 ] Legal Entity setup

Organization administration > Setup > Organization > Legal entities

 

– Name

– Company

– Country/Region

 

– Search Name

– Language

– Timezone

– Address

 

– Contact Information ( Phone / Fax )

– Tax registration number

– Bank account

– Number sequence ( System ID : Basi_1 )

 

 

[ ax2012 ] Audit trail and Database Log

Audit trail

– All ledger postings can be tracked

– is at General ledger > Inquiries > Audit trail

– update into TransactionLog table

ref : msdn

Database Log

System administrator > Setup > Database > Database Log Setup database_log_setup

Bank — Bank Account

GL — Customer list financial dimension

GL — Main Account

GL — Tax Branch

GL — Vendors

Not specified — Global address book

Not specified — operating unit

 

Inquiries > Database > Database Log

database_log_examplehistory ( previous value )

database_log_history_example

[ gae ] php framework

python dev_appserver.py --php_executable_path=/etc/alternatives/php-cgi project_dir_naja

 

 

 

NOTE : installaton of php is from appengine website

Make sure Python 2.7 is installed on your machine using the following command:

/usr/bin/env python -V

The output should look like this: Python 2.7.<number>. If Python 2.7 isn’t installed, install it now using the installation instructions for your Linux distribution.

Install version 5.4 of the php-cgi binary. PHP 5.4 is not packaged on most Linux distributions so it may be easiest to install it from source. On Debian-based Linux systems, you can use the following commands to install PHP 5.4 in such a way that it won’t affect any other versions of PHP that you may have installed:

sudo apt-get install gcc libmysqlclient-dev libxml2-dev
wget --trust-server-names http://us2.php.net/get/php-5.4.25.tar.bz2/from/us1.php.net/mirror
tar -xvf php-5.4.25.tar.bz2
cd php-5.4.25
./configure --prefix=$PWD/installdir --enable-bcmath --with-mysql
make install
cd -

Note: At the time of writing, php-cgi (the binary used by the PHP SDK) can be found in php-5.4.25/installdir/bin/php-cgi.

Install MySQL on your local machine. (You will need this to test your app locally.) On Debian-based Linux systems, you can use the following command:

sudo apt-get install mysql-server-5.5

You will be prompted to enter a password for the MySQL root user; make sure that you remember it.