Ax, this is another corner

If you were using virtual machine on aos client/server sometimes there was a significant space on the vhd file, if you dont clean it up, it will takes your physical drive space this is the solution to clean up and freespace your vhd file

just for note, I copy paste the article about Dimension Statement from technet Statement by dimensions report (LedgerTransStatement) [AX 2012] Updated: January 9, 2013 Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012 The Dimension statement report displays account and transaction information by account. How to filter the data on this report Field Description Transactions Select the origin of the transactions to be reported. Primary financial dimension set Select the primary financial dimension set. Secondary financial dimension set Select the secondary financial dimension set. Group per secondary dimension set Select this this check box to print the subtotal amount for the primary financial dimension set. Date interval Select the date interval for the report. From date Enter or select the start of the date range to print transactions for. To date Enter or select the...

when you wants to install ax 2012 client on windows 10, you have to install all prerequisite first you’ll see on the picture above, we have windows identity foundations missing how to install windows identity foundation? in earlier windows version, you can install windows identity foundation using “Windows6.1-KB974405-x64 (Windows Identity Foundation).msu” (type KB974405 in google to download the msu file) but this wont works in windows 10,

what is Load Balancer, If you do have more than 2 AOS license, you could use Load Balancer for ax balancing, this is tutorial to set the balancer 1. Go to System administration –> Setup –> System –> Server Configuration see on the top picture, I have 3 AOS license, I will set the 03@PH-SVR33 as Load Balancer

this article is talking about inventory calculation Inventory Closing Why You should Closed the Inventory All Ax Inventory transaction, recorded the transaction in average by default, so if the company did not use average costing instead using FIFO/LIFO Costing, every period they must recalculate the inventory so the inventory cost will change to FIFO/LIFO before they doing the financial closing. but in progress, the recalculation always start from the last closing inventory date, it means that if we do not closed the inventory, the recalculation will recalculate from old past period, for example, if the last inventory closing do on 2013, so recalculation starts calculate from early 2013. while we do the recalculation, the current inventory transaction will also recalculate the Cost (COGS), and if the recalculation periods start from past year, it will take an ax slow while doing inventory transactions such as receive good, picking list, packing slip and not forgot to ...

this article is talking about inventory calculation I wrote this in Bahasa (english version will at next posting) Inventory Closing Alasan dilakukan Inventory Closing berkala Agar tidak memberatkan perhitungan recalculation inventory pada masing-masing entity di AX, karena perhitungan recalculation dilakukan pada periode setelah inventory closing terakhir. Akibatnya jika inventory closing dilakukan dalam periode yang lama, recalculation akan semakin lama, dan berpengaruh kepada load aplikasi axnya sendiri ketika menjalankan transaksi yang berhubungan dengan inventory, seperti receive good, picking list, packing slip, sales invoice Secara default, nilai COGS di trans...

you have 2 tables, the first table contains ‘123’ record and the second table do not the question: how to view table in first table that not contains record in second table case: I want to know, what item that is not in sales in basic sql: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 declare @ dataareaid varchar ( 4 ); set @ dataareaid = 'Tes' ; select distinct a.itemid from inventtable a left join salesline b on a.dataareaid = b.dataareaid and a.itemid = b.itemid where a.dataareaid =@ dataareaid and b.itemid is null order by a.ITEMID so, the record will show the item that are not in sales line.

when you create a report designer in ax,and creating a duplicate from the other reports, sometimes, the paper size isn’t same from the report source while you trying to print the reports the problem is because aos did not detect the setting of paper print, check it by look the report properties, and field “changed by”, “change times” how to solve this problem:

lets call the day off while we change/upgrading the client platform from windows 7/8/2008 to window 10 (x) and all life goes on then when something different happens in using ax 2012 client you think your eyes getting problem. see the 2 picture below, (for internal reason, i had to filter the aos name) if you noticed well, we can see the different screen font while you’re not using window 10 (x). the font and the screen suddenly seems not good to see this happen because the setting of DPI scale how to solve it:

