Method Community

@Rolf Thanks for the detailed information and I agree that it looks like a date format issue that is causing the error. I would check the format that it passing to the Report Generator and make the report of the same format. I would also check in the date field of the report for the format that is it displaying.  I would modify the ...

@CDS_Josh The fomula looks fine and I built a similiar conditional statement and it is working for me on a couple of test reports. One thing I always recommend is when actually testing the reports design a simple screen that actually generates the report versus just looking at the results in report designer. Are you actually generated it ...

 Thanks Dave, I'll look there. 

 Hi Steveb, Java can invoke and use .NET webservices as needed. I suggest you google something like "java to call a microsoft webservice.", for examples of how to do that. Dave

Hi all, I am attempting to use the Method API for several potential development projects with an RDE which uses Java for connectivity.  I don't think I have a way to imbed VB or .NET code into these programs that I am aware of.  I have successully called other API's with this program using the embedded Java code ...

I just wanted to add here that we default to the last 31 days because syncing a high number of transactions can slow down the use of QuickBooks while the sync occurs.  Best practice is to only pull in a longer date range for specific transactions and not all of them.   ~C

[quote user="micheleh"]Is there a setting that  I need to change?[/quote] It sounds like the Transaction History timing is set too low for your estimates.  By default we only reach back 31 days into your transaction history, longer than this and you'll need to adjust your default settings. Go to the tab Quickbooks > ...

I'm creating a report based on the customer table wherein I extract records that fall within a date range defined by two date picker objects on the screen and one other criteria.  If either or both of those fields are empty, I enter default  start and/or end dates as necessary.  I also save these two date values in a separate ...

Here is an example of what I am talking about (The values with the arrows pointing to them should be a 1 because both criteria are met)    

I am having nightmares with these functions in the Report Designer. Here is a simple formula that is not working and I cannot figure out why: Iif(([CallReport.ComplaintCode] = 'CA' and [CallReport.DateReceived] >= AddDays(Today(),-30)),  1, 0) Can someone help me out with this.  I have been designing reports for almost 15 ...