Author: Ronny
We received an request from our user, an error, this morning while user wants to cancel the sales order, the error was: The quantity cannot be reduced. The number of inventory transactions on order is too low because the quantity or part of it is referenced by an output order or a production order or […]
Read Morein ax, we use table to transaction, and log transactions, and temporary table for report and printing sometimes the table is very big (contains alot of unused record), this is why we do need to check the database (specially the log table), so we can delete the record and reindex it SELECT t.NAME AS TableName, […]
Read More[ax 2012] inventsum recalculation
- Jun 04, 2018
in ax, during your customization, sometimes you have do the custom wrong for example, in ax, in inventory system, sometimes we do creating a inventtrans transaction that might be forget to using Update() syntax (and we using DoUpdate() syntax) we forget to deactivate allow negative stock, and we force it to active allow negative stock […]
Read More[ax2012] creating a trigger that cause havoc
- May 25, 2018
A couple months ago, I was planning to use SSAS to analyze our sales invoice, I was using database table trigger, so I donot need to requery the big data I create a table destination, which input from CustInvoiceJour transaction (insert/update/delete) what I did wrong is, I create the database destination using AX AOT the […]
Read Morein case you living daily without remote desktop activity, You won’t know there recently problem occurred while updating security updates on windows 10 KB4103727. You may notice that suddenly connection to a production server by remote desktop has been failed An authentication error has occured, the function requested is not supported. Remote desktop <your rdp […]
Read Morewhile you tried to first time install ax, you must do the step by step and when you got into database synchronize there was an error ax 2012 error : text synchronize database specified field modelid of datasource projparameters does not exists in the database or the configuration key on the field solution: turn on […]
Read More[ax2012] compiling layer conflict -> aos crash!
- Mar 22, 2018
It was a sunny day, no user aware that day would be the hardest day as an ax administrator, it was a crash day for AOS (application object server) We were uploading a custom class modification (RPTRFP_DP class) using a CUS layer, while we’re import it, there was a layer conflict (USR vs CUS), we […]
Read Morewhile generating credit note from sales order, shows an error : Mode of delivery must be specified when terms of payment include COD it happens because the customer MoD (mode of delivery) in master customer and MoD in invoices is different, to fixed it, change the MoD in Customer and MoD in CustInvoiceJournal
Read More[SSRS] how to get line number in ssrs
- Mar 16, 2018
how to get line number in ssrs ? these trick can do on AX SSRS and C# SSRS by using =RunningValue(CountDistinct([your group]),Count,[your dataset]) result:
Read More[ax 2012] how to resize dialogfield
- Feb 15, 2018
by design, dialog field width is using maximum auto width on parents so if you wants to resize dialogfields, you only can do maximum auto witdh by yourDialogFields.widthMode(1);
Read More