every year, ax user finance must upload the budget, this code below is how to upload budget to ax, this is the steps: fiscal calendar, check is the new year calendar is already created remember to check budg_3 number sequences, do not check the “continue”, reset every year create budget model 2017 at budget->setup->budget models […]

Read More

while the ax programmer using x++ to creating customization that connect to inventtrans, sometimes they have a forget code that invent trans effect to inventsum or sometimes when the proses working, aos hang etc so the solution is we must recalculate the inventsum so the sum of inventtrans = inventsum this is my source code […]

Read More

how to control overdelivery receipt in ax 2012? in ax, while we creating purchase order we might control that what we receipt is no more than we ordered, uncheck the “Accept Overdelivery” checkbox if we allowed overdelivery, check the “accept overdelivery” box please notice, this parameter setting will affect to current entity only, unless you set […]

Read More

My accountant friends working in company that use ax 2012, asking me he trying to re-opening the periods, the problem was, he cannot check the “Delete close-of-year transactions during transfer” because it was disabled by forms (look the pic below) the solutions is easy general ledger -> setup -> general ledger parameter goto ledger tab, […]

Read More

I just moved my windows laptop to linux laptop problem is, I usually using virtual box to working, and when i moved to linux there was an error “virtualbox error owner not root” this is solution 1. open console / terminal 2. type “sudo chown root:root /usr” 3. enter solved, enter the virtual box

Read More

if we had custom table in ax 2012, we cannot find the custom table in database log wizard so this is the solution open AOT create the Configuration Key (see the picture below) in this sample, I make a new configuration key called RON_CustomConfigurationKey, so every custom table that I made will be added in […]

Read More

just read from dax finance blog  so, if we created a rule that consist in those aot, the security user type will be impact (but need to wait 2-3 minutes to see if changes or not) I am using Microsoft Dynamics AX 2012 FP (Feature Pack) for reporting data   thanks to dax finance blog […]

Read More

Case How to validate production from sales order while advanced payment condition not meet story: we have 2 company using the same AX, both company use intercompany to create order from first company to second company first company are selling stuff, and the second are manufacture company when the first company have order from customer, the […]

Read More

how to get financial dimension on ax 2012 and update it Q : we have case that all customers financial dimension department must change because one of two reason, the old customer financial dimension from 111130 must change to 111135, how to do it? A : we can do that with sql server query. First […]

Read More

Microsoft PowerBI

  • Jul 21, 2016

Microsoft PowerBI -The preface- Two words to describe about Microsoft PowerBI, fascinating awesome! As the earlier, we already provide the custom own Business Intelligent application for our management, as the usual, we must do the same task we’d did before such as Designing the data, Designing the Chart, creating the application, manage the security and so on. We did this entirely using Microsoft Visual Studio Express to create the application, and we’re using Microsoft SQL Server 2008 R2 (Express edition) as the RDBMS.

Read More