Hi Here is the easy way out.
Class BankReport_Reconciliation method showQueryValues. Remove the code from the method and just return a value of true like below. boolean showQueryValues() { ; return true; } And now you can see what is happening when u are running the report. Please do read the disclaimer below *s* Regards harry This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm" The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: 14 March 2006 08:53 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Invalid field error Thanks Harry, I tried what you say and yes can see the fields appear but that does not solve my problem. The report runs and prints all the different bank accounts andstatements but still when it hits the 'problem' transactions it gives the same error :( Thanks James -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry Deshpande Sent: 14 March 2006 17:35 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Invalid field error Hi Yes, I confirmed it. Press contol+n to create a new line and then click on print bank reconciliation (without saving the new line). You will find some new fields in the dialogue box. Clear these field values. Regards harry -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: 14 March 2006 08:26 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Invalid field error Hi Harry, Sorry not quite clear on what you mean. I am not sure if it is syslastvalue as I can run the report on other account statement numbers for the same bank no problem. Its just a few of the account statements cannot and even that those cannot if I change the report code to skip the bankaccounttrans that cause the problem then they also can print.... Thanks James -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry Deshpande Sent: 14 March 2006 16:58 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Invalid field error Hi As far as I remember this is a problem with the syslastvalue. Create a new line in ur bank reco and print a report for this line and then go back to the original one, doing something like this cleared the problem If this does not work then let me know and I will try it out myself. Regards harry -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: 14 March 2006 07:22 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Invalid field error Hi I hope someone has a answer for a frustrating problem in bank recon In the bank reconciliation report for SOME bank statements that I have reconciled I cannot print the 'Bank Reconciliation' report. It will always stop with an error 'Invalid field'. I have debugged and found certain bankaccounttrans records throw the error when the call for send(bankaccounttrans) is made. I have checked the data and cannot see anything wrong/different with these records. I have checked the report object and it is okay. I tried deleting all the fields in the report's bankaccounttrans body section but still get the error Only if I delete the whole bankacccounttrans section does the error not appear for the trans causing the problem (but then of course the report is not much use.) Has anyone else experienced any such behaviour and if so any solutions? I am using Ax3.0SP1 Thanks James [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/