Thursday, August 28, 2014

[AX 2012 - SSRS] DrillThroughCommonHelper.ToPurchTable does not work anymore

Normally you can use DrillThroughCommonHelper.ToPurchTable on your SSRS report to create a link to the PurchTable form:

[DataMethod(), PermissionSet(SecurityAction.Assert, Name = "FullTrust")]
public static String drillThroughActionPurchId(String reportContext, String purchId)
{
  return DrillThroughCommonHelper.ToPurchTable(reportContext, purchId);
}

If this function somehow does not work anymore (in my case my client upgraded from AX 2012 to AX 2012 R2 and since the upgrade all the hyperlink to the PurchTable form does not work anymore), a workaround is by creating directly the hyperlink on the expression window (without business logic as the code above):

="MenuItemDisplay://PurchTable/+345+[1:" & Fields!PurchId.Value & "]"

345 is the ID of the PurchTable and 1 is the ID of the PurchId field.

Is there another way to fix it / make it work?

Wednesday, January 15, 2014

[AX 2012] SEPA: 1000 records

I have just noticed that AX has a standard outbound ports setup value of Max. number of documents 1000.

The consequence is that a client can not create more than 1000 records of payment journal XML for a SEPA payment.

Therefore you must change the Limit number of documents to No.