Archives for December 2014
A common question arises in my mind that such a detail sales order invoiced exists then why we need free text invoice. I found two detail answers with reference
A free text invoice is an invoice that is not attached to a sales order. A free text invoice contains a header and one or more lines for items or services that are not tracked in inventory. Use a free text invoice for sales that do not require a sales order, packing slip, and customer invoice. For example, you can use a free text invoice for a consulting fee or services fee, or for a miscellaneous fee for an event reimbursement.
A free text invoice is not related to a sales order. It contains order lines that include ledger accounts, free-text descriptions, and a sales amount that you enter. You cannot enter an item number on this kind of invoice. You must enter the appropriate sales tax information. Also, the customer balance is posted to the summary account from the posting profile that is used for the free text invoice.
In addition, a free text invoice line can be used to sell a quantity of any kind of goods, services, or rights – providing unit price and quantity information to the customer. It also helps basic amount calculation, and it helps to better identify and explain charges to customers.
Now if we want to create a free text Invoice and post It. You have to follow this, Currently I am using
Contoso demo data and usmf legal entity.
Account receivable => common=> Free text Invoices => All free text Invoices
Free Text Invoice List page opens
Click on Free text Invoice, following form will open
Select the customer
Add invoice lines. And select main account, Sales tax group and Item sales tax group. Update the Unit price.
Now click on post on top menu
Following form will open
Click on ok button to post it, On successfully posting following form will open.
In dynamics Ax 2012, session date is appear in status bar. User can change it if required.
If you want to change it you can click on it fil=> tools=> session date and time
On click it similar form will appear.
If session Date is not appear in Status bar, then you have to enable it from following link
File > Tools > Option s > Status bar
Enable session date time by clicking on “Show session date:”
After fresh installation on VM, we usually restored the database back of Production or QA server . And this technique usually applied in multi development environment. But yesterday I got this error when I tried to restore Dynamics AX database on my newly created Dynamics Ax 2012 VM.
BACKUP LOG cannot be performed because there is no current database backup. (Microsoft.SqlServer.Smo)
As per Sql Authority Website, it was backup creation issue, But surprisingly it was rights issue. I was trying to restored database from User who has not db owner or rights on the database. I switched the User and make my user as db owner, And then try to restored it. It works for me.
If this solution is not working then Please do the following.
• Stop the AOS service.
• Open BDS and delete the Dynamics Ax database.
• Restored the Dynamics Ax database from Back files
• Gave the db owner rights to service user on Dynamics Ax databases. Service user means that the user which Dynamics Ax service is running.
• Get the Current user SID by running following command in Powershell (Run as administrator).
$AdObj = New-Object System.Security.Principal.NTAccount(“administrator”)
$strSID = $AdObj.Translate([System.Security.Principal.SecurityIdentifier])
• Update the statement in database table
update userinfo set
networkdomain = ‘dynamicworlds.com’,
networkalias = ‘administrator’,
SID = ‘S-1-5-21-3030200632-4028267746-237368394-500’
where ID = ‘Admin’
In dynamics Ax 2012, You can read image from physical path and stored in database as follow
BinData binData = new BinData();
str extention, path, nameOfFile;
// if ( WinAPI::fileExists(imageFilePathName))
imageContainer = binData.getData();
table.Person = _Party.RecId;
table.Image = imageContainer;
This code runs both for server side and client side. At server side execution table use winserverapi::FileExists
During one of my development i got following error, which occurs when I try to convert image into bits and stored in tables. I solved this by adding before the code
FileIoPermission _perm;_perm = new FileIoPermission("c:\\File.txt",'r'); _perm.assert();
In real world every person has unique identified number provided by Government of country or organization where he is working. For example if we talk about Pakistan every person either Applicant or worker has its unique CNIC (Computerized National Identity Card) or National Passport or NTN (National Tax Number). And we have to store these in Human resource management implemented in organization.
For these implementation In Dynamics Ax 2012 provide a form for its set up. You can define these unique setup form and then links in Applicant or worker to step link
Human resource => Setup=> worker=> Identification types
When you click on button following form will open where you can set required Identification Types according to your country
Now you want to setup the values against these Values You can open Worker List page, select required worker and from top strip select Personal Information.
Similar form open for selected worker.
You can also set these Identification from detail form of work, Go on Personal Detail fast tab and click on “Government and Organizational Identifications”
Similarly if you can select Identification for Applicant. Select the required Applicant form grid and click on personal Information from Top tab
Or open the detail from of applicant and from Personal Information fast tab you can enter its CNIC or Identification number.
Dynamics Ax 2012 R3 CU8 demo virtual machine, is available now. You can deployed it on Azure services through Life cycle services.
Dynamics Ax 2012 R3 CU8 has following new features.
You can download demo vm from following link through partner source or customer source credential
In previous post I just create an Item product without its variant and released it to required legal entity.
But product required one more step to finalize it before used in sales or purchase.
- Item group
- Item module group.
- Storage dimension.
- Tracking dimension.
For this purpose you have to go in Specific Legal entity and open the release product page.
When Release product form opens, select or highlight you required release product and click on Edit button.
You can find similar form.
You find that there is validate button on Product tab, this button helps you to identify what is missing in finalizing the release product.
I clicked it for my newly released product.
It gives me warning that values for Item model group, Item group, storage Dimension groups and tracking dimension group values are missing.
Let’s first set the values for Storage and tracking dimension group.
For this purpose you have to click on top menu tab menu and click on Dimension groups
You can set values here for Storage Dimension group and Tracking Dimension group.
After setting dimensions go to General fast tab you find the Item model group drop down, you have to set its value from there
For Item group please expend the Manage Costs fast tab and set its value from there.
After setting all these values click on Validate button to check that Release product is properly configured.
In Dynamics Ax 2012, there is separate module made for product management. There are two types of products in Dynamics ax.
Product. It is bare bone and independent product no further variation is not possible or required.
Product Master. When same product has different variant for example if we consider the hair color product that same color, quantity but slight different of shade can make different Product. Here we can make a master product and then creates its variant. We use Ax configuration technology to create its variants.
In Dynamics Ax 2012, The product creation is 4 step process.
- Create the product.
- Release to different legal entities.
- Update the release product information according to different Legal Entity.
- Used the product in different operation like purchase, sales and inventory management.
If you open the Product Management Area page in Dynamics Ax 2012 You can find following links that for product related information.
Currently If we open the All Product and Product Management then Product List Page will be appeared as.
In this article I am using contoso demo data.
Now click on top menu product to add new product.
Now if you see that there two important drop down first one is Product Type
And second one is Product Sub Type.
If we check the product type there is two values
Item and Services
Item type option is selected when product can be stored and Inventory can be manage.
Services Type can select when Product is non Inventory type. Or possible non tangible type.
Product sub type is option provided us capability to create standard product or Product which can be vary in terms of color size or config.
Product type: The standard product. There is no variant possible so no product associate with it.
Product Master: A template product its one or more than one variant can be exists. Variants exists in terms of its size, color and config.
If I am going to create a Product Master the New Product form will be look like.
Currently I am interested in simple standard Product. So I go for first option
And click on ok.
New Product is created
Now click on top menu to release product, Here we release the product In Particular legal entity.
Now click on select companies
For example I want to release Product for Only USMF. Click on OK to release Product in USMF.