Skip to Content
0
Former Member
Apr 10, 2014 at 03:08 PM

QUERY FOR CUSTOMERS FULL DEBIT AND CREDIT WITH CLOSING BALANCE

56 Views

Hi Friends,

I need query for CUSTOMERS FULL DEBIT AND CREDIT WITH CLOSING BALANCE for selection criteria from date and to date.

I know the Trial Balance Report will sort out this issue... but i need routeday wise report

1. Business Partner Master Data - i created one UDF field called U_Routeday (MONDAY, TUESDAY, WEDNESDAY,THURSDAY,FRIDAY)

2. The query should be like selection criteria

- Routeday [%0]

- Posting Date [%1]

- Posting Date [%2]

CardCode Debit Credit Balance D10503 25031.50 24711.50 2962.00 D10641 5466.00 7460.00 285.00 D10642 2866.00 142.00

give any helpful query ASAP... Thanks in advance