Wednesday, July 18, 2018

Dynamics NAV - Update Bank Account - Check entries Report to indicate reconciled status and allow filters


  • Objects:
    • P388 Bank Acc Reconciliation List
      • Add button to runobject R1406
    • R1406 Bank Account - Check Details
      • Check Ledger - On after get record
      • Get Reconciled Status of Bank Line


BLine.SETCURRENTKEY("Entry No.");
BLine.SETFILTER("Entry No.",FORMAT("Check Ledger Entry"."Bank Account Ledger Entry No."));
IF BLine.FIND('-') THEN BEGIN
IF BLine."Statement Line No." > 0 THEN BEGIN
IsReconciled := TRUE;
StmtLine := FORMAT(BLine."Statement Line No.");
END ELSE BEGIN
IsReconciled := FALSE;
StmtLine := '';
END;
END;

No comments:

Post a Comment