Method Community

the value i entered in criteria is multiple invoice number and it joined with comma like "001121,001122" and I want to update a Yes/No field in those invoices. when i test it with "=", it show me an error message. when i using "<>", it update  field in every invoice to "yes" which is the value i ...

Ian, Can you let me know what information you filled in for the action or send me a screenshot of what you filled in to m.melo@methodintegration.com -Michael

Thanks Paul.  Always a second set of eyes will do the trick. I have been staring at this for at least an hour

 Case UCase("Qty on Hand")                 Cells(iRow, 3) = Format(objChild.Text, "#,###")             Case UCase("Avg ...

I did not get error message , the whole table has been updated including the value i entered.

Just a quick thanks in advance!! Here is my issue: I am trying to use the VBa example to pull 4 fields from the item table into an excel sheet.  i am not sure where i am off because only the first 2 columns are being populated.  But it seems like ALL the rows are there. I used the Import/Export tool to get the entire table list to make ...

 Hi Ian, Are you getting an error message? What results are you getting? I tried the following: This updated everyone but Amy Smith. -Michael

Hi Hannah, Can you get in contact with me a m.melo@methodintegration.com? I will take a look at this using the standard report template, if the issue is user error and you want us to fix it then we would charge for consulting time but if the issue is with Method itself we will make sure it gets resolved. -Michael

I try to update multiple record about one field by using update field in table function, i saw the criteria can only perform in two way, one is "=", the other is "<>. When i using "<>" it actually same as no criteria, it update all record regarding to that field even i put a condition there, it does not work.

Hi there, Yes, this has come up once before. I’m assuming it is because you have never had any Purchase Orders to sync with from you QB file. Although I have personally never seen this message (my QB files have always had at least one PO) you can get around it by entering a dummy PO and then delete it. Let us know if any of those options ...