Microsoft Dynamics AX

Forum Post: SSRS report not printing in Landscape

Zahir Hussan — Tue, 21 May 2013 14:43:00 GMT

Hi experts,

We have modified some SSRS reports to print A4 Landscape. The reports are 'Ledger Transactions List' and 'Trial Balance' (both found in General Ledger -> Reports -> Transactions).

I have attached a screenshot (TB.jpg) of the modifications made to the Trial Balance Report (LedgerTrialBalance). This report has four designs - all four designs have been modified.

As you can see, we have set the Page Setup on the Report Properties to 'A4' Paper, Orientation 'Landscape'.

When I print the report from within the AX client (see attached TB_settings.jpg), the report appears to be formatted for Landscape but actually prints out in Portrait.

If I print it to an XPS printer (Microsoft XPS Document Writer - orientation Landscape, paper A4) I get the same result - it prints out in Portrait.

I have attached the XPS file that is produced (TB_xps.xps)- to best view the problem, zoom out so you can see the whole page. What is produced in the XPS file matches exactly what happens when I print it to a physical printer.

How can I get these reports to actually print in Landscape?

Forum Post: RE: AX 2012 (R2) Compilation Performance and Best Practice

Joris dG — Tue, 21 May 2013 14:43:00 GMT

Hi Tommy, if the KB only gave you a few extra minutes, it's more likely due to SQL caching than anything else :-)

Forum Post: RE: struct sort

Joris dG — Tue, 21 May 2013 14:41:00 GMT

No, you can't sort a struct.

Forum Post: RE: Is the position of AddGroupByField?

Tommy Skaue — Tue, 21 May 2013 14:30:00 GMT

Consider this example instead:

static void GroupByExample(Args _args) {     SalesTable  salesTable;     SalesLine   salesLine;          Query                   query;     QueryRun                queryRun;     QueryBuildDataSource    qbds1, qbds2;     int i;          query = new Query();          qbds1 = query.addDataSource(tableNum(SalesTable));     qbds1.fields().clearFieldList();         qbds1.fields().addField(fieldNum(SalesTable, LanguageId));     qbds1.addGroupByField(fieldNum(SalesTable, LanguageId));          qbds2 = qbds1.addDataSource(tableNum(salesLine));     qbds2.relations(true);     qbds2.fields().clearFieldList();         qbds2.fields().addField(fieldNum(salesLine, CustGroup));     qbds2.addGroupByField(fieldNum(salesLine, CustGroup));          queryRun = new QueryRun(query);          info(strFmt('%1', qbds1.toString()));          while(queryRun.next())     {         i++;                  salesTable  = queryRun.get(tableNum(SalesTable));         salesLine   = queryRun.get(tableNum(SalesLine));                  info(strFmt('%1 - %2', salesTable.LanguageId, salesLine.CustGroup));                     } }

Forum Post: IDMF with AX2012 R2

Syed Sadiq — Tue, 21 May 2013 14:04:00 GMT

Hi,

Is it IDMF supported for AX2012 R2?

From the information what i have from few blogs, IDMF is not supported for AX2012 R2.

Please confirm.

Regards,

Syed

Blog Post: Microsoft Dynamics AX 2009 AOS service terminated with Error Code 100

M.Aamer — Tue, 21 May 2013 13:58:00 GMT

Recently I have shared Microsoft Dynamics AX 2009 AOS service terminated with Error Code 90

Today I have tried to start AX Service and I got this message Microsoft Dynamics AX 2009 AOS service terminated with Error Code 100

This time I have check the SQL service it was stopped, after starting it every thing work fine.

Forum Post: Add Purachase Order Using AIF - Dax 2009

DAX09 — Tue, 21 May 2013 13:37:00 GMT

Is it possible to create a new PO using the exposed AIF services in Dax 2009?

Forum Post: RE: ax2009 with sql 2012 ?

Tommy Skaue — Tue, 21 May 2013 13:32:00 GMT

Thank you for marking the answer.

Have a splendid day! :D

Forum Post: RE: subworkflow document key

jerea — Tue, 21 May 2013 12:54:00 GMT

Thank you Colin.

If something can be written to mass change assignments in those top elements, then I assume it could change them at any level. That would simplify maintenance tremendously. I greatly appreciate your help.

Jim

Forum Post: RE: "Same key" Error on SSRS Report

Tommy Skaue — Tue, 21 May 2013 12:19:00 GMT

You've already restarted the AOS, so it can't be this one:

blogs.msdn.com/.../ssrs-error-in-ax2012-an-item-with-the-same-key-has-already-been-added.aspx

Could it be your Query?

blogs.msdn.com/.../getting-message-quot-an-item-with-the-same-key-has-already-been-added-quot-when-creating-an-ssrs-report.aspx

Could you try refresh the Dataset and redeploy the report?

Blog Post: Microsoft Announces Winners of the 2013 Partner of the Year Awards

MSDynamicsWorld.com — Tue, 21 May 2013 12:16:00 GMT

Microsoft Corp. has announced the winners and finalists of 2013 Partner of the Year Award Winners and Finalists.

The annual awards honor Microsoft partners for delivering innovative solutions during the past year that directly address customer challenges. Award winners and finalists, chosen from global nominations, will be recognized at the 2013 Microsoft Worldwide Partner Conference, July 7-11 in Houston.

This year, there were 44 awards that celebrated each core partner competency, including Microsoft Dynamics, and 95 Country partner of the Year awards. More than 3,000 entries were collected from 106 countries; the award finalists and winners were selected from nominations based on their commitment to customers, their solutions' market impact and exem...

