Method Community

He there I'm new to Method and trying to convert a sales order to an invoice, but it keeps asking me to enter a valid AR Account - I'm not sure what one of these is, can anyone help please? Thanks Giles

Thanks Adam, but as I already said, they are REPORT fields, not Method fields, so they do not show up in the fields list as fields that I can calculate with.  If there is a way to calculate on REPORT fields I would love to hear it! To clarify,  what I have done in my report is used 3 label fields to add together three different amount ...

Hi Karen, You could use calculated fields in the Report Designer.  Just right click on the table at the top right of the designer and add a calculated field.  You can then create an expression to add the values of the fields you want.  It should look like this: First right click to add the field, then right click again and ...

Hi LaCrews, I don't think it is. I'm also gonna suggest you take a quick gander at this post...it should answer your questions (but if you have more feel free to ask) http://www.methodintegration.com/cs/forums/t/3820.aspx Dave

Hi, You can find a list of Method actions and some examples on our Action References section of the Help Center.  If you have any additional questions, let us know and we'll be happy to help. - Adam

Dear Mr. Adam,  Thank you for prompt response and applogies for late thank note... Anyway Thank you a lot... Where can find complete reference of all Method actions along with examples?  Regards, ASK AINiT.net.au

Dave I may have answered my own question.  It looks like I can use a select call to download the document field from the document library table.  Would you happen to know if this is base64 encoded?

Adam, No, actually I was hoping there was a way to add values in fields on the report together - but it seems like this is not possible.  They are not fields in a Method table/screen.  They are label fields on the report that are summing the amount field from Method.  I want to add 3 "sums" together. Karen

Hi Karen, I'm assuming the other fields are field on screen?  If so, I would put this calculated field in whatever table/screen this report is generated from.  If you don't need the field on screen, you can hide it.  You can then do the calculations on screen, using the Basic Math Calculation ...

Hi LaCrews, Can you elaborate what calls in particular did you have in mind? Dave