Report 116 Statement filtered on OPEN tbl Cust. Ledger Entry

Sevententh

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

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

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

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?