Method Community

Birch, It's probably is a better idea to put these action in the same location where you generate the report that displays this info and not on the OnScreenLoad for the screen. Are you updating based on RecordID from Row? If not that could be the issue. Also another suggestion is to loop through grid instead of through the table should make ...

Michael, I've abbreviated my item to just a few items that I want to update. I'm using the Item table and have no conflicts, but it's coming back saying this same error message.  These items do have a duplicate as a SUBITEM, but that's it.  I also checked to see if there was duplications of these items that were ...

I added a linked field 'ItemType' to the 'InvoiceLine' table. Then, I tried to add the following 'on screen load' actions to the advanced screen properties and I received an error message that 'An error has occured in the Update Field In Table action. Please verify all data being entered is ...

Greetings, I dont even know if i should be commenting on this but it woked for me. Might not work for you i dont know. About 8 years ago when i got quick books about once to 4 times a year, quickbooks would give me problems like corupped files, slow quick books start ups to name a few. Then one day i was talking a friend of mine, shes a computer ...

Greetings, Rats! i did not know about the right click thing on the table designer. I tried it and it was so quick. Just like using excel or access. One of these days i will have to break out the manual on this. Thanks guys

John M, One thing I'll add to this (since there are other non script people reading this that we don't want to freek out!) is that before resorting to VB script, you can always try to accomplish your calculations using Calculated Fields.  You can right-click on a table in the designer and add a calculated field, and then drag that ...

Birch, You can apply the same SQL override concept to only be applied to items of type subtotal. You could also loop through your items and have a condition that checks to see if the item type is subtotal and if it is update that row to have subtotal in the ImportSku field. You may need to link ItemType from the item table into the InvoiceLine ...

Rajni, This question is being addressed HERE.  -Michael

Hi Rajni, Can you send me a screenshot of what the bill looks like that you are creating? Is there any special characters in the bill? Does this only happen with bills? What happens when you create a new customer or invoice in Method? -Michael

Hi Michael - Sorry for the delayed response. After watching the webinar, I have been trying to think through the potential problems of using the SQL override that you suggested above. In the event that the field 'ImportSKU' is blank for an item that is not the subtotal line (ie. if someone accidentally leaves the importSKU field blank on ...