Method Community

 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 ...

I had everything working fine and with ZERO changes to the above formulas, now it is no loner working correctly.  It just groups everything in "<= 30 Days".  I did not change a thing and it just stops working. Can we open this thread back up for suggestions?

Thanks that worked great

I figured out a difference approach.  I created 3 Date Fields using the AddDay function for 30,60,90 days ago and then made my formula based off that. I really wanted to see the DATEDIFF fuction get incorporated because this is a great tool for aging reports. Thanks anyways.  I think I figure out what I need!! Here is my code for ...