Sunday, November 15, 2015

Cannot Edit A LIne in SourceDocumentLine....




1.       As checked,  the table “PurchLine” and table “SourceDocumentLine” relation is one-to-one, but a record in SourceDocumentLine don’t have a correspondent purchase line(RecId = 6089).

update SourceDocumentLine
set SourceDocumentHeader = 9999999
where RecId = 6089
2.        I tried to unbind their relation, the PO confirm is can be.

 Conclusion:
              Unbind record SourceDocumentLine relation to PurchLine, then be ok.

Sunday, February 15, 2015

AX SSRS - copy report design from one VS to another VS


Purpose of such action

Scenario:

SSRS Report has alot of report design. If export/import via XPO, may cause AOT to hang, or load too long while importing. This works for situation where you only want to update one report design. Only works where you have access rights to develop in Visual Studio.

Steps:


  1. Open visual studio, browse through the Application Explorer and locate the SSRS > Report, and open the report you required. 
  2. Open only the desired report design, nothing else. 
  3. Select any object, right click and open its properties (textbox properties). Copy the textbox name (for example, textbox123).
  4. In the report designer, find or click Ctrl + f, find any object in the report design, in this case, find "textbox123". It will open the XML code of the report.
  5. Copy the XML code, do the same at the destination Visual Studio, and paste the code there.
copy object name

find object name to open the XML codes