Method Community

This might be a little redundant but for debugging it could help.  This is a trick I use to capture all the processing steps on an AR to see if something went wrong and where. Call one of your ARs debug and use the character function to join the results together as they process.  For example, as soon as you pull the date to do your ...

[quote user="CDS_Josh"]"Back in Method just after the Generate Report action make sure clear the fields again"[/quote] In the same vein as updating the company table before you generate the report, you'll want to make sure you clear those values from the table after the report is generated.  The last step is just ...

[quote user="crosewood"]I haven't been able to find a way to do this. Is it even possible to control the formatting conditionally?[/quote] Yes.  A SQL override would be able to help you to change the formatting on a grid.  On Step 2 when editing a grid you'll notice an advanced button, click that and you'll see the ...

Worked like a charm. But can you explain the correct way to do this? "Back in Method just after the Generate Report action make sure clear the fields again"

Thanks Chad..  I think I understand what you mean.  I will try it out and see if I am on the same page. We are under the assumption that the end-user will not be able to "update the custom field created above in the company table" each time they want to run teh report. But I will see if I can get it to work that way

Here's a decent work around as you cannot pass parameters from the Generate Report action.  Open a Method report and you'll notice one common table regardless of your report... the Company table.  Add a custom field to the Company table to hold the parameters you want to pass to the report. Just prior to generating the ...

I'm working on customizing our Items List screen, to make it look and behave more like QuickBooks. I'd like to have a distinction between parent items, and sub items (the same concept *could* follow through to customers/jobs as well). Ideally, I'd like to indent sub-items, like QuickBooks does. Alternatively, making the parent items ...

[quote user="Method_Chad"]2 full syncs.[/quote] My mistake here, it's not 2 full sync's that need to happen, you need to close and open QuickBooks twice (and sometimes restart the computer).  If that doesn't work then it's a permission issue. ~C

I have a report that is using filtering within method.  However, the customer wants these filters to be printed on the reports.  So my only solution was to create 2 parameters within the report and have method assign values to these parameters based on some drop-down menus within method.  The parameters are PARAM_StartDate and ...

Thx. Using show message isn't allowed since this is all being done in a loop. What I have done is write these values into a variable and then dump it to a field on the screen (like trace or debug info). This trace info shows an empty value prior to insert. But the insert statement goes the Min Date route, for some reason. I may have to ...