Method Community

Blake, When you refer to orders are you talking about work orders? Based on what criteria do you want these work order created? Specific intervals? Have you taken a look at Method Field Services? -Michael

Birch, You can try an SQL Override. Something along the lines of:  CASE WHEN [ImportSKU]=' ' Or [ImportSKU] IS NULL THEN 'Subtotal' ELSE [ ImportSku] END  **Note the above code may not won't but its would be the format used, fields names are in [ ], regualr text is in ' ' This may work in your ...

TogsTeam, You could create another table that has the SalesRep intial and the extra details and use actions to pull that information as needed. -Michael

 When we enter line items on a bill, we typically assign the costs to a customer/job but rarely do we mark them as "billable" since the costs are part of our contracted price.  We would leave that field blank instead of choosing bilable, has been billed or not billable.  By leaving it blank we assume as in QB's that it ...

We are facing dificulties with data stored in our database, international characters such as "ç" are shown as ASCII code "ç". This was not happening in the last week, and it was detected by our users today. This ...

Am wondering if anyone is already doing this.... I am in the process of creating custom tables, screens, functionality in Method for my business. Basically, we have ~300 regular customers set up on 'programs'...which is basically a bunch of products we sell them throughout the year. These programs are created yearly, with moderate ...

Hi Michael - No, I did not have to link it. The custom field was already listed as a field in the 'InvoiceLine' table (I do not have the option to delete it either). So, the data is automatically populated next to the quantity and amount for each item on the invoices. Thanks, Birch

Michael - Yes, we tried that originally, but unfortunately some of our reps are neither employees nor vendors, but actually Other Names.

Hi Birch, Is the Import SKU field a linked field in the InvoiceLine table? If not how is that data populated? Are you exporting the grid using the Export Grid to Excel action? -Michael

TogsTeam, Have you tried using Linked Fields? You should be able to add Linked fields to the table which can pull data based on the entity(Empolyee/Vendor) that is assigned to the SalesRep. -Michael