Hi, i have to create a report which shows me the sucess of reminding our customers. Dataitem=Issued Reminder Line globals: Name DataType Subtype Length Mahnkopf Record Issued Reminder Header debitposten Record Cust. Ledger Entry Trigger On After Get Record Mahnkopf.GET(“Reminder No.”); debitposten.SETCURRENTKEY(“Document No.”,“Document Type”,“Customer No.”); debitposten.GET(“Issued Reminder Line”.“Document No.”,“Issued Reminder Line”.Type,Mahnkopf.“Customer No.”); Now the Problem is, that the report breaks at debitposten.get(…), because the tablekey is set to Entry No. I don´t know how to fix it. best regards Michael
The GET function only works with the primary key. On your case, you will a to set filters (SETRANGE or SETFILTER) and use the function FIND(’-’). debitposten.SETCURRENTKEY(“Document No.”,“Document Type”,“Customer No.”); debitposten.SETRANGE(“Document No.”, “Issued Reminder Line”.“Document No.”); debitposten.SETRANGE(“Document Type”, “Issued Reminder Line”.Type); debitposten.SETRANGE(“Customer No.”, Mahnkopf.“Customer No.”); IF debitposten.FIND(’-’) THEN BEGIN //Manage the possibility of finding more than 1 record with the same values END;