Method Community

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 ...

Great job!   Having a bit of VB knowledge does come in handy when working with the scripts in the report designer. -Michael

Roger, This should work, what you can try doing though is to only try importing and updating a small set of records and if that works continue on and do the rest. The updates done to Method should have no affect on this. -Michael

cpitts, You should be able to have to objects with the same Name, because since its a subitem the FullName will be composed of both the Item and Subitem name. You could also just remove the items from the list that you don't want update before the import. -Michael