Method Community

HI Greg, I read your original post and it got me thinking about how I might solve this problem, thought I'd share. Much of this overlaps with Chad's comments:   - What you're describing is a many-to-many relationship, not a one-to-many. As you said, one FSR can have many calls, but one call can also have many FSRs.  - The ...

@Greg From the information given I have the following recommendations : Initially set a Result action to the lowest Call#. Loop through the Grid/Table and compare the Result against the Value of the Row If the value from row > Result then change the Result to that value  (I would record the Record ID in another Result just in ...

You're not wrong to expect that but the fact that you're seeing behaviour different from the stock screens suggests to me that you've broken a link on the stock set of screens.  Without seeing your screen it's impossible for us to provide a solution to fixing the link on your stock screen.   At this point we've ...

Wylie, A few things about the Credit Card field here... Inside QuickBooks, under Edit > Preferences > Integrated Applications > Company Preferences  Select the Method Integration Engine (MIE) for use with QuickBooks and click properties Under the Access Rights tab, the last checkbox is to Allow this application access to SSN, ...

 Hi Chad, I don't know that I really answered your question ... there is nothing in the credit card # field, it is blank.  Everything else is still there, however ... name, expiration, billing & payment type. Thanks, wylie

I can't seem to figure out how to tell it to retrieve the "LAST" record.  I've tried it several ways but there is nothing to point at to match the criteria. In the "From table ____ where ____ is equal to _____"  I'm not sure how to tell it to look at the last record ID and retrieve the CALL# from that ...

I was also wondering if there is a way to use SQL outside of the Grid - either at the screen level or directly in Method Report Designer. Thanks!!

 Hi Chad, I was not aware that Method did not store the info. and have seen the data passed back to method in the format above.  That is not the issue in this situation, however, as the # was stored in QB.  I did just recently update it in QB though and actually saved and went back into QB to make sure it updated before I threw the ...

[quote user="wmousseau"]lost their credit card numbers[/quote] When you say lost is there no information in the field?  By default only QuickBooks can store this information - if you enter this field into Method, QuickBooks with store it and send us back xxxxxxx000 instead of the actual number for secuirty.  There should be no ...

Can you please tell me what type of SQL code Method is based on (i.e. Sybase, MS, Oracle, etc.)?