invoice no. on customize report

vyanku

When we open the test report of any invoice, the no. filter field automatically gets the current invoice no.

If we create a customize report and run it it will not get the invoice no automatically ,we have to insert it manually.

Can we insert the current invoice no. in the report automatically?

ssingla

Here is an example
CurrForm.SETSELECTIONFILTER(SalesInvHeader)
on the print option of Posted Sales Invoice form.

themave

are you an end user, if so you can not access cal/code in the form unless you have the application designer granule. you can not do it with just the standard forms designer.

so even though you can access cal/code in reports, you can not make the form you are working with feed the no to the report.

if you are a developers then the above example works great.

vyanku

I write this code on OnPush trigger of the button. But it is not working.

Belias

maybe you run the report with Runobject property with the button: if so the code doesn't works. The variable you use in setselectionfilter must be the same as the one you use to run the report. So, you must write in the on push:

currform.setselectionfilter(TBSlsHead);
REPORT.RUNMODAL(INTReportNumber,TRUE 
                              ,FALSE,TBSlsHead);

Make sure you clear the runobj property of the button. The TBslshead variable points to the same table of the current form i.e. "sales invoice header"

vyanku

Thanks .
Its Working Now. \:D/