Related TFS(Team Foundation Server) Articles

TFS Articles:

Now a days I went through TFS. TFS is related to development work and source code management, what makes developer’s life easier.And also helps for support Quality Assurance guidance and validations, testing and all the rest of Application.A developer can view different versions of modifications done by others and more secure other developer code. 

Below links are related to TFS:

1) http://www.dotnetcurry.com/ShowArticle.aspx?ID=120
2) https://www.axug.com/blogs/viral-suthar/2016/01/28/microsoft-dynamics-ax-2012-r3-and-tfs-online
3) https://stoneridgesoftware.com/tfs-code-repository-and-dynamics-ax/
4) http://dev.goshoom.net/en/2012/07/tfs-workspaces-in-ax2012/

Send email notification when there is an update/change to the invoice account on sales order

To am going explore How to setup the email notification for changing any fields:

1) Configure the Email  with below path

 >USMF/System administration/Common/Users/Users
>Option>General> Give Email id(which is in server domain)
>Notification>set the pop up notification (tick)
>Notification > set the email notification (tick)

2)USMF/System administration/Periodic > Alerts>Change Based Alerts

 >Run the batch job for alerts, before that keep the recurrence for running the batch job.
>Set the batch group as Alerts.

3)Goto the batch job  and check the batch job status for below path

>USMF/System administration/Inquiries>batch job

4) Create the alert rule for particular field which you want to change the field

     ex: Invoice account

> Invoice account>RC(right click)>create alert rule
> set the rule for change type
>Check the notification pop box
> check the Email

5) After 4 steps,when changing invoice account , popup notifications and email notification will get with configured Email Id.

Remove the special characters using X++ in AX 2012

Use below code to remove the special character from the string

strRem('string','*')

Sale Order and Purchase Order Tables and Classes

Sale Order classes and Tables:

SalesTableType and SaleslineType classes will get called while creating the Sales Orders.
SalesFormLetter_Confirm
SalesFormLetter_PickingLlst
SalesFormLetter_PackingSlip
SalesFormLetter_Invoice
Classes used to post the sales order at various document status (packing, invoice etc).
Tables:

Sales Table contains all Sales Order headers regardless whether they have been posted or not.
The SalesParmTable and SalesParmLine contains detailed information regarding posting sales headers and Lines.
CustConfirmJour and CustConfirmTrans tables contains all Sales Confirmation headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.
CustPackingSlipJour and CustPackingSlipTrans tables contains all sales Packing Slip headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.
CustInvoiceJour and CustInvoiceTrans tables contains all sales all Sales Invoice headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.

Purchase Order classes and Tables:

PurchTableType and PurchTableLine classes will get called while creating the PurchaseOrders.
PurchFormLetter_PurchOrder
PurchFormLetter_PackingSlip
PurchFormLetter_ReceiptsList
PurchFormLetter_Invoice
classes will be used to post the PurchaseOrder at various document status (packing, invoice etc).
Tables:
PurchTable contains all purchase order headers regardless whether they have been posted or not.
PurchParmTable and PurchParmLine contains detailed information regarding posting Purchase headers and Lines.
VendPackingSlipJour and VendPackingSlipTrans tables contains posted packingslip headers and lines.
VendInvoiceJour and VendInvoiceTrans tables contains all invoiced purchase order headers and Lines.
VendReceiptsJour and VendReceiptsTrans tables contains posted receipt header and lines.
VendPurchOrderJour and VendPurchOrderTrans tables contains Purchase requisition headers and lines.

Joins concept

Joins:

In ax 4 types of joins is there:

1) Inner join : Select the record from Main Table that have matching record form child table. These two records together and gives single record.

2) Outer join : select all records from Main Table and select the related records from child table. If there is no match ,it gives empty value

3)Exist join : select the records from Main table if there is any records matching in child table. It should return only main table not child table records.

4)Not Exist join : select the records from Main Table if there is no matching records in Child Table. opposite of Exist join.

While generating the report BI Services problem.

   While running the SSRS report  got following error

    " BI Services problem"


Solution:

1)  Full CIL Compilation( if not started BI service) then process 2nd step

2) Stop AOS services

3) Delete the XPPIL folder

4) Start the AOS services

Check the BI services as below path

System Administrator> Setup>Application Integration Framework Services>Inbound>BI Servciesl

No report data table with name exists in report schema for data provider

   I was getting the  error message  when  running the report

   "No report data table with name exists in report schema for data provider"

Solution:

     1)  Restart the reporting services

     2)  Clear cache and the usage data

     3)  Restart the AOS