Dynamics Community Forum Thread Details

How to Invoice multiple sales order with single InvoiceId using SalesFormLetter?

Hello everyone,

I have tried multiple ways to invoice multiple sales orders combined. How to achieve this through code.

Here is my final approach. It is Invoicing separately, not a single invoice.

public static void main(Args _args)
    {
        SalesFormLetter salesFormLetter;
        SRSPrintDestinationSettings printSettings;
        SysQueryRun queryRun;
        QueryBuildRange queryRange;
        Query query;
        str strSalesTable = "SO-D00000222, SO-D00000223";
        ;

        salesFormLetter = SalesFormLetter::construct(DocumentStatus::Invoice);
		
        query = new Query(QueryStr(SalesUpdate));
        queryRange = query.dataSourceTable(tablenum(SalesTable)).addRange(fieldnum(SalesTable, SalesId));
        queryRange.value(strSalesTable);

        queryRun = new SysQueryRun(query);

        salesFormLetter.chooseLinesQuery(queryRun);
        salesFormLetter.transDate(systemdateget());
        salesFormLetter.specQty(SalesUpdate::All);
        salesFormLetter.sumBy(AccountOrder::Account);
        salesFormLetter.showQueryForm(false);
        salesFormLetter.printFormLetter(true);
        
        
        //salesFormLetter.reArrange();
        
        salesFormLetter.chooseLines();

        salesFormLetter.run();
    }

What am I doing wrong? Please help me!

Regards,

Khurshid Wali

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL