Override standard report with custom report in India GST taxes Invoice report in D365FO:

Override standard report with custom report in India GST taxes Invoice report in D365FO:
We came across the scenario where we have to skip the standard Report and call our customized Report:
·         Standard GST reportName is set in the setReportName() method. And it is a private method, so can’t be overridden in COC.
·         We had handled it by storing Boolean flag in the Global Cache and skip the setReportMethod() execution by returning false in the  [PostHandlerFor(classStr(SysCountryRegionCode), staticMethodStr(SysCountryRegionCode, isLegalEntityInCountryRegion))] method.
·         Custom reportName is set in outputReport() method in the extension class HSOSalesInvoiceController_IN_Extension.

[ExtensionOf(classStr(SalesInvoiceController))]
final class HSOSalesInvoiceController_IN_Extension
{
    protected void outputReport()
    {
        boolean skipReportNameINMethod;
       
        #ISOCountryRegionCodes

        if (SysCountryRegionCode::isLegalEntityInCountryRegion([#isoIN]))
        {
            FormLetterReport    formLetterReportLoc = formLetterReport;
            PrintMgmtPrintSettingDetail printSettingDetailLoc = formLetterReport.getCurrentPrintSetting();

            CustInvoiceJour custInvoiceJourLoc = this.parmArgs().record();

            if (this.parmArgs().menuItemName() == menuitemOutputStr(HSOBillOfSupply_IN))
            {
                this.parmReportName(ssrsReportStr(HSOBillOfSupplyReport_IN, BillOfSupplyReport));
                isGSTInvoice = false;
            }
            else if(this.parmArgs().menuItemName() == menuitemOutputStr(HSOTaxInvoice_IN))
            {
                if (custInvoiceJourLoc.SalesId != "")
                {
                    this.parmReportName(ssrsReportStr(HSOSalesTaxInvoiceReport_IN, SalesInvoiceTaxReport));
                    isGSTInvoice = false;
                }
                else
                {
                    this.parmReportName(ssrsReportStr(HSOSalesTaxInvoiceFTIReport_IN, SalesInvoiceTaxFTIReport));
                    isGSTInvoice = false;
                }
            }
            else if (this.parmArgs().menuItemName() == menuitemOutputStr(HSOSalesCreditNote_IN))
            {
                if (custInvoiceJourLoc.SalesId != "")
                {
                    this.parmReportName(ssrsReportStr(HSOSalesCreditNoteReport_IN, SalesCreditNoteReport));
                    isGSTInvoice = false;
                }
                else
               {
                    this.parmReportName(ssrsReportStr(HSOSalesCreditNoteReport_IN, SalesCreditNoteFTIReport));
                    isGSTInvoice = false;
                }
            }
            else if (this.parmArgs().menuItemName() == menuitemOutputStr(HSOSalesDebitNote_IN))
            {
                this.parmReportName(ssrsReportStr(HSOSalesDebitNoteReport_IN, SalesDebitNoteFTIReport));
                isGSTInvoice = false;
            }
            else if (this.parmArgs().menuItemName() == menuItemOutputStr(SalesInvoice) && this.parmArgs().callerName() == classStr(SalesInvoiceJournalPrint))
            {
                CustInvoiceJour_IN    custInvoiceJour_IN = CustInvoiceJour_IN::findByCustInvoiceJour(custInvoiceJour.RecId);

                if (custInvoiceJour_IN.HSOSalesTaxInvoice_IN == NoYes::Yes)
                {
                    this.parmReportName(ssrsReportStr(HSOSalesTaxInvoice_IN, SalesTaxInvoice_IN));
                    isGSTInvoice = false;
                }
                else if (custInvoiceJour_IN.HSOFreeofCostInvoice_IN == NoYes::Yes)
                {
                    this.parmReportName(ssrsReportStr(HSOSalesTaxInvoice_IN, FOCInvoice_IN));
                    isGSTInvoice = false;
                }
                else if (custInvoiceJour_IN.HSOSampleInvoice_IN == NoYes::Yes)
                {
                    this.parmReportName(ssrsReportStr(HSOSalesTaxInvoice_IN, SampleInvoice_IN));
                    isGSTInvoice = false;
                }
            }
            else
            {
                if (this.parmArgs().menuItemName() == menuItemOutputStr(HSOSalesTaxInvoice_IN))
                {
                    this.parmReportName(ssrsReportStr(HSOSalesTaxInvoice_IN, SalesTaxInvoice_IN));
                    isGSTInvoice = false;
                }
                else if (this.parmArgs().menuItemName() == menuItemOutputStr(HSOFreeofCostInvoice_IN))
                {
                    this.parmReportName(ssrsReportStr(HSOSalesTaxInvoice_IN, FOCInvoice_IN));
                    isGSTInvoice = false;
                }
                else if (this.parmArgs().menuItemName() == menuItemOutputStr(HSOSampleInvoice_IN))
                {
                    this.parmReportName(ssrsReportStr(HSOSalesTaxInvoice_IN, SampleInvoice_IN));
                    isGSTInvoice = false;
                }
            }
            printSettingDetailLoc.parmReportFormatName(this.parmReportName());
        }

        skipReportNameINMethod = true;
   
        SysGlobalObjectCache cache = TaxSolutionScopeIntegrationUtil::getCacheObject();
        cache.insert(
                TaxSolutionScopeIntegrationUtil::companyEnableScope,
                ['HSOSalesInvoiceController_IN_Extension'],
                [skipReportNameINMethod]);
       
        next outputReport();
    }

    /// <summary>
    ///
    /// </summary>
    /// <param name="args"></param>
    [PostHandlerFor(classStr(SysCountryRegionCode), staticMethodStr(SysCountryRegionCode, isLegalEntityInCountryRegion))]
    public static void SysCountryRegionCode_Post_isLegalEntityInCountryRegion(XppPrePostArgs args)
    {
        boolean skipReportNameINMethod;
        SysGlobalObjectCache cache = TaxSolutionScopeIntegrationUtil::getCacheObject();

        [skipReportNameINMethod] = cache.find(
                TaxSolutionScopeIntegrationUtil::companyEnableScope,
                ['HSOSalesInvoiceController_IN_Extension']);

        if (skipReportNameINMethod)
        {
            TaxSolutionScopeIntegrationUtil::getCacheObject().remove(TaxSolutionScopeIntegrationUtil::companyEnableScope,
                                                                ['HSOSalesInvoiceController_IN_Extension']);

            args.setReturnValue(false);
        }

    }

}

Thanks
Dynamics 365 Learner

Comments

Post a Comment

Popular posts from this blog

Identifying the Database Synchronization Issue in D 365 FO

Image
Identifying the Database Synchronization Issue in D365FO I came across a scenario where I was able to build the environment (Did full build of the environment i.e all the models) but was getting the synchronization error everytime. You can refer to the below screenshot for error list. Error List: (1) System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation,---> System.InvalidOperationException: An exception was encountered while initializing chain of command initializer,see event viewer for the detailed information. (2) Syncengine.exe exited with code -1. Solution to recreate the issue : After doing the full build of the environment also I was getting the synchronization issue. So to identify this error I checked into the event viewer. In event viewer I followed the following steps to come across the issue. Step(1) Open the event viewer and right click and run as  administrator. In the event viewer go to the Microsoft folder
Read more

Steps to create new cheque layout in D365 FO

Image
Step1. Extend the Standard BaseEnum as ChequeFormType with proper naming convention say (ChequeFormType.SAGlobalExtension) Step(2) - Duplicate the standard menu item Cheque_US as SAGCheque_TEPL_SCB and set the property of the menu item as given in the screenshot. Step(3) - Now duplicate the report Cheque_US as SAGCheque_TEPL_SCB and call this report in the controller class extension. Step(4). Following classes need to be modified to support the new Cheque layout in Extension. (1)add extension class for existing BankChequePrint class and add below logic.   [ ExtensionOf ( classStr ( BankChequePrint ))] final class SAGBankChequePrint_Extension {     protected str determineReportMenuOutput( ChequeFormType _chequeFormType)     {         str menuOutput = next determineReportMenuOutput(_chequeFormType);               switch (_chequeFormType)         {             case ChequeFormType ::SAGStyle :                 menuOutput =
Read more

SSRS Reports using the QueryInsertRecordSet in D 365 FO

                                               Logic for Report Using QueryInsertRecordSet: I used QueryInsertRecordSet that will insert the data in one trip and it is faster than insert recordset  and also we are not using the contract class and it works fine. The Key point here is that we have to make the Report Data Set Property(Dynamics Filters to True) to make the logic working. This is required to access the DP class query in the controller class. Printing the report for selected record in the SalesQuotationJournal. [ SRSReportQueryAttribute(queryStr(SalesQuotationQuery)) ] class gbSalesQuotationDP extends SrsReportDataProviderPreProcessTempDB { SalesQuotationTmpTable  salesQuotationTmpTable; CustQuotationJour  custQuotationJour; CustQuotationTrans  custQuotationTrans; /// <summary> /// /// </summary> private void addInsertFieldMapping(QueryBuildFieldList _fieldList, Map _fieldMapping, int _sourceTableUniqueId, FieldId _sourceFieldId, FieldName _sourc
Read more