Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Sunday, June 8, 2014

Customization or completed development of SalesInvoice report in Dynamic AX 2012

Hi,

DP - SalesInvoiceDP
Contract - SalesInvoiceContract
Conttroller - SalesInvoiceController
Temporary Header table - salesInvoiceHeaderFooterTmp
Temporary Header table - salesInvoiceLocalizationTmp
Temporary lines table - salesInvoiceTmp
(Its not tempDB but the records will be deleted once the transaction completes)

Details about DP and explaination of few method
(Not all the method I explaied only mandrantry method)
I added few fields in the lines table and inserted values.


Methods Description Country
generateInvoiceHeaderLocalizationData Populates a SalesInvoiceHeaderFooterTmp record for the Eastern Europe countries. EA
getDataFromContract Initializes data from the contract class. (Overrides the getDataFromContract Method.)  
getInvoiceCount_IN Calculates the invoice count. For line count  
insertCreditNoteSummaryLine_PL Insert the credit note summary line. (Overrides the insertCreditNoteSummaryLine_PL Method.)  
insertDataInSalesInvoiceTmp_IN Inserts data into SalesInvoiceTmp_IN table. Only for India
insertIntoSalesInvoiceHeaderFooterTmp Inserts the invoice header information.  
insertIntoSalesInvoiceLocalizationTmp Inserts the invoice detail information.  
insertIntoSalesInvoiceTmp Inserts the invoice detail information.  
processReport Processes the report business logic. (Overrides the processReport Method.)  
Regards,

Saturday, June 7, 2014

Customization or complete development of Purchase order report in Dynamic AX 2012

Hi,

DP - PurchPurchseOrderDP
Contract - PurchPurchaseOrderContract
Controller - PurchPurchaseOrderController.
Temporary Header table - PurchPurchaseOrderHeader
(Its not tempDB but the records will be deleted once the transaction completes)
Temporary lines table - PurchPurchaseOrderTmp

Details about DP and uses of main method
(Not all the method I explained only mandatory methods)

Method Description
setPurchPurchaseOrderDetails Inserts the record field data into the temporary table. (Here I added my customized line fields in to the table)
setPurchPurchaseOrderHeader Inserts common data into the template table buffer.
in lines table standard passes the values by 1 to 1 relation where as in header by insert_recordset technique fetching from PurchTable

Regards,

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...