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
