Method Community

I am creating a custom Quickbooks_Estimate screen that allows the user to edit fields in the EstimateLine grid which then recalculate other fields in the grid and update the associated values in the EstimateLine table. I am having an issue with trying to call the "Footer buttons>>Save_Click" action set from the "Text ...

Thank you for the input Fran. I will also look into this very helpful info. Im sure there is a lot I can do with those reports and my next step is to work on them. J In the meantime , I am being asked to have this info available for the other time frames right on the Contact grid screen,  just like I did with the previous sql overide for ...

Hi, we have the problem that several of our invoices display a wrong subtotal in the (default Method) invoice screen. As an example: - 3 positions in the invoice - totaling $99.99 - Subtotal shows up as $259.97, basically triple-counting the first position If I look at the subtotal field using a customized screen, the correct value shows up, ...

Solution: I determined using "show messages" actions that the grid is smart enough to know thr recordID of the row in which a field is being edited. Hello, I have added a "Gross Profit %" field to the EstimateLine grid on my customized Quickbooks_Estimate screen. I am allowing editing directly inside the grid ...

When retrieving a value from a table, Field is not available from 1st value when select Criteria, until you Save and Back, then Edit again

I would like to send an email when a user submits information through the portal but I do not know how to combine merge fields into a single email. I would like to include relevant customer information from the customers table and also from the screen as they submit it. Can I use the markup TableName.FieldName in the Send Email action of the ...

EDIT: the problem was in our data - sometimes we accidentaly added an empty value. I have recently created a report using scripting (might be relevant) that calculates sum of groups based on specific criteria. While it works when I generate a report for a time window shorter than (about) 2 and half months, when the time frame is ...

Hello Method! We are getting a yellow pop up when we log in that says "Processed 500 records from a total of 512" Do you know why this pop up is appearing? Thanks, James

Callum, Mortaza and you may have already resolved this, but which Estimateline.estimatequantiy are you using on your report? Under the ESTIMATE teble list there is an ESTIMATELINE  Fied with a "+" next to it.  That is where you should be getting your Quantity from. Not from the ESTIMATELINE field listing .  I know its ...

HI Afrodite, You are asking good questions.  With all of the dates you want, I would generate a "pivot grid" report using the report designer and then display that report on your screen.  The pivot grid tool  gives you all sorts of date options.   Just a thought.  Also keep in mind how far back you have ...