how to create xml file in c# we use xml file for client configuration, each client have different configuration, so we need to custom each client for its configuration this sample, shows us how to create xml file in c# 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 try { XmlDocument doc = new XmlDocument(); //(1) the xml declaration is recommended, but not mandatory XmlDeclaration xmlDeclaration = doc.CreateXmlDeclaration( "1.0" , "UTF-8" , null ); XmlElement root = doc.DocumentElement; doc.InsertBefore(xmlDeclaration, root); //(2) string.Empty makes cleaner code XmlElement element1 = doc.CreateElement( string .Empty, "EstimationClientSetup" , string .Empty); doc.AppendChild(element1); XmlElement element2 = doc.CreateElement( string .Empty, "ClientSQLServerName" , string .Empty); XmlText texte2 = doc.CreateTextNode(aa.ServerInstance); element2.AppendChild(texte2); element1.Appe...

this post is discussing about how to upload fixed asset in ax 2012 FP if you have asset to registered in ax 2012, there are 2 ways to do, manual input in entity–>fixed asset–>common–>fixed assets–>fixed assets upload the data through xls file if you want to upload you’ll need to follow the step: have xls contains fixed asset data,  if you need the acquisition journal and accumulation depreciation journal, you must provide the xls also have the xpo for upload, i will explain the xpo later,  but if you need to upload acquisition journal and accumulation depreciation journal, you must have other xpo also please look for this xls 20150430-FAFIX it is containing asset data master only, such as Asset Group, Asset Number, Asset Name, Asset Location, Asset QTY, Asset UOM, and Asset Costs (purchase cost) another file is 20150430-ABFIX it is asset book, contains data posting profile, value model depreciation run date, service life, depreciation periods, ac...

while ar settlement, showing an error : this transaction has been marked for settlement by another user it happens because the transaction is marked for another settlement check on inquiry –> specifications open journal form, if there is non posted transaction, just marked it but if there are not? how to solve it? just click on record info on marked transaction, note the record id, and find in spectrans table, delete the record id on column specrecid and press f5, the marked symbol will vanished

if you are ax 2012 administrator, and sometimes when you need to add security roles, but you cannot create new security role. the button create security role is inactive just like this picture (watch the red box) it did happen when your administrator accidentally activates version control in aot,  AOT –> Version Control –> Version Control Parameter change version control status to “disabled” -RF-

SSRS is not working, it shows error like this: “The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)” what should you do is:

error occurs while posting purchase invoice, “customer invoice in company [xxx]=xxxx, purchase is updated with xxxx” rounding problem while posting purchase invoice how to solved it:

while posting sales, purchase or inventory, sometimes you will get alert like this Item “itemid” is on hold for transactions in sales order/inventory on site it is because the setting on the item is prevent to be sales/purchase/inventory transaction, how to solve it:

report in AX 2012 that use SSRS are vendors, transaction list in general journal sometimes you’ll found an Error in AX 2012 like the picture below, The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs. The InnerException message was ‘Element ‘http://tempuri.org/:queryBuilderArgs’ contains data from a type that maps to the name ‘http://schemas.datacontract.org/2004/07/XppClasses:SrsReportProviderQueryBuilderArgs’. The deserializer has no knowledge of any type that maps to this name. Consider using a DataContractResolver or add the type corresponding to ‘SrsReportProviderQueryBuilderArgs’ to the list of known types – for example, by using the KnownTypeAttribute attribute or by adding it to the list of known types passed to DataContractSerializer.’.  Please see InnerException for more details. This case is happen in AOS, because it is too much Exception...

What is the difference between replication and mirroring in SQL Server 2008 replication, is to replicate or duplicating one or some transaction in primary server to target server: copy selected table to target server, need primary key on table to be publish it is not working in fail-over server concept best practice for publishing data to webserver / website can be replicated to 2 or more replicate server need to modified manual if the primary server created a new object/field/sp mirror, is 1=1 server, all data, object, transaction in one server is same in other server: primary server is mirroring server, mirror can be use as fail-over server concept it is not best practice for integrating publishing data to webserver / website taking resources in server more than replicate 1=1 connection from primary to mirror server automatic creating object on mirroring server while the primary add some object (sp/table columns/view) so, the replication and mirroring concept has ...