Forum Post: RE: Maximum buffer size error in Ax 2012 CU3

VasanthArivali — Tue, 21 May 2013 11:52:00 GMT

Thanks for your valuable reply Andre, I will try this and update you as well :-)

Forum Post: RE: Microsoft Dynamics AX 2009 & SQL Server 2012

sql-troubles — Tue, 21 May 2013 10:34:00 GMT

AX 2009 SP1 is with SQL Server 2012 compatible, with or without SP1.

See blogs.technet.com/.../announcing-compatibility-certification-of-sql-server-2012-and-sql-server-2012-sp1-with-dynamics-ax-2009-sp1.aspx

Forum Post: Employee benefit management

davion — Tue, 21 May 2013 10:33:00 GMT

Hi all

May I know AX able to create a benefit that tight with Travel and Expenses module? Example : Employee A entitle to Benefit Z with $400. A able to create a $ 200 expense in Expense Management for claim the Benefit Z and the remaining balance of Benefit Z are $200 for A.

Forum Post: RE: compare ax 2012 ssrs reports

Rosie Jones — Tue, 21 May 2013 10:12:00 GMT

Hi Tony,

I have just done something very similar. You need to export the .xpo's for each layer (the VAR, FPK and SYS).

Then use a 3-way compare tool to compare the changes between the FPK and the SYS layer, and merge into the VAR. Then once the VAR .xpo is saved, it can be imported back into AX. I have written a blog on a compare tool I found really useful for this job, take a look: www.k3technical.com/using-code-compare-to-merge-ssrs-reports-in-dynamics-ax-2012

Hope this helps,

Thanks

Rosie

Blog Post: The P.O. invoices vouchers are doubled in the G/L

Dynamics AX Support — Tue, 21 May 2013 09:51:00 GMT

We have come across an issue where the Purchase Order invoices vouchers are doubled in the G/L in Microsoft Dynamics AX 2012.

In customer environment, the Batch Transfer rules selected in the G/L was Scheduled Batch and the Summarize accounting entries had the option "Yes".

We verified that partner solved the issue installing KB 2758624. This KB originally addresses another issue, similar but not equal, that is: system does not summarize transactions when you update the G/L.

Installing it, it had the side effect to correct also the Customer issue (Note: the result may change according to specific G/L setup).

As for all the KB fixes, the correction is not retroactive and users should correct wrong vouchers already posted manually. An efficient way to do this activity is the following one:

a) Run the Vendor/Ledger reconciliation report

b) Identify the differences

c) Create and post G/L journals (only for Ledger, not involving Vendors), in order to re-align the G/L and the A/P.

The Finance department users should choose if doing one G/L transaction per each vendor/period or only one transaction per period/accounts Payable ledger account .

Forum Post: RE: Merging SSRS Reports In Dynamics AX 2012

Rosie Jones — Tue, 21 May 2013 09:18:00 GMT

I have written a blog on how I used the Code Compare to Merge SSRS Reports if you are interested in taking a look:

www.k3technical.com/using-code-compare-to-merge-ssrs-reports-in-dynamics-ax-2012

Forum Post: RE: Calling Parent Form Public method in child Form

Sivananth Subramaniam — Tue, 21 May 2013 09:04:00 GMT

Try the below line of code.It should work as you expected.

callerForm.owner().parentMethod();

Blog Post: Using Code Compare to Merge SSRS reports in Dynamics AX 2012

K3 BlogAX — Tue, 21 May 2013 08:59:00 GMT

Recently, I was asked to merge an SSRS report for Dynamics AX 2012 which was modified in the ISP layer with a hotfix which was installed in the SYP layer. The easiest way to do this was to compare the changes between SYS and SYP and then merge with the ISP layer.

The AX Compare Tool allows you to compare two reports at once, but does not allow you to merge changes into the code. This meant I had to export the .xpo for each layer. I then began trying to use several compare tools such as ExamDiff and UltraCompare. Unfortunately, these only did a two way compare. I would compare the SYS and SYP and then manually edit the ISP .xpo in notepad. This was time consuming and potentially error prone. It was not always clear which lines had been inserted and which lines had been moved in the code.

I decided to look for a new tool and found Code Compare (http://www.devart.com/codecompare/).

Here is how it helped me:

1) It has a three way compare, so I could compare ISP, SYP and SYS with all thre layers on the screen at one time.

2) Easy to see which changes have been made in the SYP hotfix.

3) Easy to merge the changes into the ISP layer.

4) Can compare Word By Word, rather than Line By Line, if you have a long text string, making it easier to show what needs to be changed.

5) This tool does not have the ability to know if a line has been moved further down the script. Like many other compare tools, it tries to insert it in one layer and remove from another. However, if you know the field is standard, you have a fair idea, that line has been moved elsewhere. In this case you would delete one change, and then the compare tool reassess the code and asks you to insert the code again into the correct place.

Overall, this is a good tool to compare SSRS Reports in AX, when merging is required. Although it is not an absolutely fool proof solution, it does make the job a lot quicker and easier. Using a 2-way compare tool and notepad, took me a full day with my first report. When I used the Code Compare 3-way compare tool for my second report and it took only 1.5 hours. Whilst the second report had a lot less changes to merge than the first it was definitely a quicker and smoother process. I would recommend this tool for merging SSRS reports in Dynamics AX 2012.

Forum Post: RE: Multiple AX 2012 client instances at the same time

Tommy Skaue — Tue, 21 May 2013 08:29:00 GMT

If I had the time to find the reference, I would, but I can assure you, RTM and R2 is not supported on the same machine. Avoid it or live with the instability and errors.