Pl. assist me in designing of sql query as per following details:-
Cust. Ledger Entry
- Entry No.
- Posting Date
- Customer No.
- Document No.
- Date Filter
- Original Amt. (LCY)
- Remaining Amt (LCY)
Innter Join (Cust. Ledger Entry.Entry No. = Detailed Cust. Ledg. Entry.Entry No.)
Detailed Cust. Ledg. Entry - Entry No.
The value of Cust. Ledger Entry.Original Amt.(LCY) should be sum of Detailed Cust. Ledg. Entry.Amount(LCY)
WHERE
Detailed Cust. Ledg. Entry.Cust. Ledger Entry No. = Cust. Ledger Entry.Entry No.
AND
Detailed Cust. Ledg. Entry.Entry Type = Cust. Ledger Entry.Initial Entry
AND
Detailed Cust. Ledg. Entry.Posting Date = Cust. Ledger Entry.Date Filter
The value of Cust. Ledger Entry.Remaining Amt LCY) should be sum of Detailed Cust. Ledg. Entry.Amount(LCY)
WHERE
Detailed Cust. Ledg. Entry.Cust. Ledger Entry No. = Cust. Ledger Entry.Entry No.
AND
Detailed Cust. Ledg. Entry.Posting Date = Cust. Ledger Entry.Date Filter
Fields to be displayed as
Posting Date, Customer No., Document No., Original Amt. (LCY), Remaining Amt (LCY)