AP Account Statement report

(1) Share

Report

Posted on by faiz7049

2,302

Hi Experts,

In Account Payable, I want to add PurchId in account statement report using below code.

But PuchId is not showing correct. Could you help me what missing in code.

internal final class AT_CustVendAccountStatementTmp_EventHandler
{
    /// <summary>
    ///
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    [DataEventHandler(tableStr(CustVendAccountStatementIntTmp), DataEventType::Inserted)]
    public static void CustVendAccountStatementIntTmp_onInserted(Common sender, DataEventArgs e)
    {
    }

    /// <summary>
    ///
    /// </summary>
    /// <param name="args"></param>
    [PostHandlerFor(classStr(VendAccountStatementIntDP), methodStr(VendAccountStatementIntDP, processReport))]
    public static void VendAccountStatementIntDP_Post_processReport(XppPrePostArgs args)
    {
        VendInvoiceJour     vendInvJr;
        VendAccountStatementIntDP dpInstance = args.getThis() as VendAccountStatementIntDP;
      
        CustVendAccountStatementIntTmp custVendAccountStatementIntTmp = dpInstance.getCustVendAccountStatementIntTmp();
        ttsbegin;
        while select forUpdate custVendAccountStatementIntTmp
        {
            select vendInvJr where vendInvJr.LedgerVoucher == custVendAccountStatementIntTmp.Voucher
                && vendInvJr.InvoiceDate == custVendAccountStatementIntTmp.TransDate && vendInvJr.InvoiceAccount == custVendAccountStatementIntTmp.AccountNum;

            custVendAccountStatementIntTmp.DocumentNum  =   vendinvjr.PurchId;
           
            custVendAccountStatementIntTmp.update();
        }
        ttscommit;
    }

}

Thanks,

Faiz

Categories:

Dynamics 365 Supply Chain Management

All responses (4)

Answers (1)

Verified answer

faiz7049 2,302 on at

Like (1)

Report

AP Account Statement report

Hi Andre and Amine,

Issue has been resolved. The problem was in Purchase order there the invoice account and vendor code were different from each other.
Suggested answer

Mohamed Amine Mahmoudi 24,520 Super User 2025 Season 1 on at

Like (0)

Report
AP Account Statement report

Hi @faiz7049,

Try this code :

while select forUpdate custVendAccountStatementIntTmp { vendInvJr = VendInvoiceJour::findFromVendTrans(custVendAccountStatementIntTmp.Invoice, custVendAccountStatementIntTmp.TransDate, custVendAccountStatementIntTmp.AccountNum, false, custVendAccountStatementIntTmp.Voucher); if(!vendInvJr) { vendInvJr = VendInvoiceJour::findFromVendTrans(custVendAccountStatementIntTmp.Invoice, custVendAccountStatementIntTmp.TransDate, custVendAccountStatementIntTmp.InvoiceAccount, false, custVendAccountStatementIntTmp.Voucher); } custVendAccountStatementIntTmp.DocumentNum = vendinvjr.PurchId; custVendAccountStatementIntTmp.update(); }

Best regards,

Mohamed Amine MAHMOUDI
André Arnaud de Cal... 296,042 Super User 2025 Season 1 on at

Like (0)

Report

AP Account Statement report

Hi Faiz,

When reading your reply, I wonder of you already found the culprit or is there a pending question?
faiz7049 2,302 on at

Like (0)

Report

AP Account Statement report

Thank. Code is working only issue was there were different account for vendor account and invoice account in purchase order.

Community site session details

AP Account Statement report

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates

Community site session details

AP Account Statement report

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates