Dynamics Community Forum Thread Details

Inserting supplementary rows into SalesInvoiceTmp

Hi community,

I have a requirement to insert additional rows into a sales pro forma invoice. These rows are created on the SalesLine table with a 0 quantity thus they have no LotId and standard logic does not insert them into SalesInvoiceTmp.

Below my code to insert said records, I want to confirm that it is safe to call the standard method this.insertIntoSalesInvoiceTmp() in this way, with a in-memory buffer of CustInvoiceTrans.

Since this only applies to pro forma I expect any possible transaction in scope to be rolled back, and from what I can see there is no logic in the insertIntoSalesInvoiceTmp() call stack that would persist the CustInvoiceTrans buffer.

Or would you advise rather writing bespoke logic to insert the required fields directly into SalesInvoiceTmp from the DP_Extension class and to not call this standard insertIntoSalesInvoiceTmp() method.

[ExtensionOf(classStr(SalesInvoiceDP))]
final class ABCSalesInvoiceDP_Extension
{
    public void generateInvoiceRelatedInformation(CustInvoiceJour _custInvoiceJour)
    {
        next generateInvoiceRelatedInformation(_custInvoiceJour);

        if (_custInvoiceJour.isProforma())
        {
            this.abcPopulateSomeItems(_custInvoiceJour);
        }
    }

    private void abcPopulateSomeItems(CustInvoiceJour _custInvoiceJour)
    {
        SalesTable          salesTable = _custInvoiceJour.salesTable();
        SalesLine           SalesLine;
        InventTable         InventTable;
        CustInvoiceTrans    custInvoiceTransBuffer;

        while select SalesLine
        where SalesLine.Field == SomeValue
        {
            custInvoiceTransBuffer.clear();
            custInvoiceTransBuffer.initValue();
            custInvoiceTransBuffer.initFromCustInvoiceJour(_custInvoiceJour);
            custInvoiceTransBuffer.initFromSalesLine(SalesLine);

            this.insertIntoSalesInvoiceTmp(_custInvoiceJour, custInvoiceTransBuffer, null, null, null, null);
        }
    }
}

Categories:

Dynamics 365 Finance

Quick Links

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