Dynamics Community Forum Thread Details

How to mark Vendor open settlement transaction using x++ in D365fo

By clicking on 'Settle transactions,' the system will automatically display only the invoices linked to my specific table that have a relationship with the selected LedgerJournalTrans and mark them for settlement
I tried the code, but it doesn't work

[ExtensionOf(formStr(VendOpenTrans))]

final class GTCVendOpenTrans_Form_Extension

{

    public void init()

    {

        VendTrans VendTrans;

        VendTransOpen vendTransOpen;

        GTCLCInvoiceLink LCInvoiceLink;

        LedgerJournalTrans ledgerJournalTrans;

        SpecTransManager specTransManager;

        SpecTransExecutionContext specTransExecutionContext;

        CustTransSettleTransactionParameters settleParams;

next init();

FormDataSource formeDataSource = this.VendTransOpen_ds;

        if (originator.TableId == tableNum(LedgerJournalTrans))

        {

            ledgerJournalTrans = originator;

        }

        if (ledgerJournalTrans)

        {

            QueryBuildDataSource vendTransQbds = VendTrans_ds.query().dataSourceTable(tableNum(VendTrans));

            List invoiceList = new List(Types::String);

            if (vendTransQbds)

            {

                while select GTCInvoice from LCInvoiceLink

                    where ledgerJournalTrans.GTCLCCode == LCInvoiceLink.GTCLCCode

                {

                    QueryBuildRange invoiceRange = vendTransQbds.addRange(fieldNum(VendTrans, Invoice));

                    invoiceRange.value(LCInvoiceLink.GTCInvoice);
  ttsbegin;
// If transactions were marked, write back to originating record if needed
manager.updateOriginatorForMarkedTrans();

// update all SpecTrans records with date used to calculate discount
manager.updateSpecTransWithSelectedDate();
ttscommit;
}}}