Method Community

How Can I join the following tables in the Report Designer?  Transaction Table to Bill and BillLineItem tables   

Is it possible to link user-created tables so that they can be used in the same manner as QBs linked tables?

Does Method provide a tool for viewing the contents of a table?

Correction: Export your Entity table and look for duplicates. It's possible there may be something missed if you export the 4 tables separately. Sorry about that. - Ashur

Whilst the sync process appears to go through all tables sucessfully using either full sync or changes only - the date on the control panel remains unchanged.  Is this something you can help with please. Regards

Can the activities table be link to the activitiesjobitems table? How?

Hi all, Has anyone successfully connected Method to Power BI for reporting? We’re looking to bring in the Sales Orders, Invoices, and Estimates tables, either using the API, or any other approach. Would really appreciate any advice, examples, or pointers to documentation that helped you get started. Thanks in ...

I would love to have availavle the Method tables for import into PowerBI... PowerBi can import all sorts of formats.... web url, files, databases or whatever for import.   Anyway to do this?   Do I need API to do? Would take Method reporting metrics to a whole new level.

Hi, I'm looking to find the re-orderpoint min & max fields for an item. I see names that are close, but when I export either the item or item inventory files the data for these fields are blank. Am I looking in the wrong tables or do these fields not cross over? thanks -geoff

The following updates are now live for users of Method New Capabilities Schedule - Added the schedule app under early access feature flag. (PL-58754) Fixes Tables & Fields - Fixed an issue preventing custom field creation in Entity and Customer tables. (PL-59854) Regards, Harman