Dynamics Community Forum Thread Details

Populate value from PO form into VendEditInvoice form

Hi Andre,

FYI, I'm working on AX 2012 R3 ya, not in D365 F&O. Let me start from beginning what I wan to achieve on VendEditInvoice form.

I had some 1 custom table on PurchTable and 1 custom table on PurchLine link by their RecId respectively as foreign keys. So when user convert the PO to Invoice. I wanted to copy the value of my field both table to VendtInvoiceInfoTable and VendnvoiceInfoLine table, as I had created custom field on both table as well.

So far, now I managed to copy the value from my custom table on PurchTable into VendEditInvoiceTable, but not on VendEditInvoiceLine table.

On the left hand, the highlighted field is my custom table on PurchLine which link to purchline.recid in my custom table. So when user convert it to invoice for this PO, I wanted to copy the value into right hand form which is the VendnvoiceInfoLine Table on VendEditInvoice form. The field is already added on VendnvoiceInfoLine table.

Below is the code that used in Insert method of VendInvoiceInfoLine table.

/// <summary>
/// Optionally sets the status of the corresponding <c>PurchLine</c> to be set to Open order as there
/// is a saved pending invoice against the <c>PurchLine</c>.Optionally activates the Purchase Request
/// workflow.Create a <c>SourceDocumentLine</c>.
/// </summary>
/// <param name="_defaultRelatedTables">
/// True if related tables should be defaulted on insert; otherwise false. This parameter would
/// typically be false when <c>VendInvoiceInfoLine</c>records are copied between the saved and active
/// images of this document.
/// </param>
/// <remarks>
/// Inserting will cause the status of the corresponding <c>PurchLine</c> table to be set to open order
/// as there is a saved pending invoice against the <c>PurchLine</c> table.
/// </remarks>
public void insert(boolean _defaultRelatedTables = true)
{
    PurchLine               purchLine;
    VendInvoiceInfoTable    vendInvoiceInfoTable = this.vendInvoiceInfoTable();
    //Custom Code added 09/07/2024
    MyCustomTable myCustomTable;
    //Custom Code
    ttsbegin;

    // Insert and reference a source document line
    SourceDocumentProcessorFacade::submitSourceDocumentLineImplementation(this);
    
    
    super();

    this.SysExtensionSerializerMap::postInsert();

    if (this.DocumentOrigin != DocumentOrigin::Service)
    {
        // Only delete tax information if the invoice line is not being inserted via AIF.
        TaxUncommitted::deleteForDocumentHeader(vendInvoiceInfoTable.TableId, vendInvoiceInfoTable.RecId);

        // Delete tax Withhold information.
        if (TaxWithholdParameters_IN::checkTaxParameters())
        {
            TaxWithholdUncommitted_IN::deleteForDocumentHeader(vendInvoiceInfoTable.TableId, vendInvoiceInfoTable.RecId);
        }
    }

    // Update header round-off amounts.
    vendInvoiceInfoTable.updateFromVendLines();

    if (_defaultRelatedTables)
    {
        if (this.isNonPO())
        {
            this.createMarkupTrans(this.vendInvoiceInfoTable());

            VendInvoiceInfoLine_Asset::createVendInvoiceInfoLine_Asset(this).insert();
        }
        else
        {
            purchLine = PurchLine::findInventTransId(this.InventTransId, true);

            if (purchLine.RecId !=0)
            {
                purchLine.setPurchStatus(true);

                //COR submit to workflow
                if(purchLine.PurchaseType == PurchaseType::Purch)
                {
                    if(purchLine.calcPendingMatchedQtyPurch() < purchLine.calcPendingQtyPurch())
                    {
                        PurchCORInvReceivedWorkflow::submit(purchLine);
                    }
                }
                //Custom Code added 09/07/2024
                myCustomTable=MyCustomTable::findPurchLine(this.PurchLineRecId);
                this.myCustomField=myCustomTable.myCustomFld;
                //Custom Code
            }
        }
    }

    // <PubSect>
    if (this.isActive())
    {
        this.updateVendInvoiceProjectFromBudgetRes(true, false);
    }
    // </PubSect>

    // <GTE>
    if (TaxSolutionScopeIntegrationUtil::isCompanyEnabled())
    {
        this.markCurrentTaxDocumentTaxStatusDirty();
    }
    // </GTE>

    ttscommit;
}

//Custom Code added 09/07/2024
MyCustomTable myCustomTable;
//Custom Code

//Custom Code added 09/07/2024
myCustomTable=MyCustomTable::findPurchLine(this.PurchLineRecId);
this.myCustomField=myCustomTable.myCustomFld;
//Custom Code

I using similar code on the FormDatasource write method or InitFromPurchline method on VendInvoiceInfoLine table. But still no luck.

Thanks.

Regards,
Teh

Quick Links

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