Publications

Sometimes you come across offbeat requirements. One such was to iterate over characters of string to perform a particular operation. I googled and came across many examples of C#, small journey began to use CLR types for this operation…

Code to print sales invoice to PDF file and uplo Code to upload to a cloud/azure.

Can be used for calculations in background to avoid blocking of main process. For example to prind invoice to PDF file and then send it as business event. To schedule the main process needs to call the main method:

Class to upload file stream to a cloud Usage: To browse result: Download and Install Microsoft Azure Storage Explorer. - Open connect dialog - Storage account or service - Account name and key - populate Display name, Account name, Account…

The name should include the noun or phrase that corresponds with theevent, followed by the BusinessEvent suffix. New business event for Customers. Main contract class: Business event class: Extension to CustTable table to trigger…

AX2012r3 SSRS Report DataContract class: class Declaration: add parm method: UIBuilder class: Class Declaration: override methods:

Usual update/insert InventSum event handlers to handle simple cases Update inventSum advanced case (InventUpdateOnhand.updateInventSum())

Contract class: Controller class: Data provider class: Output menu item: Temporary table (VKSalesQuotationDailyHeaderFooter) should be Table Type = TempDB Create/Prepare a Query in AOT Add the query as dataset to SSRS report. Set Dynamic…

Error: " Something went wrong while generating the report. Please try again." It could be any stack trace in Controller or Data provider class. Unfortunately the system does not let you know the exact error of the stack trace. Set…

Contract class: Controller class: Data provider class: Output menu item: Temporary table (VKSalesQuotationDaily. VKSalesQuotationDailyHeaderFooter) should be Table Type = TempDB Creating datasets at the SSRS report set Dynamic Filters…

Error: The number of defined parameters is not equal to the number of cell definitions in the parameter panel. 1. Check the Parameters Check that Parameters at the Datasets level match (and referencing correctly, property Parameter value)…

AX infolog error: An internal error occurred on the report server. See the error log for more details. SSRS error: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: ScalableList: Index 6 outside the…

Cash and bank management / Bank statements / Import statement New field should be added to BankStatementFormat table (and form) to identify our specific format. It could be enum (if you have several custom formats) or just checkbox like in…

Parse date string of different formats to AX utcDateTime format: DateTime.ParseExact()

Replace default financial dimension value Check that financial dimension value exists: Get financial dimension value: Change/replace financial dimension value: Usage: Compose finantial dimension value: Usage: Other helper classes, which…

Browse for folder: Browse for folder and file:

Warning: Assigning a numerical value to extensible enum 'Extensible Enumeration(EnumerationType)' will yield unexpected results. Extensible enum values are not deterministically assigned to a numerical value. Warning: Comparing a numerical…

There is how you can select cross company all customers which does not exist in specific company. This can be adjusted to select eny entity in AX cross company, which does not exist in specific company. VKTmpRecIdFilter is duplicate of…

This topic shows how to extend the list of packable variables of the existing class which realize SysPackable interface or not, the class needs to have only pack and unpack methods. For example, you want to extend the…

In case of following conditions Item is enabled for advanced warehousing WHSInventEnabled::exist(ItemId); some warehouses have negative stock You will see that Available physical figure is different from what you most probably want to get:…