topic Re: Smartform Problem in Application Development and Automation Discussions

Smartform Problem

Former Member — Thu, 19 May 2011 05:09:48 GMT

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')

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

Former Member — Thu, 19 May 2011 06:13:01 GMT

please help me someone..

Former Member — Thu, 19 May 2011 06:21:05 GMT

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?

Former Member — Thu, 19 May 2011 06:31:32 GMT

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

Unsettled Advances/Credit Notes

15/03/2010 HHIN00023952 100000 100 750

Total 500000

Unsettled Return Cheques

15/03/2010 HHIN00023952 100000 100 750

Total 200000