How do I build my own reports?

Modified on Wed, 1 Nov, 2023 at 4:51 PM

Softbase Evolution allows users to build their own reports via all the popular reporting tools such as Microsoft Excel or Microsoft Power BI. Any reporting tool that supports the OData standard can be used. 

Below are the data points currently available via OData. 

You can add the following filter to the end of a URL to return only the top 10 lines of data: ?$top=10 

GL: company name)connect/dataaccess/gl

GL Detail: company name)connect/dataaccess/gldetail

Customers: company name)connect/dataaccess/customer

Equipment: company name)connect/dataaccess/equipment

Vendor: company name)connect/dataaccess/vendor

Invoice Register: company name)connect/dataaccess/invoicereg

Part: company name)connect/dataaccess/part

AR Detail: company name)connect/dataaccess/ardetail

AP Detail: company name)connect/dataaccess/apdetail

WO: company name)connect/dataaccess/wo

WO Labor: company name)connect/dataaccess/wolabor

WO Misc: company name)connect/dataaccess/womisc

WO Parts: company name)connect/dataaccess/wopart

WO Quote: company name)connect/dataaccess/woquote

WO Equipment: company name)connect/dataaccess/woeq

Chart Of Accounts: company name)connect/dataaccess/chartofaccount

Equipment PO Detail: company name)connect/dataaccess/equipmentpodetail

Misc PO Detail: company name)connect/dataaccess/miscpodetail

Order: company name)connect/dataaccess/order

Orders Received: company name)connect/dataaccess/ordersrecv

Person: company name)connect/dataaccess/person

PM: company name)connect/dataaccess/pm

PM Name: company name)connect/dataaccess/pmname

PM Parts: company name)connect/dataaccess/pmpart

PM Secondary: company name)connect/dataaccess/pmsecondary

PM Status: company name)connect/dataaccess/pmstatus

PO Header: company name)connect/dataaccess/poheader

WO Rental: company name)connect/dataaccess/worental

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article