Method Community

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

Hi Paul,  I am facing a problem during the Sync of Bills with the QuickBooks. After creation of the Bills from Methods, during the sync with the QuickBooks the QuickBooks is shutting down abruptly.  Scenario : I have created one bill from method. Then I triedto create another Bill from Method, then when I look at the QB it ...

Hi Denis,  I am facing a problem during the Sync of Bills with the QuickBooks. After creation of the Bills from Methods, during the sync with the QuickBooks the QuickBooks is shutting down abruptly.  Scenario : I have created one bill from method. Then I tried to create another Bill from Method, then when I look at the QB it is ...

Thank goodness i did not throw out my old VB books. They were really dusty. label5.text = xrLabel39.text \ 12 There is the script. Works great. I want my future customers to know what the monthly cost will be for their gardening service.