Method Community

[quote user="smohyee"]I assume running through the AR is more resource efficient than running through the value on screen when used by multiple functions.[/quote] Using the AR might be a little more resource efficient but the biggest reason for using an AR is code reuseability. ~C

Hi Martin, The problem you are having comes down to a Mac issue which we can't fix.  What happens is the local system preferences are used when this report is generated; on a PC those preferences are respected and the currency shows correctly; on a Mac the preferences are ignored.  I tried a few solutions on the report deisgner to ...

[quote user="smohyee"]...if I type in "Vendor" into the "replace from table"  field, and put my desired Vendor record ID as an Action Result in the next field, then the function will go lookup every merge field in my template...[/quote] Correct.  Method is quite clever with the merge function! ...

[quote user="smohyee"]...the merge fields use the active record ID for the current screen/table the template is loaded into.[/quote] The merge is not always based off active RecordID.  Replacing merge fields relies on the Character Function action, specifically the option Replace <<merge>> fields.  Take a look the ...

The same is not true for the Quantity and Rate fields (there's no background processing) in the line item grids but you shouldn't remove those fields.  If anything you should hide those columns instead of removing them. Also keep in mind that if you have a user working inside QB, and they change values for those fields, it would only ...

[quote user="jnoneiliv1"]Do you think it's just a coincidence that you are using terms like "Where clause", "Select", "Distinct", etc.?[/quote] No coincidence and all those terms are all applicable - Distinct is the only one I always try to refer to as unique outside SQL statements.  [quote ...

James, [quote user="jnoneiliv1"]I think answering this question in terms of typical SQL statement logic might help clear things up.[/quote] While it's helpful to answer in terms of SQL statement logic, we're not writing a SQL statement so I wanted to try and explain what distinct means outside a SQL statement. [quote ...

Rolf, Just wanted to let you know this issue was resolved.  You'll have to log out/in again, make sure you're on the April version of Method and make sure you republish the screen. ~Chad

[quote user="Old Sales Guy"]How can I get this to work?[/quote] Log out of Method and on the login screen click the Switch to April version link.  The HTML editor was upgraded in the most recent version of Method.  Check the April release notes to see other changes and enhancements made. ~C

Rolf, Would you mind sending me your contact info so I can let you know once this has been resolved. We're aware of this issue right now and will post and update with more details later. ~C