I am customizing the sales invoice report for the role tailored client,
in this case, i have to show the payment detail for the sales invoice,
for example, invoice# 1, customer #c1.
Amount = 245, the customer paid the part payment 50 bucks,
in the cust. ledger entry table, the record inserted when this payment done.
and in the Detailed Cust. Ledg. Entries table it also updated.
in the classic report i achieved this by adding two dataitems cust. ledge. entry tbl and detailed cust. ledger entry table....
sales invoice header table:->customer no.
sales invoice header table:->no.(invoice no.)
cust. ledger entry table:->customer no.
cust. ledger entry table:->Document No.(invoice no.)
cust. ledger entry table:-> entry no.
Detailed cust. ledg. entry table:->cust. ledger entry no.
now i want to show this detail in the rtc how can i achieve this?
Sr. Software Engineer