SAVE REPORT TO PDF FROM AX JOB CONTROLLER CLASS : VIKAS MEHTA HOW TO CALL A REPORT FROM JOB AND SAVE IT IN PDF

SAVE REPORT TO PDF FROM AX JOB CONTROLLER CLASS : VIKAS MEHTA

HOW TO CALL A REPORT FROM JOB AND SAVE IT IN PDF

public static void SaveReportToPDFFromController(Args _args)

{

    VIKSalesInvoiceFinanceController  salesInvoiceController;

    VIKSalesInvoiceFinanceContract    salesInvoiceContract;

    Args                    args = new Args();

    SrsReportRunImpl        srsReportRun;

    CustInvoiceJour         custInvoiceJour;

    SRSReportExecutionInfo  reportExecutionInfo;

    ReportName              reportName = "VIKSalesFinance.PrecisionDesign1";//PrecisionDesign1_backup

    #define.ReportName('VIKSalesFinance.PrecisionDesign1')

    ;

    //SRSReportExecutionInfo = new SRSReportExecutionInfo();d

    select firstOnly custInvoiceJour where custInvoiceJour.SalesId == "1234”;

    args.record(custInvoiceJour);

    salesInvoiceController = new VIKSalesInvoiceFinanceController();

    salesInvoiceController.parmReportName(reportName);

    reportExecutionInfo = salesInvoiceController.parmReportContract().parmReportExecutionInfo() as SrsPrintMgmtExecutionInfo;

    if (!reportExecutionInfo)

    {

       reportExecutionInfo = new SrsPrintMgmtExecutionInfo();

    }

    //reportExecutionInfo.parmOriginalDestinationFileName("c:\\SalesInvoice.pdf");

    salesInvoiceContract = salesInvoiceController.parmReportContract().parmRdpContract();

    salesInvoiceContract.parmReportCopyName('');

    salesInvoiceContract.parmTenderTypeId('21');

    salesInvoiceContract.parmInvoiceId(custInvoiceJour.InvoiceId);

    salesInvoiceContract.parmSalesId(custInvoiceJour.SalesId);

  //  salesInvoiceContract.

   // salesInvoiceContract.parmRecordId(custInvoiceJour.RecId); // Record id must be passed otherwise the report will be empty

   // salesInvoiceContract.parmInvoiceIdparm(custInvoiceJour.RecId); // Record id must be passed otherwise the report will be empty

    salesInvoiceController.parmArgs(args);

    salesInvoiceController.parmReportName(#ReportName);

    salesInvoiceController.parmDialogCaption("Sales Finance Invoice");

     args.parm(strFmt("Copy - 1"));

    srsReportRun = salesInvoiceController.parmReportRun() as SrsReportRunImpl;

    salesInvoiceController.parmReportRun(srsReportRun);

    salesInvoiceController.parmReportContract().parmReportExecutionInfo(reportExecutionInfo);

    salesInvoiceController.parmReportContract().parmPrintSettings().printMediumType(SRSPrintMediumType::File);

    salesInvoiceController.parmReportContract().parmPrintSettings().overwriteFile(true);

    salesInvoiceController.parmReportContract().parmPrintSettings().fileFormat(SRSReportFileFormat::PDF);

    salesInvoiceController.parmReportContract().parmPrintSettings().fileName("c:\\test123\\SREPORT.pdf");

    salesInvoiceController.runReport();

}

static void SaveReportToPDFFromController(Args _args)

{

    SalesInvoiceController  salesInvoiceController;

    SalesInvoiceContract    salesInvoiceContract;

    SRSPrintDestinationSettings     settings;

    Args                    args = new Args();

    SrsReportRunImpl        srsReportRun;

    CustInvoiceJour         custInvoiceJour;

    ReportName              reportName = "SalesInvoice.Report";

    ;

    select firstOnly custInvoiceJour where custInvoiceJour.invoiceid == "sid";

    args.record(custInvoiceJour);

    salesInvoiceController = new SalesInvoiceController();

    salesInvoiceController.parmReportName(reportName);

    salesInvoiceContract = salesInvoiceController.parmReportContract().parmRdpContract();

    salesInvoiceContract.parmRecordId(custInvoiceJour.RecId); // Record id must be passed otherwise the report will be empty

  //  salesInvoiceContract.parmCountryRegionISOCode(SysCountryRegionCode::countryInfo()); // comment this code if tested in pre release

    salesInvoiceController.parmArgs(args);

    srsReportRun = salesInvoiceController.parmReportRun() as SrsReportRunImpl;

     salesInvoiceController.parmReportName(ssrsReportStr(VIKSalesFinance, PrecisionDesign1));

    // Use execution mode appropriate to your situation

  //  salesInvoiceController.parmExecutionMode(SysOperationExecutionMode::ScheduledBatch);

    // Suppress report dialog

    salesInvoiceController.parmShowDialog(false);

    salesInvoiceController.parmReportRun(srsReportRun);

    salesInvoiceController.parmReportContract().parmPrintSettings().printMediumType(SRSPrintMediumType::File);

    salesInvoiceController.parmReportContract().parmPrintSettings().overwriteFile(true);

    salesInvoiceController.parmReportContract().parmPrintSettings().fileFormat(SRSReportFileFormat::PDF);

    salesInvoiceController.parmReportContract().parmPrintSettings().fileName("c:\\VIKAS\\sdc.pdf");

    settings = salesInvoiceController.parmReportContract().parmPrintSettings();

    settings.printMediumType(SRSPrintMediumType::File);

    settings.fileFormat(SRSReportFileFormat::PDF);

    settings.fileName(@'c:\\TEST\1234.pdf');

    salesInvoiceController.startOperation();

}

p EXPORT TO CSV WITH DATE DIRECT JOB X++ : VIKAS MEHTA :MICROSOFT DYNAMICS AX X++ CODE

EXPORT TO CSV DIRECT JOB X++ WITH DATE : VIKAS MEHTA

public static void export2csvInvJourTrans(InventJournalId _invJournalId)

{

    container           con, conHeader;

    InventJournalTrans  invJourTrans;

    InventJournalTable  invJourTable;

    InventDim           invDim;

    CommaIo              io;

    Dialog              dialog;

    DialogField         dlgFileName;

    Filename            csvfileName;

    FileIOPermission    permission;

    int                 recordCount = 0;

    SysOperationProgress exportprogress = new SysOperationProgress();

    #File

    #AviFiles

    ;

    try

    {

        exportprogress.setCaption("Exporting journal lines to CSV file....");

        exportprogress.setAnimation(#AviTransfer);

        // Header Column

        conHeader = ["JournalId","Date","ItemId","Description","LineNum","Site","Warehouse","Location","SerialNumber","OnHand","Counted","Quantity"];

        dialog = new Dialog("Export to CSV");

        dialog.filenameLookupFilter(["Excel Files","*.csv"]);

        dlgFileName = dialog.addField(extendedTypeStr(FilenameSave),"File Name");

        if(dialog.run())

        {

            csvfileName = dlgFileName.value();

            if(csvfileName)

            {

                permission = new FileIOPermission(csvfileName,#io_write);

                permission.assert();

                io = new CommaIo(csvfileName,#io_write);

                io.inFieldDelimiter(',');

                if(!io || io.status() != IO_Status::Ok)

                {

                    throw error("Error in opening file!");

                }

                // Write the header column

                io.writeExp(conHeader);

                invJourTable = InventJournalTable::find(_invJournalId);

                if(!invJourTable.Posted)

                {

                    recordcount = 1;

                    while select * from invJourTrans where invJourTrans.JournalId == _invJournalId

                    {

                         // Create rows

                        invDim   = InventDim::find(invJourTrans.InventDimId);

                        con= [ _invJournalId,

                               date2str(invJourTrans.TransDate,123,-1,-1,-1,-1,-1),

                               invJourTrans.ItemId,

                               invJourTrans.itemName(),

                               invJourTrans.LineNum,

                               invDim.InventSiteId,

                               invDim.InventLocationId,

                               invDim.wMSLocationId,

                               invDim.inventSerialId,

                               num2str(invJourTrans.InventOnHand,1,2,1,0),

                               num2str(invJourTrans.Counted,1,2,1,0),

                               num2str(invJourTrans.Qty,1,2,1,0)

                            ];

                        io.writeExp(con);

                        recordCount++;

                    }

                }

                CodeAccessPermission::revertAssert();

            }

            else

            {

                info("Invalid file name specified!");

            }

        }

    }

    catch(Exception::Error)

    {

        throw error("Erorr in exporting journal lines.");

    }

}

PURCHASE ORDER CATEGORY PRODUCT RECEIPT CALLER CLASS

Purchase category

1.       PO invoice and product receipt

Changes have been done in the forms clicked ok methods of post and close ok

Blow is code for product receipt

// po category start

    VendPackingSlipJour         vendPackingSlipJour;

    Vik_PurchaseOrderCategory   poCategory;

    int                         daydiff,prodreceiptcount;

    PurchTable                  purchTableLocal;

    if(curext() == 'SDS')

    {

        if( classidget(purchFormLetter) == classnum(PurchFormLetter_PackingSlip)) //&& (purchTable.Vik_PurchaseCategory != Vik_PurchaseCategory::None))

        {

            select purchTableLocal where purchTableLocal.PurchId == purchFormLetter.purchTable().PurchId;

            select poCategory where poCategory.Vik_PurchaseCategory == purchTableLocal.Vik_PurchaseCategory;

            select count(RecId) from vendPackingSlipJour where vendPackingSlipJour.PurchId == purchTableLocal.PurchId;

            prodreceiptcount = int642int(vendPackingSlipJour.RecId);

            if(prodreceiptcount > poCategory.DeliveryTimes)

                throw error(strFmt(" The Product receipt for Purchase Order %1 has exceeded for the category %2",purchTableLocal.PurchId,purchTableLocal.Vik_PurchaseCategory));

        }

    }

 //   po category end

Below is code for Invoice

void clicked()

{

    // po category start

    Vik_PurchaseOrderCategory   poCategory;

    int                         daydiff,prodreceiptcount;

    PurchTable                  purchTableLocal;

    if(curext() == 'SDS')

    {

        select purchTableLocal where purchTableLocal.PurchId == purchFormLetter.purchTable().PurchId;

        if( classidget(purchFormLetter) == classnum(PurchFormLetter_Invoice) && (purchTable.Vik_PurchaseCategory != Vik_PurchaseCategory::None))

        {

           

            select poCategory where poCategory.Vik_PurchaseCategory == purchTableLocal.Vik_PurchaseCategory;

          //  daydiff = purchTableLocal.createdDateTime - DateTimeUtil::getSystemDateTime();

            daydiff = DateTimeutil::getDifference(DateTimeUtil::getSystemDateTime(), purchtablelocal.createddatetime) / 86400;

            if(daydiff > poCategory.ExpireDays)

                throw error(strFmt(" The Purchase Order %1 has exceeded the expire days for the category %2",purchTableLocal.PurchId,purchTableLocal.Vik_PurchaseCategory));

        }

    }

 //   po category end

    // <GEERU>

    if (SysCountryRegionCode::isLegalEntityInCountryRegion([ #isoRU ]) && ! purchFormLetter.checkBeforePost())

    {

        return;

    }

    // </GEERU>

    super();

}