05-19-2011 6:09 AM
Hi friends,
I'm new to smartforms. I have created a smartform for customer outstanding Report. but have some issues.
That is,
I want to categorize all rows in reports to,
- Unsettled Invoices (Condition is -> BSID-BLART = 'RV' AND BSID-BLART = 'SA')
- Unsettled Advances/Credit Notes (Condition is -> BSID-BLART = 'DZ' AND BSID-BLART = 'DG' AND BSID-UMSKZ = 'A')
- Unsettled return Cheques (Condition is -> BSID-BLART = 'DZ' AND BSID-UMSKZ = 'D' AND BSID-XBLNR = 'R')
This is the download link to my smartform - https://rapidshare.com/files/785255519/zcusrep.xml
please help me someone. Thanks
Moderator Message: Please dont expect the forum to do your work for you. Also, Smartform-related questions belong to Form Printing Forum.
Edited by: kishan P on May 19, 2011 12:06 PM
05-19-2011 7:13 AM
05-19-2011 7:21 AM
could you please ellaborate on "I want to categorize all rows in reports to ..... "
Do you intend to display rows together base don conditions specified? or something else?
05-19-2011 7:31 AM
ya i want to display rows together based on the conditions i specified
for example the output is like this:
Date invoice No Amount No of Days Balance Less30 Over30 Over60 Over90 Over120
Unsettled Invoices
15/03/2010 HHIN00023952 100000 100 750
15/03/2010 HHIN00023952 100000 100 750
15/03/2010 HHIN00023952 100000 100 750
Unsettled Advances/Credit Notes
15/03/2010 HHIN00023952 100000 100 750
15/03/2010 HHIN00023952 100000 100 750
Total 500000
Unsettled Return Cheques
15/03/2010 HHIN00023952 100000 100 750
15/03/2010 HHIN00023952 100000 100 750
Total 200000