Report 116 Statement filtered on OPEN tbl Cust. Ledger Entry

Sevententh
Sevententh
edited 2011-10-04 in NAV/Navision Classic Client
Hi all,

The details section to Report 116 Statement uses table Detailed Cust. Ledg. Entry
I'm trying to figure out how to relate/join table Cust. Ledger Entry and filter on field 'OPEN' = True


Any help would be great

Comments

  • Koshe
    Koshe
    I don't know if this exactly what you're looking for, but in table Detailed Cust. Ledg. Entry contains field Cust. Ledger Entry No., which show exact ledger entry related to detailed ledg. entry.
  • Sevententh
    Sevententh
    Yes that is correct it does... but I'm unsure how to code this or where...

    in section DtldCustLedgEntries - OnPreDataItem() 
    SETRANGE("Customer No.",Customer."No.");
SETRANGE("Posting Date",StartDate,EndDate);
SETRANGE("Currency Code",Currency2.Code);

    What I need to code is this 
    "Cust. Ledger Entry".SETRANGE(Open, TRUE);
    but how do I get the relationship between the two tables??
  • Koshe
    Koshe
    it depends on the situation. the easiest way would be get(Cust. Ledger Entry No.). What kind of information do you need from Cust. Ledger Entry?

Categories